Discounted Cash Flow (DCF) Analysis Unlevered

New Concept Energy, Inc. (GBR)

$1.03

+0.04 (+0.00%)
All numbers are in Millions, Currency in USD
Stock DCF: -2.56 | 1.03 | 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 0.680.590.100.100.210.220.230.240.250.26
Revenue (%)
EBITDA -0.21-0.05-0.030.090.190.050.050.050.060.06
EBITDA (%)
EBIT -0.47-0.14-0.040.080.180.010.010.010.010.02
EBIT (%)
Depreciation 0.250.080.010.010.010.040.040.040.040.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 0.360.020.030.250.440.240.250.260.270.28
Total Cash (%)
Account Receivables 4.134.123.683.563.544.504.704.915.135.36
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 0.060.350.080.030.020.080.090.090.090.10
Accounts Payable (%)
Capital Expenditure --0.66-0.11-0.11-0.24-0.25-0.26-0.27-0.28-0.30
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 1.03
Beta 0.420
Diluted Shares Outstanding 5.13
Cost of Debt
Tax Rate -189.50
After-tax Cost of Debt 5.00%
Risk-Free Rate
Market Risk Premium
Cost of Equity 6.141
Total Debt -
Total Equity 5.29
Total Capital 5.29
Debt Weighting 0.00
Equity Weighting 100.00
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 0.680.590.100.100.210.220.230.240.250.26
EBITDA -0.21-0.05-0.030.090.190.050.050.050.060.06
EBIT -0.47-0.14-0.040.080.180.010.010.010.010.02
Tax Rate 0.00%-5.53%3,784.62%280.00%-189.50%773.92%773.92%773.92%773.92%773.92%
EBIAT -0.47-0.141.47-0.140.52-0.09-0.09-0.09-0.10-0.10
Depreciation 0.250.080.010.010.010.040.040.040.040.04
Accounts Receivable -0.020.440.120.02-0.95-0.20-0.21-0.22-0.23
Inventories ----------
Accounts Payable -0.30-0.27-0.05-00.060000
Capital Expenditure --0.66-0.11-0.11-0.24-0.25-0.26-0.27-0.28-0.30
UFCF -0.21-0.411.53-0.160.31-1.19-0.51-0.53-0.56-0.58
WACC
PV UFCF -1.12-0.45-0.45-0.44-0.43
SUM PV UFCF -2.90

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 6.14
Free cash flow (t + 1) -0.60
Terminal Value -14.38
Present Value of Terminal Value -10.67

Intrinsic Value

Enterprise Value -13.57
Net Debt -0.44
Equity Value -13.13
Shares Outstanding 5.13
Equity Value Per Share -2.56