Google (GOOG): A hard Sell For Superior Long-Term Returns!


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:
























CAGR# of YearsStock Price
1010240.06
1510343.79
2010491.85
2310608.20
2510701.19
3010994.29


Assumptions and Basis:
  • 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:
















BetaRisk-Adjusted Discount Rate10-year CAGRStock Price
1.51429626.06
2.01734603.24
2.52040635.11




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…

Related Posts:

1. Google Chrome Web Browser Beta 1 User Experience - Review.




No comments :

Labels

401k ( 15 ) Abad Turtle Beach ( 1 ) Abrams Capital Management ( 5 ) Acoustic Electric Guitars ( 1 ) Acoustic Guitars ( 1 ) ACT ( 1 ) Activist ( 4 ) Address Change ( 2 ) Advanced Placement ( 4 ) air asia ( 2 ) airlines ( 2 ) Akre Capital Management ( 18 ) Alex Roepers ( 5 ) AP ( 4 ) apartments ( 2 ) Appaloosa ( 15 ) ARIUS ( 1 ) Arlington Value Capital ( 3 ) Atlantic Investment Management ( 5 ) Ayemenem ( 1 ) Bangalore ( 3 ) Bangkok ( 2 ) Bannerghatta National Park ( 1 ) barbuda ( 2 ) Battery Park ( 1 ) Baupost ( 2 ) Baupost Group ( 17 ) bay area ( 2 ) BDCs ( 3 ) Benjamin Graham ( 2 ) Benjamin Graham Model ( 2 ) Berijam Lake ( 2 ) Berkshire Hathaway ( 30 ) best sites ( 9 ) Bill & Melinda Gates Foundation ( 13 ) Bill Ackman ( 19 ) Bill Gates ( 14 ) Blue Ridge Capital ( 13 ) Blum Capital Partners ( 12 ) books ( 4 ) Boone Pickens ( 2 ) BP Capital Management ( 2 ) Brave Warrior ( 3 ) Brave Warrior Advisors ( 12 ) british honduras ( 2 ) Bruce Berkowitz ( 19 ) Bruce Fund ( 12 ) Camcorders ( 3 ) canada ( 4 ) cancun ( 3 ) CANROYs ( 7 ) Cantillon ( 12 ) carl icahn ( 9 ) Carl Ichan ( 8 ) casino ( 3 ) Casio ( 2 ) CBRE ( 2 ) CEF ( 2 ) Charles Akre ( 15 ) Charlie Munger ( 13 ) Chase Coleman ( 13 ) Chou Associates ( 18 ) Christmas gifts ( 7 ) Christopher H. Browne ( 7 ) Chuck Akre ( 13 ) Cisco ( 2 ) Class Action Settlements ( 2 ) CLEP ( 1 ) Coatue Management ( 13 ) Cochin ( 2 ) coin collecting ( 266 ) collectibles ( 266 ) Consumer Product Reviews ( 29 ) cook islands ( 2 ) coonoor ( 2 ) Covered Calls ( 2 ) credai ( 4 ) Daily Journal ( 13 ) Dalal Street ( 8 ) Dan Loeb ( 10 ) DAT ( 1 ) David Abrams ( 5 ) David Einhorn ( 22 ) David Swensen ( 17 ) David Tepper ( 15 ) David Winters ( 15 ) DCF ( 2 ) Digital Piano ( 3 ) Dinakar Singh ( 13 ) Donald Yacktman ( 10 ) dry bulk shipping ( 2 ) Duquesne ( 18 ) Education ( 37 ) Edward Lampert ( 14 ) Egerton Capital ( 13 ) Egypt ( 3 ) Elementary Education ( 10 ) Elementary School Textbooks ( 5 ) eReaders ( 2 ) Eric Mindich ( 13 ) ESL Investments ( 9 ) ESPP ( 6 ) ETF ( 2 ) ETN ( 2 ) Eton Park ( 13 ) Everyday Musings ( 58 ) Exam Prep ( 7 ) Exiting the rat race - how to? ( 19 ) EXPLORE ( 1 ) Fair Value Estimates ( 4 ) Fairfax Financial ( 4 ) Fairfax Financial Holdings ( 14 ) Fairholme ( 19 ) Fairpointe ( 13 ) Family Office ( 5 ) FD Laddering ( 1 ) Financial Independence ( 93 ) Fisher Asset Management ( 10 ) Flash Camcorders ( 3 ) flat ( 4 ) flats ( 2 ) Flip ( 3 ) Francis Chou ( 18 ) free ( 17 ) frugal ( 3 ) Frugal Living ( 34 ) Fund Holdings ( 755 ) futures ( 2 ) FVE ( 2 ) gambling ( 3 ) garmin ( 2 ) Genting ( 2 ) george soros ( 21 ) giveaway ( 15 ) Glenn Greenberg ( 16 ) Glenview Capital ( 10 ) GMAT ( 1 ) Google ( 2 ) Gotham Asset Management ( 7 ) gps ( 4 ) GRE ( 1 ) Greenlight Capital ( 22 ) Guitars ( 3 ) Half Marathon ( 2 ) Hawaii ( 2 ) Hedge Funds ( 774 ) HELOC ( 1 ) High School Education ( 7 ) High School Textbooks ( 6 ) HOA ( 3 ) hobby ( 17 ) holiday shopping ( 7 ) Holidays ( 3 ) Holyland ( 11 ) Home Improvement ( 2 ) home ownership ( 5 ) Homes ( 18 ) Homeschool ( 18 ) Houses ( 2 ) Housing ( 3 ) Hykon ( 2 ) Ian Cumming ( 15 ) Icahn Enterprises ( 6 ) india real estate ( 5 ) Infinuvo ( 6 ) Insurance ( 2 ) invesco ( 17 ) investing strategies ( 2 ) Investment Portfolio ( 94 ) Investment Research ( 10 ) Investments ( 7 ) iRobot ( 5 ) Irving Kahn ( 10 ) israel ( 5 ) Jason Maynard ( 10 ) Jefferies ( 2 ) Jeffrey Bruce ( 13 ) Jeffrey Ubben ( 12 ) Jerusalem ( 2 ) Jim Chanos ( 13 ) Joel Greenblatt ( 7 ) John Armitage ( 13 ) John Griffin ( 13 ) John Paulson ( 17 ) Joho Capital ( 15 ) Jordan ( 3 ) Joseph Steinberg ( 9 ) Julian Robertson ( 4 ) Kahn Brothers ( 10 ) Kakkanad ( 4 ) Kanyakumari ( 2 ) Kawai ( 2 ) Ken Fisher ( 10 ) kerala real estate ( 5 ) Kids ( 49 ) Kids Yamaha ( 3 ) Kindle ( 2 ) kochi ( 8 ) Kodaikanal ( 2 ) Korg ( 2 ) Kraft ( 2 ) Kuala Lumpur ( 2 ) KWA ( 2 ) Kynikos ( 13 ) laptop ( 5 ) Larry Robbins ( 10 ) Las Vegas ( 2 ) Leon Cooperman ( 14 ) Leucadia ( 2 ) Leucadia National ( 13 ) Lone Pine Capital ( 9 ) long ( 6 ) long call ( 2 ) long puts ( 3 ) Lou Simpson ( 15 ) LSAT ( 1 ) Mahabalipuram ( 2 ) Malaysia ( 3 ) Marathon ( 2 ) Mark McGoldrick ( 10 ) Markel ( 13 ) Mason Hawkins ( 4 ) MCAT ( 1 ) Melinda Gates ( 7 ) memorabilia ( 266 ) MFP Investors ( 13 ) Michael Dell ( 15 ) Michael Price ( 13 ) Middle School Education ( 4 ) Middle School Textbooks ( 3 ) Mini Notebook ( 2 ) MODUS ( 1 ) Mohnish Pabrai ( 21 ) mortgage ( 2 ) Mount Kellett ( 10 ) MSD Capital ( 15 ) Music ( 6 ) Mutual Funds ( 5 ) mysore ( 2 ) Nelson Peltz ( 9 ) Netbook ( 3 ) Notebook ( 2 ) numismatics ( 266 ) O-Duster ( 1 ) Oahu ( 2 ) offers ( 2 ) Ole Andreas Halvorsen ( 10 ) Omega Advisors ( 14 ) online tax ( 3 ) ooty ( 2 ) Options ( 4 ) Pabrai Fund ( 17 ) passive income ( 7 ) pattaya ( 2 ) Paulson & Company ( 7 ) Paulson and Company ( 9 ) PEG ( 2 ) Pershing Square ( 19 ) Phil Fisher ( 5 ) philately ( 283 ) Philippe Laffont ( 13 ) Piano ( 9 ) PLAN Test ( 1 ) portfolio ( 4 ) Prem Watsa ( 17 ) product reviews ( 13 ) Property Taxes ( 2 ) PSAT ( 1 ) R2I ( 24 ) R2I Finances ( 3 ) R2I Housing ( 5 ) Raising Kids ( 41 ) Rat Race ( 15 ) RBS Partners ( 12 ) reading ( 5 ) real estate ( 6 ) Reducing Expenses ( 2 ) REIT ( 3 ) Retirement Portfolio ( 9 ) Reviews ( 81 ) Richard C. Blum ( 12 ) Robert Bruce ( 13 ) Robert Karr ( 15 ) Robotic Vacuum ( 4 ) Roland ( 2 ) Roomba ( 10 ) schooling ( 2 ) Sears ( 9 ) seeking alpha ( 2 ) Services - Reviews ( 33 ) Seth Klarman ( 19 ) Shipping ( 5 ) Shopping ( 3 ) short ( 5 ) short calls ( 2 ) short put ( 2 ) short puts ( 2 ) short selling ( 7 ) Ski ( 5 ) Sled ( 4 ) Solar Stocks ( 13 ) Soros Fund Management ( 14 ) Southeastern Asset Management ( 4 ) Southwest ( 2 ) spin-offs ( 2 ) SQ Advisors ( 15 ) stamp collecting ( 283 ) Stanley Druckenmiller ( 18 ) Statue of Liberty ( 2 ) Stephen Mandel ( 9 ) Stock Analysis ( 84 ) Stock Investments ( 4 ) Stock Portfolio Updates ( 6 ) stocks ( 3 ) summer ( 2 ) tax ( 5 ) TaxAct ( 2 ) TaxCut ( 1 ) Teacher's Editions ( 5 ) Technology ( 4 ) Test Prep ( 11 ) Thailand ( 3 ) Thekkady ( 2 ) theme park ( 2 ) Third Point ( 10 ) Thomas Gayner ( 13 ) Thyra Zerhusen ( 13 ) Tiger Cub ( 28 ) Tiger Global ( 14 ) Tiger Management ( 12 ) Time Square ( 2 ) TOEFL ( 1 ) TPG-Axon ( 13 ) Travel ( 278 ) Travel Reviews ( 82 ) Trian Fund Holdings ( 9 ) trip report ( 21 ) TurboTax ( 3 ) Tweedy Browne ( 10 ) Vacations ( 28 ) value investing ( 12 ) ValueAct ( 5 ) ValueAct Holdings ( 6 ) Vancouver ( 2 ) Video ( 3 ) Viking Global ( 10 ) Wallace Weitz ( 10 ) Warren Buffett ( 30 ) Wayanad ( 4 ) Weitz Investment Management ( 9 ) wilbur ross ( 17 ) William Von Mueffling ( 12 ) Wintergreen Advisors ( 15 ) Yacktman Asset Management ( 10 ) Yale Endowment ( 17 ) Yale University ( 7 ) Yamaha ( 7 ) YDP ( 1 ) YPG ( 1 )