Michael Caine revisited pt 2 - Calculations10 Jul 2023 08:16
I have run these numbers through an NPV spreadsheet – the key difference is I have applied a 12% discount rate to reflect that the cost of money has increased considerably over the last year. For those not familiar with an NPV, this assumes that money has a cost, so is like reverse compounded interest, in that future value of income is decreased each year - in this model by 12% each year, compounded – so income by year 10 is not worth very much! So the NPV is the value TODAY of the future cash flows (profits).
We will initially look at two of the possibilities, both with the 50% inflated capex as per the above presentation: 10mmcfgd giving net profit of $10.28 per mmcf, and 50mmcfgd giving $9.79 per mmcf. Production ramp up assumptions, capex (now increased by 50%) as per the above RNS. The 10-yr NPV12 for the 10mmcfgd operation is $177M (£138M), and for the 50mmcfgd is $795M (£619M), both assuming 360 days per year operation.
Now that isn't the whole story – 10mmcfgd only uses 34 BCF over a 10-year period, 50mmcfgd uses 171 BCF over 10 years. As Paul said “what the hell do we do with all the gas?” The answer is gas to power or to Europe. For G2P & G2EU, I am assuming a price of only $10 per mmcf, giving a net profit of just $7 per mmcf, and capital expenditure of $100M, which is generous for a short connection to the Trans Maghreb Pipeline. This gives a NPV12 of $3225M (£2511M), and requires 900 BCF. There have been a number of suggestions that PRD will achieve the CPR P10 figure of 1.8 TCF just for drilling so far.
Multiply the above by 75% to get nett to PRD, then assume 450M shares, this gives a current value per share of 23p for 10mmcfgd, £1.03p for 50mmcfgd (both G2I) and £4.18p for 250mmcfgd G2P/G2EU. 50 G2I + 250 G2P/G2EU gives over £5 per share.
We have seen that utilising 250mmcfgd for 10 years provides an NPV12 of $3225M. That works out at $3.58M per BCF, after discounting over a 10 year period. Were PRD to achieve a recoverable volume of 1.8 TCF, that still leaves 900BCF unused. If you were to additionally extract that remaining 900 Bcf, so that the entire P10 resource was used up in 10 years, then the NPV12 moves up to $6450M (£5023M / £11.16p per share). If you could extract it faster, then the money comes in sooner, and the negative effects of discounting at a compound rate of 12% are reduced, so the value is correspondingly higher.
This is just for 10-year output from the MOU-Fan & Ma sands at the current drilled boreholes MOU-1, -3 & -4. Nothing for any residual MOU-Fan gas. Nothing for anything else – not Jurassic or Triassic at MOU-4, nor for any of the many Neogene, Jurassic or Triassic prospects already identified across the licence area equivalent to 60 North Sea Blocks. Nothing for Ireland, nothing for T&T.
You can see why Paul is talking about trying to retain a 10% royalty or stub equity in any deal.