# Microsoft Stock Analysis: Can Cost Of Equity Be Too High Or Too Low?

• Microsoft stock analysis reveals its cost of equity could be as high as 30%, using the dividend capitalization model.
• The Capital Asset Pricing Model (CAPM) would lead to a much lower number.
• Here's a look at the two commonly used methods using Microsoft as an example.

Cost of equity is the required rate of return a shareholder expects to get on an equity investment. Is it possible that a rate of return which one shareholder requires, could seem high or low to another shareholder? I think that is very much possible. And hence, the argument related to cost of equity arises, on whether it is too high, too low or just what is expected.

There are two best known ways to calculate Cost of Equity; the dividend capitalization model and the Capital Asset Pricing Model (CAPM).

## Dividend Capitalization Model:

It is the simpler way to calculate cost of equity relative to CAPM. According to this model,

Cost of Equity = Dividend growth rate (g) + Expected dividend yield

Where, sustainable dividend growth rate is calculated using PRAT model, i.e.

g = Profit Margin (P) x Retention Rate (R) x Asset Turnover (A) x  Financial Leverage (T)

Seeing the inputs for cost of equity, we can safely assume that this model is suitable only for companies with stable dividend policy. The benefit of this model is that it uses the inputs from company's financial statement, which tend to give a better picture.

However, this model could lead to ridiculously high cost of equity. Like after reading my recent post, Microsoft earnings analysis, a fellow financial analyst was amazed to see a cost of equity of 30%. Well, my answer was, "the company's financials say so!"

When I used the dividend capitalization model and the growth rate estimates from PRAT model (28.09% and declining), my mean value came out to be \$ 48.50.

Let us see what would have happened if I would have taken the CAPM route.

## Capital Asset Pricing Model (CAPM):

CAPM is a widely used method to calculate the required rate of return. It is suitable for companies which do not pay dividend or have volatile dividend policy. According to CAPM, required rate of return is calculated using the inputs from the market.

Re = Risk free rate + Beta x (Expected market return - Risk free rate)

Now, I calculated risk free rate using the average US 10 year Treasury yield rates over the last 10 years, to accommodate for almost two economic cycles. Beta was calculated using 6 year monthly data of Microsoft stock price and S&P 500.

Since, it's a little difficult to know what exactly expected market return is, I used historical price for S&P 500 to know what shareholders got out of it in last 6 years. CAGR for S&P 500 calculated from 6 year monthly data was 17%. I assumed that this would be expected in future too.

Applying the CAPM formula,

Re = 3.27% + 0.94 x (17%-3.27%) = 16%

As you can see, there is a significant difference between the required rate of return calculated from the dividend capitalization model (30%) and CAPM (16%). However, using the low discount rate from CAPM (16%) and high growth rate estimates from PRAT model (28.09% and declining), would have given me an absurdly high stock value. Which in Microsoft's case was nearly \$ 105, over 120% upside potential!

When I used CAPM calculated Cost of Equity (16%) and growth rate estimates from Yahoo finance analyst estimates, I got the fair value estimate as \$44.41. I believe if we are using market inputs for calculating cost of equity, we should as well use the growth rate estimates from the market to get to the fair value estimate of a stock.

All in all, in case of valuation, yearly growth rates play a role as important as the cost of equity. Hence, I rest my case by stating that there is nothing wrong with using cost of equity too high or too low but they should be used in conjunction with relevant growth rate estimates to give a price valuation which can be called fair value estimate.

You can check out Amigobulls' Microsoft stock analysis video for a quick look at key fundamentals.

Cover Image courtesy Stuart Miles at FreeDigitalPhotos.net

5 2
Is this article helpful ?

on Amigobulls :

The views expressed in the article are of individual authors and are not necessarily supported by Amigobulls.We do not hold any stake in the aforesaid stocks. Please read our detailed disclaimer.

Amigobulls Disclosures & Disclaimers:

This post has been submitted by an independent external contributor. This author may or may not hold any positions in the stocks discussed. Neither Amigobulls, nor any members of its staff hold positions in any of the stocks discussed in this post. Amigobulls has not verified the author’s positions in the stocks discussed, and does not provide any guarantees in this regard. The author may be paid by Amigobulls for this contribution, under the paid contributors program. However, Amigobulls does not guarantee the authenticity or accuracy of the information provided by the author in this post.

The author may not be a qualified investment advisor. The opinions stated in the post should not be treated as investment advice. Buying and selling of securities carries the risk of monetary losses. Readers/Viewers are advised to carry out their own due diligence and consult their investment advisors before making any investment decisions.

Amigobulls does not have any business relationship with any of the companies covered in this post. This post represents the views of the author/contributor and may not reflect the views of Amigobulls.

show more

## Comments on this article and MSFT stock

Do share this awesome post