|
|
|
|
|
|
|
|
|
|
|
|
|
|
Intrinsic Valuation of AAPL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AAPL Free Cash Flow Average and Growth over
past 5Y |
|
Key Statistics |
|
|
Year |
|
FCF |
FCF Growth |
|
|
|
|
|
|
|
|
2021 |
|
$92,953,000,000 |
26.70% |
|
EPS (FY) |
5.61 |
|
Market Cap |
2514B
|
|
|
2020 |
|
$73,365,000,000 |
24.57% |
|
P/E Ratio |
24.88 |
|
Total Asset |
351B |
|
|
2019 |
|
$58,896,000,000 |
-8.15% |
|
Net Income |
95B |
|
Total Debt |
137B |
|
|
2018 |
|
$64,121,000,000 |
25.37% |
|
EBITDA |
131B |
|
Total Liab |
288B |
|
|
2017 |
|
$51,147,000,000 |
-3.66% |
|
Opr Margin |
0.3096 |
|
Debt/Equity |
1.78 |
|
|
2016 |
|
$53,090,000,000 |
|
|
PreTax Margin |
0.3082 |
|
BV/Share |
3.84 |
|
|
5Y Average FCF |
|
$68,096,400,000 |
12.96% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Overall Market Assumptions: |
|
|
Assumptions: |
|
|
|
P/E for No-Growth Company: |
7.00 |
|
|
|
Perpetual Growth Rate (g): |
2.50% |
|
|
|
Historical US Bond Yield: |
4.40% |
|
|
|
Discount Rete (WACC): |
9.33% |
|
|
|
Current US Bond Yield: |
1.48% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forcasting Future Free Cash Flow for next 6Y |
|
Modified Benjamin Graham's Intrinsic Value |
|
|
Year |
|
FCF Projection |
|
|
|
|
|
|
|
|
|
2022 |
|
$105,004,177,138 |
|
|
MBG Intrinsic Value |
$118.39 |
|
|
2023 |
|
$118,617,766,144 |
|
|
|
|
|
|
|
|
|
2024 |
|
$133,996,330,703 |
|
|
|
|
|
|
|
|
|
2025 |
|
$151,368,696,491 |
|
|
|
|
|
|
|
|
|
2026 |
|
$170,993,355,992 |
|
|
|
|
|
|
|
|
|
2027 |
|
$193,162,314,739 |
|
|
|
|
|
|
|
|
|
Terminal Value |
|
$2,899,165,552,261 |
|
|
Net Worth/Share |
$3.76 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DCF Valuation |
|
DCF Valuation "What If" Scenario
Table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enterprise Value |
$2,179,158,350,307 |
|
|
|
Growth Rate |
|
|
(+) Cash & Cash Equivalents |
$62,639,000,000 |
|
|
126.05 |
1.50% |
2.00% |
2.50% |
3.00% |
3.50% |
|
|
(-) Total Debt |
$136,522,000,000 |
|
WACC |
9.23% |
115.1 |
121.2 |
128.2 |
136.3 |
145.8 |
|
|
Equity Value |
$2,105,275,350,307 |
|
9.28% |
114.2 |
120.2 |
127.1 |
135.1 |
144.4 |
|
|
Shares Outstanding |
16701272000 |
|
9.33% |
113.4 |
119.3 |
126.0 |
133.9 |
143.0 |
|
|
|
|
|
9.83% |
105.6 |
110.6 |
116.4 |
122.9 |
130.6 |
|
|
DCF Intrinsic Value |
$126.05 |
|
10.33% |
98.7 |
103.0 |
108.0 |
113.5 |
119.9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Swarnadeep
Seth (2022) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|