Docstoc

Start Up Stock Exchange

Document Sample
Start Up Stock Exchange Powered By Docstoc
					Stock Profile

                                    Click on "Clear Sheets" clear previous data
                     Clear Sheets

          Name Google
          Ticker GOOG
       Exchange Nasdaq




Sheet Revision   2
Stock Price


              Stock Price $   611.00 Manually enter current stock price
10-Year Statement

  Find Balance Sheet Start                                       URL http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol=GOOG&lst
                                                        Balance Sheet             23
  Fix "Millions"         Fix "Billions"


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".


Income Statement - 10
                                                                 Sales              EBIT          Depreciation Total Net Income     EPS
9-Dec                                                        23,650.56          8,381.19             1,524.31          6,520.45   20.41
8-Dec                                                        21,795.55          5,853.60             1,491.94          4,226.86   13.31
7-Dec                                                        16,593.99          5,673.98               965.94          4,203.72   13.29
6-Dec                                                        10,604.92          4,011.04               568.63          3,077.45    9.94
5-Dec                                                         6,138.56          2,141.68               293.81         1,465.40     5.02
4-Dec                                                         3,189.22            650.23               148.47           399.12     1.46
3-Dec                                                         1,465.93            346.65                50.19           105.65     0.41
2-Dec                                                           439.51            184.92                18.03             99.66    0.45
1-Dec                                                            86.43             10.07                10.03              6.99    0.04
Dec-00                                                           19.11            -14.69                    0            -14.69   -0.22

Balance Sheet - 10 Year
                                                                                  Current                               Shares
                                                        Current Assets          Liabilities    Long Term Debt      Outstanding
9-Dec                                                        40,496.78          4,492.55                    0            317.8
8-Dec                                                        31,767.58          3,528.71                    0            315.1
7-Dec                                                        25,335.81          2,646.13                    0            313.3
6-Dec                                                        18,473.35          1,433.51                    0              309
5-Dec                                                        10,271.81            852.86                    0              293
4-Dec                                                         3,313.35              384.3                   0            266.9
3-Dec                                                           871.46            268.82                 1.99            160.9
2-Dec                                                           286.89              99.07                6.51            160.9
1-Dec                                                                 0                    0                0                0
Dec-00                                                                0                    0                0                0
atemnt.aspx?Symbol=GOOG&lstStatement=10YearSummary&stmtView=Ann




               Tax Rate (%)
                       22.2
                      27.79
                      25.91
                      23.28
                     31.58
                     38.62
                     69.52
                     46.11
                     30.62
                         0
10-Year Ratios

                                URL             http://moneycentral.msn.com/investor/invsub/results/compare.asp?Page=TenYearSummary&Symbol=GOO
    Find Book Value
                                Book Value                  22
      Fix "CAD"
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


                                  Avg P/E       Price/ Sales               N
                                                                Price/ Book et Profit Margin (%)
                       9-Dec           21.6             8.37             5.47            27.6
                       8-Dec           35.1             4.48             3.43            19.4
                       7-Dec           40.6           13.18              9.55            25.3
                       6-Dec           41.4           13.44              8.35              29
                       5-Dec           55.7           19.73             12.91            23.9
                       4-Dec          104.1           16.49             17.57            12.5
                       3-Dec    NA              NA             NA                         7.2
                       2-Dec    NA              NA             NA                        22.7
                       1-Dec    NA              NA             NA                         8.1
                      Dec-00    NA              NA             NA                       -76.9


                                           Debt/ Equity
                            Book Value/ Share                     Return         Interest
                                                    Return on Equity (%) on Assets (%) Coverage
9-Dec                             $113.30            0          18.1           16.1          NA
8-Dec                              $89.61            0             15          13.3          NA
7-Dec                              $72.43            0          18.5           16.6          NA
6-Dec                              $55.15            0          18.1           16.7          NA
5-Dec                              $32.14            0          15.6           14.3       2599.6
4-Dec                              $10.97            0          13.6             12        742.7
3-Dec                                $3.75        0.01          17.5           12.1        177.4
2-Dec                                $1.17        0.06          53.1           34.7         72.6
1-Dec                                  NA            0            NA            NA           6.2
Dec-00                                 NA            0            NA            NA           NA
ge=TenYearSummary&Symbol=GOOG
Cash Flow

                       URL http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol=GOOG&lstStatement=CashFlow&stmtView=An


                                   2009          2008             2007             2006          2005
Period End Date               12/31/2009    12/31/2008       12/31/2007       12/31/2006    12/31/2005
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               2/12/2010     2/13/2009        2/15/2008         3/1/2007     3/16/2006
Stmt Update Type                 Updated       Updated          Updated          Updated       Updated


Net Income/Starting Line         6,520.45      4,226.86         4,203.72         3,077.45     1,465.40


Depreciation/Depletion           1,240.03      1,212.24          807.74           494.43        256.81
Amortization                       284.28        287.65          159.92            77.51            37
Deferred Taxes                    -268.06       -224.65          -164.21               0             0
Non-Cash Items                   1,073.78      2,055.44          489.44           -112.83       656.47


Changes in Working                 465.72        295.32            278.8           43.96         43.74
Capital

Cash from Operating             9,316.20      7,852.86         5,775.41        3,580.51      2,459.42
Activities

Capital Expenditures              -809.89     -2,358.46        -2,402.84        -1,902.80      -853.04


Other Investing Cash            -7,209.32     -2,960.96        -1,278.75        -4,996.35     -2,505.16
Flow Items, Total

Cash from Investing            -8,019.21     -5,319.42        -3,681.59        -6,899.15    -3,358.19
Activities

Financing Cash Flow                 90.27        159.09          379.21           581.73             0
Items

Total Cash Dividends                    0             0               0                0             0
Paid
Issuance (Retirement) of           143.14        -71.52            23.86         2,384.67     4,372.26
Stock, Net
Issuance (Retirement) of                0             0               0                0          -1.43
Debt, Net
Cash from Financing               233.41         87.57          403.07         2,966.40      4,370.83
Activities

Foreign Exchange Effects            10.51        -45.92            40.03           19.74        -21.76


Net Change in Cash              1,540.92      2,575.08         2,536.92           -332.5     3,450.30




Net Cash - Beginning             8,656.67      6,081.59         3,544.67         3,877.17       426.87
Balance
Net Cash - Ending   10,197.59   8,656.67   6,081.59   3,544.67   3,877.17
Balance
stStatement=CashFlow&stmtView=Ann
Income Statement


                   URL http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol=GOOG&lstStatement=Income&stmtView=Qtr


                                2010 Q3           2010 Q2            2010 Q1            2009 Q4           2009 Q3
Period End Date                 9/30/2010         6/30/2010          3/31/2010         12/31/2009         9/30/2009
Period Length                    3 Months           3 Months          3 Months           3 Months           3 Months
Stmt Source                           8-K              10-Q               10-Q               10-K              10-Q
Stmt Source Date               10/14/2010         7/30/2010           5/5/2010          2/12/2010         11/4/2009
Stmt Update Type                  Updated           Updated            Updated            Updated           Updated


Revenue                          7,286.00           6,820.00           6,775.00          6,673.83           5,944.85
Total Revenue                   7,286.00           6,820.00          6,775.00           6,673.83           5,944.85


Cost of Revenue, Total           2,552.00           2,467.00           2,452.00          2,408.40           2,226.24


Gross Profit                    4,734.00           4,353.00          4,323.00           4,265.43           3,718.61


Selling/General/Admini           1,193.00           1,090.00           1,017.00          1,048.21             887.37
strative Expenses,
Total
Research &                            994                898               818             736.23             757.52
Development
Depreciation/Amortizat                  0                  0                 0                  0                  0
ion
Interest Expense                        0                  0                 0                  0                  0
(Income), Net
Operating
Unusual Expense                         0                  0                 0                  0                  0
(Income)
Other Operating                         0                  0                 0                  0                  0
Expenses, Total
Operating Income                2,547.00           2,365.00          2,488.00           2,480.98           2,073.72


Interest Income                       167                  0                 0                  0                  0
(Expense), Net Non-
Operating
Gain (Loss) on Sale of                  0                  0                 0                  0                  0
Assets
Other, Net                              0                 -4                 3               4.88               0.63
Income Before Tax               2,714.00           2,434.00          2,506.00           2,568.67           2,066.54


Income Tax - Total                    547                594               551             594.57             427.57
Income After Tax                2,167.00           1,840.00          1,955.00           1,974.10           1,638.98


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               2,167.00           1,840.00          1,955.00           1,974.10           1,638.98
Extra. Items
Total Extraordinary            0           0           0           0           0
Items
Net Income              2,167.00    1,840.00    1,955.00    1,974.10    1,638.98




Total Adjustments to           0           0           0           0           0
Net Income


Basic Weighted            318.62      318.35       317.9      317.23       316.5
Average Shares
Basic EPS Excluding           6.8        5.78        6.15        6.22        5.18
Extraordinary Items
Basic EPS Including           6.8        5.78        6.15        6.22        5.18
Extraordinary Items

Diluted Weighted          322.38      322.49      322.61      317.23      319.75
Average Shares
Diluted EPS Excluding        6.72        5.71        6.06        6.22        5.13
Extrordinary Items
Diluted EPS Including        6.72        5.71        6.06        6.22        5.13
Extraordinary Items

Dividends per Share -          0           0           0           0           0
Common Stock Primary
Issue
Gross Dividends -              0           0           0           0           0
Common Stock
Depreciation,                257         266         264      296.82       311.1
Supplemental

Normalized EBITDA        2,889.00    2,701.00    2,815.00    2,856.08    2,448.12
Normalized EBIT          2,547.00    2,365.00    2,488.00    2,480.98    2,073.72
Normalized Income        2,714.00    2,434.00    2,506.00    2,568.67    2,066.54
Before Tax
Normalized Income        2,167.00    1,840.00    1,955.00    1,974.10    1,638.98
After Taxes
Normalized Income        2,167.00    1,840.00    1,955.00    1,974.10    1,638.98
Available to Common

Basic Normalized EPS          6.8        5.78        6.15        6.22        5.18
Diluted Normalized           6.72        5.71        6.06        6.22        5.13
EPS
Amortization of               85          70          63       78.28         63.3
Intangibles
Statement=Income&stmtView=Qtr
Earnings Estimates


                     URL http://moneycentral.msn.com/investor/invsub/analyst/earnest.asp?Page=EarningsGrowthRates&Symbol=GOOG


 Earnings Growth Rates      Last 5 Years        FY 2010            FY 2011     Next 5 Years      10 P/E
Company                           48.30%            21.10%             15.90%        19.60% 23.8
Industry                          18.00%            -0.20%             18.80%        17.40% 2.7
S&P 500                            -3.00%           40.50%             15.50% NA            14.7
hRates&Symbol=GOOG
Big 5 Numbers
                               Generate Data            "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.1%                     8.5%              53.3%                     26.4%
    5            12.6%                    49.3%              69.5%                     59.5%
    9            13.0%                   120.6%             -265.4%                 Invalid Data
 Year Ago          ROIC                 Sales Growth        EPS Growth                BVPS Growth
    1              14.1%                    8.5%                53.3%                     26.4%
    2              10.8%                   31.3%                 0.2%                     23.7%
    3              13.7%                   56.5%                33.7%                     31.3%
    4              13.9%                   72.8%                98.0%                     71.6%
    5              10.6%                   92.5%               243.8%                    193.0%
    6              8.4%                    117.6%              256.1%                    192.5%
    7              5.3%                    233.5%               -8.9%                    220.5%
    8              27.6%                   408.5%            1025.0%                   Invalid Data
    9           Invalid Data               352.3%             -118.2%                  Invalid Data




ROIC
 Year Ago       Net Income                 NOPAT          Long Term Debt                  Equity
     1           6520.45                   5072.91              0                      $36,006.74
     2           4226.86                   3052.22              0                      $28,236.11
     3           4203.72                   3114.54              0                      $22,692.32
     4           3077.45                   2361.02              0                      $17,041.35
     5            1465.4                   1002.63              0                       $9,417.02
     6            399.12                   244.98               0                       $2,927.89
     7            105.65                     32.20             1.99                      $603.38
     8             99.66                     53.71             6.51                      $188.25
     9              6.99                  4.849662              0                      Invalid Data
    10            -14.69                    -14.69              0                      Invalid Data



Sales
 Year Ago         Sales         Sales Growth
     1           23650.56                    8.5%
     2           21795.55                   31.3%
     3           16593.99                   56.5%
     4           10604.92                   72.8%
     5           6138.56                    92.5%
     6           3189.22                   117.6%
     7           1465.93                   233.5%
     8            439.51                   408.5%
     9            86.43                    352.3%
    10            19.11                  Invalid Data



EPS
 Year Ago          EPS          EPS Growth
    1              20.41                  53.3%
    2              13.31                   0.2%
    3              13.29                  33.7%
    4               9.94                  98.0%
    5               5.02                 243.8%
    6               1.46                 256.1%
    7               0.41                  -8.9%
    8               0.45                 1025.0%
    9               0.04                 -118.2%
    10             -0.22                   N/A



BVPS
 Year Ago          BVPS        BVPS Growth
    1             $113.30                 26.4%
    2              $89.61                 23.7%
    3              $72.43                 31.3%
    4              $55.15                 71.6%
    5              $32.14                193.0%
    6              $10.97                192.5%
    7              $3.75                 220.5%
    8              $1.17               Invalid Data
    9           Invalid Data           Invalid Data
    10          Invalid Data               N/A



Free Cash Flow
 Year Ago      Cash from Ops       Capital Expenditures       Cash Flow       Free Cash Flow Growth
     1             9316.2                 -809.89              8,506.31                 54.8%
     2            7852.86                -2358.46              5,494.40                 62.9%
     3            5775.41                -2402.84              3,372.57                101.0%
     4            3580.51                 -1902.8              1,677.71                  4.4%
     5            2459.42                 -853.04              1,606.38                   N/A



Debt
 Year Ago       Cash Flow            Long Term Debt       Years to Pay Back
     1           8,506.31                   0                      0.0
     2           5,494.40                   0                      0.0
     3           3,372.57                   0                      0.0
     4           1,677.71                   0                      0.0
     5           1,606.38                   0                      0.0
     6             N/A                      0                      N/A
     7             N/A                    1.99                     N/A
     8             N/A                    6.51                     N/A
     9             N/A                      0                      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
                          54.8%                                     0.0                       2

                          51.7%                                                               3
                           N/A                                                                4

                   Free Cash Flow Growth             10%
                           54.8%                     10%
                           62.9%                     10%
                          101.0%                     10%
                            4.4%                     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.1%                                   Free Cash Flow Growth
                            10.8%                                   10%
                            13.7%
                            13.9%
                            10.6%
                             8.4%
                             5.3%
                            27.6%
                         Invalid Data
                         Invalid Data


                                                    9          8            7          6          5
Warnings
    Pass
    Pass

    Pass
    Pass




                           400.0%

                           350.0%

                           300.0%

                           250.0%

                           200.0%

                           150.0%

                           100.0%

                           50.0%

                           0.0%
    5      4   3   2   1
                           -50.0%

                           -100.0%
Sticker Price

                 EPS (ttm)        24.71

  Estimated EPS Growth           19.6%
  Historical BVPS Growth         26.4%
        User Input Growth

            Historical PE         21.6
     PE from EPS Growth           39.2
           User Input PE

            10-Year EPS          147.97
            Sticker Price        790.06
                Entry Price    395.03
BVPS Growth
      Year Ago                    BVPS        BVPS Growth
         1                       $113.30           26.4%
         2                        $89.61           23.7%
         3                        $72.43           31.3%
         4                        $55.15           71.6%
         5                        $32.14          193.0%
         6                        $10.97          192.5%
         7                        $3.75           220.5%
         8                        $1.17         Invalid Data
         9                     Invalid Data     Invalid Data
         10                    Invalid Data         N/A

        Average               BVPS Growth
1-Year                           26.4%
3-Year Avg                       27.1%
5-Year Avg                       59.5%
10-Year Avg                                        Error



PE
        Year Ago                    PE
           1                       21.6
           2                       35.1
           3                       40.6
           4                       41.4
           5                       55.7
           6                      104.1
           7                       NA
           8                       NA
           9                       NA
           10                      NA

        Average                    PE
1-Year                            21.6
3-Year Avg                    32.43333333
5-Year Avg                       38.88
10-Year Avg                      49.75
Payback Time


               EPS (ttm)    24.71
 Estimated EPS Growth       19.6%
    Current Stock Price    $611.00


         Payback Time        9.0       Years


EPS - For Reference Only
                                        Cummulative
    Year in Future           EPS         Earnings
          1                 $29.55         $29.55
          2                 $35.35         $64.90
          3                 $42.27         $107.17
          4                 $50.56         $157.73
          5                 $60.47         $218.20
          6                 $72.32         $290.52
          7                 $86.49         $377.01
          8                $103.45         $480.46
          9                $123.72         $604.19
         10                $147.97         $752.16
         11                $176.98         $929.14
         12                $211.66        $1,140.80
         13                $253.15        $1,393.95
         14                $302.77        $1,696.72
         15                $362.11        $2,058.83
         16                $433.08        $2,491.91
         17                $517.97        $3,009.88
         18                $619.49        $3,629.37
         19                $740.91        $4,370.28
         20                $886.13        $5,256.41
         21                $1,059.81      $6,316.22
         22                $1,267.53      $7,583.75
         23                $1,515.97      $9,099.71
         24                $1,813.10     $10,912.81
         25                $2,168.46     $13,081.28
Tutorial

Short 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 For "Stock Price" tab, manually enter stock price.

        5 For other yellow tabs, click on URL and copy and paste data into spreadsheet.
        6 Click on "Generate Data" in the "Big 5" tab.
          Check "Warnings" table on the right to see if there are any warnings in the
        7 spreadsheet. Follow any instructions displayed.
        8 Click on "Sticker Price" tab.
          If you find that the highlighted growth rate is too high/low, you can enter your own
        9 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
       10 the "User Input PE" cell.
       11 Entry price is the price below which you can purchase the stock.
       12 Click on "Payback Time" tab.

       13 Payback Time is considered acceptable if it is less than or equal to 10 years.

Long 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 For Stock Price tab, manually enter stock price.

           5 For other yellow tabs, click on URL and copy and paste data into spreadsheet.
           6 Click on "10-year Statement" tab.

        7 Click on "Find Balance Sheet Start" to find the start of the Balance Sheet section.
          For "Shares Outstanding", click on "Fix Millions" button to remove "mil" or "Fix
        8 Billions" to remove "bil"
        9 Click on "10-year Ratios" tab.
       10 Click on "Find Book Value" to find the start of the BVPS section.
          For "Book Value/Share", click on "Fix 'CAD'" button to remove "CAD" if the stock is
       11 Canadian.
       12 Click on "Big 5" tab.
          Check "Warnings" table on the right to see if there are any warnings in the
       13 spreadsheet. Follow any instructions displayed.
       14 Click on "Sticker Price" tab.
          If you find that the highlighted growth rate is too high/low, you can enter your own
       15 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
       16 the "User Input PE" cell.
       17 Entry price is the price below which you can purchase the stock.
       18 Click on "Payback Time" tab.

       19 Payback Time is considered acceptable if it is less than or equal to 10 years.
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.

				
DOCUMENT INFO
Description: Start Up Stock Exchange document sample