Valuation

Inputs

• Read Me First - This file describes the programs in this section and provides some insights into their usage.



• WACC Calculator - This spreadsheet allows you to estimate the cost of capital for your firm.



• Capital Expenditure - This program summarizes the three approaches that can be used to estimate the net capital expenditures for a firm, when it reaches stable growth.



• Operating Lease Expenses - This program converts operating lease expenses into financing expenses and restates operating income and debt outstanding.



• R&D Expenses - This program converts R&D expenses from operating to capital expenses, estimates a value for the research asset and restates operating income.



• Implied Risk Premium - This spreadsheet calculates the implied risk premium in a market. This can be used in discounted cashflow valuation to do market neutral valuation.

Note

You will need MS Excel 97 of hire to use this spreadsheets. If you do not have MS Excel and you are trying to open it with different Excel-like software please note that some of the functions may not work properly.

Spreadsheet 123 Spreadsheet Software Development