disbion.blogg.se - Microsoft excel spreadsheet example

#Microsoft excel spreadsheet example free

41 DCF - Menu driven Excel program (must enable macros) for Discounted Cash Flow Analysis from the book Analysis for Financial Management by Robert C.

40 SLG Ratio Master (exe) - Excel workbook for creating 25 key performance ratios.

39 Breakeven Analysis (zip) - Pricing and breakeven analysis for optimal pricing - Biz Pep.

37 Financial History Pivot Table - Microsoft Financials.

36 Tanly (zip) - Suite of technical analysis models for Excel.

35 Hamlin (zip) - Financial function add-on's for Excel.

34 Forex (zip) - Foreign market exchange simulation for Excel.

33 Business Financial Analysis Template for start-up businesses from Small Business Technology Center.

32 Cash Flow Matrix - Basic cash flow model.

31 Black Scholes Option Pricing (zip) - Excel add on for the pricing of options.30 Risk Analysis (exe) - Analysis and simulation add on for excel, self extracting exe file.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.

#Microsoft excel spreadsheet example 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.