Overview

Weighted average cost of capital (WACC) is the required return a company should generate for the risk associated with investing capital in the company. Another way of looking at WACC is to see it as the minimum rate of return an enterprise should earn in order to create value for its investors. In effect, it represents the opportunity cost of the firm.

The WACC formula used by the calculator in the Excel template is: WACC = (E/V x Re) + ((D/V x Rd) x (1 – T)) Where: E = market value of the firm’s equity (market cap) D = market value of the firm’s debt V = total value of capital (equity plus debt) E/V = percentage of capital that is equity D/V = percentage of capital that is debt Re = cost of equity (required rate of return) Rd = cost of debt (yield to maturity on existing debt) T = tax rate
Share
Reviews Add a review
Avatar
Abdul-Rauf
Justin @ Getting People Right
Justin @ Getting People Right

Great, saved me a lot of time

Avatar
Alistair Williams

Nice but very basic, gets the job done

More From Corporate Finance Institute®

Browse our top rated business templates. See All
Synthetic Call Chart Option Profit/Loss Graph Maker
347
189
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
216
0
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
185
80
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…
Levelized Cost of Energy (LCOE) Template Levelized Cost of Energy (LCOE) Template
1
278
105
The levelized cost of energy (LCOE), also referred to as the levelized energy cost (LEC) or the levelized cost of…
Bank Mixed Statement Ratio Calculator Bank Mixed Statement Ratio Calculator
151
53
The Bank Mixed Statement Ratio Calculator is a tool that you can use to determine a bank's profitability and financial…
Bank Income Statement Ratio Calculator Bank Income Statement Ratio Calculator
169
58
The Bank Income Statement Ratio Calculator is a tool that you can use to determine a bank's profitability, efficiency, and…