test30 Mar 2023 16:14
These are the results using the new swap schedule from this years annual report.
-----------------OUTFLOW (what Angus pays Mercuria)----------
Production Period 1-------------- 01/07/22 - 30/09/22
SEP multiplier for swap 843,750 x floating price £2.5600 = £2,160,000
Production Period 2--------------- 01/10/22 - 31/03/23
OCT multiplier for swap 1,788,452 x floating price £1.1017 = £1,969,377
NOV multiplier for swap 1,730,760 x floating price £1.2486 = £2,216,083
DEC multiplier for swap 1,788,452 x floating price £2.7736 = £4,960,466
JAN multiplier for swap 2,079,077 x floating price £1.5827 = £3,290,555
FEB multiplier for swap 1,877,875 x floating price £1.3533 = £2,541,328
MAR multiplier for swap 2,079,077 x floating price £ = £
TOTAL OUTFLOW FROM PRODUCTION PERIOD 2 £
TOTAL OUTFLOW FROM ANGUS TO MERCURIA prod periods 1,2 £
-----------------INFLOW (what Mercuria pays Angus)-------------
production period 1------------ 01/07/22 - 30/09/22
SEP multiplier for swap 843,750 x fixed price £0.4140 = £349,312
Production Period 2-------------- 01/10/22 - 31/03/23
OCT multiplier for swap 1,788,452 x fixed price £0.5205 = £930,868
NOV multiplier for swap 1,730,670 x fixed price £0.5205 = £900,840
DEC multiplier for swap 1,788,452 x fixed price £0.5205 = £930,868
JAN multiplier for swap 2,079,077 x fixed price £1.0600 = £2,203,822
FEB multiplier for swap 1,877,875 x fixed price £1.0600 = £1,990,547
MAR multiplier for swap 2,079,875 x fixed price £1.0600 = £2,203,822
TOTAL INFLOW FROM PRODUCTION PERIOD 2 £9,160,767
TOTAL INFLOW FROM MERCURIA TO ANGUS prod periods 1,2 £9,510,079
PRODUCTION PERIOD 1 --------------LOSS £1,810,688
PRODUCTION PERIOD 2 --------------LOSS £
TOTAL loss on commodity swap to 31st March inc £
GAS SALES (Inc monthly Shell take-off at 1.5% and NTSEC 0.386p per therm deductions)
Production Period 1--------------- 01/07/22 to 30/09/22
SEP 1,220,442 therms for £3,069,061
Production Period 2------------- 01/10/22 to 31/03/23
OCT 1,858,101 therms for £1,991,096
NOV 1,984,426 therms for £2,525,361
DEC 1,801,043 therms for £4,955,520
QUARTERLY therms produced 5,643,570 for £9,638,336
JAN 1,908,520 therms for £2,971,955
FEB 1,680,025 therms for £2,236,878
MAR therms for £
QUARTERLY therms produced for £
PRODUCTION PERIOD 1-----------PROFIT £
PRODUCTION PERIOD 2-----------PROFIT £
Total gas sales PROFIT to 31st March inc £
Sales - Swap loss () = £
Gas sales PROFIT at Saltfleetby to 31st March inc £