WACC Calculator | Discount Rate Estimation

WACC Discount Rate Estimation

This Excel model calculates the Weighted Average Cost of Capital (WACC) or discount rate which is used when building a DCF model to discount future cash flows to firm to their present value.

The weighted average cost of capital has three main components: The cost of equity, the cost of debt and the weighting factor. The model contains the WACC formula and allows you to systematically work through the required financial parameters to fine-tune and justify your discount rate by calculating the WACC.

The discount rate is a measure of a company’s risk and the required opportunity cost to compensate investors to carry such. The higher the discount rate, the lower the present value of future cash flows. Given the discount rate is one of the major drivers in almost any DCF valuations, a careful analysis is required.

The spreadsheet with the WACC calculator is free for download.

Add to wish list

 

WACC calculator
WACC calculator
Add to wish list

 

 

 

Users who purchased WACC Calculator | Discount Rate Estimation, also purchased:
Real Estate Developer Model
Real estate developer
Add to wish list
Purchase Excluding 7.7% tax
Biogas Financial Model
Biogas Financial Model
Add to wish list
Purchase Excluding 7.7% tax
Wind Energy Financial Model
Wind Energy Financial Model
Add to wish list
Purchase Excluding 7.7% tax
Industry ,
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 , , ,

You must log in and be a buyer of this download to submit a review.