| Intrinsic Valuation of MSFT | |||||||||||
| MSFT Free Cash Flow Average and Growth over past 5Y | Key Statistics | ||||||||||
| Year | FCF | FCF Growth | |||||||||
| 2021 | $56,118,000,000 | 24.06% | EPS (FY) | 8.05 | Market Cap | 1981B | |||||
| 2020 | $45,234,000,000 | 18.23% | P/E Ratio | 27.36 | Total Asset | 345B | |||||
| 2019 | $38,260,000,000 | 18.63% | Net Income | 61B | Total Debt | 82B | |||||
| 2018 | $32,252,000,000 | 2.79% | EBITDA | 96B | Total Liab | 192B | |||||
| 2017 | $31,378,000,000 | 25.60% | Opr Margin | 0.4256 | Debt/Equity | 0.48 | |||||
| 2016 | $24,982,000,000 | PreTax Margin | 0.4291 | BV/Share | 18.88 | ||||||
| 5Y Average FCF | $40,648,400,000 | 17.86% | |||||||||
| 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.03% | Current US Bond Yield: | 1.48% | ||||||||
| Forcasting Future Free Cash Flow for next 6Y | Modified Benjamin Graham's Intrinsic Value | ||||||||||
| Year | FCF Projection | ||||||||||
| 2022 | $66,141,301,953 | MBG Intrinsic Value | $169.76 | ||||||||
| 2023 | $77,954,877,651 | ||||||||||
| 2024 | $91,878,489,994 | ||||||||||
| 2025 | $108,289,015,105 | ||||||||||
| 2026 | $127,630,643,399 | ||||||||||
| 2027 | $150,426,902,660 | ||||||||||
| Terminal Value | $2,361,049,231,564 | Net Worth/Share | $20.25 | ||||||||
| DCF Valuation | DCF Valuation "What If" Scenario Table | ||||||||||
| Enterprise Value | $1,735,186,155,188 | Growth Rate | |||||||||
| (+) Cash & Cash Equivalents | $130,334,000,000 | 236.28 | 1.50% | 2.00% | 2.50% | 3.00% | 3.50% | ||||
| (-) Total Debt | $82,278,000,000 | WACC | 8.93% | 215.3 | 226.9 | 240.3 | 255.9 | 274.5 | |||
| Equity Value | $1,783,242,155,188 | 8.98% | 213.7 | 225.1 | 238.3 | 253.6 | 271.8 | ||||
| Shares Outstanding | 7547000000 | 9.03% | 212.2 | 223.4 | 236.3 | 251.4 | 269.2 | ||||
| 9.53% | 197.7 | 207.3 | 218.2 | 230.7 | 245.4 | ||||||
| DCF Intrinsic Value | $236.28 | 10.03% | 185.0 | 193.2 | 202.5 | 213.1 | 225.3 | ||||
| Swarnadeep Seth (2022) | |||||||||||