This model calculates the Weighted Average Cost of Capital (WACC) which can be used as discount rate in a Discounted Cash Flow (DCF) valuation.
The discount rate has two components, cost of equity and cost of debt. The model allows you to systematically work through and come up with a reasonable justification of your discount rate.
For the required parameters such as unlevered beta and the market risk premium, you can either use the indicated sources of Damodaran Data Page or use your own analysis to come up with your value. The model gives you a quick structure of the formulas to follow.
|Industry||Financial Model, General|
|Summary||This model calculates the Weighted Average Cost of Capital (WACC) which can be used as discount rate for any DCF calculation.|
|Screenshots / Pictures|
|Use Cases||DCF, Discount Rate, FREE, NPV|