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

APPF 4.30%
CMG 40.33%
PSTG -1.39%
WDAY -5.41%
VEEV 19.23%
INTU 20.20%
RDDT 16.57%
NTNX 27.22%
CRWD 95.83%
SE 32.72%
SNOW 13.92%

Buy List

PINS -38.24%
SEMR -33.68%
TSM -40.25%
ZETA -27.44%
GOOG -50.34%
NYAX -30.24%
MSFT -28.00%
FLYW -39.29%
HRMY -59.63%
YOU -39.80%
ABNB -31.51%
ADBE -41.68%

Hold List

ASML -23.91%
VTEX -13.76%
ODD -6.91%
ASR -24.09%
CELH 39.84%
TOST 18.60%
CPNG -11.81%
HIMS -5.43%
PAYC -18.56%
MNDY 21.64%
GLBE -21.93%
ZS 38.75%
V -4.82%
ADSK 1.57%
NOW 15.34%
MELI -19.68%
FTNT 1.73%
TEAM 0.14%