Discounted Cash Flow (DCF) Analysis Levered

Confidence Petroleum India Limited (CONFIPET.NS)

69.65 ₹

-1.10 (-1.55%)
All numbers are in Millions, Currency in USD
Stock DCF: -54.71 | 69.65 | overvalue

Free Cash Flow

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 6,138.9810,045.3010,777.758,631.0114,276.9018,432.1423,796.7630,722.7239,664.4651,208.67
Revenue (%)
Operating Cash Flow 654.45682.59662.28975.301,0291,552.282,004.062,587.343,340.374,312.58
Operating Cash Flow (%)
Capital Expenditure -632.79-1,423.52-842.04-1,092.20-1,604.22-2,071.12-2,673.92-3,452.15-4,456.89-5,754.05
Capital Expenditure (%)
Free Cash Flow 21.66-740.94-179.76-116.90-575.22-518.84-669.85-864.81-1,116.51-1,441.47

Weighted Average Cost Of Capital

Share price $ 69.65
Beta 1.252
Diluted Shares Outstanding 284.01
Cost of Debt
Tax Rate 22.89
After-tax Cost of Debt 3.86%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.544
Total Debt -
Total Equity 19,781.44
Total Capital 19,781.44
Debt Weighting 0.00
Equity Weighting 100.00
Wacc

Build Up Free Cash Flow

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 6,138.9810,045.3010,777.758,631.0114,276.9018,432.1423,796.7630,722.7239,664.4651,208.67
Operating Cash Flow 654.45682.59662.28975.301,0291,552.282,004.062,587.343,340.374,312.58
Capital Expenditure -632.79-1,423.52-842.04-1,092.20-1,604.22-2,071.12-2,673.92-3,452.15-4,456.89-5,754.05
Free Cash Flow 21.66-740.94-179.76-116.90-575.22-518.84-669.85-864.81-1,116.51-1,441.47
WACC
PV LFCF -473.66-558.26-657.96-775.48-913.99
SUM PV LFCF -3,379.35

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 9.54
Free cash flow (t + 1) -1,470.30
Terminal Value -19,499.95
Present Value of Terminal Value -12,364.31

Intrinsic Value

Enterprise Value -15,743.66
Net Debt -206.30
Equity Value -15,537.36
Shares Outstanding 284.01
Equity Value Per Share -54.71