Model behaviour3 Jun 2021 15:27
My latest cash model output update if anyone wants a look…
Assumptions
FX rate 1.4 average for the year
2021 production 207k boe per day (is the mid point of the company’s 200-215k guidance)
50% oil and 50% gas production
2021 Hedges (as provided by the company on 1 April when the deal closed). 22m bbl oil at $58 bbl and 25m boe gas at 44p a therm
2022 hedges (as above – company has provided). 12m bbl oil at $60 bbl and 25m boe gas at 44p a therm
Average realised unhedged oil price for 2021 $65. Despite the current oil px being $72 bbl the average spot for brent YTD is $63. I am assuming we remain elevated and being conservative at $65.
Average realised unhedged gas price for 2021 50p a therm. UK nat gas futures currently trading at 63.2p a therm versus ~40p in January so taking midpoint of this.
Gas price conversion from pence per therm to $ per bbl: 58.14 therms is the same as 1 bbl oil equivalent (boe). FX rate 1.4 gets you from pence per therm to $ per boe. I.e. 50p per therm is 0.5*1.4(FX)*58.14 = $40.7 boe
Opex per barrel $15 (company have stated “will be less than $15 bbl” so I am being conservative)
Fixed costs of $182m for combined biz (assuming no synergies so being conservative)
Opening Net Debt 2.9bn (provided by company at close)
Cost of debt 5% (company said will be <5% post close)
Number of shares in issue (pre consolidation) = 18,510,652,139
Dividend: will pay out 30% of FCF
Other cash costs in cashflow statement $150m (conservative guestimate)
Sales:
207k boe daily production x 360 days = 74.52m boe total pro forma production for 2021
50% oil / 50% gas gives oil production as 37.26m bbl and Gas as 37.26m boe for 2021
Hedged oil revs = 22m *$58 = $1.276bn
Hedged gas revs = 25m * $35.8 (which is the $ boe equiv of 44p a therm) = $895m
Unhedged oil revs = (37.26m-22m) *$65 = $991m
Unhedged gas revs = (37.26m-25m)* $40.7 = 502.66m
TOTAL GROUP PRO FORMA REVS FOR 2021 = $3.666bn
Costs
opex per bbl * total production = 15* 74.52 = $1.118bn
fixed costs 182m
GIVES EBITDAX: 3.666-1.118-0.182 = $2.365bn
Free Cashflow
Free cashflow pre dividend = EBITDAX – cash interest – tax – delta working capital – capex- other cash costs below the line. I have no view on WC so I assume will be zero delta
FCF = 2.366bn - 0.145bn (5% * 2.9bn net debt)- 0 (no tax) – 0 (no change in WC) – 1.1bn – 0.15bn
= $970.76m of glorious pro forma FCF
Dividend
30% of 970.76m = $291.228m
In GBP = 291/1.4 = £208.02m
Payout per share in GBP = £208.02m / 18510.652139m shares = £0.011 per share.
This is 5.4% yield at the current share price of 21p
YEAR END 2021 CLOSING NET DEBT OF
= opening net debt at start of 2021 of $3.2bn – FCF after paying div of $679.532m
= $2.52bn