| Intrinsic Valuation of M_M | |||||||||||
| M_M Free Cash Flow Average and Growth over past 5Y | Key Statistics | ||||||||||
| Year | FCF | FCF Growth | |||||||||
| 2021 | $41,948,500,000 | -65.38% | EPS (FY) | 58.96 | Market Cap | 1537B | |||||
| 2020 | $121,177,900,000 | 253.72% | P/E Ratio | 20.88 | Total Asset | 1741B | |||||
| 2019 | ($78,830,100,000) | 32.22% | Net Income | 66B | Total Debt | 776B | |||||
| 2018 | ($116,304,800,000) | -124.75% | EBITDA | 147B | Total Liab | 1173B | |||||
| 2017 | ($51,749,500,000) | -13.50% | Opr Margin | 0.1239 | Debt/Equity | 1.37 | |||||
| 2016 | ($45,593,100,000) | PreTax Margin | 0.0832 | BV/Share | 423.71 | ||||||
| 5Y Average FCF | ($16,751,600,000) | 16.46% | |||||||||
| 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.14% | Current US Bond Yield: | 1.48% | ||||||||
| Forcasting Future Free Cash Flow for next 6Y | Modified Benjamin Graham's Intrinsic Value | ||||||||||
| Year | FCF Projection | ||||||||||
| 2022 | $48,854,068,284 | MBG Intrinsic Value | $1,237.79 | ||||||||
| 2023 | $56,896,432,242 | ||||||||||
| 2024 | $66,262,731,346 | ||||||||||
| 2025 | $77,170,911,996 | ||||||||||
| 2026 | $89,874,798,961 | ||||||||||
| 2027 | $104,670,001,679 | ||||||||||
| Terminal Value | $2,951,436,447,998 | Net Worth/Share | $511.50 | ||||||||
| DCF Valuation | DCF Valuation "What If" Scenario Table | ||||||||||
| Enterprise Value | $2,298,192,823,286 | Growth Rate | |||||||||
| (+) Cash & Cash Equivalents | $219,674,900,000 | 1567.87 | 1.50% | 2.00% | 2.50% | 3.00% | 3.50% | ||||
| (-) Total Debt | $776,052,100,000 | WACC | 6.04% | 1215.0 | 1395.6 | 1627.3 | 1935.2 | 2364.3 | |||
| Equity Value | $1,741,815,623,286 | 6.09% | 1194.6 | 1370.6 | 1595.6 | 1893.5 | 2306.3 | ||||
| Shares Outstanding | 1110943402 | 6.14% | 1174.7 | 1346.2 | 1564.9 | 1853.1 | 2250.6 | ||||
| 6.64% | 997.4 | 1131.7 | 1298.4 | 1511.0 | 1791.2 | ||||||
| DCF Intrinsic Value | $1,567.87 | 7.14% | 852.0 | 959.4 | 1090.0 | 1252.1 | 1458.8 | ||||
| © Swarnadeep Seth (2022) | |||||||||||