Discounted Cash Flow (DCF) Analysis Levered
Mittal Life Style Limited (MITTAL.NS)
9.85 ₹
-0.20 (-1.99%)
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 | 801.32 | 897.40 | 983.24 | 521.53 | 518.17 | 484.43 | 452.88 | 423.39 | 395.82 | 370.05 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | -10.59 | 10.31 | -9.53 | 4.71 | 48.92 | 8.92 | 8.34 | 7.79 | 7.29 | 6.81 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -0.13 | -0.23 | -0.27 | -0.32 | -0.18 | -0.16 | -0.15 | -0.14 | -0.13 | -0.12 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | -10.71 | 10.08 | -9.80 | 4.40 | 48.74 | 8.76 | 8.19 | 7.65 | 7.16 | 6.69 |
Weighted Average Cost Of Capital
Share price | $ 9.85 |
---|---|
Beta | 0.773 |
Diluted Shares Outstanding | 12.93 |
Cost of Debt | |
Tax Rate | 27.56 |
After-tax Cost of Debt | 4.40% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 7.129 |
Total Debt | 7.54 |
Total Equity | 127.31 |
Total Capital | 134.85 |
Debt Weighting | 5.59 |
Equity Weighting | 94.41 |
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 | 801.32 | 897.40 | 983.24 | 521.53 | 518.17 | 484.43 | 452.88 | 423.39 | 395.82 | 370.05 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | -10.59 | 10.31 | -9.53 | 4.71 | 48.92 | 8.92 | 8.34 | 7.79 | 7.29 | 6.81 |
Capital Expenditure | -0.13 | -0.23 | -0.27 | -0.32 | -0.18 | -0.16 | -0.15 | -0.14 | -0.13 | -0.12 |
Free Cash Flow | -10.71 | 10.08 | -9.80 | 4.40 | 48.74 | 8.76 | 8.19 | 7.65 | 7.16 | 6.69 |
WACC | ||||||||||
PV LFCF | 8.19 | 7.15 | 6.25 | 5.46 | 4.77 | |||||
SUM PV LFCF | 31.83 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 6.98 |
Free cash flow (t + 1) | 6.82 |
Terminal Value | 137.01 |
Present Value of Terminal Value | 97.78 |
Intrinsic Value
Enterprise Value | 129.61 |
---|---|
Net Debt | 5.18 |
Equity Value | 124.42 |
Shares Outstanding | 12.93 |
Equity Value Per Share | 9.63 |