Discounted Cash Flow (DCF) Analysis Unlevered

TraqIQ, Inc. (TRIQ)

$0.35

0.00 (0.00%)
All numbers are in Millions, Currency in USD
Stock DCF: 1,658.73 | 0.35 | undervalue

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 0.060.180.681.012.717.3219.7853.42144.28389.64
Revenue (%)
EBITDA -0.29-0.23-0.43-0.89-7.61-14.87-40.16-108.47-292.93-791.10
EBITDA (%)
EBIT -0.29-0.23-0.45-0.92-7.69-15.09-40.75-110.04-297.17-802.56
EBIT (%)
Depreciation 00.010.020.030.080.220.581.574.2411.46
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 000.010.030.060.150.411.112.998.08
Total Cash (%)
Account Receivables 00.010.600.750.772.998.0821.8258.92159.12
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable --0.881.162.157.9121.3857.73155.90421.03
Accounts Payable (%)
Capital Expenditure ---0-0-0.01-0.03-0.07-0.19-0.52-1.42
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 0.35
Beta 5.215
Diluted Shares Outstanding 3.93
Cost of Debt
Tax Rate -1.34
After-tax Cost of Debt -25.78%
Risk-Free Rate
Market Risk Premium
Cost of Equity 28.148
Total Debt 5.14
Total Equity 1.38
Total Capital 6.52
Debt Weighting 78.90
Equity Weighting 21.10
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 0.060.180.681.012.717.3219.7853.42144.28389.64
EBITDA -0.29-0.23-0.43-0.89-7.61-14.87-40.16-108.47-292.93-791.10
EBIT -0.29-0.23-0.45-0.92-7.69-15.09-40.75-110.04-297.17-802.56
Tax Rate 0.00%0.00%0.00%-0.13%-1.34%-0.29%-0.29%-0.29%-0.29%-0.29%
EBIAT -0.29-0.23-0.45-0.92-7.79-15.13-40.87-110.36-298.05-804.92
Depreciation 00.010.020.030.080.220.581.574.2411.46
Accounts Receivable --0.01-0.59-0.15-0.02-2.22-5.09-13.74-37.10-100.20
Inventories ----------
Accounts Payable ---0.280.985.7713.4636.3598.17265.13
Capital Expenditure ---0-0-0.01-0.03-0.07-0.19-0.52-1.42
UFCF -0.29-0.23-1.02-0.76-6.76-11.39-31.98-86.37-233.26-629.95
WACC
PV UFCF -13.31-43.65-137.71-434.46-1,370.69
SUM PV UFCF -1,999.81

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -14.40
Free cash flow (t + 1) -642.55
Terminal Value 3,918.01
Present Value of Terminal Value 8,525.04

Intrinsic Value

Enterprise Value 6,525.22
Net Debt 5.09
Equity Value 6,520.14
Shares Outstanding 3.93
Equity Value Per Share 1,658.73