WACC (Weighted Average Cost of Capital) Calculator
Originally published: 27/01/2021 13:37
Publication number: ELQ-62957-1
View all versions & Certificate
certified

WACC (Weighted Average Cost of Capital) Calculator

This is a free excel template to calculates the weighted average cost of capital for long term funding supplied

Description
The free excel template help the user to calculates the weighted average cost of capital for the long-term funding used by the firms, supplied by its creditors (or lenders) and the owners (or shareholders),

Inputs in the green cells only

Equity financing (Column C, Row 8): The long-term funding supplied by the shareholders includes both common stock and preferred stock, common stock includes outstanding common stock and retained earnings

Debt financing (Column C, Row 9): The long-term funding supplied by the creditors is long term debt only. Accounts payable, accrued expenses, and other non-debt or current liabilities are excluded, short term seasonal debt is also excluded, if the short-term debt is continuing as a revolving, so that debt can be included as part of long-term debt

Risk free rate (Column F, Row 8): is return of an investment with zero risk, approximated by the return on very short government treasury bond
Market risk premium (Column F, Row 9): is difference between expected return on a market portfolio and risk-free rate
Levered beta (Column F, Row 10): is a measure of market risk
Debt interest (Column I, Row 8): it is annual interest on long term debt
Corporate tax (Column I, Row 9): tax on net profit

Outputs

After you fill the green cells, the data will dynamically flow into the following below

Capital structure weights
Cost of equity using CAPM formula
Cost of debt after tax
Weighted average cost of capital
First dashboard showing the impact of changing capital structure on WACC
Second dashboard showing the impact of changing levered beta on WACC

Conclusion and customization
This is a highly versatile, very sophisticated financial model template, and is also user-friendly.
If you have any inquiries, modification request or other requests of assistance to customize the model template for your business case please contact us here: https://www.eloquens.com/channel/ecorporatefinance

This Best Practice includes
Excel Template

ECF Consultancy offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from ECF Consultancy

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on WACC (Weighted Average Cost Of Capital) Calculator?

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


5.0 / 5 (8 votes)

please wait...