Discounted Cash Flow (DCF) Analysis Unlevered

Callon Petroleum Company (CPE)

$30.26

-0.40 (-1.30%)
All numbers are in Millions, Currency in USD
Stock DCF: -3,503.92 | 30.26 | 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 587.62671.571,033.152,045.033,230.965,040.787,864.3612,269.5619,142.3229,864.84
Revenue (%)
EBITDA 310.97106.14-1,836.61805.591,767.79-150.59-234.95-366.55-571.88-892.21
EBITDA (%)
EBIT 310.97106.14-2,317.24-145.78264.71-2,495.62-3,893.53-6,074.48-9,477.09-14,785.66
EBIT (%)
Depreciation --480.63951.371,503.082,345.023,658.585,707.938,905.2113,893.44
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 16.0513.3420.249.883.4073.24114.27178.28278.14433.94
Total Cash (%)
Account Receivables 131.72209.46133.11232.44237.13858.891,3402,090.603,261.655,088.65
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 261.18238.76101.23151.84785.311,225.191,911.482,982.194,652.667,258.84
Accounts Payable (%)
Capital Expenditure -611.17-640.54-677.15-1,072.22-992.98-3,509.32-5,475.06-8,541.91-13,326.63-20,791.51
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 30.26
Beta 2.711
Diluted Shares Outstanding 61.90
Cost of Debt
Tax Rate 0.97
After-tax Cost of Debt 3.52%
Risk-Free Rate
Market Risk Premium
Cost of Equity 16.200
Total Debt 2,241.30
Total Equity 1,873.22
Total Capital 4,114.51
Debt Weighting 54.47
Equity Weighting 45.53
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 587.62671.571,033.152,045.033,230.965,040.787,864.3612,269.5619,142.3229,864.84
EBITDA 310.97106.14-1,836.61805.591,767.79-150.59-234.95-366.55-571.88-892.21
EBIT 310.97106.14-2,317.24-145.78264.71-2,495.62-3,893.53-6,074.48-9,477.09-14,785.66
Tax Rate 2.63%34.20%-5.06%0.05%0.97%6.56%6.56%6.56%6.56%6.56%
EBIAT 302.7969.84-2,434.52-145.71262.16-2,332.01-3,638.28-5,676.25-8,855.79-13,816.33
Depreciation --480.63951.371,503.082,345.023,658.585,707.938,905.2113,893.44
Accounts Receivable --77.7476.35-99.33-4.69-621.77-481.11-750.60-1,171.04-1,827
Inventories ----------
Accounts Payable --22.43-137.5350.60633.47439.89686.291,070.711,670.472,606.18
Capital Expenditure -611.17-640.54-677.15-1,072.22-992.99-3,509.32-5,475.06-8,541.91-13,326.63-20,791.51
UFCF -308.38-670.87-2,692.21-315.281,401.03-3,678.19-5,249.58-8,190.11-12,777.78-19,935.22
WACC
PV UFCF -3,365.53-4,395.05-6,274.06-8,956.41-12,785.54
SUM PV UFCF -35,776.58

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 9.29
Free cash flow (t + 1) -20,333.93
Terminal Value -278,929.05
Present Value of Terminal Value -178,892.29

Intrinsic Value

Enterprise Value -214,668.87
Net Debt 2,237.90
Equity Value -216,906.77
Shares Outstanding 61.90
Equity Value Per Share -3,503.92