#Data analysis excel template free#

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.

#Data analysis excel template free#

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.