:: Subscribe to our newsletter
Articles / Directory
Latest version of TraderCode(v5.6) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.

InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.

Launch of
Free Investment and Financial Calculator for Excel.

Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.

Launch of NeuralCode(v1.0) for
Neural Networks Trading.

Cost of Capital

Capital is the money that a company uses to finance its business. For example, in buying assets for operating the business and investing in projects that generate cash flows for the company. The capital can come from investors who invest in the common stocks of the company or from funds borrowed from others known as debt. The cost of capital can be thought of as the cost of doing business.

Imagine if the company uses only common stocks (equity) to finance all its assets, then the stockholders will own all the assets and all the cash flows generated by the business. The investors will be expecting a certain rate of return for putting money into the common stock. The cost of capital in this case can be thought of as the required rate of return by the investors. When the company needs to invest in a new project, it may need to consider whether the returns will be able to meet the expectations of the investors.

To complicate matters, most companies use a mixture of debt and equity to finance their business. Thus cost of capital involves a mixture of the cost of equity and the cost of debt. In this case, the cost of capital for a company is the required rate of return that the company needs to earn in order to pay the debts and to meet the expectations of the rate of return required by the investors.

Weighted Average Cost of Capital (WACC)

Weighted Average Cost of Capital is defined as the average cost of capital for a company, calculated as a weighted average of the costs of equity and the costs of debt.

The formula below is used to calculate the Weighted Average Cost of Capital (WACC):

WACC = (Debt / (Debt + Equity)) * Cost of Debt + (Equity / (Debt + Equity)) * Cost of Equity

Equity = Shares Market Price * Shares Issued

Cost of Debt is usually defined as the after-tax cost of debt:

After-tax Cost of Debt = (1- Tax Rate)* Cost of Debt

The WACC Calculator spreadsheet uses the formula above to calculate the Weighted Average Cost of Capital.

Cost of Equity

The Cost of Equity is defined as the rate of return that an investor expects to earn for bearing risks in investing in the shares of a company. Two common ways of calculating the Cost of Equity is the Dividend Growth Model by Gordon and the Capital Asset Pricing Model (CAPM).

Cost of Equity (Gordon)
In the Dividend Growth Model by Gordon, the price of a company stock is calculated as the sum of all the company's future dividends. The dividends are assumed to be growing at a constant rate.

Price of Stock Today = (Current Dividend * (1+ Dividend Growth Rate)) / (Required Return- Dividend Growth Rate)

Rearranging the formula gives us the following:

Required Return = (Current Dividend * (1+ Dividend Growth Rate))/Current Price of Stock + Dividend Growth Rate

The Required Return is the Cost of Equity and this is calculated in the worksheet CostofEquity-Gordon.

Cost of Debt

A company's debt is usually a mixture of loans, bonds and other securities. A company's Cost of Debt is the interest rate that a company pays on its debt. It is important to note that the interest a company pays is a tax deductible expense. Thus the after-tax rate is usually used for a company's cost of debt.

After-tax Cost of Debt = (1 - Tax Rate) * Cost of Debt

Download Free Weighted Average Cost of Capital (WACC) spreadsheet - v1.0

System Requirements

Microsoft® Windows XP®, Microsoft® Windows Vista®, Windows 7 or Windows 8
Windows Server 2003, 2008, 2012
512 MB RAM
5 MB of Hard Disk space
Excel 2002, 2003, XP, 2007, 2010, 2013


By downloading this software from our web site, you agree to the terms of our license agreement.


FreeWeightedAverageCostOfCapital_WACC.zip (Zip Format - 72 KB)

Get the Professional version

  • Unlocked
  • Allows removal of copyright message in the template
  • Allows commercial use within the company
  • Allows full customization of the model
  • Supports the calculation of Cost of Equity using Dividend History
  • Supports the calculation of Cost of Equity using the Capital Asset Pricing Model (CAPM)
Details PDF Specifications


USD20.00 - Purchase


Copyright (c) 2007-2014, ConnectCode Pte Ltd. All Rights Reserved.

Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners