Discounted Cash Flow (DCF) Analysis Levered
Dana Incorporated (DAN)
$16.02
+0.66 (+4.30%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Revenue | 7,209 | 8,143 | 8,620 | 7,106 | 8,945 | 9,551.68 | 10,199.52 | 10,891.29 | 11,629.98 | 12,418.77 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 554 | 568 | 637 | 386 | 158 | 558.74 | 596.64 | 637.10 | 680.31 | 726.46 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -393 | -325 | -426 | -326 | -369 | -441.24 | -471.17 | -503.12 | -537.25 | -573.69 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 161 | 243 | 211 | 60 | -211 | 117.50 | 125.47 | 133.98 | 143.07 | 152.77 |
Weighted Average Cost Of Capital
Share price | $ 16.02 |
---|---|
Beta | 2.323 |
Diluted Shares Outstanding | 144.50 |
Cost of Debt | |
Tax Rate | 19.26 |
After-tax Cost of Debt | 3.96% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 13.719 |
Total Debt | 2,669 |
Total Equity | 2,314.89 |
Total Capital | 4,983.89 |
Debt Weighting | 53.55 |
Equity Weighting | 46.45 |
Wacc |
Build Up Free Cash Flow
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Revenue | 7,209 | 8,143 | 8,620 | 7,106 | 8,945 | 9,551.68 | 10,199.52 | 10,891.29 | 11,629.98 | 12,418.77 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 554 | 568 | 637 | 386 | 158 | 558.74 | 596.64 | 637.10 | 680.31 | 726.46 |
Capital Expenditure | -393 | -325 | -426 | -326 | -369 | -441.24 | -471.17 | -503.12 | -537.25 | -573.69 |
Free Cash Flow | 161 | 243 | 211 | 60 | -211 | 117.50 | 125.47 | 133.98 | 143.07 | 152.77 |
WACC | ||||||||||
PV LFCF | 108.30 | 106.58 | 104.89 | 103.23 | 101.60 | |||||
SUM PV LFCF | 524.60 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 8.50 |
Free cash flow (t + 1) | 155.83 |
Terminal Value | 2,397.31 |
Present Value of Terminal Value | 1,594.32 |
Intrinsic Value
Enterprise Value | 2,118.92 |
---|---|
Net Debt | 2,401 |
Equity Value | -282.08 |
Shares Outstanding | 144.50 |
Equity Value Per Share | -1.95 |