|
|
|
|
|
|
|
|
|
|
|
|
|
|
Intrinsic Valuation of INTC |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
INTC Free Cash Flow Average and Growth over
past 5Y |
|
Key Statistics |
|
|
Year |
|
FCF |
FCF Growth |
|
|
|
|
|
|
|
|
2021 |
|
$9,662,000,000 |
-54.26% |
|
EPS (FY) |
4.86 |
|
Market Cap |
147B |
|
|
2020 |
|
$21,125,000,000 |
24.76% |
|
P/E Ratio |
7.93 |
|
Total Asset |
170B |
|
|
2019 |
|
$16,932,000,000 |
18.81% |
|
Net Income |
20B |
|
Total Debt |
39B |
|
|
2018 |
|
$14,251,000,000 |
37.93% |
|
EBITDA |
25B |
|
Total Liab |
73B |
|
|
2017 |
|
$10,332,000,000 |
-15.19% |
|
Opr Margin |
0.1745 |
|
Debt/Equity |
0.35 |
|
|
2016 |
|
$12,183,000,000 |
|
|
PreTax Margin |
0.2835 |
|
BV/Share |
23.44 |
|
|
5Y Average FCF |
|
$14,460,400,000 |
2.41% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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): |
6.45% |
|
|
|
Current US Bond Yield: |
1.48% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forcasting Future Free Cash Flow for next 6Y |
|
Modified Benjamin Graham's Intrinsic Value |
|
|
Year |
|
FCF Projection |
|
|
|
|
|
|
|
|
|
2022 |
|
$9,894,876,471 |
|
|
MBG Intrinsic Value |
$102.02 |
|
|
2023 |
|
$10,133,365,802 |
|
|
|
|
|
|
|
|
|
2024 |
|
$10,377,603,276 |
|
|
|
|
|
|
|
|
|
2025 |
|
$10,627,727,436 |
|
|
|
|
|
|
|
|
|
2026 |
|
$10,883,880,165 |
|
|
|
|
|
|
|
|
|
2027 |
|
$11,146,206,764 |
|
|
|
|
|
|
|
|
|
Terminal Value |
|
$289,041,522,034 |
|
|
Net Worth/Share |
$24.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DCF Valuation |
|
DCF Valuation "What If" Scenario
Table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enterprise Value |
$237,316,188,355 |
|
|
|
Growth Rate |
|
|
(+) Cash & Cash Equivalents |
$28,413,000,000 |
|
|
55.96 |
1.50% |
2.00% |
2.50% |
3.00% |
3.50% |
|
|
(-) Total Debt |
$38,576,000,000 |
|
WACC |
6.35% |
47.4 |
51.9 |
57.5 |
64.9 |
74.8 |
|
|
Equity Value |
$227,153,188,355 |
|
6.40% |
46.9 |
51.3 |
56.8 |
63.9 |
73.5 |
|
|
Shares Outstanding |
4059000000 |
|
6.45% |
46.4 |
50.6 |
56.0 |
62.9 |
72.2 |
|
|
|
|
|
6.95% |
41.8 |
45.2 |
49.3 |
54.5 |
61.3 |
|
|
DCF Intrinsic Value |
$55.96 |
|
7.45% |
37.9 |
40.7 |
44.0 |
48.0 |
53.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Swarnadeep
Seth (2022) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|