Buying Alphabet/Google After Reviewing Price Target

main image

During my routine review of the fair value targets for Watch List stocks, I noticed there was a bug in my spreadsheet for the calculation of Google's (GOOG) fair value target. For terminal value, I was discounting by the free cash flow margin rate instead of the discount. This led to a quite substantial under-estimation of the company's worth based on free cash flows.

How substantial? Well, consider that the free cash flow margin target for Google is 28.5%, while the discount rate is MUCH lower, at just 10.25%. The previous fair value target was $127, which frankly had always confused me a bit because most analyst targets are well into the $200's. After fixing the DFCF calculation, my fair value more than doubles to $291 per share.

With the stock trading right around $200, that makes Alphabet/Google stock a pretty attractive buy right now, trading more than 30% under the new fair value assignment. I'm adding it to the Buy List today, and kicking myself for not having added it earlier this year. We would have had a nice gain by now.

As for the qualitative factors, not much has changed since the initial review. Google is still one of a handful of great American tech companies. It has a ridiculous 9 products with over 1 billion users. Its search engine is completely dominant, a verb unto itself. YouTube is the #1 streaming video service (by far). Chrome is the leading web browser on the open web. Android/Google Play are #1 in smartphone ecosystems. The list goes on, simply put, Google is a absolute no brainer for a "green dot" stock.

With this price fix, I've gone back and reviewed ALL of the other Watch List and owned stocks and didn't find any similar fair value bugs. I think we are good!

Watch List

S 18.10%
NTNX 22.76%
VEEV 17.64%
PSTG 48.00%
CRWD 85.74%
SEMR -7.52%
WDAY 15.98%
INTU 30.64%
SNOW 19.77%
SE 54.88%
PINS 4.48%
CMG 96.36%
TSM 0.61%

Buy List

GOOG -31.90%
NYAX -60.49%
ASR -27.51%
HRMY -51.38%
YOU -47.02%
MELI -27.17%
ADBE -28.78%

Hold List

MSFT -18.49%
ODD -13.46%
FLYW 9.77%
CELH -3.31%
TOST 35.51%
CPNG 0.43%
HIMS 11.61%
PAYC -19.98%
MNDY 30.16%
GLBE 21.43%
ZS 29.37%
V -12.50%
ADSK 14.19%
NOW 56.28%
ABNB -20.84%
FTNT 5.55%
TEAM 24.15%