RE: test11 Mar 2023 04:37
These are the results using the new swap schedule from this years annual report.
-----------------OUTFLOW (what Angus pays Mercuria)----------
SEP multiplier for swap 843,750 x ave floating price £2.5600 = £2,160,000
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 swap1 1,788,452 x floating price £1.5827 = £2,830,586
JAN multiplier for swap2 290,625 x floating price £1.5827 = £459,850
FEB multiplier for swap1 1,615,375 x floating price £1.3533 = £2,183,887
FEB multiplier for swap 2 262,500 x floating price £1.3533 = £355,258
TOTAL OUTFLOW FROM ANGUS TO MERCURIA £17,135,507
-----------------INFLOW (what Mercuria pays Angus)-------------
SEP multiplier for swap 843,750 x fixed price £0.4140 = £349.312
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 swap1 1,788,452 x fixed price £0.5205 = £930,868
JAN multiplier for swap2 290,625 x fixed price £4.3800 = £1,272,937
FEB multiplier for swap1 1,615,375 x fixed price £0.5205 = £840,784
FEB multiplier for swap2 262,500 x fixed price £4.3800 = £1,149,750
TOTAL INFLOW FROM MERCURIA TO ANGUS £7,306,188
TOTAL loss on commodity swap to 28th Feb inc £9,829,319
GAS SALES (Inc monthly Shell take-off at 1.5% and NTSEC 0.386p per therm deductions)
PRODUCTION PERIOD 01/07/22 to 30/09/22
SEP 1,220,442 therms for £3,069,061
PRODUCTION PERIOD 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
Total gas sales to 28th FEB inc. £17,949,911
Sales 17,949,911 - Swap loss (9,829,319) = £7,920,592
Gas sales PROFIT at Saltfleetby to 28th FEB inc. £7,920,592