WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Investment Banking Tutorials » Valuation Tutorials » Cost of Equity Formula

Cost of Equity Formula

What is Cost of Equity Capital Formula?

Cost of equity (Ke) is what shareholders expect to invest their equity into the firm. Cost of Equity formula can be calculated through below two methods:

  • Method 1 – Cost of Equity Formula for Dividend Companies
  • Method 2 – Cost of Equity Formula using CAPM Model

We will discuss each of the methods in detail.

Method #1 – Cost of Equity Formula for Dividend Companies

Cost of Equity (Ke) = DPS/MPS + r

Where,

  • DPS = Dividend Per Share
  • MPS = Market Price per Share
  • r = Growth rate of Dividends

The dividend growth model requires that a company pays dividends, and it is based on upcoming dividends. The logic behind the equation is that the company’s obligation to pay dividends is the cost of paying its shareholders and, therefore, the Ke, i.e., cost of equity. This is a limited model in its interpretation of costs.

Cost of Equity Formula

Cost of Equity Calculations

You can consider the following example for a better understanding of the Cost of Equity Formula:

You can download this Cost of Equity Formula Excel Template here – Cost of Equity Formula Excel Template

Example #1

Let’s try the calculation for Cost of Equity formula with a 1st formula where we assume a company is paying regular dividends. 

Suppose a company named XYZ is a regularly paying dividend company, and its stock price is currently trading at 20 and expects to pay a dividend of 3.20 next year has following dividend payment history. Calculate the cost of equity of the company.

cost of equity formula excel1.1

Solution:

Let’s first calculate the average growth rate of dividends. Continuing the same formula as per below will yield yearly growth rates.

cost of equity formula excel1.2

So the growth rate for all the years will be-

cost of equity formula excel1.3

Now take a simple average growth rate, which will come to 1.31%.

Now we have all the inputs i.e. DPS for next year = 3.20, MPS = 20 and r = 1.31%

Popular Course in this category
Sale
Investment Banking Training (117 Courses, 25+ Projects)
4.9 (831 ratings)
117 Courses | 25+ Projects | 600+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Hence

  • Cost of Equity Formula= (3.20/20) + 1.31%
  • Cost of Equity Formula= 17.31%
  • Hence, the cost of equity for the XYZ company will be 17.31%.

Example #2 – Infosys

Below is the dividend history of the company, ignoring interim and any special dividend for the time being.

dividend history of infosys

The Share price of Infosys is 678.95 (BSE), and its average dividend growth rate is 6.90%, computed from the above table, and it paid last dividend 20.50 per share.

Therefore,

  • Cost of Equity Formula = {[20.50(1+6.90%)]/678.95} +6.90%
  • Cost of Equity Formula = 10.13%

Method #2 – Cost of Equity Formula using CAPM Model

Below is the formula of the Cost of Equity using the Capital Asset Pricing Model.

cost of equity formula2

Where,

  • R(f) = Risk-Free Rate of Return
  • β = Beta of the stock
  • E(m) = Market Rate of Return
  • [E(m)-R(f)] = equity risk premium

The capital asset pricing model (CAPM), however, can be used on n number of stock, even if they are not paying dividends. With that said, the logic behind CAPM is rather complicated, which suggests the cost of equity (Ke) is based on the stock’s volatility, which is computed by Beta and level of risk compared to the general market, i.e., the equity market risk premium which is nothing but a differential of Market Return and Risk-Free Rate.

In the CAPM equation, the risk-free rate (Rf) is the rate of return paid on risk-free investments like Government bonds or Treasuries. Beta, a measure of risk, can be calculated as a regression on the company’s market price. The higher the volatility goes, the higher the beta will come, and its relative risk compared to the general stock market. The market rate of return Em(r) is the average market rate, which has generally been assumed to be eleven to twelve % over the past eighty years. In general, a company with a high beta will have a high degree of risk and will pay more for equity.

Example #1

Below, inputs have been arrived for the three companies, calculate its cost of equity.

cost of equity formula example2.1

Solution:

First, we will calculate the equity risk premium, which is the difference between Market Return and Risk-Free Return Rate, i.e. [E(m) – R(f)]

cost of equity formula excel2.2

Then we will calculate cost of equity using CAPM i.e. Rf + β [E(m) – R(f)]  i.e. Risk-free rate + Beta(Equity Risk Premium).

Continuing the same formula as per above for all the company, we will get the cost of equity.

cost of equity formula excel2.4

So, the cost of equity for X, Y, and Z comes to 7.44%, 6.93%, and 8.20%, respectively.

Example #2 – TCS Cost of Equity using the CAPM Model

Let’s try the calculation of the cost of equity for TCS through CAPM Model.

For the time being, we will take 10-year Govt Bond yield as Risk-Free Rate as 7.46%

10-year Govt Bond yeild

Source: https://countryeconomy.com

Secondly, we need to come up to Equity Risk Premium,

Equity Risk Premium table

Source: http://pages.stern.nyu.edu/

For India, Equity Risk Premium is 7.27%.

Now we need Beta for TCS, which we have taken from Yahoo finance India.

Beta for TCS

Source: https://in.finance.yahoo.com/

So the cost of equity (Ke) for TCS will be-

  • Cost of Equity Formula = Rf + β [E(m) – R(f)]
  • Cost of Equity Formula= 7.46% + 1.13 * (7.27%)
  • Cost of Equity Formula= 15.68%

Cost of Equity Calculations

You can use the following Cost of Equity Formula Calculator.

Dividend per Share
Market price per Share
Growth Rate of Dividends
Cost of Equity Formula =
 

Cost of Equity Formula = =
Dividend per Share
+ Growth Rate of Dividends =
Market price per Share
0
+0 = 0
0

Relevance and Use

  • A firm uses a cost of equity (Ke) to assess the relative attractiveness of its opportunities in the form of investments, including both external projects and internal acquisition. Companies will typically use a combination of debt and equity financing, with equity capital is proving to be more expensive.
  • Investors willing to invest in stock also use a cost of equity to find whether the company is earning a rate of return greater than it, less than it, or equal to that rate.
  • Equity Analyst, Research Analyst, Buy or sell side Analyst, etc. who are majorly involve in financing modeling and issue research reports uses the cost of equity to arrive at the valuation of the companies they follow and then accordingly advise whether the stock is over or under value and then take an investment decision based on that.
  • There are many other methods also used to compute the cost of equity, which are running a regression analysis, multi-factor model, survey method, etc.

Cost of Equity Formula in Excel (with excel template)

Now let us take the case mentioned in the above Cost of Equity Formula Example #1 to illustrate the same in the excel template below.

Suppose a company named XYZ is a regularly paying dividend company. Its stock price is currently trading at 20 and expects to pay a dividend of 3.20 next year has the following dividend payment history.

In the below-given table is the data for the calculation of the cost of equity.

cost of equity formula excel1.6

In the below given excel template, we have used the calculation of Cost of Equity Equation to find the Cost of Equity.

cost of equity formula excel1.4

So the calculation of the Cost of equity will be-

cost of equity formula excel1.5

Cost of Equity Formula Video

Recommended Articles:

This article has been a guide to the Cost of Equity Formula. Here we learn the two methods to calculate the cost of equity 1) for dividend-paying companies 2) using CAPM Model along with practical examples and concepts. You may learn more about valuations from the following articles –

  • Equity Formula
  • What is Equity Financing?
  • Beta Coefficient
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

Login

Forgot Password?

WallStreetMojo

Download Cost of Equity Formula Excel Template

New Year Offer - Investment Banking Training (117 Courses, 25+ Projects) View More