REVENUE FOR 24/04/2325 Apr 2023 18:50
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 63,011 therms
SPOT PRICE per THERM £0.9690
MERCURIA PAYMENT TO ANGUS
66,964 X £0.75967 = £50,870
ANGUS PAYMENT TO MERCURIA
66,964 X £0.9690 = £64,888
LOSS on SWAP is £14,018
GAS SALES PAYMENT BY SHELL TO ANGUS
63,011 therms @ £0.9690 sold for = £61,055
61,055 - 14,018 = £47,037 GAS SALES gross profit.
Month to date GAS SALES PROFIT £999,067
less Shell 1.5% and Ntsec 0.386p/therm
1)SAP used instead of NBP