Test8 May 2023 04:41
COMBINING THE SWAPS
SWAP 1
CURRENT PRODUCTION PERIOD 01/04/23 - 30/06/23
5,250,000 THERMS, FIXED PRICE 37.55p per THERM.
5,250,000 THERMS/91 DAYS = 57,692 THERMS per DAY.
SWAP2
CURRENT PRODUCTION PERIOD 01/04/23 - 30/06/23
843,750 THERMS, FIXED PRICE £3.1500 per THERM.
843,750 THERMS/91 DAYS = 9,272 THERMS per DAY.
FIXED and VARIABLE MULTIPLIER
57,692 + 9,272 = 66,964
DAILY REVENUE FROM FIXED PRICE
(57,692 X £0.3755) + (9,272 X £3.15) = £50,870
FIXED PRICE per THERM is 50,870/66,964 = £0.7597
DAILY PRODUCTION 62,063 therms
SPOT PRICE per THERM £0.8289
MERCURIA PAYMENT TO ANGUS
66,964 X £0.75967 = £50,870
ANGUS PAYMENT TO MERCURIA
66,964 X £0.8289 = £55,506
LOSS on SWAP is £4636 (made up from a loss on swap 1 £26,157 and a profit on swap 2 £21,521)
GAS SALES PAYMENT BY SHELL TO ANGUS
62,063 therms @ £0.8289 sold for = £51,444
51,444 - 4,636 = £46,808 GAS SALES gross profit.
Month to date GAS SALES PROFIT £1,265,747
less Shell 1.5% and Ntsec 0.386p/therm
1)SAP used instead of NBP