EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula WACC Formula
Secondary Sidebar
Finance Blog
  • Accounting Fundamentals Resources (720+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Resources (374+)
  • Credit Research Fundamentals (6+)
  • Economics (104+)
  • Finance Formula (384+)
  • Financial Modeling in Excel (16+)
  • Investment Banking Resources (142+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • valuation basics (26+)
  • Insurance Resources (15+)
  • Top Finance Books (33+)
Finance Blog Courses
  • Investment Banking Course
  • Investment Banking Online Course
  • Financial Modeling Certification

WACC Formula

By Madhuri ThakurMadhuri Thakur

WACC Formula

WACC Formula (Table of Contents)

  • Formula
  • Examples
  • Calculator

What is the WACC Formula?

The term “WACC” is the acronym for a weighted average cost of capital (WACC), which is a financial metric that helps in calculating a firm’s cost of financing by combining the cost of debt and cost of equity structure together. In other words, it indicates the minimum rate of return that a company needs to generate in order to compensate both shareholders and lenders. WACC is also known as the simple cost of capital.

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

Formula for WACC

The formula for WACC is expressed as the sum of the product of weightage of equity and cost of equity plus a product of weightage of debt, cost of debt and one minus the applicable tax rate.  Mathematically, it is represented as,

WACC = Weightage of Equity * Cost of Equity + Weightage of Debt * Cost of Debt * (1 – Tax Rate)

Where,

Weightage of Equity = Total Equity / (Total Equity + Total Debt)

Weightage of Debt = Total Debt / (Total Equity + Total Debt)

Example of WACC Formula (With Excel Template)

Let’s take an example to understand the calculation of WACC  in a better manner.

You can download this WACC Formula Excel Template here – WACC Formula Excel Template

WACC Formula – Example #1

Let us take an example of a company DCF Inc. to illustrate the computation of WACC. During FY19, the company’s real estate investment generated a return of ~5.5%.  As per the latest annual report, the company has an outstanding debt of $50.0 million and common equity valued at $70.0 million. During that period the company has incurred $2.0 million as interest expense on its debt. On the other hand, the risk-free rate of return is 1.5%, the market return is 4.0% and the company’s beta is 1.2x. Calculate WACC based on the given information and check whether the investment return of 5.5% exceeds its cost of capital if the tax rate is 32%.

company DCF Inc

Solution:

Total Capital is calculated using the formula given below

Total Capital = Total Debt + Total Equity

Total Capital

  • Total Capital = $50.0 million + $70.0 million
  • Total Capital = $120.0 million

Weightage of Debt is calculated using the formula given below

Weightage of Debt = Total Debt / Total Capital

Weightage of Debt

  • Weightage of Debt = $50.0 million / $120.0 million
  • Weightage of Debt = 0.417

Cost of Debt is calculated using the formula given below

Cost of Debt = Interest Expense / Total Debt

Cost of Debt

  • Cost of Debt = $2.0 million / $50.0 million
  • Cost of Debt = 4.0%

Weightage of Equity is calculated using the formula given below

Weightage of Equity = Total Equity / Total Capital

WACC Formula - 5

  • Weightage of Equity = $70.0 million / $120.0 million
  • Weightage of Equity = 0.583

Cost of Equity is calculated using the formula given below

Cost of Equity = Risk-Free return + Beta * (Market Return – Risk-free Return)

WACC Formula - 6

  • Cost of Equity = 1.5% + 1.2 * (4.0% – 1.5%)
  • Cost of Equity = 4.5%

WACC is calculated using the formula given below

WACC = Weightage of Equity * Cost of Equity + Weightage of Debt * Cost of Debt * (1 – Tax Rate)

WACC Formula - 7

  • WACC  = 0.583 * 4.5% + 0.417 * 4.0% * (1 -32%)
  • WACC  = 3.76%

Based on the given information, the WACC is 3.76%, which is comfortably lower than the investment return of 5.5%. Hence, it is a good idea to raise the money and invest.

Explanation

The formula for WACC can be calculated by using the following points:

Typically, companies are financed by a mix of debt and equity. Further, the cost of debt is usually lower than that of the cost of equity and as such, it is important to capture the average cost of capital. However, it would be wrong if we take straight away the average of the cost of debt and cost of equity because in some cases companies might raise more funding from one source than another. As such, it is quintessential that we compute the weighted average of the cost of capital by taking into account the proportion of each category of funding (debt and equity) in the overall capital structure. Generally, companies intend to take more debt funding due to its lower cost of financing coupled with tax benefits for interest payment. The cost of two major sources of financing are as follows:

  • Cost of Debt: The cost of debt of a company can be derived as interest expense for the year divided by the average outstanding debt. Mathematically, it is represented as,

Cost of Debt = Interest Expense / Amount of Outstanding Debt

  • Cost of Equity: The cost of equity is expressed as the product of stock beta and difference of market return and risk-free return, which is then added to the risk-free return. In this case, equity is a generic name used for anything other than debt. Mathematically, it is represented as,

Cost of Equity = Risk-free return + Beta * (Market Return – Risk-Free Return)

Relevance and Use of WACC Formula

It is important that one understands the concept of WACC as it plays a vital role in making financial management decisions. The primary purpose of the formula for WACC is the assessment of the overall cost of funds based on the contribution of debt and equity in the company’s capital structure. Typically, the management of a company use WACC to evaluate whether it should finance the purchase of any new asset with equity or debt or a mix of both. Lower cost of financing is always desirable.

On the other hand, investors and creditors use WACC to evaluate whether it is worth investing or lending loan to an entity. As WACC increases, the investment will be less likely to create any value and as such investors might look for some other prospects.

Conclusion

So, it can be seen that WACC is a very useful metric in the financial domain for everyone. However, various everyone come up with a different WACC number for the same company due to a different set of assumptions.

WACC Formula Calculator

You can use the following WACC Formula Calculator

Weightage of Equity
Cost of Equity
Weightage of Debt
Cost of Debt
Tax Rate
WACC
 

WACC = Weightage of Equity *Cost of Equity+Weightage of Debt*Cost of Debt* (1-Tax Rate)
= 0 *0+0*0*(1-0)= 0

Recommended Articles

This is a guide to WACC Formula. Here we discuss how to calculate the WACC along with practical examples. We also provide a WACC Formula calculator with a downloadable excel template. You may also look at the following articles to learn more –

  1. Gearing Formula
  2. Cost of Capital Formula
  3. Debt to Equity Ratio Formula
  4. Interpretation of Debt to Equity Ratio
Popular Course in this category
Investment Banking Training
  124 Online Courses |  25 Hands-on Projects |   600+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Financial Modeling Training4.9
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download WACC Formula Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड WACC Formula Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more