Estimation of Stock’s Fair Value Price Range

monthly-dividend-portfolio-reviewIn my stock analysis process, I attempt to estimate the fair value of a given stock. I estimate the fair value range (instead of a one fair value). This estimation should be interpreted as the price I am willing to pay based on my risk profile and my investing objective. My fair value estimation does not necessarily attempt to determine the fair value based on value investing principles.


My process of determining the fair value captures the essence of “what is being priced by the market” and “historically what has been priced by the market”.

(I) NPV price based on 15 year DCF: I have discussed DCF based net present value pricing.

(II)  Average high yield price calculated based on past 10 years

I am attempting to estimate what would be current stock’s price based on its historical dividend payment standards. I measure this using yield. It is calculated as follows.

(i) For Year 1, I calculate the high yield in percentage.

[(Year 1 dividends) / (lowest stock price in Year 1)]


(ii) I continue to calculate this for Year 2, Year 3, and so on. Ideally, I would like to calculate this for at least past 10 years, but in many cases data is not easily available. I calculate for as many number of years as possible, and then make judgment call if it is worth digging more data.


(iii) I calculate average of ‘high yield’

[Year 1 high yield + Year 2 high yield + …..] / (number of years)]

This gives me 10 year average high yield.


(iv) I calculate the price based on this 10 year average high yield.

[(Current Dividends) / (10 year average high yield)]


(III) Pricing relative to 10 year average PE ratio

Here, I am attempting to estimate what would be current stock’s price based it’s historically market pricing.

(i) For Year 1, I calculate the average PE ratio.

[(Year 1 average stock price) / (adjusted EPS)]


(ii) I continue to calculate this for Year 2, Year 3, and so on. Ideally, I would like to calculate this for at least past 10 years, but in many cases data is not easily available. I calculate for as many number of years as possible, and then make judgment call if it is worth digging more data.


(iii) I calculate 10 year average PE ratio

[(Year 1 average PE + Year 2 average PE + …..) / (number of years)]


(iv) I calculate the relative price based on this 10 year average PE ratio.

[(Trailing Three Years Average EPS) x (10 year average PE ratio)]


(IV) Pricing based on PE ratio of 12

This is very simple straight forward calculation.

[(Trailing Three Years Average EPS) x (PE ratio of 12)]


(V) Graham number

Graham number is the formula Ben Graham used to calculate the “maximum” price one should pay for the stock. According this rule of thumb – the product of P/E ratio and price-to-book should not be more than 22.5 (P/E ratio of 15 x price-to-book value of 1.5). The 15 P/E came from the thought that Graham wanted his portfolio to have a yield that is equal yield to that of AA bond (during those days this yield being 7.5%). The inverse of this yield is 1 divided by 7.5%. This is approximately equal to 13.3, which Graham rounded up to 15. I calculate Graham number as follows:

Square Root [ (22.5) x (book value per share) x (EPS) ]

I have been investigating to use tangible book value in this formula. I may change this in future. But for now, I will continue to use book value. I have observed that it does not have any significant effect on my fair value range calculation.


Fair Value Range

At this point, I go on to calculate the fair value range.

High End = [ Average of above five criteria ]

Low End = [ (Average of above five criteria) – (0.5)x(Std Dev) ]

I hope this helps understand how I estimate fair value for my stock investments.

Don’t Miss my future “how to” articles.   Get it Free in Your Email  !









My Top Three Investing Mistakes Corporate India Continues to Dole Out Dividend Cash

8 Responses to “Estimation of Stock’s Fair Value Price Range”

  1. Mahesh says:

    Incredible Explanation. :) .

    Very less people are interested in educating novice investors about stock market.

    keep up the hard work.

  2. TIP Guy says:

    Mahesh,
    Thanks for stopping by and glad to know your visit was worthwhile.

    Hope to see you more often.

    Best Wishes,

  3. Supal Patel says:

    Great analysis. Can you please help me with following related questions:

    1) As all above analysis is data driven, what source(web site) you recommend to get all the data required for this analysis?

    2) Any idea why book values at different site (MoneyControl , rediff , BSE) are different? What is the authentic source for book value data?

    • TIP Guy says:

      Hello Supal,

      (1) I use moneycontrol to start the data collection (and then use 50% verification at rediff and 50% verification at company annual reports. I also add new information as necessary).

      (2) Honestly, I do not know why the difference. I can speculate it – may be due to different ways they calculate book values. Book values can be tangible book value or intangible book value depending upon how you calculate.

      (3) Book value is not the “only” parameter I use for my fair value calculation. In my calculations, it is one parameter along with four other parameters. Therefore, it is not very very significant for me. It is important to be consistent in using same approach rather than trying to be precise. I take it from company balance sheet (if not available then use money control value).

      Thanks for stopping by!

      Best Wishes,

  4. Arun says:

    Hi,
    Excellent – keep it up!

    I was curious about one thing: InWhen this analysis is rigorously applied to the universe of stocks, have you/do you miss out on potential multi-bagger? Sorry to be asking a Lynch-ish question to a Buffeter ;-)

    Rgds,
    Arun

    • TIP Guy says:

      Arun,

      If you haven’t already noticed, I like to go for consistency and sustainability. I tend to go for lower expected growths. This way I know the probability of success is much higher.

      Looking for that elusive multi-bagger has less probability. And may be I am not skilled at it.

      Plus, if you look at my portfolio, aren’t they multi-bagger? In my book, all on them are multi-bagger. Honestly, I just don’t know what multi-bagger really means.

      Best Wishes,

  5. Naveen says:

    Hi,

    Can you please let me know which site should I use to get previous 5/10 yrs data about the companies to import the data in excel file. Also if ay site provides forward PE, forward EPS values??

    Regds
    Naveen

    • TIP Guy says:

      Hello Naveen,

      I use moneycontrol. And then I verify randomly from rediff and annual reports. I spend about 30min to 45mins for verification. But it is one time only so worth it.

      I don’t know where to get forward looking PE or EPS values. I do not use readily available values for these parameters. In my DCF calculation, I use my own projections for both.

      Hope this helps.

      Best Wishes,

Leave a Reply




Spam protection by WP Captcha-Free

Visit blogadda.com to discover Indian blogs Link Listings Directory ~