Valuation Inputs Models for Excel
In this section, you will find spreadsheets that allow you to:
A. Estimate
the right discount rate to use for your firm, starting with the risk premium in
your cost of equity and concluding with the cost of capital for your firm.
B.
Convert R&D and operating leases into capitalized assets
C. estimate the
right capital expenditures and diagnose the terminal value assumptions to see if
they are reasonable.
WACC Model Worksheet - This spreadsheet allows you to estimate the cost of capital for your firm.
Capital Expenditure Model
- The Spreadsheet 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 excel model converts operating lease expenses into
financing expenses and restates operating income and debt outstanding.
R&D Expenses - This spreadsheet 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.
Read Me First - This file describes the programs
in this section and provides some insights into their usage.
Check out our most popular Excel & Spreadsheet resources...!
First-time visitor to Spreadsheet123?
Try the site's
most popular pages, chosen by our readers:
Suggested Reading
Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
