Discounted Cash Flow (DCF) Analysis Unlevered
Eurotex Industries and Exports Limi... (EUROTEXIND.NS)
13.9 ₹
0.00 (0.00%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Revenue | 2,497.20 | 1,950.64 | 414.43 | 232.49 | 22.51 | 9.29 | 3.84 | 1.58 | 0.65 | 0.27 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| EBITDA | -41.06 | -65.87 | -137.88 | -52.75 | -48.20 | -5.11 | -2.11 | -0.87 | -0.36 | -0.15 |
| EBITDA (%) | ||||||||||
| EBIT | -80.90 | -104.94 | -174.98 | -89.35 | -81.23 | -8.37 | -3.45 | -1.43 | -0.59 | -0.24 |
| EBIT (%) | ||||||||||
| Depreciation | 39.85 | 39.07 | 37.10 | 36.60 | 33.03 | 3.25 | 1.34 | 0.55 | 0.23 | 0.09 |
| Depreciation (%) |
Balance Sheet Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Total Cash | 14.15 | 125.90 | 4.92 | 8.86 | 12.47 | 1.25 | 0.52 | 0.21 | 0.09 | 0.04 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | - | - | - | - | - | - | - | - | - | - |
| Account Receivables (%) | ||||||||||
| Inventories | 548.50 | 330.25 | 100.15 | 18.90 | 7.40 | 1.93 | 0.80 | 0.33 | 0.14 | 0.06 |
| Inventories (%) | ||||||||||
| Accounts Payable | 305.04 | 190.39 | 95.35 | 116.92 | 90.34 | 9.23 | 3.81 | 1.57 | 0.65 | 0.27 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -2.08 | -0.88 | -0.02 | -0.55 | -0.01 | -0.01 | -0 | -0 | -0 | -0 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 13.9 |
|---|---|
| Beta | 0.250 |
| Diluted Shares Outstanding | 8.75 |
| Cost of Debt | |
| Tax Rate | -9.69 |
| After-tax Cost of Debt | 6.68% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 4.559 |
| Total Debt | 380.80 |
| Total Equity | 121.62 |
| Total Capital | 502.42 |
| Debt Weighting | 75.79 |
| Equity Weighting | 24.21 |
| Wacc |
Build Up Free Cash
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Revenue | 2,497.20 | 1,950.64 | 414.43 | 232.49 | 22.51 | 9.29 | 3.84 | 1.58 | 0.65 | 0.27 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | -41.06 | -65.87 | -137.88 | -52.75 | -48.20 | -5.11 | -2.11 | -0.87 | -0.36 | -0.15 |
| EBIT | -80.90 | -104.94 | -174.98 | -89.35 | -81.23 | -8.37 | -3.45 | -1.43 | -0.59 | -0.24 |
| Tax Rate | 7.26% | 1.24% | 13.97% | 2.66% | -9.69% | 3.09% | 3.09% | 3.09% | 3.09% | 3.09% |
| EBIAT | -75.03 | -103.64 | -150.54 | -86.97 | -89.10 | -8.11 | -3.35 | -1.38 | -0.57 | -0.24 |
| Depreciation | 39.85 | 39.07 | 37.10 | 36.60 | 33.03 | 3.25 | 1.34 | 0.55 | 0.23 | 0.09 |
| Accounts Receivable | - | - | - | - | - | - | - | - | - | - |
| Inventories | - | 218.25 | 230.10 | 81.24 | 11.51 | 5.46 | 1.14 | 0.47 | 0.19 | 0.08 |
| Accounts Payable | - | -114.65 | -95.03 | 21.57 | -26.58 | -81.11 | -5.42 | -2.24 | -0.92 | -0.38 |
| Capital Expenditure | -2.08 | -0.88 | -0.02 | -0.55 | -0.01 | -0.01 | -0 | -0 | -0 | -0 |
| UFCF | -37.26 | 38.14 | 21.61 | 51.89 | -71.16 | -80.51 | -6.29 | -2.60 | -1.07 | -0.44 |
| WACC | ||||||||||
| PV UFCF | -75.83 | -5.58 | -2.17 | -0.84 | -0.33 | |||||
| SUM PV UFCF | -84.76 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 6.17 |
| Free cash flow (t + 1) | -0.45 |
| Terminal Value | -10.83 |
| Present Value of Terminal Value | -8.03 |
Intrinsic Value
| Enterprise Value | -92.78 |
|---|---|
| Net Debt | 374.72 |
| Equity Value | -467.51 |
| Shares Outstanding | 8.75 |
| Equity Value Per Share | -53.43 |