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

WDAY -13.18%
VEEV 12.52%
PSTG -7.13%
INTU 14.19%
CMG 31.78%
RDDT 7.17%
NTNX 17.22%
CRWD 76.14%
SE 19.26%
SNOW 5.28%
APPF 6.95%

Buy List

PINS -37.54%
ASML -25.06%
SEMR -37.55%
TSM -43.44%
ZETA -32.89%
GOOG -51.47%
NYAX -30.39%
MSFT -31.81%
ODD -32.30%
ASR -26.98%
FLYW -44.52%
HRMY -60.41%
YOU -37.20%
ABNB -33.55%
MELI -26.26%
ADBE -45.26%

Hold List

VTEX -17.92%
CELH 49.08%
TOST 16.30%
CPNG -14.83%
HIMS -23.69%
PAYC -21.14%
MNDY 7.35%
GLBE -24.43%
ZS 23.06%
V -7.38%
ADSK -2.06%
NOW -1.85%
FTNT -4.90%
TEAM -8.65%