Analysts: Spencer Elkinton, Jake Gregg and Adam Smith
AAPL
Washburn University Applied Portfolio Management
Apple Inc.
Sector:
HOLD
Information Technology Report Date:
Market Cap (mm) Return on Capital EPS (ttm) Current Price 12‐mo. Target Price
$614,005 139.9% $9.46 $106.72 $130.00
Annual Dividend Dividend Yield Price/Earnings (ttm) Economic Value‐Added (ttm) Free Cash Flow Margin
$2.03 1.9% 11.3 $49,438 17.8%
Business Description Apple Inc. designs, manufactures, and markets mobile communication and media devices, personal computers, and portable digital music players to consumers, small and mid‐sized businesses, education, and enterprise and government customers worldwide. The company also sells related software, services, accessories, networking solutions, and third‐party digital content and applications. It offers iPhone, a line of smartphones; iPad, a line of multi‐ purpose tablets; and Mac, a line of desktop and portable personal computers. The company also provides iLife, a consumer‐oriented digital lifestyle software application suite; iWork, an integrated productivity suite that helps users create, present, and publish documents, presentations, and spreadsheets; and Investment Thesis Apple continues to be a strong stock for the SIF, boasting growing revenue, large market share and a dedicated consumer base, and high returns on assets, equity, and invested capital. Apple has steadily increased R&D investment in order to maintain its competitive advantage. The Information Technology sector is currently underweighted in the SIF, and we believe that as macroeconomic recovery slows, this sector will foster strong growth with lower volatility than the currently overweighted Energy and Utilities sectors. Apple operates in a highly competitive and rapidly changing sector while maintaining a low beta, which has led us to the decision to hold with the potential to increase our position.
2‐Yr Beta (S&P 500 Index) Annualized Alpha Institutional Ownership Short Interest (% of Shares) Days to Cover Short
AAPL
1.19 ‐13.0% 5.8% 0.9% 1.0
ANNUALIZED 3‐YEAR CAGR Total Revenue EBIT NOPAT Earnings Per Share Dividends Per Share
Margins and Yields
14.3% 8.8% 8.3% 13.3% 73.4%
2011
Operating Margin Free Cash Flow Margin Earnings Yield Dividend Yield Per Share Metrics
Free Cash Flow Total Invested Capital Total Assets Economic Value‐Added Market Value‐Added
2012
31.2% N/A 6.9% 0.0% 2011
2012
4.01 0.00 3.96 N/A
Earnings Dividends NOPAT Free Cash Flow
35.3% 20.4% 6.7% 0.4%
6.38 0.38 6.32 4.88
Economic Value‐Added
2013 28.7% 13.8% 8.3% 2.4% 2013 5.72 1.64 5.59 3.63
9.1% 1.2% 18.2% 8.7% 2.3%
2014
30.5% 17.8% 8.1% 1.7%
2014
2015
6.49 1.82 6.37 10.03
9.28 1.98 9.12 7.21
2011
GOOGL
$500,000
20
$400,000
$30,000
$300,000
$20,000
$200,000
$10,000
$100,000
5
$0
0
Datasource: Capital IQ
ROIC
2013
2014
2015
Net Operating Profit After Tax
2012
Price/Earnings
$40,000
2015
2012
2011
Market Valued‐Added
2014
^SPX
ROE
EBIT
$50,000
2013
KOSE:A005930
$80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0
25
2012
and the S&P 500 Index
160% 140% 120% 100% 80% 60% 40% 20% 0%
$600,000
2011
Samsung Electronics Co. Ltd.
AAPL
$60,000
$0
Alphabet Inc.
10% 5% 0% ‐5% ‐10% ‐15% ‐20% ‐25% ‐30%
2015
28.7% 33.4% 6.4% 1.8%
Compared With:
50% 40% 30% 20% 10% 0% ‐10% ‐20% ‐30% ‐40%
ROA
2013
2014
2015
Price/Free Cash Flow
15 10
2012
2013
4/18/2016
Apple Inc.
2014
2015
Apple Inc.
Sector
AAPL
Information Technology
Alphabet Inc.
GOOGL
Income Statement Highlights 2011
2012
2013
2014
Sector
Information Technology
Income Statement Highlights 2011
2012
2013
2014
2015
Total Revenue Cost of Goods Sold Gross Profit SG&A Expense R&D Expense Dep. & Amort. Other Oper. Exp. Operating Income Interest Expense Other Non‐Oper. Exp. EBT ex‐Unusuals Total Unusual Exp. Earnings Before Tax Income Tax Expense Net Income
108,249 64,431 43,818 7,599 2,429 0 0 33,790 0 (104) 34,205 0 34,205 8,283 25,922
156,508 87,846 68,662 10,040 3,381 0 0 55,241 0 (566) 55,763 0 55,763 14,030 41,733
170,910 106,606 64,304 10,830 4,475 0 0 48,999 (136) (324) 50,155 0 50,155 13,118 37,037
182,795 112,258 70,537 11,993 6,041 0 0 52,503 (384) (636) 53,278 205 53,483 13,973 39,510
233,715 140,089 93,626 14,329 8,067 0 0 71,230 (733) (812) 72,606 (91) 72,515 19,121 53,394
2015
Total Revenue Cost of Goods Sold Gross Profit SG&A Expense R&D Expense Dep. & Amort. Other Oper. Exp. Operating Income Interest Expense Other Non‐Oper. Exp. EBT ex‐Unusuals Total Unusual Exp. Earnings Before Tax Income Tax Expense Net Income
37,905 13,188 24,717 7,313 5,162 0 0 12,242 (58) (314) 12,682 (356) 12,326 2,589 9,737
46,039 17,176 28,863 8,946 6,083 0 0 13,834 (85) (450) 13,999 470 14,469 2,916 10,737
55,519 21,993 33,526 10,986 7,137 0 0 15,403 (81) (298) 15,790 109 15,899 2,739 12,733
66,001 25,313 40,688 13,982 9,832 0 0 16,874 (101) (272) 17,247 12 17,259 3,639 14,136
74,989 28,164 46,825 15,183 12,282 0 0 19,360 (104) (270) 19,985 (334) 19,651 3,303 16,348
Earnings per Share Dividends per Share Effective Tax Rate Total Common Shares Year‐end Stock Price
$4.01 $0.00 24.22% 6,470 $57.76 996
$6.38 $0.38 25.16% 6,544 $95.30 997
$5.72 $1.64 26.15% 6,477 $68.96 998
$6.49 $1.82 26.13% 6,086 $100.75 999
$9.28 $1.98 26.37% 5,753 $114.71 1000
Earnings per Share Dividends per Share Effective Tax Rate Total Common Shares Year‐end Stock Price
$15.08 $0.00 21.00% 646 $322.95 996
$16.41 $0.00 20.15% 654 $353.69 997
$19.13 $0.00 17.23% 666 $560.36 998
$20.91 $0.00 21.08% 676 $530.66 999
$23.88 $0.00 16.81% 685 $778.01 1000
2011
2012
Balance Sheet Highlights
Assets Cash and Equivalents Short‐Term Investments Total Cash & ST Invest. Total Receivables Inventory Prepaid Expenses Total Current Assets Net PPE Total Assets Liabilities and Equity Accounts Payable Accrued Expenses Short‐Term Debt Total Current Liab. Long‐Term Debt Total Liabilities Preferred Equity Common Stock & APIC Retained Earnings Treasury Stock Total Common Equity Total Equity Total Liab. and Equity
1. Margins and Profitability
2013
Balance Sheet Highlights 2014
2015
9,815 16,137 25,952 11,717 776 0 44,988 7,777 116,371
10,746 18,383 29,129 18,692 791 0 57,653 15,452 176,064
14,259 26,287 40,590 20,641 1,764 0 73,286 16,597 207,000
13,844 11,233 25,158 27,219 2,111 0 68,531 20,624 231,839
21,120 20,481 41,995 30,343 2,349 0 89,378 22,471 290,479
14,632 4,829 0 27,970 0 39,756 0 13,331 62,841 0 76,615 76,615 116,371
21,175 6,749 0 38,542 0 57,854 0 16,422 101,289 0 118,210 118,210 176,064
22,367 8,427 0 43,658 16,960 83,451 0 19,764 104,256 0 123,549 123,549 207,000
30,196 18,372 6,308 63,448 28,987 120,292 0 23,313 87,152 0 111,547 111,547 231,839
35,490 24,169 8,499 80,610 53,463 171,124 0 27,416 92,284 0 119,355 119,355 290,479
Assets Cash and Equivalents Short‐Term Investments Total Cash & ST Invest. Total Receivables Inventory Prepaid Expenses Total Current Assets Net PPE Total Assets Liabilities and Equity Accounts Payable Accrued Expenses Short‐Term Debt Total Current Liab. Long‐Term Debt Total Liabilities Preferred Equity Common Stock & APIC Retained Earnings Treasury Stock Total Common Equity Total Equity Total Liab. and Equity
AAPL, Page 2 of 22
2011
2012
8,723 34,643 43,366 5,427 35 1,710 52,758 9,603 72,574
13,849 33,310 47,159 7,885 505 2,132 60,454 11,854 93,798
17,628 39,819 57,447 9,290 0 3,253 72,886 16,524 110,920
2013
16,585 46,048 62,633 9,974 0 3,412 78,656 23,883 129,187
2014
15,409 56,517 71,926 13,459 0 3,139 90,114 29,016 147,461
2015
588 3,069 3,225 8,913 2,986 14,429 0 20,264 37,605 0 58,145 58,145 72,574
2,012 5,490 4,222 14,337 2,988 22,083 0 22,835 48,342 0 71,715 71,715 93,798
2,453 6,253 3,374 15,908 1,990 23,611 0 25,922 61,262 0 87,309 87,309 110,920
1,715 7,474 4,777 16,779 2,992 25,327 0 28,767 75,066 0 103,860 103,860 129,187
1,931 8,293 4,428 19,310 1,995 27,130 0 32,982 89,223 0 120,331 120,331 147,461
Copyright Robert A. Weigand, Ph.D., 2016
AAPL Profit Margins Gross Profit Margin Operating Profit Margin Net Profit Margin Free Cash Flow Margin Gross Profit Margin
Apple Inc. 2011
2012
2013
2014
2015
40.5% 31.2% 23.9% N/A
43.9% 35.3% 26.7% 20.4%
37.6% 28.7% 21.7% 13.8%
38.6% 28.7% 21.6% 33.4%
40.1% 30.5% 22.8% 17.8%
GOOGL Profit Margins Gross Profit Margin Operating Profit Margin Net Profit Margin Free Cash Flow Margin
Gross Profit Margin
Operating Profit Margin
AAPL
40% 30% 20% 10% 0% 2011
2012
2013
Operating Profit Margin
2014
AAPL
2012
Net Profit Margin
GOOGL
2013
2014
AAPL
2015
20.0% 15.0% 10.0% 5.0% 0.0% 2012
2013
2014
2015
2014
2015
61.6% 25.6% 21.4% 0.9%
62.4% 25.8% 21.8% ‐1.0%
Operating Profit Margin
2012
2013
Free Cash Flow Margin
2014
AAPL
2015
GOOGL
40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% ‐5.0% ‐10.0%
25.0%
2011
2013
60.4% 27.7% 22.9% ‐3.4%
2011
GOOGL
30.0%
40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0%
2012
62.7% 30.0% 23.3% 12.9%
70% 60% 50% 40% 30% 20% 10% 0% 2011
2015
2011
65.2% 32.3% 25.7% N/A
Gross Profit Margin
GOOGL
70% 60% 50% 40% 30% 20% 10% 0%
50%
Alphabet Inc.
2011
2012
2013
2014
2015
2012
2013
2014
2015
Analyst Comments: AAPL's margins have been recovering since 2013, though have been in ranging competition with GOOGL. While AAPL's gross profit margin has consistently been 20‐25% below GOOGL, AAPL's operating margin has risen above GOOGL since 2013 and AAPL's net margin has risen above GOOGL since 2014. Though GOOGL significantly outperforms AAPL's gross profit margin, AAPL is able to convert revenues to bottom line profits more efficiently than GOOGL. AAPL's growing operating and net profit margins are a positive sign of revenue‐to‐profit conversion for investors.
1. Margins and Profitability
AAPL, Page 3 of 22
Copyright Robert A. Weigand, Ph.D., 2016
AAPL Profitability Ratios Net Profit Margin × Total Asset Turnover = Return on Assets × Equity Multiplier = Return on Equity
Apple Inc.
Return on Assets
2011
2012
2013
2014
2015
23.9% 0.9 22.3% 1.5 33.8%
26.7% 0.9 23.7% 1.5 35.3%
21.7% 0.8 17.9% 1.7 30.0%
21.6% 0.8 17.0% 2.1 35.4%
22.8% 0.8 18.4% 2.4 44.7%
GOOGL Profitability Ratios Net Profit Margin × Total Asset Turnover = Return on Assets × Equity Multiplier = Return on Equity
Total Asset Turnover
Return on Equity
50%
1.0
40%
0.8
30%
0.6
20%
0.4
10%
0.2
AAPL
2011
2012
2013
Equity Multiplier
2014
AAPL
GOOGL
2012
2013
2014
2015
23.3% 0.5 11.4% 1.3 15.0%
22.9% 0.5 11.5% 1.3 14.6%
21.4% 0.5 10.9% 1.2 13.6%
21.8% 0.5 11.1% 1.2 13.6%
Return on Assets
2012
2013
Return on Assets
2014
AAPL
2011
2015
25.0%
50.0%
2.5
20.0%
40.0%
15.0%
30.0%
10.0%
20.0%
0.5
5.0%
10.0%
0.0
0.0%
1.5 1.0
2011
2012
2013
2014
2015
2012
Return on Equity
GOOGL
3.0 2.0
Return on Equity
18% 16% 14% 12% 10% 8% 6% 4% 2% 0% 2011
2015
2011
25.7% 0.5 13.4% 1.2 16.7%
GOOGL
0.0
0%
Alphabet Inc.
2013
2014
AAPL
2015
GOOGL
0.0% 2011
2012
2013
2014
2015
2011
2012
2013
2014
2015
Analyst Comments: AAPL's profitability ratios have been in general downtrends, though they have been outperforming GOOGL. AAPL's total asset turnover has consistently outperformed GOOGL by 0.3, while ROA has outperformed GOOGL by 7‐9% and ROE has outperformed GOOGL by 15‐30%. AAPL's ROA has been in consolidation following a 5% drop in 2013, while ROE has risen nearly 15% since 2013. AAPL's outperformance of GOOGL in profitability ratios indicates AAPL's greater return on deployment of assets and equity than its competitor.
1. Margins and Profitability
AAPL, Page 4 of 22
Copyright Robert A. Weigand, Ph.D., 2016
AAPL Multiples and Yields Price/Earnings Price/Book Price/Free Cash Flow Earnings Yield Dividend Yield
Apple Inc. 2011
2012
14.4 3.2 N/A 6.9% 0.0%
Price/Earnings
14.9 3.5 19.5 6.7% 0.4%
2013
12.1 2.2 19.0 8.3% 2.4%
Price/Free Cash Flow
25.0
2014
2015
15.5 2.6 10.0 6.4% 1.8%
12.4 2.3 15.9 8.1% 1.7%
Price to Earnings
GOOGL Multiples and Yields Price/Earnings Price/Book Price/Free Cash Flow Earnings Yield Dividend Yield AAPL
15.0 10.0 5.0 0.0 2012
2013
Earnings Yield
2014
2015
2013
Earnings Yield
2014
2013
Price to Book
2014
AAPL
GOOGL
4.0 3.5 3.0 2.5 2.0 1.5 1.0 0.5 0.0
AAPL
Price/Free Cash Flow
2013
Earnings Yield
2014
2015
Dividend Yield
2.0% 1.0% 0.0% 2013
Dividend Yield
2014
AAPL
2015
2012
2013
Price to Free Cash Flow
GOOGL
2014
AAPL
2015
GOOGL
700.0 600.0 500.0 400.0 300.0 200.0 100.0 0.0
1.0% 0.5% 0.0% 2015
32.6 3.6 N/A 3.1% 0.0%
3.0%
1.5%
2014
2015
25.4 2.8 629.1 3.9% 0.0%
4.0%
2.0%
2013
2012
GOOGL
2.5%
2012
2014
29.3 3.4 N/A 3.4% 0.0%
5.0%
2012
2015
2013
21.6 2.5 39.1 4.6% 0.0% Price/Earnings
2015
9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.0% 2.0% 1.0% 0.0% 2012
2012
21.4 2.9 N/A 4.7% 0.0%
700.0 600.0 500.0 400.0 300.0 200.0 100.0 0.0 2012
Dividend Yield
9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.0% 2.0% 1.0% 0.0%
2011
GOOGL
35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0
20.0
Alphabet Inc.
2012
2013
2014
2015
2012
2013
2014
2015
Analyst Comments:
2. Relative Valuation and Debt
AAPL, Page 5 of 22
Copyright Robert A. Weigand, Ph.D., 2016
AAPL Liquidity and Debt Current Ratio Quick Ratio Days Sales Outstanding Inventory Turnover Total Debt to Assets Long‐Term Debt to Equity Times Interest Earned
Apple Inc.
Current Ratio
2011
2012
2013
2014
1.61 1.58 39.51 139.50 0.0% 0.0% N/A
1.50 1.48 43.59 197.86 0.0% 0.0% N/A
1.68 1.64 44.08 96.89 8.2% 13.7% 360.29
1.08 1.05 54.35 86.59 15.2% 26.0% 136.73
Quick Ratio
GOOGL Liquidity and Debt Current Ratio Quick Ratio Days Sales Outstanding Inventory Turnover Total Debt to Assets Long‐Term Debt to Equity Times Interest Earned
2015
1.11 1.08 47.39 99.50 21.3% 44.8% 97.18
Current Ratio
1.8 1.6 1.4 1.2 1.0 0.8 0.6 0.4 0.2 0.0
AAPL
2012
2013
Days Sales Outstanding
2014
2012
2013
Total Debt to Assets
Inventory Turnover
2012
2013
2014
2015
5.92 5.92 52.26 1083.00 8.6% 5.1% 211.07
4.22 4.18 62.51 91.17 7.7% 4.2% 162.75
4.58 4.58 61.08 N/A 4.8% 2.3% 190.16
4.69 4.69 55.16 N/A 6.0% 2.9% 167.07
4.67 4.67 65.51 N/A 4.4% 1.7% 186.15
Current Ratio
Quick Ratio
7.0 6.0 5.0 4.0 3.0 2.0 1.0 0.0 2011
2015
2011
GOOGL
7.0 6.0 5.0 4.0 3.0 2.0 1.0 0.0 2011
Alphabet Inc.
2014
2015
AAPL
GOOGL
2011
2012
2013
Days Sales Outstanding
250.0
25%
1,200.0
200.0
20%
1,000.0
150.0
15%
100.0
10%
50.0
5%
0.0
0%
2014
2015
Inventory Turnover
800.0 600.0
2011
2012
Total Debt to Assets
2013
2014
200.0 0.0 2011
2015
2012
2013
Long-Term Debt to Equity
Long-Term Debt to Equity
50%
50%
40%
40%
30%
30%
20%
20%
10%
10%
0%
400.0
2014
2015
AAPL
GOOGL
2012
2013
2014
2015
2012
Total Debt to Assets
2013
2014
2015
Long-Term Debt to Equity
9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.0% 2.0% 1.0% 0.0%
0% 2011
2011
2011
2012
2013
2014
2015
2011
2012
2013
2014
2015
Analyst Comments:
2. Relative Valuation and Debt
AAPL, Page 6 of 22
Copyright Robert A. Weigand, Ph.D., 2016
AAPL Total Invested Capital Total Cash and ST Investments + Receivables + Inventory − Accounts Payable − Accrued Expenses = Net Oper. Working Capital + Net Property, Plant & Equip. = Total Invested Capital ÷ Total Weighted Shares = Total Invested Capital/Share
Apple Inc.
Net Property, Plant & Equip.
2011
2012
2013
2014
2015
25,952 11,717 776 14,632 4,829 18,984 7,777 26,761 6,470 $4.14
29,129 18,692 791 21,175 6,749 20,688 15,452 36,140 6,544 $5.52
40,590 20,641 1,764 22,367 8,427 32,201 16,597 48,798 6,477 $7.53
25,158 27,219 2,111 30,196 18,372 5,920 20,624 26,544 6,086 $4.36
41,995 30,343 2,349 35,490 24,169 15,028 22,471 37,499 5,753 $6.52
GOOGL Total Invested Capital Total Cash and ST Investments + Receivables + Inventory − Accounts Payable − Accrued Expenses = Net Oper. Working Capital + Net Property, Plant & Equip. = Total Invested Capital ÷ Total Weighted Shares = Total Invested Capital/Share
Total Invested Capital per Share
Total Invested Capital
AAPL
$50,000 $40,000 $30,000 $20,000 $10,000 $0 2011
2012
2013
AAPL NOPAT and Free Cash Flow Operating Income (EBIT) × (1−Effective Tax Rate) = Net Oper. Profit After Tax − ∆ Total Invested Capital = Free Cash Flow NOPAT per Share Free Cash Flow per Share
2014
2012
2013
$20,000 $0 2012
2013
2014
2015
33,790 24.2% 25,607 N/A N/A $3.96 N/A
55,241 25.2% 41,342 9,379 31,963 $6.32 $4.88
48,999 26.2% 36,183 12,658 23,525 $5.59 $3.63
52,503 26.1% 38,786 (22,254) 61,040 $6.37 $10.03
71,230 26.4% 52,448 10,955 41,493 $9.12 $7.21
2015
Total Invested Capital
$40,000
2013
2014
Net Property, Plant & Equip.
2015
71,926 13,459 0 1,931 8,293 75,161 29,016 104,177 685 $152.17
$60,000
2012
Free Cash Flow
2014
62,633 9,974 0 1,715 7,474 63,418 23,883 87,301 676 $129.16
$80,000
2011
Net Operating Profit After Tax
2013
57,447 9,290 0 2,453 6,253 58,031 16,524 74,555 666 $112.00
$100,000
Apple Inc.
$70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0
2012
47,159 7,885 505 2,012 5,490 48,047 11,854 59,901 654 $91.53
$120,000
2011
2015
2011
43,366 5,427 35 588 3,069 45,171 9,603 54,774 646 $84.85
GOOGL
$160.00 $140.00 $120.00 $100.00 $80.00 $60.00 $40.00 $20.00 $0.00
$60,000
Alphabet Inc.
NOPAT per Share
2014
2015
GOOGL NOPAT and Free Cash Flow Operating Income (EBIT) × (1−Effective Tax Rate) = Net Oper. Profit After Tax − ∆ Total Invested Capital = Free Cash Flow NOPAT per Share Free Cash Flow per Share AAPL
2011
2012
2013
2014
2015
13,834 20.2% 11,046 5,127 5,919 $16.88 $9.04
15,403 17.2% 12,749 14,654 (1,905) $19.15 ($2.86)
16,874 21.1% 13,316 12,746 570 $19.70 $0.84
19,360 16.8% 16,106 16,876 (770) $23.53 ($1.12)
Net Operating Profit After Tax
GOOGL $15,000
$15.00
$10,000
$10.00
$5,000
$5.00
$0
$0.00
($5,000) 2015
2015
2011
$20.00
2014
2014
12,242 21.0% 9,671 N/A N/A $14.98 N/A
$20,000
2013
2013
Alphabet Inc.
$25.00
2012
2012
2012
2013
2014
Free Cash Flow
2015
Analyst Comments: AAPL has increased NOPAT significantly since 2011 and has consistently recorded 3‐4x as much NOPAT as GOOGL, GOOGL far outperforms AAPL's NOPAT per share. AAPL has recorded positive free cash flow since 2012, with a low of +$9,379 in 2012. GOOGL conversely has recorded negative free cash flow in 2013 and 2015 as invested capital has exceeded NOPAT. AAPL has invested less than GOOGL in 2013 and 2015, which is cause for concern as the Technology Hardware, Storage, and Peripherals is a rapidly‐ developing and changing sector. Though AAPL's proportionally and sometimes absolutely lower than GOOGL invested capital is a negative signal for investors, consistently positive free cash flow available to investors is a positive signal.
3. Value Creation and DCF Model
AAPL, Page 7 of 22
Copyright Robert A. Weigand, Ph.D., 2016
AAPL Cost of Capital Equity Capitalization + Total Debt + Preferred Stock = Value of All Securities Effective Tax Rate Risk‐Free Rate Beta (5‐Yr) Market Risk Premium CAPM Cost of Equity
Apple Inc. 2015 Weight % Cost Weighted % $659,975 91.4% 8.435% 7.711% $61,962 8.6% 5.000% 0.316% $0 0.0% 0.000% 0.000% $721,937 100.0% 26.37% Alternative RF Rate: 1.910% 1.910% 1.924% 0.932 Alternative Beta: 0.93221 7.0% 8.435% Weighted Average Cost of Capital: 8.027% 8.027% 8.027% 8.027% 8.027% 8.027% Apple Inc. 2011 2012 2013 2014 2015 95.7% 114.4% 74.1% 146.1% 139.9% 23,459 38,441 32,266 36,655 49,438 297,062 505,412 323,155 501,574 540,620 $3.63 $5.87 $4.98 $6.02 $8.59 $45.92 $77.24 $49.89 $82.42 $93.96
AAPL ROIC, EVA and MVA Return on Invested Capital Economic Value‐Added Market Valued‐Added EVA per Share MVA per Share Economic Value-Added
Market Valued-Added 600,000
$12.00
50,000
500,000
$10.00
40,000
400,000
$8.00
30,000
300,000
$6.00
20,000
200,000
$4.00
10,000
100,000
$2.00
0
$0.00
2011
2012
2013
Return on Invested Capital
2014
2015
Return on Equity
AAPL
2012
2013
2014
2015
Alphabet Inc. 2011 2012 17.7% 18.4% 5,182 6,137 150,337 159,749 $8.03 $9.38 $232.88 $244.11
Weighted %
8.146% 0.050% 0.000%
1.924% 0.90485
8.195%
2013 17.1% 6,639 285,715 $9.97 $429.20
Economic Value-Added
GOOGL
2012
2013
Return on Invested Capital
2014
AAPL
2015
2014 15.3% 6,162 254,832 $9.12 $377.01
2015 15.5% 7,568 412,315 $11.05 $602.25
Market Valued-Added 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 0
2011
2012
2013
2014
Return on Invested Capital
GOOGL
160.0% 140.0% 120.0% 100.0% 80.0% 60.0% 40.0% 20.0% 0.0% 2011
Alphabet Inc. 2015 Weight % Cost $532,646 98.8% 8.244% $6,423 1.2% 5.000% $0 0.0% 0.000% $539,069 100.0% 16.81% Alternative RF Rate: 1.910% 1.910% 0.905 Alternative Beta: 7.0% 8.244% Weighted Average Cost of Capital:
8,000 7,000 6,000 5,000 4,000 3,000 2,000 1,000 0 2011
160% 140% 120% 100% 80% 60% 40% 20% 0%
GOOGL ROIC, EVA and MVA Return on Invested Capital Economic Value‐Added Market Valued‐Added EVA per Share MVA per Share
EVA per Share
60,000
0
GOOGL Cost of Capital Equity Capitalization + Total Debt + Preferred Stock = Value of All Securities Effective Tax Rate Risk‐Free Rate Beta (5‐Yr) Market Risk Premium CAPM Cost of Equity
2015
Return on Equity
20% 15% 10% 5% 0% 2011
2012
2013
2014
2015
2011
2012
2013
2014
2015
Analyst Comments: ROIC has been risen to outstanding levels, far above the WACC and above competitor GOOGL's WACC. Due to this spread, AAPL is able to generate significant EVA and far more than its competitors can generate. Though AAPL's ROIC displays more volatility than GOOGL's ROIC, AAPL's ROIC is a substantially higher range. AAPL's high ROIC, conservative WACC, and growing EVA are a positive sign of value creation for investors.
3. Value Creation and DCF Model
AAPL, Page 8 of 22
Copyright Robert A. Weigand, Ph.D., 2016
AAPL Intrinsic Value Model PV of Future FCFs + Value of Non‐Oper. Assets = Total Intrinsic Firm Value − Total Debt = Intrinsic Value of Equity ÷ Total Weighted Shares = Per Share Intrinsic Value vs. Year‐End Stock Price Over (Under) Valuation/Share % Over (Under) Valued Year-End Stock Price
Apple Inc. 2011 644,221 25,952 670,173 0 670,173 6,470 $103.58 $57.76 ($45.83) ‐44.2%
2012 663,972 29,129 693,101 0 693,101 6,544 $105.92 $95.30 ($10.62) ‐10.0%
Long‐Term Growth Rate: 2.0% 2013 2014 2015 693,747 688,397 702,165 40,546 25,077 41,601 734,293 713,474 743,766 16,960 35,295 61,962 717,333 678,179 681,804 6,477 6,086 5,753 $110.75 $111.44 $118.50 $68.96 $100.75 $114.71 ($41.78) ($10.69) ($3.79) ‐37.7% ‐9.6% ‐3.2%
Per Share Intrinsic Value
$140 $120 $100 $80 $60 $40 $20 $0
GOOGL Intrinsic Value Model PV of Future FCFs + Value of Non‐Oper. Assets = Total Intrinsic Firm Value − Total Debt = Intrinsic Value of Equity ÷ Total Weighted Shares = Per Share Intrinsic Value vs. Year‐End Stock Price Over (Under) Valuation/Share % Over (Under) Valued
MVA per Share
AAPL
2012
2013
$ Over (Under) Valued
2014
2015
0%
($10)
‐10%
($20)
‐20%
($30)
‐30%
($40)
‐40%
($50)
‐50% 2011
2012
2013
2014
2015
Per Share Intrinsic Value
$900 $800 $700 $600 $500 $400 $300 $200 $100 $0 2011
% Over (Under) Valued
$0
Year-End Stock Price
GOOGL
$700 $600 $500 $400 $300 $200 $100 $0 2011
Long‐Term Growth Rate: 2.0% 2013 2014 2015 ‐10,962 ‐12,430 ‐12,679 57,447 62,633 71,926 46,485 50,203 59,247 5,364 7,769 6,423 41,121 42,434 52,824 666 676 685 $61.77 $62.78 $77.16 $560.36 $530.66 $778.01 $498.58 $467.88 $700.85 807.1% 745.3% 908.3%
Alphabet Inc. 2011 2012 ‐5,520 ‐11,892 43,366 47,159 37,846 35,267 6,211 7,210 31,635 28,057 646 654 $49.00 $42.87 $322.95 $353.69 $273.95 $310.82 559.0% 725.0%
2012
2013
2014
Return on Invested Capital
2011
2015
WACC
160% 140% 120% 100% 80% 60% 40% 20% 0%
2012
2013
$ Over (Under) Valued
2014
2015
% Over (Under) Valued
$800 $700 $600 $500 $400 $300 $200 $100 $0 2011
2012
2013
2014
2015
1000% 800% 600% 400% 200% 0% 2011
2012
2013
2014
2015
Analyst Comments: AAPL is consistently mildly undervalued, while GOOGL is severly overvalued. AAPL's undervalutation is in a manageable range for investors to take advantage of the undervaluation the market is likely to realize. While AAPL's stock prices have risen steadily, GOOGL's price have risen rapidly, which is a concern when coupled with GOOGL's low intrinsic valuation. AAPL's Piotroski scores significantly outperform GOOGL, reaching an impressive score of 9/10 in 2015 while GOOGL peaked at 8 in 2013 and 2014 then fell to the moderately‐high 7/10 in 2015. Both companies are considered "in the safe zone" with their Altman scores, though GOOGL strongly outperforms AAPL. Per the intrinsic value model and the Piotroski score, AAPL has historically been the better investment of the two companies.
3. Value Creation and DCF Model
AAPL, Page 9 of 22
Copyright Robert A. Weigand, Ph.D., 2016
AAPL
Apple Inc.
Piotroski Financial Fitness Scorecard Positive Net Income Positive Free Cash Flow Growing ROA (% change NI > % change TA) Earnings Quality (Operating Income > Net Income) Total Assets Growing Faster Than Total Liabilities Increasing Liquidity (Current Ratio) % Change Shares Outstanding % change assets) Total Liabilities to Operating Cash Flow (EBIT) % change TA) Earnings Quality (Operating Income > Net Income) Total Assets Growing Faster Than Total Liabilities Increasing Liquidity (Current Ratio) % Change Shares Outstanding (Diluted) % change assets) Total Liabilities to Operating Cash Flow (EBIT) 2.9, Grey Zone = 1.23