Discounted Cash Flow (DCF) Analysis Levered
3M Company (MMM)
$93.62
+0.36 (+0.39%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 32,765 | 32,136 | 32,184 | 35,355 | 34,229 | 34,648.09 | 35,072.32 | 35,501.74 | 35,936.41 | 36,376.41 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 6,439 | 7,070 | 8,113 | 7,454 | 5,591 | 7,226.06 | 7,314.53 | 7,404.09 | 7,494.75 | 7,586.51 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -1,577 | -1,699 | -1,501 | -1,603 | -1,749 | -1,691.35 | -1,712.05 | -1,733.02 | -1,754.24 | -1,775.71 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 4,862 | 5,371 | 6,612 | 5,851 | 3,842 | 5,534.71 | 5,602.48 | 5,671.08 | 5,740.51 | 5,810.80 |
Weighted Average Cost Of Capital
Share price | $ 93.62 |
---|---|
Beta | 0.968 |
Diluted Shares Outstanding | 567.60 |
Cost of Debt | |
Tax Rate | 9.62 |
After-tax Cost of Debt | 2.58% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 9.143 |
Total Debt | 16,200 |
Total Equity | 53,138.71 |
Total Capital | 69,338.71 |
Debt Weighting | 23.36 |
Equity Weighting | 76.64 |
Wacc |
Build Up Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 32,765 | 32,136 | 32,184 | 35,355 | 34,229 | 34,648.09 | 35,072.32 | 35,501.74 | 35,936.41 | 36,376.41 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 6,439 | 7,070 | 8,113 | 7,454 | 5,591 | 7,226.06 | 7,314.53 | 7,404.09 | 7,494.75 | 7,586.51 |
Capital Expenditure | -1,577 | -1,699 | -1,501 | -1,603 | -1,749 | -1,691.35 | -1,712.05 | -1,733.02 | -1,754.24 | -1,775.71 |
Free Cash Flow | 4,862 | 5,371 | 6,612 | 5,851 | 3,842 | 5,534.71 | 5,602.48 | 5,671.08 | 5,740.51 | 5,810.80 |
WACC | ||||||||||
PV LFCF | 5,143.31 | 4,838.10 | 4,551.01 | 4,280.95 | 4,026.92 | |||||
SUM PV LFCF | 22,840.28 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 7.61 |
Free cash flow (t + 1) | 5,927.01 |
Terminal Value | 105,650.85 |
Present Value of Terminal Value | 73,216.65 |
Intrinsic Value
Enterprise Value | 96,056.93 |
---|---|
Net Debt | 12,545 |
Equity Value | 83,511.93 |
Shares Outstanding | 567.60 |
Equity Value Per Share | 147.13 |