Discounted Cash Flow (DCF) Analysis Unlevered

Camber Energy, Inc. (CEI)

$1.99

-0.11 (-5.24%)
All numbers are in Millions, Currency in USD
Stock DCF: -69.21 | 1.99 | 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 5.306.862.740.400.400.290.200.140.100.07
Revenue (%)
EBITDA -83.27-17.2719.56-3.82-167.68-25.07-17.85-12.71-9.05-6.45
EBITDA (%)
EBIT -85.97-18.7519.08-3.84-167.78-25.14-17.90-12.75-9.08-6.47
EBIT (%)
Depreciation 2.701.480.480.020.100.070.050.030.020.02
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 0.710.767.780.665.851.100.790.560.400.28
Total Cash (%)
Account Receivables 1.220.650.130.260.020.060.040.030.020.02
Account Receivables (%)
Inventories 0.200.260.100.020.020.010.010.0100
Inventories (%)
Accounts Payable 3.092.971.521.471.450.510.360.260.180.13
Accounts Payable (%)
Capital Expenditure -3.79-2.05-2.10-0.24-0.24-0.17-0.12-0.09-0.06-0.04
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 1.99
Beta -1.232
Diluted Shares Outstanding 2.48
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt 9.21%
Risk-Free Rate
Market Risk Premium
Cost of Equity -2.284
Total Debt 21.50
Total Equity 4.94
Total Capital 26.44
Debt Weighting 81.32
Equity Weighting 18.68
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 5.306.862.740.400.400.290.200.140.100.07
EBITDA -83.27-17.2719.56-3.82-167.68-25.07-17.85-12.71-9.05-6.45
EBIT -85.97-18.7519.08-3.84-167.78-25.14-17.90-12.75-9.08-6.47
Tax Rate 0.02%0.00%0.02%0.00%0.00%0.01%0.01%0.01%0.01%0.01%
EBIAT -85.96-18.7519.08-3.84-167.78-25.13-17.90-12.75-9.08-6.47
Depreciation 2.701.480.480.020.100.070.050.030.020.02
Accounts Receivable -0.570.52-0.130.23-0.040.020.010.010.01
Inventories --0.060.160.09-000000
Accounts Payable --0.12-1.45-0.05-0.02-0.94-0.15-0.10-0.07-0.05
Capital Expenditure -3.79-2.05-2.10-0.24-4.10-0.17-0.12-0.09-0.06-0.04
UFCF -87.05-18.9316.69-4.14-167.72-26.21-18.10-12.89-9.18-6.54
WACC
PV UFCF -24.48-15.79-10.50-6.99-4.65
SUM PV UFCF -62.41

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 7.06
Free cash flow (t + 1) -6.67
Terminal Value -131.77
Present Value of Terminal Value -93.69

Intrinsic Value

Enterprise Value -156.10
Net Debt 15.65
Equity Value -171.74
Shares Outstanding 2.48
Equity Value Per Share -69.21