WACC Calculator - Excel Model Template
Originally published: 12/06/2019 10:26
Last version published: 04/02/2020 15:01
Publication number: ELQ-67378-2
View all versions & Certificate
certified

WACC Calculator - Excel Model Template

Simple WACC (Weighted Average Cost of Capital) calculator

Description
This simple WACC Calculator is a free excel template for calculating weighted average cost of capital based on the proportions of capital structure, cost of equity, cost of debt and tax rate of a business. WACC is often used in DCF (Discounted Cash Flow) calculations to determine the discount rate, to then calculate the present net value of a business.

The calculator uses the WACC formula to give the business’ cost of capital:
WACC = (E / V) × Re + (D / V) × Rd × (1 − Tc)

The model is designed to be plug-and-play, making it very easy to use and to get results for your business. To use the template, you can input your own data or formulas to auto-populate output numbers. It also contains other elements of a financial model, included within the template in the following tabs (in addition to the WACC tab). These include:
• Assumptions
• Income Statement
• Balance Sheet
• Cash Flow Statement
• PPE Schedule
• Debt Schedule
• DCF
• LBO Modelling
• FCFE Valuation
• PE Returns analysis

If you have any questions about this template, feel free to reach out to us by starting a discussion below or via direct message here on Eloquens.

Like this model? Leave us a review or a rating to show your appreciation!

This Best Practice includes
1 WACC calculator excel sheet

Wall Street Oasis offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.8 / 5 (11 votes)

please wait...