Discounted Cash Flow (DCF) Analysis Unlevered

Mohota Industries Limited (MOHOTAIND.NS)

4.9 ₹

0.00 (0.00%)
All numbers are in Millions, Currency in USD
Stock DCF: -78.07 | 4.9 | overvalue

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 3,516.742,988.021,110.5478.3510.963.921.400.500.180.06
Revenue (%)
EBITDA 190.09139.36-211.49-60.99-22.99-2.33-0.83-0.30-0.11-0.04
EBITDA (%)
EBIT 156.42107.99-242.21-91.28-52.70-4.80-1.72-0.61-0.22-0.08
EBIT (%)
Depreciation 33.6731.3630.7230.2929.712.470.880.320.110.04
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 11.0913.012.044.5613.421.010.360.130.050.02
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories 521.88536.1035.6617.8611.531.290.460.160.060.02
Inventories (%)
Accounts Payable 257.87270.83316.20302.39301.4924.968.943.201.140.41
Accounts Payable (%)
Capital Expenditure -9.97-1.75-0.40-0.10-0.01-0-0-0-0-0
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 4.9
Beta 1.108
Diluted Shares Outstanding 14.71
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt 5.07%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.761
Total Debt 864.63
Total Equity 72.09
Total Capital 936.72
Debt Weighting 92.30
Equity Weighting 7.70
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 3,516.742,988.021,110.5478.3510.963.921.400.500.180.06
EBITDA 190.09139.36-211.49-60.99-22.99-2.33-0.83-0.30-0.11-0.04
EBIT 156.42107.99-242.21-91.28-52.70-4.80-1.72-0.61-0.22-0.08
Tax Rate 39.13%18.98%9.43%0.00%0.00%13.51%13.51%13.51%13.51%13.51%
EBIAT 95.2187.50-219.36-91.28-52.70-4.15-1.48-0.53-0.19-0.07
Depreciation 33.6731.3630.7230.2929.712.470.880.320.110.04
Accounts Receivable ----------
Inventories --14.22500.4417.806.3310.240.830.300.110.04
Accounts Payable -12.9645.37-13.81-0.90-276.52-16.03-5.74-2.05-0.74
Capital Expenditure -9.97-1.75-0.40-0.10-0.01-0-0-0-0-0
UFCF 118.90115.86356.76-57.10-17.58-267.97-15.81-5.66-2.03-0.72
WACC
PV UFCF -254.36-14.24-4.84-1.64-0.56
SUM PV UFCF -275.64

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 5.35
Free cash flow (t + 1) -0.74
Terminal Value -22.07
Present Value of Terminal Value -17.01

Intrinsic Value

Enterprise Value -292.65
Net Debt 855.99
Equity Value -1,148.64
Shares Outstanding 14.71
Equity Value Per Share -78.07