Aapl 5yr Osv Stock Valuation Spreadsheet

  • Uploaded by: Old School Value
  • 0
  • 0
  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Aapl 5yr Osv Stock Valuation Spreadsheet as PDF for free.

More details

  • Words: 7,431
  • Pages: 14
Jae Jun | Old School Value Author

All spreadsheet related questions and support is now handled only through the forum. http://www.oldschoolvalue.com/forum/spreadsheet-installation/

Disclaimer Nothing on Old School Value, related pages, emails, or other communications by the author, either written or oral, are intended to be a recommendation to either buy, hold, or sell any specific security or group of securities. Likewise, nothing herein should be construed as an endorsement of any financial adviser, investment manager, commercial information provider, transaction service, or brokerage firm. The findings from this spreadsheet is merely a start to a means of further research and uncovering a great business and investment. Old School Value holds no responsibility for any investment whatsoever.

Spreadsheet Installation Related - Refer to the manual and ask for help on the forums to reduce repetitive questions and answers.The manual contains every possible problem related to the spreadsheet. - When requesting help, please try to find out whether it is a spreadsheet issue or excel issue. PDF: http://www.oldschoolvalue.com/intrinsic-value-spreadsheets/installation-troubleshooting-guide/ Forum: http://www.oldschoolvalue.com/forum/spreadsheet-installation/

How to Use - Yellow highlighted fields are user input fields. Enter ticker in the Summary tab only. - Use yellow fields to override the default values without messing up formulas and accidently saving incorrect values - If a graph is squashed or looks out of place, zoom in and zoom out to refresh the view. - Press F9 to start calculations. Automatic formula calculations have been turned off in the excel menu to improve start speed and convenience. - Protected sheets do not have any passwords. Simply unprotect it. - Summary page provides a quick overview of all valuation methods and important graphs and numbers. Easy to add more or less yourself. - DCF Valuation is based on discounted cash flow. Important company fundamental metrics included. - Useful for companies with either 5yr or 10yrs of operating history - Use 5yr version if there has been a recent turnaround or a major event changing the fundamentals of the business - Use 10yr version for stable, cash cows such as KO or JNJ. You can even use it for stable consistent small caps - Adjust user growth, discount rate, FCF override, terminal rate (default 3%) - Price vs Value tab displays only the DCF intrinsic value compared to the historical stock price. (Thinking of how to add Graham intrinsic value and EPV to the graph) - Graham Intrinsic Value is based on Ben Graham's formula defined in the Intelligent Investor Intrisic Value = "normal" earnings x (8.5 + (2 x expected 5 yr growth)) x (4.4/20yr A corp bond) - Use for companies where FCF is erratic such as cyclicals or short history companies. - Remember that earnings are usually inflated. Companies may overstate earnings by hiding some numbers in there but they will never understate earnings on purpose. - Which means that the value you get with the Graham equation will be higher than normal. - Use high margin of safety (MOS) - Adjust user growth - EPV is based on Bruce Greenwald's book. http://www.oldschoolvalue.com/book-reviews/greenwald-earnings-power-value-investing-epv/ - Detailed instructions on how to use the spreadsheet with a rundown of Microsoft http://www.oldschoolvalue.com/stock-analysis/earnings-power-value-epv-valuation-microsoft/ - To explain it here, I would have to write out the entire book again. Please read it yourself to fully understand it. - "Adjust +/-" column is for adding or subtracting values from the stated numbers - "Multiplier" is to select what % you want to consider it. e.g. intangibles usually = 0% - Select the pinkish cell to select either data from MSN or ADVFN - Cell P47, select either 3 or 4 years of R&D you want to include into the valuation - EPV section row 66, include or exclude extraordinary items to EBIT - Read the comments to see references and explanations from the book - Competitors tab allows you to view 6 companies side by side - Charts tab shows different performance graphs of the companies - Assessment tab is a checklist that you should try to folllow before making investment decisions. - You should at least be able to draw up the spider graph

Company Name

ticker

Apple Inc

AAPL

www.oldschoolvalue.com

10/1/2009

Figures in Millions except per share values

Apple Inc.designs, manufactures, and markets personal computers, portable digital music players, and mobile communication devices and sells a variety of related software, services, peripherals, and networking solutions. The Company sells its products worldwide through its online stores, its retail stores, its direct sales force, and third-party wholesalers, resellers, and value-added resellers. In addition, the Company sells a variety of third-party Macintosh (Mac), iPod and iPhone compatible products, including application software, printers, storage devices, speakers, headphones, and various other accessories and peripherals through its online and retail stores, , and digital content through the iTunes Store. It sells to consumer, small and mid-sized business (SMB), education, enterprise, government, and creative customers.

Asset Valuation Total Net Reprod. Cost Reprod. Cost of Assets BV Tangible BV NNWC

EPV Valuation 10.57 EPV $ 36.95 Normalized Income $ 30.26 Discount Rate 7.31 Margin of Safety

$ $ $ $

Key Statistics Market Cap (millions) 52-Week Low % off 52-Week Low

DCF Valuation Current Price DCF Price $ 161.07 $ 183.62 Growth Rate 20% Discount Rate 9% Margin of Safety 0%

Financial Strength

Margins & Profitability 2.09

Gross (TTM)

35.49

Operating (TTM)

188.90

Current Ratio (MRQ)

2.11

Gross - 5 Yr. Avg.

31.83

Operating - 5 Yr. Avg.

78.20

LT Debt to Equity (MRQ)

0

EBITD (TTM)

21.84

Pre-Tax (TTM)

Total Debt to Equity (MRQ)

0

EBITD - 5 Yr. Avg.

16.82

Pre-Tax - 5 Yr. Avg.

137.0%

Valuation Ratios

Growth Stats

P/E Ratio (TTM)

Management Effective

32.4

Sales (MRQ) vs Qtr. 1 Yr. Ago

Price to Sales (TTM)

4.8

Sales (TTM) vs TTM 1 Yr. Ago

Price to Book (MRQ)

6.41

Sales - 5 Yr. Growth Rate

39.23

Price to Tangible Book (MRQ)

6.56

EPS (MRQ) vs Qtr. 1 Yr. Ago

Price to Cash Flow (TTM)

28.56

Price to Free Cash Flow (TTM)

16.31

Enterprise Value/Revenue (TTM) Enterprise Value/EBITDA (TTM)

Graham Valuation Graham Price $ 102.87 Growth Rate 30% Normalized EPS $ 2.03 Margin of Safety 0%

Quick Ratio (MRQ)

166,040

52-Week High

68.52 3,692.87 9% 0%

4.1

19.98 15.4 21.2

Efficiency

12.96

Revenue/Employee (TTM)1080063

ROA - 5 Yr. Avg.

13.96

Net Income/Employee (TTM) 161719

ROI (TTM)

19.18

Receivable Turnover (TTM)16.12

13.89

ROI - 5 Yr Avg

21.57

Inventory Turnover (TTM) 48.21

EPS (TTM) vs TTM 1 Yr. Ago

11.88

ROE (TTM)

22.74

Asset Turnover (TTM)

EPS - 5 Yr. Growth Rate

124.7

ROE - 5 Yr. Avg.

Capital Spending - 5 Yr. Grwth

48.87

4.8

14.97

Net Profit - 5 Yr. Avg. 12.15

17.24

ROA (TTM)

11.7

Net Profit (TTM)

0.87

24

18.862

Historical Stock Price Vs Intrinsic Value Per Share 250

200

150 Historical Price Intrinsic Value 100

Buy Price

50

0 1/21/2003

7/21/2003

1/21/2004

7/21/2004

1/21/2005

7/21/2005

1/21/2006

7/21/2006

1/21/2007

7/21/2007

1/21/2008

7/21/2008

1/21/2009

7/21/2009

Multi-Year Performance Shareholder Equity Free Cash Flow CROIC FCF/Sales ROA ROE Revenue Growth Gross Margin Operating Margin Net Margin Earnings Growth Cash from Ops Growth

2003-2007 36.3% 261.6% 14.7% 8.1% 13.6% 21.3% 40.2% 29.0% 11.8% 9.6% 150.4% 108.6%

2004-2008 42.5% 102.6% 15.7% 9.0% 13.8% 22.8% 40.7% 29.0% 12.7% 10.3% 96.4% 79.0%

2003-2006 33.6% 342.3% 9.7% 5.5% 8.7% 13.6% 46.0% 28.2% 7.9% 6.5% 183.1% 97.3%

2004-2007 41.8% 130.9% 15.2% 8.5% 13.7% 22.0% 42.6% 29.0% 12.3% 9.9% 121.8% 80.3%

2005-2008 40.7% 49.8% 16.3% 10.9% 14.4% 25.0% 32.6% 31.5% 15.5% 12.4% 50.9% 55.8%

2003-2005 33.8% 734.7% 4.7% 3.0% 3.7% 5.9% 49.8% 27.5% 3.9% 3.3% 295.0% 196.2%

2004-2006 40.3% 149.6% 14.7% 8.1% 13.6% 21.3% 52.7% 29.0% 11.8% 9.6% 151.1% 54.2%

2005-2007 38.8% 56.7% 15.7% 9.0% 13.8% 22.8% 31.3% 29.0% 12.7% 10.3% 58.7% 46.9%

2006-2008 44.7% 64.6% 16.9% 12.8% 14.9% 27.2% 29.7% 34.0% 18.4% 14.6% 53.7% 107.9%

Median 40.3% 130.9% 15.2% 8.5% 13.7% 22.0% 40.7% 29.0% 12.3% 9.9% 121.8% 80.3%

Margin Percentages 40.00% 35.00% 30.00% 27.65%

27.92%

27.13%

27.52%

29.02%

27.29%

33.97%

34.31%

18.37%

19.32%

Gross Margin

14.56%

14.88%

Operating Margin

28.98%

25.00% 23.03%

20.00% 15.00% 10.00%

9.80%

9.85%

5.00%

5.85%

6.54%

12.70% 10.30%

2005

2006

Net Margin

3.94% 3.33%

0.00% -5.00%

11.84% 9.58%

1999

-0.47% 2001

2000

1.13% 0.30%

1.11% -0.02%

2002

2003

2004

2007

2008

-6.41%

-10.00%

Free Cash Flow vs Tangible Shareholder Equity Trend

Efficiency & Profitability

$25,000.0

35.0% 30.0%

$20,000.0

25.0%

20.0%

CROIC

FCF

15.0%

FCF/Sales

Shareholder Equity

10.0%

ROA

5.0%

ROE

$15,000.0 $10,000.0 $5,000.0

0.0%

$$(5,000.0)

1999

2000

2001

2002

2003

2004

2005

2006

2007

1999

-5.0%

2008

2000

2001

2002

2003

2004

2005

2006

2007

2008

-10.0%

Sales, AR, Inventory

CAPEX vs PPE

$40,000.0

$3,500.0

$35,000.0

$3,000.0

$30,000.0

Last 6 yrs

$2,500.0

Last 5 yrs

$25,000.0 $20,000.0 $15,000.0

Sales

$2,000.0

Last 4 yrs

Accts Receivable

$1,500.0

Last 3 yrs

Inventory

$10,000.0

Last 2 yrs

$1,000.0

Last 1 yr

$5,000.0

$500.0

$-

$1999 2000 2001 2002 2003 2004 2005 2006 2007 2008

TTM

PPE 2002

2003

2004

2005

2006

2007

2008

TTM

Company Name

ticker

Apple Inc

AAPL

www.oldschoolvalue.com

10/1/2009

Figures in Millions except per share values Financial Data

AAPL

1999

2000

2001

2002

2003

2004

2005

2006

2007

2008

TTM

Income Statement Revenue % change from last year COGS COGS (%)

$

6,134.0

$

$

4,438.0 72.4%

$

Gross Profit

$

1,696.0

$

Gross Profit (%)

27.6%

7,983.0 $ 23.2% 5,817.0 $ 72.9%

5,363.0 $ -48.9% 4,128.0 $ 77.0%

5,742.0 $ 6.6% 4,139.0 $ 72.1%

6,207.0 $ 7.5% 4,499.0 $ 72.5%

8,279.0 $ 25.0% 6,020.0 $ 72.7%

2,166.0

1,235.0

1,603.0

1,708.0

2,259.0

$

27.1%

$

23.0%

$

27.9%

$

27.5%

$

27.3%

13,931.0 $ 40.6% 9,888.0 $ 71.0% 4,043.0

$

29.0%

19,315.0 $ 27.9% 13,717.0 $ 71.0% 5,598.0

$

29.0%

24,006.0 $ 19.5% 15,852.0 $ 66.0% 8,154.0

$

34.0%

32,479.0 $ 26.1% 21,334.0 $ 65.7%

34,562.0 6.0% 22,297.0 64.5%

11,145.0

12,265.0

$

34.3%

35.5%

Operating Expenses SG&A SG&A (%) R&D R&D (%) Other Other (%) Operating Income

$ $ $

$

Operating Income (%)

996.0 16.2% 314.0 5.1% 27.0 0.4% 359.0

$ $ $

$

5.9%

1,166.0 $ 14.6% 380.0 $ 4.8% 98.0 $ 1.2% 522.0

$

6.5%

1,138.0 $ 21.2% 441.0 $ 8.2% $ 0.0% (344.0)

$

-6.4%

1,111.0 $ 19.3% 447.0 $ 7.8% 28.0 $ 0.5% 17.0

$

0.3%

1,212.0 $ 19.5% 471.0 $ 7.6% 26.0 $ 0.4% (1.0)

$

0.0%

1,421.0 $ 17.2% 489.0 $ 5.9% 23.0 $ 0.3% 326.0

$

3.9%

1,859.0 $ 13.3% 534.0 $ 3.8% $ 0.0%

2,433.0 $ 12.6% 712.0 $ 3.7% $ 0.0%

2,963.0 $ 12.3% 782.0 $ 3.3% $ 0.0%

3,761.0 $ 11.6% 1,109.0 $ 3.4% $ 0.0%

4,085.0 11.8% 1,273.0 3.7% 0.0%

1,650.0

2,453.0

4,409.0

6,275.0

6,907.0

$

11.8%

$

12.7%

$

18.4%

$

19.3%

20.0%

Other Income and Expense Net Int Inc & Other

$

317.0

Earnings Before Taxes Income Taxes Tax Rate %

$ $

676.0 $ 75.0 $ 11.1%

Earnings After Taxes Acctg Changes Disc Operations Ext Items

$ $ $ $

601.0 -

Net Income

$

601.0

Net Income (%) Diluted EPS, Cont Ops$ Diluted EPS$ Shares

$ $

$

$

292.0

93.0

$

1,092.0 306.0 28.0%

$ $

(52.0) $ (15.0) $ 28.8%

87.0 $ 22.0 $ 25.3%

92.0 24.0 26.1%

$ $

383.0 $ 107.0 $ 27.9%

1,815.0 $ 480.0 $ 26.4%

2,818.0 $ 829.0 $ 29.4%

5,008.0 $ 1,512.0 $ 30.2%

6,895.0 $ 2,061.0 $ 29.9%

7,328.0 2,153.0 29.4%

$ $ $ $

786.0 -

$ $ $ $

(37.0) $ 12.0 $ $ $

65.0 -

$ $ $ $

68.0 1.0 -

$ $ $ $

276.0 -

$ $ $ $

1,335.0 -

$ $ $ $

1,989.0 -

$ $ $ $

3,496.0 -

$ $ $ $

4,834.0 -

$ $ $ $

5,175.0 -

$

786.0

$

(25.0)

65.0

$

69.0

$

276.0

$

1,335.0

$

1,989.0

$

3,496.0

$

4,834.0

$

5,175.0

9.8% 0.9 $ 0.9 $ 696

570.0

9.8% 1.1 $ 1.1 $ 720

$

$

70.0

$

-0.5% (0.1) $ (0.0) $ 691

1.1% 0.1 $ 0.1 $ 723

1.1% 0.1 $ 0.1 $ 726

2,252.0 $ 2,085.0 $ 565.0 $ 17.5% 45.0 $ 75.6% 441.0 $

3,396.0 1,170.0 766.0 26.2% 56.0 19.6% 499.0

$ $ $

57.0

$

3.3% 0.4 $ 0.4 $ 774

165.0

9.6% 1.6 1.6 856

$

$ $

365.0

10.3% 2.3 2.3 877

$

$ $

599.0

$

14.6% 3.9 $ 3.9 $ 889

620.0

14.9% 5.4 5.4 902

$

$ $

421.0

15.0% 5.7 5.7 904

Balance Sheet Assets Cash and Equiv Short-Term Investments Accts Rec % change from last year Inventory % change from last year Other Current Assets

$ $ $

1,326.0 1,900.0 681.0

$ $ $

$

358.0

$

1,191.0 2,836.0 953.0 28.5% 33.0 39.4% 414.0

$

20.0

$

$ $ $

$

2,310.0 $ 2,026.0 $ 466.0 $ -104.5% 11.0 $ -200.0% 330.0 $

$

2,969.0 2,495.0 774.0 1.0% 101.0 44.6% 716.0

Total Current Assets Net PP&E Intangibles Other Long-Term Assets

$ $ $ $

4,285.0 318.0 558.0

$ $ $ $

5,427.0 313.0 1,063.0

$ $ $ $

5,143.0 564.0 314.0

$ $ $ $

5,388.0 621.0 119.0 170.0

$ $ $ $

5,887.0 669.0 109.0 150.0

$ $ $ $

7,055.0 707.0 97.0 191.0

$ $ $ $

10,300.0 817.0 96.0 338.0

$ $ $ $

14,509.0 1,281.0 177.0 1,238.0

$ $ $ $

21,956.0 1,832.0 337.0 1,222.0

$ $ $ $

34,690.0 2,455.0 492.0 1,935.0

$ $ $ $

35,170.0 2,653.0 466.0 9,851.0

Total Assets

$

5,161.0

$

6,803.0

$

6,021.0

$

6,298.0

$

6,815.0

$

8,050.0

$

11,551.0

$

17,205.0

$

25,347.0

$

39,572.0

$

48,140.0

$ $ $ $

1,157.0 776.0

$ $ $ $

801.0 717.0

$ $ $ $

911.0 747.0

$ $ $ $

1,154.0 304.0 899.0

$ $ $ $

1,451.0 1,229.0

$ $ $ $

1,779.0 1,705.0

$ $ $ $

3,390.0 3,081.0

$ $ $ $

4,970.0 4,329.0

$ $ $ $

5,520.0 8,572.0

$ $ $ $

4,854.0 3,338.0

$

8,469.0

14,092.0 -

$ $

16,661.0 -

$

$

$ $ $ $ $

3,491.0 4,770.0 895.0 13.5% 165.0 38.8% 979.0

$ $ $ $ $

6,392.0 3,718.0 1,252.0 28.5% 270.0 38.9% 2,877.0

$ $ $ $ $

9,352.0 6,034.0 1,637.0 23.5% 346.0 22.0% 4,587.0

$ $ $ $ $

11,875.0 12,615.0 2,422.0 32.4% 509.0 32.0% 7,269.0

$ $ $ $ $

5,605.0 18,617.0 2,686.0 9.8% 380.0 -33.9% 7,882.0

Liabilities & Stockholders' Equity Accts Payable Short-Term Debt Taxes Payable Accrued Liabilities

$ $ $ $

Other Short-Term Liabilities

$

Total Current Liabilities Long-Term Debt

$ $

812.0 737.0 1,549.0 300.0

Other Long-Term Liabilities

$

208.0

Total Liabilities

$

2,057.0

Total Equity

$

3,104.0

Total Liabilities & Equity

$

5,161.0

$ $ $

-

$

1,518.0 317.0

$ $ $

1,658.0 316.0

$ $ $

2,357.0 -

$ $ $

-

1,933.0 300.0

$ $

2,680.0 -

$

463.0

$

266.0

$

229.0

$

235.0

$

294.0

$

2,696.0

$

2,101.0

$

2,203.0

$

2,592.0

$

2,974.0

$

4,107.0

$

3,920.0

$

4,095.0

$

4,223.0

$

5,076.0

$

6,803.0

$

6,021.0

$

6,298.0

$

6,815.0

$

8,050.0

69.0 $ 113.0 $ (11.0) $ 118.0 $ 289.0

$ $ $

-

$

3,484.0 -

$ $

$

601.0

$

4,085.0

$

7,466.0

$

11,551.0

276.0 150.0 20.0 488.0

$ $ $ $

1,335.0 179.0 52.0 969.0

$ $ $ $

934.0

$

2,535.0

$

-

$

9,299.0 -

$ $ $

-

6,471.0 -

$ $

$

750.0

$

1,516.0

$

4,450.0

$

5,591.0

$

7,221.0

$

10,815.0

$

18,542.0

$

22,252.0

$

9,984.0

$

14,532.0

$

21,030.0

$

25,888.0

$

17,205.0

$

25,347.0

$

39,572.0

$

48,140.0

1,989.0 225.0 53.0 (47.0)

$ $ $ $

3,496.0 317.0 78.0 1,579.0

$ $ $ $

4,834.0 473.0 4,289.0

$ $ $ $

5,175.0 640.0 5,529.0

2,220.0

$

5,470.0

$

9,596.0

$

11,344.0

Cash Flows Statement Cash Flows From Operating Activities

Net Income Depr & Amort Deferred Taxes Other

$ $ $ $

601.0 $ 85.0 $ (35.0) $ 147.0 $

786.0 $ 84.0 $ 163.0 $ (207.0) $

(25.0) $ 102.0 $ (36.0) $ 144.0 $

Cash from Operations

$

798.0

826.0

185.0

$

$

$

65.0 $ 118.0 $ (34.0) $ (60.0) $ 89.0

$

$

Cash Flows From Investing Activities Cap Ex Purchase of Business Other

$ $ $

(47.0) $ $ (917.0) $

(107.0) $ $ (823.0) $

Cash from Investing

$

(964.0)

(930.0) $

$

(232.0) $ $ 1,124.0 $

(174.0) $ (52.0) $ (26.0) $

(164.0) $ $ 992.0 $

(176.0) $ $ (1,312.0) $

(260.0) $ $ (2,296.0) $ (2,556.0) $

(657.0) $ $ 1,014.0 $

892.0

$

(252.0)

$

828.0

$

(1,488.0) $

$ $ $ $

42.0 -

$ $ $ $

105.0 -

$ $ $ $

27.0 -

$ $ $ $

427.0 $ (300.0) $ $ $

543.0 -

$ $ $ $

42.0 1,119.0

$ $ $

105.0 $ $ (58.0) $

27.0 1,144.0

$ $ $

127.0 $ $ (427.0) $

543.0 522.0

$ $ $

89.0 $ (174.0) $

289.0 $ (164.0) $

934.0 $ (176.0) $

2,535.0 $ (260.0) $

2,220.0 $ (657.0) $

250.0 6.56

1,254.0 8.72

1,557.0 11.38

(735.0) $ $ (2,514.0) $

(1,091.0) $ $ (7,098.0) $ (8,189.0)

$

(1,088.0) (14,568.0)

357.0

$

(3,249.0) $

(15,656.0)

(37.0) 361.0

$ $ $ $

362.0 377.0

$ $ $ $

483.0 633.0

$ $ $ $

$ $ $

739.0 2,960.0

$ $ $

1,116.0 2,523.0

$ $ $

544.0 (3,768.0)

5,470.0 $ (735.0) $

9,596.0 $ (1,091.0) $

11,344.0 (1,088.0)

3,078.0 16.35

4,216.0 23.31

4,727.0 28.64

Cash Flows From Financing Activities Net Issuance of Stock Net Issuance of Debt Dividends Other

$ $ $ $

Cash from Financing Currency Adj Change in Cash

$ $ $

11.0 $ $ (155.0) $

(31.0) $ $ (135.0) $

Cash from Operations Cap Ex

$ $

798.0 $ (47.0) $

826.0 $ (107.0) $

185.0 $ (232.0) $

Free Cash Flow Book Value Per Share

$ $

639.0 4.46

763.0 5.70

(155.0) 5.67

11.0 -

$ $ $ $

(31.0) -

324.0 2,901.0

360.0 184.0

Free Cash Flow

$ $

$ $

$ $

9.0 5.66

$ $

18.0 5.82

$ $

$ $

$ $

$ $

$ $

$ $

Company Name

ticker

Apple Inc

AAPL

10/1/2009

User Growth

User Input Params

www.oldschoolvalue.com

Desired MOS 50%

20.00% Growth 20.0%

Discount % 9.0%

1999

2000

2001

$

Price 185.35 2002

Figures in Millions except per share values

Share Value Buy under Actual D/C % $ 161.07 $ 80.53 0% Financial Data 2003 2004 2005

52Wk High $188.90

52Wk Low $78.20

2006

2007

$ 13,931.0 $ 4,043.0 $ 1,650.0 $ 1,335.0 $ 1.6

$ 19,315.0 $ 5,598.0 $ 2,453.0 $ 1,989.0 $ 2.3

$ 24,006.0 $ 8,154.0 $ 4,409.0 $ 3,496.0 $ 3.9

$ $ $ $ $

32,479.0 11,145.0 6,275.0 4,834.0 5.4

$ $ $

$ $ $

$ $ $

5,470.0 3,078.0 735.0

$ $ $

9,596.0 4,216.0 1,091.0

$ 21,956.0 $ 9,299.0 $ 10,815.0 $ 14,195.0

$ $ $ $

34,690.0 14,092.0 18,542.0 20,538.0

2008

Income Sheet Data Revenue Gross Profit Operating Income Net Income Diluted EPS

$ $ $ $ $

6,134.0 1,696.0 359.0 601.0 0.9

$ $ $ $ $

7,983.0 2,166.0 522.0 786.0 1.1

$ $ $ $ $

$ $ $

798.0 639.0 47.0

$ $ $

826.0 763.0 107.0

$ $ $

$ $ $ $

4,285.0 1,549.0 2,057.0 3,104.0

$ $ $ $

5,427.0 1,933.0 2,696.0 4,107.0

$ $ $ $

5,363.0 1,235.0 (344.0) (25.0) (0.0)

$ $ $ $ $

5,742.0 1,603.0 17.0 65.0 0.1

$ $ $ $ $

6,207.0 1,708.0 (1.0) 69.0 0.1

$ $ $ $ $

8,279.0 2,259.0 326.0 276.0 0.4

185.0 $ (155.0) $ 232.0 $

89.0 9.0 174.0

$ $ $

289.0 18.0 164.0

$ $ $

934.0 250.0 176.0

5,388.0 1,658.0 2,203.0 3,976.0

$ $ $ $

5,887.0 2,357.0 2,592.0 4,114.0

$ $ $ $

7,055.0 2,680.0 2,974.0 4,979.0

Cash Flow Data Cash from Operations Free Cash Flow Capex

2,535.0 1,254.0 260.0

2,220.0 1,557.0 657.0

Balance Sheet Data Current Assets Current Liabilities Total Liabilities Tangible Shareholder Equity

5,143.0 1,518.0 2,101.0 3,920.0

$ $ $ $

$ 10,300.0 $ 3,484.0 $ 4,085.0 $ 7,370.0

$ 14,509.0 $ 6,471.0 $ 7,221.0 $ 9,807.0

Margins Gross Margin Operating Margin Net Margin Current Assets>1.5 times

27.65% 5.85% 9.80% 276.6%

27.13% 6.54% 9.85% 280.8%

23.03% -6.41% -0.47% 338.8%

27.92% 0.30% 1.13% 325.0%

27.52% -0.02% 1.11% 249.8%

27.29% 3.94% 3.33% 263.2%

29.02% 11.84% 9.58% 295.6%

28.98% 12.70% 10.30% 224.2%

33.97% 18.37% 14.56% 236.1%

34.31% 19.32% 14.88% 246.2%

17.7% 10.4% 221.9 12.72% 27.04%

15.7% 9.6% 176.3 13.14% 22.51%

-3.4% -2.9% 375.3 -0.39% -0.63%

0.2% 0.2% 92.0 1.06% 1.62%

0.4% 0.3% 80.3 1.05% 1.66%

4.7% 3.0% 59.6 3.71% 5.94%

15.7% 9.0% 59.9 13.62% 21.29%

14.7% 8.1% 50.8 13.83% 22.80%

19.6% 12.8% 45.8 16.43% 28.52%

16.9% 13.0% 41.9 14.89% 27.19%

66.3% 8.8% 31.1%

65.6% 6.8% 28.3%

53.6% 7.5% -7.4%

53.8% 7.2% 0.4%

61.4% 0.0% 0.7%

58.6% 0.0% 8.4%

54.7% 0.0% 30.7%

72.3% 0.0% 21.6%

74.4% 0.0% 28.5%

88.2% 0.0% 22.7%

2003-2007 36.3% 261.6% 14.7% 8.1% 13.6% 21.3% 40.2% 29.0% 11.8% 9.6% 150.4% 108.6%

2004-2008 42.5% 102.6% 15.7% 9.0% 13.8% 22.8% 40.7% 29.0% 12.7% 10.3% 96.4% 79.0%

2003-2006 33.6% 342.3% 9.7% 5.5% 8.7% 13.6% 46.0% 28.2% 7.9% 6.5% 183.1% 97.3%

2003-2005 33.8% 734.7% 4.7% 3.0% 3.7% 5.9% 49.8% 27.5% 3.9% 3.3% 295.0% 196.2%

2004-2006 40.3% 149.6% 14.7% 8.1% 13.6% 21.3% 52.7% 29.0% 11.8% 9.6% 151.1% 54.2%

2005-2007 38.8% 56.7% 15.7% 9.0% 13.8% 22.8% 31.3% 29.0% 12.7% 10.3% 58.7% 46.9%

2006-2008 44.7% 64.6% 16.9% 12.8% 14.9% 27.2% 29.7% 34.0% 18.4% 14.6% 53.7% 107.9%

Median

2015 $13,429.96 2025 $ 23,271.40

2016 $14,013.60 2026 $ 23,969.54

2017 $16,283.80 2027 $ 24,688.63

2018 $18,921.78 2028 $ 25,429.28

Efficiency & Profitability CROIC FCF/Sales Inventory Turnover Return On Assets (ROA) Retun On Equity (ROE)

Debt Related Debt to Equity Capitalization Ratio FCF to Debt

Multi-Year Performance Shareholder Equity Free Cash Flow CROIC FCF/Sales ROA ROE Revenue Growth Gross Margin Operating Margin Net Margin Earnings Growth Cash from Ops Growth

2004-2007 41.8% 130.9% 15.2% 8.5% 13.7% 22.0% 42.6% 29.0% 12.3% 9.9% 121.8% 80.3%

2005-2008 40.7% 49.8% 16.3% 10.9% 14.4% 25.0% 32.6% 31.5% 15.5% 12.4% 50.9% 55.8%

40.3% 130.9% 15.2% 8.5% 13.7% 22.0% 40.7% 29.0% 12.3% 9.9% 121.8% 80.3%

Projection of future Free Cash Flow Growing at 20%

$ $

2009 5,059 2019 19,489.43

2010 $ 6,071 2020 $ 20,074.11

2011 7,285 2021 $ 20,676.33 $

2012 $8,173.89 2022 $ 21,296.62

Company Valuation Total Value Shares Outstanding Per Share Value Margin of Safety Purchase Price Current Price Actual Discount Enterprise Value Enterprise Value/EBITDA

$ $ $ $ $

2013 $9,645.19 2023 $ 21,935.52

2014 $11,381.32 2024 $ 22,593.59

Free Cash Flow and Tangible Shareholder Equity Trend 143,948 893.71 893.71 161.07 50% 80.53 185.35 0% 141,840.00 18.859

$25,000.0

FCF

$20,538.0

Shareholder Equity

$20,000.0 $14,195.0 $15,000.0 $10,000.0 $5,000.0

$9,807.0 $7,370.0 $4,979.0 $4,216.0 $3,104.0 $4,107.0 $3,920.0 $3,976.0 $4,114.0 $3,078.0 $1,254.0 $1,557.0 $639.0 $763.0 $(155.0) $9.0 $18.0 $250.0

$-

$(5,000.0)

1999

2000

2001

2002

2003

2004

2005

2006

2007

2008

Multi-Year Performance Graph 400.0%

Gross Margin

Operating Margin

Net Margin

Earnings Growth

ROA

ROE

350.0% 5.9% 3.7% 300.0%

250.0%

13.6% 8.7%

21.3% 13.6%

200.0%

22.8% 13.8%

150.0%

21.3% 13.6%

22.0% 13.7%

295.0%

25.0% 14.4%

183.1%

150.4% 100.0%

121.8%

96.4%

50.9% 50.0%

9.6% 11.8% 29.0%

10.3% 12.7% 29.0%

6.5% 7.9% 28.2%

2003-2007

2004-2008

2003-2006

0.0%

9.9% 12.3%

12.4% 15.5%

29.0% 2004-2007

27.2%

22.8% 13.8%

151.1%

14.9% 53.7%

58.7%

14.6% 18.4%

9.6% 11.8% 29.0%

10.3% 12.7%

31.5%

3.3% 3.9% 27.5%

29.0%

34.0%

2005-2008

2003-2005

2004-2006

2005-2007

2006-2008

Margin Percentages 40.00% 35.00% 30.00%

27.65%

27.92%

27.13%

27.52%

27.29%

29.02%

20.00%

10.00%

9.85% 6.54%

9.80% 5.85%

5.00% 0.00% -5.00%

34.31%

18.37% 14.56%

19.32%

2007

2008

23.03%

25.00%

15.00%

33.97% 28.98%

1999

2000

-0.47%

1.13% 0.30%

1.11% -0.02%

-6.41% 2001

2002

2003

11.84% 9.58%

12.70% 10.30%

2005

2006

Gross Margin Operating Margin

14.88%

Net Margin

3.94% 3.33%

2004

-10.00%

Efficiency & Profitability 35.0%

CROIC

FCF/Sales

Debt

ROA

100.0%

ROE

30.0%

Debt to Equity

Capitalization Ratio

FCF to Debt

80.0%

25.0% 60.0%

20.0% 15.0%

40.0%

10.0%

20.0%

5.0% 0.0%

0.0% -5.0%

1999

2000

2001

2002

2003

2004

2005

2006

2007

2008

-10.0%

Sales, Receivables, Inventory $40,000.0

Sales

Accts Receivable

Inventory

$35,000.0 $30,000.0

$25,000.0 $20,000.0 $15,000.0 $10,000.0 $5,000.0 $1999

2000

2001

2002

2003

2004

2005

2006

2007

2008

TTM

1999 -20.0%

2000

2001

2002

2003

2004

2005

2006

2007

2008

Company Name

ticker

Apple Inc

AAPL

www.oldschoolvalue.com

10/1/2009

Figures in Millions except per share values Desired MOS

Growth

Discount %

Price

50%

20.0%

9%

$ 185.35

Share Value $

161.07

Buy under $

80.53

Actual D/C % 52Wk High 0%

$

188.90

52Wk Low $

78.20

Historical Stock Price Vs Intrinsic Value Per Share 250 Historical Price

Intrinsic Value

Buy Price

Linear (Historical Price)

200

150

100

50

0 1/21/2003

-50

7/21/2003

1/21/2004

7/21/2004

1/21/2005

7/21/2005

1/21/2006

7/21/2006

1/21/2007

7/21/2007

1/21/2008

7/21/2008

1/21/2009

7/21/2009

Company Name

ticker

Apple Inc

AAPL

10/1/2009

User Growth

Figures in Millions except per share values

30.00% User Input Params

www.oldschoolvalue.com

Desired MOS

Growth

Price

Actual DC%

66%

30.0%

$ 183.62

0%

1999 0.90 2009 $ 2.99 $

Diluted EPS

Earnings Growth EPS Weighted Average

2000 1.09 2010 $ 3.92 $

Share Value $

2001 2002 (0.04) $ 0.09 2011 2012 $ 5.13 $ 5.56

$

102.87

Buy under

P/B Ratio

$

34.97

Earnings 2003 $ 0.10 $

2004 0.36

$

Net Net Working Capital 9

7.95

$

2005 1.56

$

4.67 2006 2.27

$

2007 3.93

Multi-Year Performance 2003-2007 2004-2008 2003-2006 2004-2007 2005-2008 2003-2005 2004-2006 2005-2007 2006-2008 150.4% 96.4% 183.1% 121.8% 50.9% 295.0% 151.1% 58.7% 53.7% $ 1.64 $ 2.70 $ 1.07 $ 2.03 $ 3.28 $ 0.67 $ 1.40 $ 2.59 $ 3.85

Company Stats Normal Earnings Expected 5 Year Growth 20 yr A Corp Bond Rate Book Value Per Share Price to Book Ratio Enterprise Value Per Share

$

$

2.03 30.00% 6.26 23.31 7.95 158.71

Company Valuation

$6.00

Per Share Value

$

Desired MOS Purchase Price Current Price Actual Discount

$ $

102.87 66.00% 34.97 185.35 0%

2008 5.36

Median 121.8% $2.0

$5.36

EPS

Linear (EPS)

$5.00

$3.93

$4.00

$3.92 $2.99

$3.00

$2.27 $1.56

$2.00 $1.00

$

$0.90

$1.09 $0.09

$0.10

$(0.04) 2001 2002

2003

$0.36

$$(1.00)

1999

2000

2004

2005

2006

2007

2008

2009

2010

Old School Value | http://www.oldschoolvalue.com Company Name

ticker

Apple Inc

AAPL

10/1/2009

User Discount %

Figures in Millions except per share values

9% Discount Rate %

Net Reprod. Cost

EPV

$

9%

68.52

$10.57

Current Price

$

MOS %

185.35

Tangible BV

0%

$

30.26

NNWC

$

7.31

Reproduction Asset Value Quarterly numbers based on: 2009 Q3 Statement Source Date: 22-Jul-09

Assets Cash & Equivalents Marketable Securities Accounts Receivable - Gross Other Receivable

Receivables Inventories: Raw Materials Inventories: Work in Progress Inventories: Purchased Components Inventories: Finished Goods Inventories: Other Inventories -- Total Prepaid Expenses Current Defered Income Taxes Other Current Assets

Total Current Assets Goodwill, Net Intangibles, Net

Intangibles Property/Plant/Equipment - Net Long Term Investments Note Receivable - Long Term Other Long Term Assets, Total

Total Assets

Data Source

Book Value

Adjust +/-

Multiplier

$ 24,222.0 $ 18,617.0 $ 2,686.0 $ 1,494.0 $ 4,180.0 $ $ $ $ $ 380.0 $ 380.0 $ $ 1,731.0 $ 6,388.0 $ 36,901.0 $ 207.0 $ 370.0 $ 577.0

MSN Reproduction Asset Value

$

24,222.0

$ $ $

18,617.0 2,686.0 1,494.0

$

4,180.0

2002 CAPEX (statements) Last 6 yrs Last 5 yrs Last 4 yrs Last 3 yrs Last 2 yrs Last 1 yr PPE Sales R&D

0% 0%

$ 2,653.0 $ 6,899.0 $ $ 2,841.0 $ 49,871.0

$

380.0

$ $ $

1,731.0 6,388.0

$

36,901.0

$ $

0.0 0.0

$

0.0

$ $ $ $

2,653.0 6,899.0 2,841.0

$

49,294.0

2003

2004

2005

2006

2007

2008

$

174.0

$

164.0

$

176.0

$

260.0

$

657.0

$

735.0

$

1,091.0

$

1,088.0

$ $ $

513.0 406.0 174.0

$ $ $

570.0 338.0 164.0

$ $ $

514.0 340.0 176.0

$ $ $

600.0 436.0 260.0

$ $ $

1,093.0 917.0 657.0

$ $ $

1,652.0 1,392.0 735.0

$ $ $

2,483.0 1,826.0 1,091.0

$ $ $

2,914.0 2,179.0 1,088.0

$ $ $

621.0 5,742.0 447.0

$ $ $

669.0 6,207.0 471.0

$ $ $

707.0 8,279.0 489.0

$ $ $

817.0 13,931.0 534.0

$ $ $

1,281.0 19,315.0 712.0

$ 1,832.0 $ 24,006.0 $ 782.0

$ $ $

2,455.0 32,479.0 1,109.0

$ $ $

2,653.0 34,562.0 1,273.0

$3,500.0 $3,000.0

Last 6 yrs

$2,500.0

Last 5 yrs $2,000.0

Last 4 yrs Last 3 yrs

$1,500.0

Last 2 yrs $1,000.0

Last 1 yr

PPE

$500.0

Reproduction Asset Value

Liabilities & Equity

Book Value Corrected BV

Accounts Payable

$

4,854.0

$

4,854.0

Accrued Expenses Accrued Liabilities Notes Payable/Short Term Debt Current Port. of LT Debt/Capital Leases Other Current Liabilities

$ $ $

933.0 -

$ $ $

933.0 -

$ $

10,874.0

Total Current Liabilities

$ $ 10,874.0 $ 16,661.0

$

16,661.0

Long-Term Debt

$

-

$

-

Capital Lease Obligations

$

-

$

-

Deferred Income Taxes

$ $ $

970.0 4,621.0

$

22,252.0

Common Stock Equity Retained Earnings

$ 970.0 $ $ 4,621.0 $ 22,252.0 $ 25,888.0 $ 17,878.0

$ $

Total Capitalization Total Equity Total Liabilities & Stock Equity

$ 25,888.0 $ 25,888.0 $ 48,140.0

Minority Interest Total Other Liabilities

Total Liabilities

Multiplier

TTM

$-

2002

2003

2004

Asset Valuation Tangible BV

Total $

2005

2006

2007

2008

TTM

Asset Valuation Data

Per Share 27,042 $ 30.26

Shares Outstanding

893.7

$ $

27,042 6,530

$ $

30.26 7.31

Balance Sheet Assets Adjusted Assets Total Liabilities

$

55,270

$

61.84

Total Equity

$

27,619.0

$

33,018

$

36.95

$

9,446

$

10.57

Marketing/Brand Value R&D Value

$ $

4,354.0 1,622.4

25,888.0 17,878.0

Cash Needed for Business Interest Bearing Debt Non Interest Bearing Debt

$ $ $

345.6 22,252.0

$

25,888.0

Excess Cash

$

23,572.4

$ $

27,619.0 48,140.0

Adjusted BV NNWC Reprod. Cost of Assets Reprod. Cost of Assets BV Total Net Reprod. Cost

$ $ $

49,871.0 49,294.0 22,252.0

893.71

Old School Value | http://www.oldschoolvalue.com

Earnings Power Value (EPV) 5 Year Annual Data Period End Date Period Length Statement Source Income Statement Sales EBIT EBIT Margin EBIT at user defined % of sales EBIT User Defined % Margin Normalized EBITDA Normalized EBIT SG&A R&D

25-Sep-04 52 Weeks 10-K

$ $

24-Sep-05 52 Weeks 10-K

2004 8,279 $ 383.0 $

30-Sep-06 53 Weeks 10-K

Past 4 Quarterly Data 29-Sep-07 52 Weeks 10-K

27-Sep-08 52 Weeks 10-K

2005 13,931 $ 1,815.0 $

2006 19,315 $ 2,818.0 $

2007 24,006 $ 5,008.0 $

4.6%

13.0%

14.6%

20.9%

4.6% 486.0 336.0 500.5 122.8

13.0% 1,822.0 1,643.0 652.4 133.8

14.6% 2,678.0 2,453.0 851.6 178.0

20.9% 4,726.0 4,409.0 1,037.1 195.5

27-Sep-08 13 Weeks 10-K

2008 32,479 6,895.0

27-Dec-08 13 Weeks 10-Q

28-Mar-09 13 Weeks 10-Q

27-Jun-09 13 Weeks 10-Q

2008 Q4 $7,895.0 $ $1,582.0

2009 Q1 10,167.0 $ $2,284.0

2009 Q2 8,163.0 $ $1,730.0

2009 Q3 8,337.0 $ $1,732.0 $

TTM 34,562.0

21.2%

20.0%

22.5%

21.2%

20.8%

$ $ $ $

21.2% 6,794.0 6,275.0 1,316.4 277.3

20.0% $1,576.0 $1,442.0 $349.7 $74.5

22.5% 2,284.0 2,126.0 349.7 74.5

21.2% 1,839.0 1,667.0 381.9 78.8

20.8% 1,848.0 1,672.0 344.8 79.8

$ $ $ $

21.2% 21.2% 7,547.0 6,907.0 1,425.9 307.5

$ $ $ $ $

$ $ $ $

$ $ $ $

$ $ $ $

$ $ $ $

$ $ $ $

$ $ $ $

7,328.0

Adjusted EBIT Adjusted EBIT %

$

1,006.3 $ 12.2%

2,601.2 $ 18.7%

3,847.6 $ 19.9%

6,240.6 $ 26.0%

8,488.6 26.1%

$2,006.2 $ 25.4%

2,708.2 $ 26.6%

2,190.6 $ 26.8%

2,156.5 $ 25.9%

9,061.4 26.2%

Income Before Tax Income Tax - Total Tax Rate

$ $

370.0 $ 104.0 $ 28.1%

1,808.0 $ 480.0 $ 26.5%

2,818.0 $ 829.0 $ 29.4%

5,008.0 $ 1,512.0 $ 30.2%

6,895.0 2,061.0 29.9%

$1,582.0 $ $446.0 $ 28.2%

2,284.0 $ 679.0 $ 29.7%

1,730.0 $ 525.0 $ 30.3%

1,732.0 $ 503.0 $ 29.0%

7,328.0 2,153.0 29.4%

Adjusted Earnings After tax Depreciation & Amortization Add user defined % of D&A

$ $ $

723.4 150.0 30.0

1,910.6 179.0 35.8

2,715.7 225.0 45.0

4,356.4 317.0 63.4

5,951.3 519.0 103.8

$1,440.6 $134.0 $26.8

$ $ $

1,903.06 158.0 31.6

$ $ $

1,525.82 172.0 34.4

$ $ $

1,530.22 176.0 35.2

$ $ $

6,399.7 640.0 128.0

Income as Adjusted Income as Adjusted % Operating Income as Reported

$

753.4 $ 9.1% 326.0 $

6,055.1 18.6% 6,275.0

$1,467.4 $0.2 $1,442.0

$

1,934.7 $0.2 2,126.0

$

1,560.2 $0.2 1,667.0

$

1,565.4 $0.2 1,672.0

$

6,527.7 18.9% 6,907.0

PPE as a % of Sales Sales Growth (decrease) to Prior Year Capex Maintenance Capex Depr & Amort

$

$ $ $

2004 8.5% $ $ $ $

2,072.0 176.0 (0.9) 150.0

$ $ $ $

$ $ $

$ $ $

$ $ $

1,946.4 $ 14.0% 1,650.0 $

2,760.7 $ 14.3% 2,453.0 $

4,419.8 $ 18.4% 4,409.0 $

2005 5.9%

2006 6.6%

2007 7.6%

5,652.0 260.0 (71.5) 179.0

$ $ $ $

5,384.0 657.0 299.9 225.0

$ $ $ $

4,691.0 735.0 377.0 317.0

2008 7.6% $ $ $ $

8,473.0 1,091.0 450.5 473.0

2004-2005 2005-2006 2006-2007 2007-2008 2008-TTM 158.3% 41.8% 60.1% 37.0% 7.8% $ 1,349.9 $ 2,353.5 $ 3,590.2 $ 5,237.4 $ 6,291.4

Multiyear Timeframe Adjusted Income & Growth

$

TTM 7.7% $ $ $ $

2,083.0 1,088.0 928.1 640.0

$

$ $ $

583.8 330.5 330.7 Possible Values for Override Box Normalized Income $ 3,692.9 Avg Adj. Income 5 yrs $ 3,187.1 TTM Adjusted Income $ 6,527.7

$3,692.9

EPV Data Cost of Capital Normalized Adjusted Income Average Maintenance Capex Interest Bearing Debt 1% of sales Cash & Equiv Cash - Debt Shares

Normal. Adj. Income Growth

2004-2007 2005-2008 2006-TTM 31.4% 29.9% 13.9% $ 2,470.1 $ 3,795.5 $ 4,940.8

39.4%

2004-2008 2005-TTM 68.4% 35.3% $ 3,187.1 $ 4,341.9

Cost of Capital Rates 5% 7%

Per Share $ 75.24 $ 53.75

$

Average

Normalized Adjusted Income

2004-2006 2005-2007 2006-2008 2007-TTM 91.4% 50.7% 48.1% 21.5% $ 1,820.2 $ 3,042.3 $ 4,411.9 $ 5,667.5

$

+Cash-Debt Adjustment $ 91,123.1 $ 71,909.8

$ $

EPV 67,246.7 48,033.4

9%

$

37,359.3

$

41.80

$

11% 13%

$ $

30,566.7 25,864.1

$ $

34.20 28.94

$ $

$ $

Per Share 101.96 80.46

61,235.7

$

68.52

54,443.1 49,740.5

$ $

60.92 55.66

$ $ $ $ $ $

User Input

9% 3,692.9 330.5 345.62 24,222 23,876.38 894

35%

Company Name

ticker

Apple Inc

AAPL

10/1/2009

www.oldschoolvalue.com Stock Price Market Cap (millions) 52-Week High 52-Week Low % off 52-Week Low

AAPL 185.35 166,040 188.90 78.20 137.0%

MSFT 24.95 222,760 27.47 14.87 73.0%

IBM 118.66 155,550 122.88 69.50 72.1%

HPQ 46.33 109,850 48.00 25.39 85.9%

PALM 16.92 2,410 $18.09 1.14 1431.6%

RIMM

Industry

Ranking

67.81 38,580 Error Error #VALUE!

NA NA NA NA NA

NA NA NA NA NA

32.4 4.8 6.41 6.56 28.56 16.31 4.1 18.862

15.88 3.93 5.79 9.08 13.4 20.06 3.51 8.812

12.79 1.61 10.19 0 8.8 12.44 1.79 7.468

15.9 0.96 2.71 82.55 9.36 12.9 0.99 7.481

0 5.69 0 0 0 0 6.1 -8.445

19.07 2.92 5.49 6.93 16.81 86.02 Error Error

17.84 0.62 2.38 4.15 10.01 30.92 NA NA

1 2 2 4 1 3 NA NA

NA 0 0 0

2.01 3.96 26.58 31.71

1.84 1.27 24.7 21.53

0.68 0.91 0 10.46

NA 0 0 0

NA 0 0 0

0.01 1.71 7.28 29.02

4 3 4

11.7 4.8 39.23 13.89 11.88 124.7 48.87

-17.29 3.93 9.67 -25.55 -13.36 16.65 22.98

-13.31 1.61 3.06 17.61 15.54 18.93 -0.35

-2.07 0.96 10.13 -15.77 -7.71 31.39 8.43

-81.46 5.69 -4.97 -201.62 -427.44 0 18.42

36.8 2.92 79.45 -3.81 15.67 99.92 94.92

-4.99 0.62 29.2 -102.49 0 11.65 21.1

2 2 2 2 3 1 2

2.09 2.11 0 0

1.8 1.82 9.47 14.53

1.15 1.22 135.68 190.98

1.03 1.17 33.45 41.36

0.58 0.62 0 0

2.14 2.41 0 0

1.45 1.85 18.24 30.11

2 2 4 4

35.49 31.83 21.84 16.82 19.98 15.4 21.2 17.24 14.97 12.15

79.2 81.06 37.94 38.98 33.56 36.03 33.92 38.82 24.93 28.01

45.14 41.09 21.79 17.89 16.48 12.54 17.57 14.01 13 9.9

23.35 24 12.23 9.65 8.27 6.92 7.69 7.19 6.25 5.76

13.65 31.69 -83.11 -1.13 -90 -3.19 -102.25 -3.04 -195.37 -5.86

43.19 49.69 22.52 27.58 20.58 24.25 21.03 25.58 15.41 18.69

8.35 18.85 0 7.92 2.58 5.34 2.67 5.87 2 4.09

4 4 3 4 3 3 2 3

12.96 13.96 19.18 21.57 22.74 24

19.34 19.63 31.08 28.63 38.42 33.44

11.26 8.71 17.64 13.69 57.96 33.46

7.08 6.62 11.88 11.36 18.3 14.59

-87.72 -6.44 -204.16 -9.79 0 -14.6

25.23 23.7 33.6 30.42 34.07 30.99

3.45 6.9 7.23 13.65 8.38 14.6

3 3 3 3 4 4

1080063 161719 16.12 48.21 0.87

628355 156656 4.72 14.28 0.78

244112 31745 3.81 19.04 0.87

365125 22816 6.97 12.82 1.13

464914 -908304 4 11.98 0.45

1030820 158844 6.39 13.81 1.64

8635093 169986 5.72 8.77 1.28

NA NA NA NA 3

Valuation Ratios P/E Ratio (TTM) Price to Sales (TTM) Price to Book (MRQ) Price to Tangible Book (MRQ) Price to Cash Flow (TTM) Price to Free Cash Flow (TTM) Enterprise Value/Revenue (TTM) Enterprise Value/EBITDA (TTM)

Dividends Dividend Yield Dividend Yield - 5 Year Avg. Dividend 5 Year Growth Rate Payout Ratio (TTM)

Growth Rates Sales (MRQ) vs Qtr. 1 Yr. Ago Sales (TTM) vs TTM 1 Yr. Ago Sales - 5 Yr. Growth Rate EPS (MRQ) vs Qtr. 1 Yr. Ago EPS (TTM) vs TTM 1 Yr. Ago EPS - 5 Yr. Growth Rate Capital Spending - 5 Yr. Growth Rate

Financial Strength Quick Ratio (MRQ) Current Ratio (MRQ) LT Debt to Equity (MRQ) Total Debt to Equity (MRQ)

Profitability Gross Margin (TTM) Gross Margin - 5 Yr. Avg. EBITD Margin (TTM) EBITD - 5 Yr. Avg. Operating Margin (TTM) Operating Margin - 5 Yr. Avg. Pre-Tax Margin (TTM) Pre-Tax Margin - 5 Yr. Avg. Net Profit Margin (TTM) Net Profit Margin - 5 Yr. Avg.

3 3

Management Effectiveness Return Return Return Return Return Return

On On On On On On

Assets (TTM) Assets - 5 Yr. Avg. Investment (TTM) Investment - 5 Yr Avg Equity (TTM) Equity - 5 Yr. Avg.

Efficiency Revenue/Employee (TTM) Net Income/Employee (TTM) Receivable Turnover (TTM) Inventory Turnover (TTM) Asset Turnover (TTM)

Company Name

ticker

Apple Inc

AAPL

www.oldschoolvalue.com

10/1/2009

Figures in Millions except per share values

Net Profit Margin 15.0%

14.9%

Cash Flow (Continuing Operations) 14.6%

11344.0 10.3%

9.8%

9.6% 3.3%

9596.0

9.8%

5470.0 1.1%

1.1%

2220.0

2535.0 934.0

289.0

826.0

798.0

2006/12 5470.0

2005/12 2220.0

2004/12 2535.0

2003/12 934.0

2002/12 289.0

2001/12 89.0

2000/12 185.0

1999/12 826.0

1998/12 798.0

146.4%

-12.4%

171.4%

223.2%

224.7%

-51.9%

-77.6%

3.5%

--

-0.5% TTM 2008/09 15.0% 14.9% 2.2% % Change

2007/09 14.6%

2006/09 10.3%

2005/09 9.6%

2004/09 3.3%

2003/09 1.1%

2002/09 1.1%

2001/09 -0.5%

2000/09 9.8%

1999/09 9.8%

41.4%

7.5%

187.5%

199.9%

-1.8%

342.8%

-104.7%

0.5%

--

Magic Formula Investing -- Return on Capital 28.1%

25.0%

27.4%

23.5%

25.0%

2.6%

3.3%

2006/12 27.4%

2005/12 23.5%

2004/12 20.1%

2003/12 8.1%

2002/12 2.6%

2001/12 3.3%

-4.7% 2000/12 -4.7%

1999/12 16.2%

1998/12 13.3%

16.8%

16.7%

149.2%

206.7%

-20.3%

170.2%

-129.1%

22.1%

--

11.6%

11.6%

11.6%

11.6%

13.8%

11.0%

5.3%

Return on Assets (ROA) 12.2%

185.0

15.8% 13.3%

8.1%

10.7%

89.0

Magic Formula Investing -- Earnings Yield

20.1% 16.2%

Now 2007/12 28.1% 25.0% -8.8% % Change

TTM 2007/12 11344.0 9596.0 % Change 75.4%

Now 2007/12 5.3% 11.0% % Change 241.0%

5.2%

3.2%

4.7%

5.0%

4.1%

3.2%

2006/12 3.2%

2005/12 4.7%

2004/12 5.0%

2003/12 4.1%

2002/12 3.2%

2001/12 15.8%

-6.6% 2000/12 -6.6%

1999/12 25.0%

1998/12 5.2%

-31.0%

-7.3%

22.4%

26.9%

-79.5%

340.1%

-126.3%

380.5%

--

Return on Equity (ROE) 23.0%

24.1%

20.0%

19.9%

17.9%

19.5%

20.3%

3.4% 1.0%

1.0%

5.4% 1.6%

-0.6% 2009/06 2007/12 10.7% 12.2% % Change -11.6%

2006/12 13.8%

2005/12 11.6%

2004/12 11.6%

2003/12 3.4%

2002/12 1.0%

2001/12 1.0%

2000/12 -0.6%

1999/12 11.6%

1998/12 11.6%

19.0%

0.0%

241.2%

240.0%

0.0%

266.7%

-105.2%

0.0%

--

3.2

3.4

Current Ratio

2.1

2009/06 2007/12 2.1 2.5 4.3% % Change

1.6%

0.0%

2006/12 24.1%

2005/12 19.9%

2004/12 17.9%

2003/12 5.4%

2002/12 1.6%

2001/12 1.6%

2000/12 0.0%

1999/12 19.5%

1998/12 20.3%

21.1%

11.2%

231.5%

237.5%

0.0%

#DIV/0!

-100.0%

-3.9%

--

2.3

2.6

2.2

2.5

2006/12 2.3

2005/12 2.2

2004/12 2.9

2003/12 2.6

2002/12 2.5

2001/12 3.2

2000/12 3.4

1999/12 2.8

1998/12 2.8

5.6%

-24.4%

12.1%

4.9%

-23.2%

-4.7%

21.2%

1.3%

--

Quick Ratio 3.0

2.5

2009/06 2007/12 20.0% 23.0% -4.6% % Change

2.4

2.6

2.5

2.2

2.8

2.9

2.8 2.1

2006/12 2.4

2005/12 2.2

2004/12 3.0

2003/12 2.6

2002/12 2.5

2001/12 3.2

2000/12 3.4

1999/12 2.8

1998/12 2.8

5.3%

-24.2%

12.3%

5.4%

-23.1%

-4.1%

20.7%

1.5%

--

2.4

2009/06 2007/12 2.1 2.4 4.4% % Change

3.2

3.4 2.8

2.8

Company Name

ticker

Apple Inc

AAPL

10/1/2009

Figures in Millions except per share values

www.oldschoolvalue.com

Company Assessment: Quantitative Valuation

Criteria over 5yrs

DCF Valuation Discount

> 25% or 50% depending on moat

0%

0

Graham Intrinsic Value Discount

> 66%

0%

0

Criteria over 5yrs

Margins, Profit and Growth Median Revenue growth Median Gross Margin Median Operating Margin Median Net Margin Median EPS growth

30% 15% 10% 10%

Criteria over 5yrs

Cash growth from Operations CROIC is postive and capable of paying off financing Median FCF growth positive and consistent Median FCF/Sales Consistent ROE (manually check) Consistent ROA (manually check)

15% 13% 10% 7% Consistent over 10yrs Consistent over 10yrs

Criteria for TTM

Balance Sheet Current assets > 1.5 x current liabilities Price to Book ratio < 2 Debt to Equity FCF to Debt Capitalization Ratio Intangibles % of assets

User Points

Points

Value 40.7% 29.0% 12.3% 9.9% 121.8%

10%

Business and Management Performance

Value

Points

Value 80.3% 15.2% 130.9% 8.5% N/A N/A

N/A

2.5 7.95

< 100%

88.2%

> 10%

22.7%

< 30%

0%

< 15% of assets

1.0%

User Points

2 1 2 1 N/A N/A Points

Value

> 1.5 x current liabilities

User Points

2 0 0 0 2

1 N/A 1 2 2 2

User Points N/A

Company Assessment: Qualitative

Apple Inc.designs, manufactures, and markets personal computers, portable digital music players, and mobile communication devices and sells a variety of related software, services, peripherals, and networking solutions. The Company sells its products worldwide through its online stores, its retail stores, its direct sales force, and third-party wholesalers, resellers, and value-added resellers. In addition, the Company sells a variety of third-party Macintosh (Mac), iPod and iPhone compatible products, including application software, printers, storage devices, speakers, headphones, and various other accessories and peripherals through its online and retail stores, , and digital content through the iTunes Store. It sells to consumer, small and mid-sized business (SMB), education, enterprise, government, and creative customers.

Competitive Advantage Stable market share? Dominant company in industry, segment? Low barriers to entry and exit? Experience goods (brand effect, trademarks) High switching costs? Network effect? E.g. eBay

Comment

User Points

Max Points max 2 max 2 max 2 max 2 max 2 max 2

Business Model

Comment

User Points

Max Points

Growth due to: a) existing product / existing market (yes/no) b) existing product / new market (yes/no) c) new product / existing market (yes/no) d) new product / new market (yes/no) Able to increase prices and retain customers? Compete on price? (1 for no, 0 for yes) Barriers of entry to the business? Diverse customers? (1 for diverse, 0 for concentrated) Involved in competition? Monopoly, duopoly, crowded Company has a recurring revenue stream? Capital intensive company? (1 for no, 0 for yes)

a) Yes b) No c) No d) NO

max 2

max 1 max 1 max 1 max 1 max 2 max 1 max 1

Management High insider ownership? Candid management on positives and negatives? Management performance at previous jobs? Compensation levels compared to sales?

Comment

User Points

Max Points max 1 max 1 max 1 max 1

Industry Boring industry? (1 for slow, 0 for fast industry) Can company adapt to changing industry environment? Industry leader or lagger? (1 for leader, 0 for lagger)

Comment

User Points

Max Points max 1 max 1 max 1

Psychological Factors to Consider. Not Weighted.

Comment No No Yes No No

Recency bias? Hindsight bias? Framing issues correctly and in different manners? Is there a data framing bias? Am I too overconfident on the situation? Performed probability analysis for -ve factors? Too much loss aversion? Sunk cost mentality? Slow in changing opinion? Psychological denial ? Bias from commitment and consistency tendency? Pavlovian association? Social proof bias? Status quo bias? False consensus bias? st Category

Total Points out of 5

Valuation Margins, Profit and Growth Business and Management Performance Balance Sheet Competitive Advantage Business Model Management

Low Risk 2.5 2.5

High Growth 5.0 5.0

Under Valued 0.0

0.0 2.0 3.0 4.0 0.0 0.0 0.0

Well Managed 4.5 4.5

Good Financial Health 5.0 5.0

Low Risk 5.0 4.0 Strong Moat

3.0

High Growth

2.0 1.0 0.0

Good Financial Health

Under Valued

Well Managed

Strong Moat 4.0 4.0

Related Documents


More Documents from ""