WACC Calculator | Discount Rate Estimation

This model calculates the Weighted Average Cost of Capital (WACC) which can be used as discount rate for any DCF calculation.

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

 

 

 

Write a Review

Get these templates too for a discount!

Price: $140.00

This is a collection of selected renewable energy model templates which are set in a bundle which will help you…

Add to wish list
Add to cart Excluding 0% tax

Price: $149.95

This is a collection of financial model templates in Excel for businesses in the Manufacturing industry and its related sectors.

Add to wish list
Add to cart Excluding 0% tax

Price: $140.00

This is a bundle of financial model templates related to the Fitness and Sports Industry. To help you save money…

Add to wish list
Add to cart Excluding 0% tax