Cost of Equity Formula

Cost of equity (Ke) formula is the method of calculating the return on what shareholders expect to get from their investments into the firm. One can calculate the equity cost by using the dividend discount approach formula or the CAPM model.

It is the way of computing the return that an organization gives its equity shareholders against the capital they provide to the company. It helps investors assess how profitable the investment is and allows the company to determine the cost of raising funds through the issue of equity. Based on this calculation, the entity decides whether to raise funds through equity or debt.

Cost of equity formula is used to compute the return that shareholders get from the equity investment in a Company. Similarly, the entity can also decide whether raising capital using equity is more costly or less costly than using debt capital.

It represents the return that the market can expect to receive from the equity investment in a business. This greatly influences the decision that investors take while buying stock. From the entity's point of view, this information helps them to save cost and maintain the company's financial strength to ensure growth and expansion.

The most used method of calculating the same is Capital Asset Pricing Model(CAPM) and the dividend discount model. Both the models are discussed in the article in details.

Let us understand how to use the cost of equity formula in finance.

Method #1 - Dividend Discount Model

Cost of Equity (K_e) = 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. Therefore, it is based on upcoming dividends. The logic behind the equation is that the company’s obligation to pay dividends is the cost of producing its shareholders. Therefore, the Ke, i.e., cost of equity. It is a limited model in its interpretation of costs.

Method #2 –   CAPM

Below is the cost of equity formula using the Capital Asset Pricing Model.

Where,

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

However, the cost of equity formula CAPM can be used on several stocks, 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 using the cost of equity formula beta and level of risk compared to the general market, i.e., the cost of equity formula 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, 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 11% to12 % over the past eighty years. A company with a cost of equity formula beta, which is high, will have a high risk and pay more for equity.

Let us look at the examples to understand the concept.

Calculating Cost Of Equity By Using Dividend Discount Model

Example #1

Let us try the cost of equity calculation with a first formula where we assume a company is paying regular dividends.

Suppose XYZ Co. is a regularly paying dividend company. Its stock price is currently trading at 20, and it expects to pay a dividend of 3.20 next year. The following is the dividend payment history. So, now, let us calculate the company's cost of equity.

Solution:

Let us first calculate the average growth rate of dividends. Then, continuing the same formula as per below will yield yearly growth rates.

So the growth rate for all the years will be-

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%

Hence

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

Example #2

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

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

Therefore,

• Cost of Equity Formula = {/678.95} +6.90%
• Cost of Equity Formula = 10.13%

CAPM Approach.

Calculation using cost of equity formula CAPM.

Example #1

Below, the three companies' inputs have arrived. Now we have to calculate their cost of equity.

Solution:

First, we will calculate the equity risk premium, which is the difference between market return and risk-free return rate, i.e.,

Then, we will calculate the cost of equity using CAPM, i.e., 

Rf + β i.e., Risk-free rate + Beta(Equity Risk Premium)

Continuing the same formula above for all the companies, we will get the cost of equity.

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

Example #2

Let us try calculating the cost of equity for TCS through the CAPM model. 

For the time being, we will take the 10-year government bond yield at a risk-free rate of 7.46%. 

Source: https://countryeconomy.com

Secondly, we need to come up with a cost of equity formula market risk premium.

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

For India, the Equity Risk Premium is 7.27%.

We need a beta for TCS, which we have taken from Yahoo finance India.

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

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

• Cost of Equity Formula = Rf + β
• Cost of Equity Formula= 7.46% + 1.13 * (7.27%)
• Cost of Equity Formula= 15.68%

• A firm uses a cost of equity (Ke) to assess the relative attractiveness of its opportunities in the form of investments, including external projects and internal acquisitions. Companies will typically use a combination of debt and equity financing, with equity capital 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 involved in financing modeling and issuing research reports, uses the cost of equity to arrive at the valuation of the companies they follow. Then, advise whether the stock is over or undervalued and then make an investment decision.
• Many other methods are also used to compute the cost of equity, which are running a regression analysis, multi-factor model, survey method, etc.

Let us take the case mentioned  in example no.1 to illustrate the same in cost of equity formula excel.

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

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

In the below given cost of equity formula excel  template, we have used the cost of equity equation calculation to find the cost of equity.

So the calculation of the cost of equity will be-