The first step to valuing Google using fundamental analysis requires coming up with a number for the Compounded Annual earnings Growth Rate (CAGR). The table below looks at the growth rates priced in at different share prices, using the Discounted Cash Flow (DCF) calcuator at moneychimp:
Assumptions and Basis:
|CAGR||# of Years||Stock Price|
- Discount rate of 11.3%, set using the Capital Asset Pricing Model (CAPM) calculator, also at moneychimp with the following assumptions:
- Benchmark return-11%, Risk-free return-5%, Beta – 1.05
- Earnings in the last 12 months – 11.76
- Google earnings and beta taken from the Google finance site.
- Earnings growth will level off to 3% after the growth phase of 10 years in the table.
As made clear in the table, for Google stock to be worthy of the current market price, it has to grow earnings at 23% for 10 years. It is of immense value to assess the assumptions employed in the table. Specifically, beta (see definition) at 1.05 implies the return expectation to be only slightly better compared with the excess return (see definition) of the benchmark.
For Google to be a superior investment, the excess return compared to the benchmark needs to be elevated more which implies higher beta going forward. The following table manifests what Google’s CAGR will have to be, to justify the current price at higher beta levels:
|Beta||Risk-Adjusted Discount Rate||10-year CAGR||Stock Price|
A beta of 2.0 implies twice the excess return of the benchmark or an expected return of 17% (Risk-Free Return + Excess Return * 2 = 5 + (11-5) * 2). As the growth phase approaches maturity 10 years from now, Google will be bound to have earnings of $219.51/share ($11.76 earnings compounded over 10 years at 34%). Assuming an aggressive profit margin of 25%, Google’s projected revenue will have to approach $2.7 Trillion around 2017 (Earnings * Shares Outstanding * 4 = 219.51 * 312M * 4) . Extending the same calculation for a CAGR of 23% for 10 years, the earnings and the projected revenue will translate to $93.21/share and $1.16 Trillion respectively. To place these numbers in perspective, the projected nominal Gross Domestic Product (GDP) of the country as a whole in the 2017 timeframe is $21.5 Trillion, assuming nominal GDP growth rate will be around 5%, comparable to the last 10 years. Thus, Google revenue will have to be between 5.4% and 12.6% of US GDP 10 years from now, depending on the growth assumption of 23% and 34% respectively – a definite impasse.
The calculators used here are fairly basic and bypasses a number of other variables. The in-depth analysis done by Dr. Aswath Damodaran 9/2006 will definitely appeal to those financially oriented.
In the spirit of full disclosure, as posted, we sold out of Google in August at about 20% below the current price…
1. Google Chrome Web Browser Beta 1 User Experience - Review.