Discounted Cash Flow (DCF) Analysis Unlevered

Cemtrex, Inc. (CETX)

$0.1742

-0.00 (-0.51%)
All numbers are in Millions, Currency in USD
Stock DCF: 0.13 | 0.1742 | overvalue

Operating Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 120.6389.9439.2743.5243.1335.3829.0323.8219.5416.03
Revenue (%)
EBITDA 8.57-6.41-15.900.46-2.31-3.17-2.60-2.13-1.75-1.44
EBITDA (%)
EBIT 5.43-10.59-18.92-3.25-4.51-5.19-4.26-3.50-2.87-2.35
EBIT (%)
Depreciation 3.144.183.013.712.212.021.661.361.120.92
Depreciation (%)

Balance Sheet Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 10.440.972.1820.3815.446.935.694.663.833.14
Total Cash (%)
Account Receivables 15.4614.118.408.129.306.385.234.293.522.89
Account Receivables (%)
Inventories 17.2711.355.216.795.664.8843.282.692.21
Inventories (%)
Accounts Payable 6.957.074.242.864.242.892.371.941.591.31
Accounts Payable (%)
Capital Expenditure -5.68-12.21-1.66-1.57-1.07-2.02-1.66-1.36-1.12-0.92
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 0.1,742
Beta 2.038
Diluted Shares Outstanding 18.91
Cost of Debt
Tax Rate 1,115.06
After-tax Cost of Debt -320.35%
Risk-Free Rate
Market Risk Premium
Cost of Equity 13.179
Total Debt 9.26
Total Equity 3.29
Total Capital 12.55
Debt Weighting 73.75
Equity Weighting 26.25
Wacc

Build Up Free Cash

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 120.6389.9439.2743.5243.1335.3829.0323.8219.5416.03
EBITDA 8.57-6.41-15.900.46-2.31-3.17-2.60-2.13-1.75-1.44
EBIT 5.43-10.59-18.92-3.25-4.51-5.19-4.26-3.50-2.87-2.35
Tax Rate 2.57%13.04%-76.96%-45.66%1,115.06%201.61%201.61%201.61%201.61%201.61%
EBIAT 5.29-9.21-33.47-4.7445.795.284.333.552.912.39
Depreciation 3.144.183.013.712.212.021.661.361.120.92
Accounts Receivable -1.355.710.28-1.182.921.150.940.770.63
Inventories -5.926.15-1.591.140.780.880.720.590.48
Accounts Payable -0.12-2.83-1.381.38-1.35-0.52-0.43-0.35-0.29
Capital Expenditure -5.68-12.21-1.66-1.57-1.07-2.02-1.66-1.36-1.12-0.92
UFCF 2.75-9.85-23.09-5.2748.267.635.834.783.933.22
WACC
PV UFCF -5.743.31-2.041.26-0.78
SUM PV UFCF -4

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -232.80
Free cash flow (t + 1) 3.28
Terminal Value -1.40
Present Value of Terminal Value 0.34

Intrinsic Value

Enterprise Value -3.66
Net Debt -6.17
Equity Value 2.51
Shares Outstanding 18.91
Equity Value Per Share 0.13