| 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) | |||||||||||