1/29/2010 2009 360 Apple Inc. 2010 $1,000 $192.06 1000 30% 900,678
1/29/2010 2009 360 Apple Inc. 2010 $1,000 $192.06 1000 30% 900,678
1/29/2010 2009 360 Apple Inc. 2010 $1,000 $192.06 1000 30% 900,678
- Financial Statements
($ in Millions, Except Per Share Amounts in Dollars and Share Counts in Thousands)
Valuation Date: 1/29/2010 Last Historical Year: 2009 Days in Year: 360
Company Name: Apple Inc. Debt Issue Date: 2010 Debt Amount: $1,000
Share Price: $192.06 Share Units: 1000 Tax Rate: 30%
Basic Shares Outstanding: 900,678 Options Calculations (in Thousands Except Exercise Price):
Basic Equity Value: $172,984
Diluted Shares Outstanding: 920,526 Exercise
Diluted Equity Value: $176,796 Name Number Price Dilution
Less: Cash & Investments $35,395 Tranche A 34,375 $81.17 19,847
Plus: Debt $0 Tranche B
Plus: Minority Interest $0 Tranche C
Plus: Preferred Stock $0 Tranche D
Plus: Other Liabilities $0 Tranche E
Enterprise Value: $141,401 Total 19,847
Historical Projections
FY 2007 FY 2008 FY 2009 FY 2010E FY 2011E FY 2012E FY 2013E FY 2014E
Equity Value / FCF: 37.3 x 20.8 x 17.1 x 13.5 x 12.1 x 10.9 x 10.1 x 9.1 x
P / E: 48.9 x 28.3 x 21.2 x 16.6 x 14.1 x 12.2 x 11.1 x 9.8 x
P / BV: 7.9 x 5.6 x 4.1 x 3.1 x 2.4 x 2.0 x 1.6 x
Operating Assumptions
Historical Projections
FY 2007 FY 2008 FY 2009 FY 2010E FY 2011E FY 2012E FY 2013E FY 2014E
Revenue Growth %: 27.2% 52.5% 14.4% 25.0% 17.0% 11.0% 9.0% 7.0%
COGS % Revenue: 66.2% 64.1% 59.0% 59.0% 59.0% 59.0% 59.0% 59.0%
R&D % Revenue: 2.4% 2.0% 1.9% 1.9% 1.9% 1.9% 1.9% 1.9%
SG&A % Revenue: 11.1% 8.9% 8.3% 8.3% 8.3% 8.3% 8.3% 8.3%
Stock-Based Compensation % Revenue: 1.0% 1.4% 1.7% 1.7% 1.7% 1.7% 1.7% 1.7%
Depreciation & Amortization % Revenue: 1.3% 1.3% 1.7% 1.7% 1.7% 1.7% 1.7% 1.7%
Effective Cash Interest Rate: 5.3% 3.4% 1.4% 1.0% 1.0% 2.0% 2.0% 3.0%
Debt Interest Rate: 0.0% 0.0% 0.0% 9.0% 9.0% 9.0% 9.0% 9.0%
Effective Tax Rate: 30.2% 31.6% 31.8% 30.0% 30.0% 30.0% 30.0% 30.0%
Accounts Receivable % Revenue: 6.5% 7.8% 7.8% 7.8% 7.8% 7.8% 7.8%
Accounts Receivable Days: 23.3 28.2 28.2 28.2 28.2 28.2 28.2
Inventory % COGS: 2.1% 1.8% 1.8% 1.8% 1.8% 1.8% 1.8%
Amortization of Intangibles: $40 $37 $28 $13 $10
Accounts Payable % COGS: 23.0% 22.1% 22.1% 22.1% 22.1% 22.1% 22.1%
Accounts Payable Days: 82.6 79.6 79.6 79.6 79.6 79.6 79.6
Accrued Expenses % Operating Expenses: 102.9% 87.6% 87.6% 87.6% 87.6% 87.6% 87.6%
Short-Term Deferred Revenue % Revenue: 4.3% 4.8% 4.8% 4.8% 4.8% 4.8% 4.8%
Long-Term Deferred Revenue % Revenue: 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0%
CapEx % Revenue: 3.0% 2.9% 2.7% 2.7% 2.7% 2.7% 2.7% 2.7%
Income Statement
FY 2007 FY 2008 FY 2009 FY 2010E FY 2011E FY 2012E FY 2013E FY 2014E
Operating Income: $4,407 $8,327 $11,740 $14,635 $17,133 $19,030 $20,761 $22,218
Interest Income: $647 $653 $407 $424 $568 $1,443 $1,780 $3,223
Interest Expense: $0 $0 $0 ($45) ($90) ($90) ($90) ($90)
Other Income & Expense: ($48) ($33) ($81) $0 $0 $0 $0 $0
Pre-Tax Income: $5,006 $8,947 $12,066 $15,014 $17,610 $20,383 $22,450 $25,351
Income Tax Provision: $1,511 $2,828 $3,831 $4,504 $5,283 $6,115 $6,735 $7,605
Net Income: $3,495 $6,119 $8,235 $10,510 $12,327 $14,268 $15,715 $17,746
Earnings Per Share (EPS): $3.93 $6.78 $9.08 $11.59 $13.59 $15.73 $17.33 $19.56
Diluted Shares Outstanding: 889,292 902,139 907,005 907,005 907,005 907,005 907,005 907,005
Balance Sheet
FY 2008 FY 2009 FY 2010E FY 2011E FY 2012E FY 2013E FY 2014E
Assets:
Current Assets:
Cash & Cash-Equivalents: $11,875 $6,559 $20,620 $35,238 $51,396 $68,903 $88,285
Short-Term Securities: $10,236 $26,282 $26,282 $26,282 $26,282 $26,282 $26,282
Accounts Receivable: $2,422 $3,361 $4,201 $4,915 $5,456 $5,947 $6,364
Inventory: $509 $455 $569 $665 $739 $805 $861
Deferred Tax Assets: $1,044 $4 $4 $4 $4 $4 $4
Other Current Assets: $3,920 $3,140 $3,140 $3,140 $3,140 $3,140 $3,140
Total Current Assets: $30,006 $39,801 $54,816 $70,245 $87,017 $105,082 $124,936
Long-Term Assets:
Long-Term Securities: $2,379 $2,554 $2,554 $2,554 $2,554 $2,554 $2,554
Plants, Property & Equipment: $2,455 $2,839 $3,352 $3,951 $4,617 $5,342 $6,118
Goodwill: $207 $207 $207 $207 $207 $207 $207
Other Intangible Assets: $285 $354 $314 $277 $249 $236 $226
Other Assets: $839 $2,011 $2,011 $2,011 $2,011 $2,011 $2,011
Total Assets: $36,171 $47,766 $63,253 $79,245 $96,654 $115,432 $136,052
Long-Term Liabilities:
Deferred Revenue: $768 $853 $1,066 $1,248 $1,385 $1,509 $1,615
Long-Term Debt: $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000
Other Long-Term Liabilities: $1,745 $3,502 $3,502 $3,502 $3,502 $3,502 $3,502
Total Liabilities: $13,874 $15,861 $19,951 $22,577 $24,565 $26,371 $27,902
Shareholders' Equity:
Common Stock: $7,177 $7,177 $7,177 $7,177 $7,177 $7,177 $7,177
Additional Paid-In Capital: $0 $1,185 $2,073 $3,111 $4,263 $5,520 $6,864
Treasury Stock: $0 $0 $0 $0 $0 $0 $0
Retained Earnings: $15,129 $23,364 $33,874 $46,201 $60,470 $76,185 $93,930
Accumulated Other Comprehensive Income: ($9) $179 $179 $179 $179 $179 $179
Total Shareholders' Equity: $22,297 $31,905 $43,302 $56,668 $72,089 $89,061 $108,151
Total Liabilities & SE: $36,171 $47,766 $63,253 $79,245 $96,654 $115,432 $136,052
Investing Activities:
Purchases of Securities: ($11,719) ($22,965) ($46,724) $0 $0 $0 $0 $0
Proceeds from Maturities & Sales: $9,424 $16,243 $30,678 $0 $0 $0 $0 $0
Purchases of LT Investments: ($17) ($38) ($101) $0 $0 $0 $0 $0
Capital Expenditures: ($735) ($1,091) ($1,144) ($1,430) ($1,673) ($1,857) ($2,024) ($2,166)
Acquisition of Intangibles: ($251) ($108) ($69) $0 $0 $0 $0 $0
Other: $49 ($230) ($74) $0 $0 $0 $0 $0
Cash Flow from Investing: ($3,249) ($8,189) ($17,434) ($1,430) ($1,673) ($1,857) ($2,024) ($2,166)
Financing Activities:
Proceeds from Common Stock: $365 $483 $475 $0 $0 $0 $0 $0
Common Stock Repurchased: $0 $0 $0 $0 $0 $0 $0 $0
Dividends Issued: $0 $0 $0 $0 $0 $0 $0 $0
Tax Benefits from Stock-Based Comp: $377 $757 $270 $0 $0 $0 $0 $0
Raise / (Pay Off) Long-Term Debt $0 $0 $0 $1,000 $0 $0 $0 $0
Cash Used for Equity Awards: ($3) ($124) ($82) $0 $0 $0 $0 $0
Cash Flow from Financing: $739 $1,116 $663 $1,000 $0 $0 $0 $0
Increase / Decrease in Cash: $2,960 $2,523 ($5,316) $14,061 $14,618 $16,158 $17,507 $19,382
Cash & Cash Equivalents: $9,352 $11,875 $6,559 $20,620 $35,238 $51,396 $68,903 $88,285
Err:502
($ in Millions, Except Per Share Amounts in Dollars and Share Counts in Thousands)
Err:502 Err:502
25th 75th
Minimum Pecentile Median Pecentile Maximum
Methodology Name Multiple Multiple Multiple Multiple Multiple
Precedent Transactions:
Precedent Transactions
DCF Analysis
0 2 4 6 8 10
10 12
Projected
EBITDA EPS Revenue EBITDA Margin
2010E 2009 2010E Growth 2009 2010E
$ 18,186 $ 3.14 $ 3.87 8.4% 14.3% 14.6%
4,129 0.79 1.18 7.7% 6.7% 7.5%
12,774 0.97 1.38 18.3% 28.9% 31.0%
18,332 0.41 1.17 21.8% 38.8% 45.9%
1,927 (1.70) 0.14 (6.0%) 3.9% 8.7%
Enterprise Value /
EBITDA P / E Multiple
2010E 2009 2010E
6.8 x 15.0 x 12.2 x
3.7 x 16.4 x 10.9 x
8.4 x 23.1 x 16.3 x
5.1 x 47.2 x 16.6 x
5.5 x NM 44.6 x
Err:502
Equity Enterprise
Acquirer Name Target Name Date Value Value
Hewlett-Packard Company 3Com 11/11/2009 $ 3,180 $ 2,714
Cisco Systems, Inc. Starent Networks 10/13/2009 2,777 2,386
Emerson Electric Co. Avocent 10/6/2009 1,114 1,147
EMC Corporation Data Domain 7/8/2009 2,362 2,085
Oracle Corporation Sun Microsystems 4/20/2009 7,075 5,392
Brocade Communication Systems, Inc. Foundry Networks 7/21/2008 2,899 2,063
Err:502
FY 2010E FY 2011E FY 2012E FY 2013E FY 2014E
Err:502
Discount Rate
$ 204.96 10.0% 11.0% 12.0% 13.0% 14.0% 15.0% 16.0%
0.0% $ 220.90 $ 214.27 $ 207.97 $ 201.98 $ 196.28 $ 190.85 $ 185.68
Terminal Growth
Err:502
Discount Rate
$ 204.96 10.0% 11.0% 12.0% 13.0% 14.0% 15.0% 16.0%
4.0 x $ 170.39 $ 165.99 $ 161.81 $ 157.83 $ 154.03 $ 150.40 $ 146.95
Terminal EBITDA
Err:502
Unlevered Equity Levered
Beta Debt Value Tax Rate Beta
WACC = Cost of Equity * % Equity + Cost of Debt * % Debt * (1 - Tax Rate) + Cost of Preferred Stock * % Preferred
WACC 12.50%
of Preferred Stock * % Preferred Stock