Sorry, I see a few posts on this, but I don’t see my question asked!
So while plotting historical P/E of Alphabet, as per the video, I realised in 2017 the provision for taxes was abnormally high, and the 10-k cited Dec 2017 tax law changes as the reason. So may I ask if I can omit the 2017 value and use the average of 2016 and 2018 instead, then I decided to give it a 20% haircut to be conservative. This flattens out the standard deviation somewhat (using acutal values, its ~ 17 and with the modification it is ~9).
I also valued it by P/CF.
Overall by both valuation methods, I feel that Alphabet is currently undervalued, with margin of safety of 19% from average P/CF (2,763) and 38% from average P/E (3,610). Is that roughly what IQ is getting also?
Current price 2234 on 4 Jul.
I adjusted the tax figure to get a rough estimated EPS for 2017 to plot a proper chart. I looked back at the average tax percentage of the previous year to assess the possible tax in 2017. Alternatively, you can do the method that you had just mentioned.
I use PE to calculate the intrinsic value of Alphabet; my MOS is about 35% which is close to your 38%.
Good job, and keep it up :)
Please login or Register to submit your answer