Stock Profile
Click on "Clear Sheets" clear previous data
Clear Sheets Click on "Refresh Data" to obtain data of current symbol
Name Google
Ticker GOOG
Exchange Nasdaq
Sheet Revision 2
Version 1.4
Google
Big 5
Free Cash Flow
Average ROIC Sales Growth EPS Growth BVPS Growth
Growth
1 14.5% 24.0% 28.9% 27.0% -17.0%
5 13.4% 36.7% 39.3% 35.0% 43.2%
9 13.2% 91.1% 105.6% Invalid Data N/A
Sticker Price Payback Time
EPS (ttm) 26.3 EPS (ttm)
Current Stock Price
Estimated EPS Growth 18.0% 18.0%
Historical BVPS Growth 25.7% Estimated EPS Growth
User Input Growth Not Entered User Input Growth
Historical PE 20.3 20.3 Payback Time
PE from EPS Growth 36
User Input PE Not Entered
10-Year EPS 137.65
Sticker Price 690.71
Entry Price 345.35
Years to
Repay Debt
0.0
26.3
$624.22
18.0%
Not Entered
9.2 Years
Big 5 Numbers
"Find Cell Positions" is same as the "Find Balance Sheet" and "Find Book Value" bu
Summary
Average ROIC Sales Growth EPS Growth BVPS Growth
1 14.5% 24.0% 28.9% 27.0%
5 13.4% 36.7% 39.3% 35.0%
9 13.2% 91.1% 105.6% Invalid Data
Year Ago ROIC Sales Growth EPS Growth BVPS Growth
1 14.5% 24.0% 28.9% 27.0%
2 14.1% 8.5% 53.3% 26.4%
3 10.8% 31.3% 0.2% 23.7%
4 13.7% 56.5% 33.7% 31.3%
5 13.9% 72.8% 98.0% 71.6%
6 10.6% 92.5% 243.8% 193.0%
7 8.4% 117.6% 256.1% 192.5%
8 5.3% 233.5% -8.9% 220.5%
9 27.6% 408.5% 1025.0% Invalid Data
ROIC
Year Ago Net Income NOPAT Long Term Debt Equity
1 8505 6700.24 0 $46,241.50
2 6520.45 5072.91 0 $36,006.74
3 4226.86 3052.22 0 $28,236.11
4 4203.72 3114.54 0 $22,692.32
5 3077.45 2361.02 0 $17,041.35
6 1465.4 1002.63 0 $9,417.02
7 399.12 244.98 0 $2,927.89
8 105.65 32.20 1.99 $603.38
9 99.66 53.71 6.51 $188.25
10 6.99 4.85 0 Invalid Data
Sales
Year Ago Sales Sales Growth
1 29321 24.0%
2 23650.56 8.5%
3 21795.55 31.3%
4 16593.99 56.5%
5 10604.92 72.8%
6 6138.56 92.5%
7 3189.22 117.6%
8 1465.93 233.5%
9 439.51 408.5%
10 86.43 N/A
EPS
Year Ago EPS EPS Growth
1 26.31 28.9%
2 20.41 53.3%
3 13.31 0.2%
4 13.29 33.7%
5 9.94 98.0%
6 5.02 243.8%
7 1.46 256.1%
8 0.41 -8.9%
9 0.45 1025.0%
10 0.04 N/A
BVPS
Year Ago BVPS BVPS Growth
1 $143.92 27.0%
2 $113.30 26.4%
3 $89.61 23.7%
4 $72.43 31.3%
5 $55.15 71.6%
6 $32.14 193.0%
7 $10.97 192.5%
8 $3.75 220.5%
9 $1.17 Invalid Data
10 Invalid Data N/A
Free Cash Flow
Year Ago Cash from Ops Capital Expenditures Cash Flow Free Cash Flow Growth
1 11081 -4018 7,063.00 -17.0%
2 9316.2 -809.89 8,506.31 54.8%
3 7852.86 -2358.46 5,494.40 62.9%
4 5775.41 -2402.84 3,372.57 101.0%
5 3580.51 -1902.8 1,677.71 N/A
Debt
Year Ago Cash Flow Long Term Debt Years to Pay Back
1 7,063.00 0 0.0
2 8,506.31 0 0.0
3 5,494.40 0 0.0
4 3,372.57 0 0.0
5 1,677.71 0 0.0
6 N/A 0 N/A
7 N/A 0 N/A
8 N/A 1.99 N/A
9 N/A 6.51 N/A
10 N/A 0 N/A
Find Balance Sheet" and "Find Book Value" buttons on the previous sheets.
Warnings
Free Cash Flow Growth Years to Repay Debt 1
-17.0% 0.0 2
43.2% 3
N/A 4
Free Cash Flow Growth 10%
-17.0% 10%
54.8% 10%
62.9% 10%
101.0% 10%
N/A 10%
N/A 10%
N/A 10%
N/A 10%
N/A 10%
ROIC
Sales Growth
EPS Growth
BVPS Growth
ROIC
14.5% Free Cash Flow Growth
14.1% 10%
10.8%
13.7%
13.9%
10.6%
8.4%
5.3%
27.6%
9 8 7 6 5
Invalid Data
Warnings
Pass
Pass
Pass
Pass
60.0%
50.0%
40.0%
30.0%
20.0%
10.0%
0.0%
5 4 3 2 1
-10.0%
-20.0%
-30.0%
Sticker Price
EPS (ttm) 26.3
Estimated EPS Growth 18.0% 18.0%
Historical BVPS Growth 25.7%
User Input Growth
Historical PE 20.3 20.3
PE from EPS Growth 36
User Input PE
10-Year EPS 137.65
Sticker Price 690.71
Entry Price 345.35
BVPS Growth
Year Ago BVPS BVPS Growth
1 $143.92 27.0%
2 $113.30 26.4%
3 $89.61 23.7%
4 $72.43 31.3%
5 $55.15 71.6%
6 $32.14 193.0%
7 $10.97 192.5%
8 $3.75 220.5%
9 $1.17 Invalid Data
10 Invalid Data N/A
Average BVPS Growth
1-Year 27.0%
3-Year Avg 25.7%
5-Year Avg 35.0%
10-Year Avg Error
PE
Year Ago PE
1 20.3
2 21.6
3 35.1
4 40.6
5 41.4
6 55.7
7 104.1
8 NA
9 NA
10 NA
Average PE
1-Year 20.3
3-Year Avg 25.66666667
5-Year Avg 31.8
10-Year Avg 45.54285714
Payback Time
EPS (ttm) 26.3
Current Stock Price $624.22
Estimated EPS Growth 18.0%
User Input Growth
Payback Time 9.2 Years
EPS - For Reference Only
Cummulative
Year in Future EPS Earnings
1 $31.03 $31.03
2 $36.62 $67.65
3 $43.21 $110.87
4 $50.99 $161.86
5 $60.17 $222.02
6 $71.00 $293.02
7 $83.78 $376.80
8 $98.86 $475.66
9 $116.65 $592.31
10 $137.65 $729.96
11 $162.43 $892.39
12 $191.66 $1,084.05
13 $226.16 $1,310.21
14 $266.87 $1,577.09
15 $314.91 $1,892.00
16 $371.59 $2,263.59
17 $438.48 $2,702.07
18 $517.41 $3,219.48
19 $610.54 $3,830.02
20 $720.44 $4,550.45
21 $850.12 $5,400.57
22 $1,003.14 $6,403.70
23 $1,183.70 $7,587.40
24 $1,396.77 $8,984.17
25 $1,648.18 $10,632.36
Stock Price
URL http://investing.money.msn.com/investments/stock-price?symbol=GOOG
Stock Price $ 624.22
Data
Symbol Value ($)
Previous Close 624.22
Open 621.25
Day's High 627.25
Day's Low 620.28
Volume 1.48 Mil
Avg Daily Vol (13 Wks) 2.42 Mil
Bid 615.58
Bid Size 100
Ask 626.5
Ask Size 300
52-Wk High 642.96
52-Wk Low 433.63
Dividend Rate NA
Yield NA
Avg Analyst Rating Moderate Buy
StockScouter Rating 9
10-Year Statement
URL http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol=GOOG
Income Statement 15
Fix "Millions" Fix "Billions" Balance Sheet 27
Click on "Find Balance Sheet Start" to find the start of balance sheet section.
Click on "Fix 'millions'" or "Fix 'billions'" to fix numbers under "Shares Outstanding".
Data
Income Statement - 10 Year Summary (in Millions)
Sales EBIT Depreciation Total Net Income
12-Oct 29,321.00 10,796.00 1,381.00 8,505.00
12-Sep 23,650.56 8,381.19 1,506.03 6,520.45
12-Aug 21,795.55 5,853.60 1,491.94 4,226.86
12-Jul 16,593.99 5,673.98 965.94 4,203.72
12-Jun 10,604.92 4,011.04 568.63 3,077.45
12-May 6,138.56 2,141.68 293.81 1,465.40
12-Apr 3,189.22 650.23 148.47 399.12
12-Mar 1,465.93 346.65 50.19 105.65
12-Feb 439.51 184.92 18.03 99.66
12-Jan 86.43 10.07 10.03 6.99
Balance Sheet - 10 Year Summary (in Millions)
Current Assets Current Liabilities Long Term Debt Shares Outstanding
12-Oct 57,851.00 11,610.00 0 321.3
12-Sep 40,496.78 4,492.55 0 317.8
12-Aug 31,767.58 3,528.71 0 315.1
12-Jul 25,335.81 2,646.13 0 313.3
12-Jun 18,473.35 1,433.51 0 309
12-May 10,271.81 852.86 0 293
12-Apr 3,313.35 384.30 0 266.9
12-Mar 871.46 268.82 1.99 160.9
12-Feb 286.89 99.07 6.51 160.9
12-Jan 0.00 0.00 0 0
/results/statemnt.aspx?Symbol=GOOG&lstStatement=10YearSummary&stmtView=Ann
EPS Tax Rate (%)
26.31 21.22
20.41 22.2
13.31 27.79
13.29 25.91
9.94 23.28
5.02 31.58
1.46 38.62
0.41 69.52
0.45 46.11
0.04 30.62
10-Year Ratios
URL http://moneycentral.msn.com/investor/invsub/results/compare.asp?Page=TenYearSummary&Symbol=GOOG
Avg PE 10
Book Value 22
Click on "Fix 'CAD" if stock is Canadian and has "CAD" in any of the columns.
Click on "Find Book Value" to find the start of the BVPS section
Data
Avg P/E Price/ Sales Price/ Book Net Profit Margin (%)
12-Oct 20.3 6.55 4.13 29
12-Sep 21.6 8.37 5.47 27.6
12-Aug 35.1 4.48 3.43 19.4
12-Jul 40.6 13.18 9.55 25.3
12-Jun 41.4 13.44 8.35 29
12-May 55.7 19.73 12.91 23.9
12-Apr 104.1 16.49 17.57 12.5
12-Mar NA NA NA 7.2
12-Feb NA NA NA 22.7
12-Jan NA NA NA 8.1
Book Value/ Share Debt/ Equity Return on Equity (%) Return on Assets (%)
12-Oct $143.92 0.07 18.4 14.7
12-Sep $113.30 0 18.1 16.1
12-Aug $89.61 0 15 13.3
12-Jul $72.43 0 18.5 16.6
12-Jun $55.15 0 18.1 16.7
12-May $32.14 0 15.6 14.3
12-Apr $10.97 0 13.6 12
12-Mar $3.75 0.01 17.5 12.1
12-Feb $1.17 0.06 53.1 34.7
12-Jan NA 0 NA NA
Financi
al data
in U.S.
dollars
asp?Page=TenYearSummary&Symbol=GOOG
Fix "CAD"
Interest Coverage
NA
NA
NA
NA
NA
2599.6
742.7
177.4
72.6
6.2
Cash Flow
URL http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol=GOOG&lstStatement=Cas
Data
2010 2009 2008 2007 2006
Period End Date 12/31/2010 12/31/2009 12/31/2008 12/31/2007 12/31/2006
Period Length 12 Months 12 Months 12 Months 12 Months 12 Months
Stmt Source 10-K 10-K 10-K 10-K 10-K
Stmt Source Date 11/2/2011 12/2/2010 02/13/2009 02/15/2008 1/3/2007
Stmt Update Type Updated Updated Updated Updated Updated
Net Income/Starting Line 8,505.00 6,520.45 4,226.86 4,203.72 3,077.45
Depreciation/Depletion 1,067.00 1,240.03 1,212.24 807.74 494.43
Amortization 329 284.28 287.65 159.92 77.51
Deferred Taxes 9.00 -268.06 -224.65 -164.21 0
Non-Cash Items 1,270.00 1,053.52 2,023.53 449.7 -111.16
Unusual Items 0 0 1,094.76 0 0
Purchased R&D 0 0 0 0 10.8
Other Non-Cash Items 1,270.00 1,053.52 928.77 449.70 -121.96
Changes in Working Capital -99.00 485.99 327.23 318.55 42.28
Accounts Receivable -1,129.00 -504.04 -334.46 -837.25 -624.01
Prepaid Expenses -414.00 262.04 -147.13 -298.69 -289.16
Accounts Payable 272.00 33.64 -211.54 70.14 95.40
Accrued Expenses 959.00 400.81 352.91 569.22 430.83
Taxes Payable 102.00 217.48 626.03 744.80 398.41
Other Liabilities 111.00 76.07 41.43 70.33 30.8
Cash from Operating Activities 11,081.00 9,316.20 7,852.86 5,775.41 3,580.51
Capital Expenditures -4,018.00 -809.89 -2,358.46 -2,402.84 -1,902.80
Purchase of Fixed Assets -4,018.00 -809.89 -2,358.46 -2,402.84 -1,902.80
Other Investing Cash Flow Items, Total -6,662.00 -7,209.32 -2,960.96 -1,278.75 -4,996.35
Acquisition of Business -1,067.00 -108.02 -3,320.30 -906.65 -402.45
Sale/Maturity of Investment 37,099.00 22,102.87 15,762.80 15,659.47 23,107.13
Investment, Net -750.00 0.00 0.00 0.00 0.00
Purchase of Investments -44,305.00 -29,204.16 -15,403.46 -16,031.57 -27,701.04
Other Investing Cash Flow 2,361.00 0.00 0.00 0.00 0.00
Cash from Investing Activities -10,680.00 -8,019.21 -5,319.42 -3,681.59 -6,899.15
Financing Cash Flow Items 94 90.27 159.09 379.21 581.73
Other Financing Cash Flow 94 90.27 159.09 379.21 581.73
Total Cash Dividends Paid 0.00 0 0.00 0 0.00
Issuance (Retirement) of Stock, Net -507.00 143.14 -71.52 23.86 2,384.67
Issuance (Retirement) of Debt, Net 3,463.00 0 0 0 0.00
Cash from Financing Activities 3,050.00 233.41 87.57 403.07 2,966.40
Foreign Exchange Effects -19.00 10.51 -45.92 40.03 19.74
Net Change in Cash 3,432.00 1,540.92 2,575.08 2,536.92 -332.5
Net Cash - Beginning Balance 10,198.00 8,656.67 6,081.59 3,544.67 3,877.17
Net Cash - Ending Balance 13,630.00 10,197.59 8,656.67 6,081.59 3,544.67
atemnt.aspx?Symbol=GOOG&lstStatement=CashFlow&stmtView=Ann
Income Statement
URL http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol=GOOG&lstStatement=
Data
2010 Q4 2010 Q3 2010 Q2 2010 Q1 2009 Q4
Period End Date 12/31/2010 09/30/2010 06/30/2010 03/31/2010 12/31/2009
Period Length 3 Months 3 Months 3 Months 3 Months 3 Months
Stmt Source 10-K 10-Q 10-Q 10-Q 10-K
Stmt Source Date 11/2/2011 10/29/2010 07/30/2010 5/5/2010 12/2/2010
Stmt Update Type Updated Updated Updated Updated Updated
Revenue 8,440.00 7,286.00 6,820.00 6,775.00 6,673.83
Total Revenue 8,440.00 7,286.00 6,820.00 6,775.00 6,673.83
Cost of Revenue, Total 2,946.00 2,552.00 2,467.00 2,452.00 2,408.40
Gross Profit 5,494.00 4,734.00 4,353.00 4,323.00 4,265.43
Selling/General/Administrative Expenses, Total 1,461.00 1,193.00 1,090.00 1,017.00 1,048.21
Research & Development 1,051.00 994 898 818 736.23
Depreciation/Amortization 0 0 0 0 0
Interest Expense (Income), Net Operating 0 0 0 0 0
Unusual Expense (Income) 0 0 0 0 0
Other Operating Expenses, Total 0 0 0 0 0
Operating Income 2,982.00 2,547.00 2,365.00 2,488.00 2,480.98
Interest Income (Expense), Net Non-Operating 0 0 0 0 0
Gain (Loss) on Sale of Assets 0 0 0 0 0
Other, Net 3 3 -4 3 4.88
Income Before Tax 3,142.00 2,714.00 2,434.00 2,506.00 2,568.67
Income Tax - Total 599.00 547.00 594.00 551 594.57
Income After Tax 2,543.00 2,167.00 1,840.00 1,955.00 1,974.10
Minority Interest 0 0 0 0 0
Equity In Affiliates 0 0 0 0 0
U.S. GAAP Adjustment 0 0 0 0 0
Net Income Before Extra. Items 2,543.00 2,167.00 1,840.00 1,955.00 1,974.10
Total Extraordinary Items 0 0 0 0 0
Net Income 2,543.00 2,167.00 1,840.00 1,955.00 1,974.10
Total Adjustments to Net Income 0 0 0 0 0
Preferred Dividends 0 0 0 0 0
General Partners' Distributions 0 0 0 0 0
Basic Weighted Average Shares 319.95 318.62 318.35 317.9 317.24
Basic EPS Excluding Extraordinary Items 7.95 6.8 5.78 6.15 6.22
Basic EPS Including Extraordinary Items 7.95 6.8 5.78 6.15 6.22
Diluted Weighted Average Shares 325.54 322.38 322.49 322.61 322.16
Diluted EPS Excluding Extrordinary Items 7.81 6.72 5.71 6.06 6.13
Diluted EPS Including Extraordinary Items 7.81 6.72 5.71 6.06 6.13
Dividends per Share - Common Stock Primary Issue 0 0 0 0 0
Gross Dividends - Common Stock 0 0 0 0 0
Depreciation, Supplemental 280 257 266 264 296.82
Normalized EBITDA 3,357.00 2,890.00 2,701.00 2,815.00 2,837.80
Normalized EBIT 2,982.00 2,547.00 2,365.00 2,488.00 2,480.98
Normalized Income Before Tax 3,142.00 2,714.00 2,434.00 2,506.00 2,568.67
Normalized Income After Taxes 2,543.00 2,167.00 1,840.00 1,955.00 1,974.10
Normalized Income Available to Common 2,543.00 2,167.00 1,840.00 1,955.00 1,974.10
Basic Normalized EPS 7.95 6.8 5.78 6.15 6.22
Diluted Normalized EPS 7.81 6.72 5.71 6.06 6.13
Amortization of Intangibles 95 86 70 63 60
Symbol=GOOG&lstStatement=Income&stmtView=Qtr
Earnings Estimates
URL http://moneycentral.msn.com/investor/invsub/analyst/earnest.asp?Page=EarningsGrowthRates&Symbol=GOOG
Data
Last 5 Years FY 2011 FY 2012 Next 5 Years 11 P/E
Company 48.30% 21.70% 18.30% 18.00% 24.3
Industry 18.70% 8.10% 24.80% 17.60% 4.5
S&P 500 -3.00% 46.80% 11.00% NA 15.9
Tutorial
Procedure
Step Action
1 When starting with a new stock, click on the "Stock" tab.
2 Click on "Clear Sheets" button to start with fresh sheet.
3 Type in Stock name, ticker, and stock exchange.
4 Click on "Refresh Data".
5 Click on "Sticker Price" tab.
If you find that the highlighted growth rate is too high/low, you can enter your own
6 growth number under the "User Input Growth" cell.
If you find that the highlighted PE is too high/low, you can enter your own PE under
7 the "User Input PE" cell.
8 Entry price is the price below which you can purchase the stock.
9 Click on "Summary" tab to view summary of results.
How do you calculate a growth rate if the starting number is a negative number?
1. If the oldest numbers are negative but get less negative in time, and then go positive and continue to grow consistently more
positive, this just indicates either a start up or a turnaround point years ago. If the first positive year was 6 years ago or more, then
go ahead and calculate the growth rate starting with the first positive year. If it was more recent than that, this is a Riskyz. Treat it
as such.
2. If there are negative numbers scattered through the 10 years, bail. This is an inconsistent business.
3. If a single negative year happens to fall on the 5 or the 3 yr calculation, shift to a positive year. For example, if 5 then go to 6, if 3
then go to 4. Don't forget to change the number of years in the calculator.
One negative year is not a deal killer. We're looking for consistency, and even great businesses can have a bad year. Often that's
when we want to be buyers -- because Mr. Market will get very depressed and sell it too cheap.
Cash Flow seems to be where the bouncy numbers are most common. As a reminder, here's how you calculate Free Cash Flow:
Free Cash Flow is defined as the cash the business has to work with to grow new business.
The right way to do Free Cash Flow is to take the Cash Flow from Operations number and subtract only the Capital Expenditures.
The balance is Free Cash Flow.
Cash Flow from Operations ($) - Capital Expenditures ($) = Free Cash Flow ($)
For businesses that are buying other businesses, MSN Money doesn't calculate it correctly (in my humble opinion). So if the other
three growth numbers are all awesome but Free Cash Flow is bad on MSN, look up the cash flow numbers in the SEC 10K filing to
see if the business bought other businesses. This takes a few minutes but it's worth it.
At MSN Money you have to click on the little blue arrow and open up the "Capital Expenditures" section to see "Purchase of Fixed
Assets" and "Purchase of Intangibles".
So you MSN users cannot use the "Capital Expenditures" line as/is. Open it up. Use the line that is called "Purchase of Fixed
Assets" for the number to subtract from "Cash from Operating Activities".
Continuously Compounded Interest
A(t) = Aoert - Continuously Compounded Interest
∫A(t) = Aoert dt
= (Aoert - Ao)/r
Current Stock Price = (Aoer Payback Time - Ao)/r, where Ao is EPS at year 0, r is EPS annual growth rate.
Find Payback Time by rearranging above equation.
Version 1.0 - May 13, 2010
# Tab Description
1 Official Release
Version 1.1 - May 19, 2010
# Tab Description
Implemented error handling to show "invalid data" for
1 Big 5 cells with errors.
Version 1.2 - October 23, 2010
# Tab Description
1 Stock Price Added this tab to allow for payback time calculation.
2 Payback Time Added this tab to allow for payback time calculation.
3 Tutorial Added steps to include payback time calculation.
Version 1.3 - November 17, 2010
# Tab Description
1 Sticker Price Fixed conditional formatting for cells B6 and B10
2 Payback Time Added User Input for EPS growth rate
3 Stock Price Added URL
4 Stock Revised "Clear Tabs" macro to include all input cells
Version 1.4 - February 16, 2011
# Tab Description
1 Implemented auto grab data from web.
Sticker Price / Ignore negative values for growth and P/E. Added cell
2 Summary to show which value is being used for calculation.
3 Tutorial Revised instructions.