RE: It's a good start... finally26 Aug 2022 11:36
No Head In the Sand, no I had not confused mmscfd and monthly production, but I had however, forgotten to put in the excess hedged amounts that needed to be added between September 2022 and June 2023 which does have a small (£4.2 million) affect on the revenue generated over the next 9 months and means that the minimum amount of money that Angus can make is actually £7.8 million at 6mmscf/d rather than the £12 million I originally quoted.
In order that there is no further confusion about the calculations I explain all of the workings belos
6mmscf/d translates into 1,876,465therms per month.
The hedged volumes per day were (as per Angus’ documentation)
Jul-22 3.34 MMSCF 1,044,566 therms hedged per month
Aug-22 3.34 MMSCF 1,044,566 therms hedged per month
Sep-22 3.45 MMSCF 1,078,967 therms hedged per month
Oct-22 5.19 MMSCF 1,623,142 therms hedged per month
Nov-22 5.37 MMSCF 1,679,436 therms hedged per month
Dec-22 5.19 MMSCF 1,623,142 therms hedged per month
Jan-23 5.19 MMSCF 1,623,142 therms hedged per month
Feb-23 5.75 MMSCF 1,798,279 therms hedged per month
Mar-23 5.19 MMSCF 1,623,142 therms hedged per month
Apr-23 5.37 MMSCF 1,679,436 therms hedged per month
May-23 5.19 MMSCF 1,623,142 therms hedged per month
Jun-23 5.37 MMSCF 1,679,436 therms hedged per month
Jul-23 4.45 MMSCF 1,391,712 therms hedged per month
So in total there hedged amount was originally
Q3 2022 there was 3,168,098 therms hedged
Q4 2022 there was 4,925,721 therms hedged
Q1 2023 there was 5,044,563 therms hedged
Q2 2023 there was 4,082,015 therms hedged
Obviously there has been no production in July and August and production will only commence for September now so this means that Angus start with 2,089,131 thems owed to the hedge.
At 6mmscf/d starting in September this means production of
Q3 2022 there will be production of 1,876,465 therms (down 1,291,633 therms on where the hedge should be)
Q4 2022 there will be production of 5,629,395 therms (down 587,959 therms on where the hedge should be)
Q1 2023 there will be production of 1,876,465 therms (down 3,127 therms on where the hedge should be)
Q2 2023 there will be production of 1,876,465 therms (up 1,129,066 therms on where the hedge should be)
So over the course of this 9 months then Angus will produce 1,129,066 therms more than they owe the hedge and all of this can be sold at market rates.
To calculate afinancial value on this then we take the average of the expected gas prices between September 2022 and June 2023 then we get an average price of £6.93 pence per therm and the multiplication of these two numbers means an income of £7.8 million.