WACC Calculator - Excel Model Template
  • WACC Calculator - Excel Model Template
Originally published: 12/06/2019 10:26
Publication number: ELQ-67378-1
View all versions & Certificate
certified

WACC Calculator - Excel Model Template

Simple WACC (Weighted Average Cost of Capital) calculator

Description
By Patrick Curtis

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

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Wall Street Oasis

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on WACC Calculator - Excel Model Template?

The user community and author are here to help. Go ahead!

please wait...