29 Financial Charting (zip) - Add on tool for Excel 97, consists of 6 files.28 CFROI (xls) - Simplified Cash Flow Return on Investment Model.27 Stock Value (zip) - Calculates expected return on stock and value based on no growth, growth, and variable growth.
26 Ratio Calculator (zip) - Calculates a standard set of ratios based on input of financial data.25 Leverage (zip) - Shows the effects on Net Income from using debt (leverage).24 Financial Projections (zip) - Spreadsheet model for generating projected financials along with valuation based on WACC.23 Cash Flow Valuation (zip) - Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows.22 Buyout (zip) - Analyzes the effects of combining two companies.21 Bond Valuation (zip) - Calculates the value or price of a 25 year bond with semi-annual interest payments.20 Statements (xls) - Generate a set of financial statements using two input sheets - operational data and financial data.
19 WACC (xls) - Calculation of Weighted Average Cost of Capital using beta's for equity. 18 Capital Structure (xls) - Spreadsheet for calculating optimal capital structures using different percents of debt. 17 Free Cash Flow (xls) - Cash flow worksheets - subsidized and unsubsidized. 16 Template (xls) - Template spreadsheet for project evaluation & capital budgeting. 15 Real Rates (xls) - Demonstrates inflation and real rates of return. 14 NPV & IRR (xls) - Explains Internal Rate of Return, compares projects, etc. 13 Lease or Buy a Car (xls) - Basic spreadsheet for deciding to buy or lease a car. 12 Time Value (xls) - Introduction to time value concepts, such as present value, internal rate of return, etc. 11 FCFF Valuation 2 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth - Aswath Damodaran. 10 FCFF Valuation 1 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates - Aswath Damodaran. 9 FCFE Valuation 3 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with three stages of growth, high growth initially, decline in growth, and then stable growth - Aswath Damodaran. 8 FCFE Valuation 2 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth - Aswath Damodaran. 7 FCFE Valuation 1 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates - Aswath Damodaran. 6 Risk Premium (xls) - Calculates the implied risk premium in a market. 5 Valuation Models (xls) - Rough calculation for choosing the correct valuation model - Aswath Damodaran. 4 Synergy (xls) - Estimates the value of synergy in a merger and acquisition - Aswath Damodaran. 3 LBO Valuation (xls) - Analyzes the value of equity in a leverage buyout (LBO) - Aswath Damodaran. 2 Rating Calculation (xls) - Estimates a rating and cost of debt based on the coverage of debt by an organization - Aswath Damodaran. 1 Capital Budgeting Analysis (xls) - Basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements, etc.
0 kommentar(er)
