Member Info for gallder

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.8433

ANGUS PAYMENT TO MERCURIA = £56,471

LOSS on SWAP is £5,601 (made up from a loss on swap 1 £26,989 and a profit on swap 2 £21,388)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 96,791

SPOT PRICE per THERM £0.8433

GAS SALES PAYMENT BY SHELL TO ANGUS = £81,624

GAS SALES gross profit = £76,023

Add back revs for 6th to 8th June. 27.9 mmsfc = 309,312therms @ ave £0.6574/therm

Total extra revenue is £203,342

Month to date GAS SALES PROFIT £801,527

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.8129

ANGUS PAYMENT TO MERCURIA = £54,434

LOSS on SWAP is £3,565 (made up from a loss on swap 1 £25,235 and a profit on swap 2 £21,670)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 98,156

SPOT PRICE per THERM £0.8129

GAS SALES PAYMENT BY SHELL TO ANGUS = £79,791

GAS SALES gross profit = £76,226

Month to date GAS SALES PROFIT £532,162

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

CORRECTED

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.7618

ANGUS PAYMENT TO MERCURIA = £51,012

LOSS on SWAP is £142 (made up from a loss on swap 1 £22,285 and a profit on swap 2 £22,143)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 101,947

SPOT PRICE per THERM £0.7618

GAS SALES PAYMENT BY SHELL TO ANGUS = £77,663

GAS SALES gross profit = £77,521

Month to date GAS SALES PROFIT £455,936

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.

ANGUS PAYMENT TO MERCURIA = £38,791

LOSS on SWAP is £142 (made up from a loss on swap 1 £22,285 and a profit on swap 2 £22,143)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 101,947

SPOT PRICE per THERM £0.7618

GAS SALES PAYMENT BY SHELL TO ANGUS = £77,663

GAS SALES gross profit = £77,521

Month to date GAS SALES PROFIT £455,936

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.6498

ANGUS PAYMENT TO MERCURIA = £43,513

PROFIT on SWAP is £7,357 (made up from a loss on swap 1 £15,825 and a profit on swap 2 £23,182)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 0

SPOT PRICE per THERM £0.6498

GAS SALES PAYMENT BY SHELL TO ANGUS = £0

GAS SALES gross profit = £7,357

Month to date GAS SALES PROFIT £378,415

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.6540

ANGUS PAYMENT TO MERCURIA = £43,798

PROFIT on SWAP is £7,071 (made up from a loss on swap 1 £16,070 and a profit on swap 2 £23,143)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 0

SPOT PRICE per THERM £0.6540

GAS SALES PAYMENT BY SHELL TO ANGUS = £0

GAS SALES gross profit = £7,072

Month to date GAS SALES PROFIT £371,058

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

The reduction in the swap loss resulting from the changes to the swap schedule in Sept 22 and

new swaps in H1 23 are as follows.

SEP 22 £582,955 reduction in swap loss.

JAN 23 £813,603 reduction in swap loss.

FEB 23 £787,812 reduction in swap loss.

MAR 23 £956,825 reduction in swap loss.

APR 23 £603,941 reduction in swap loss.

MAY 23 £701,075 reduction in swap loss.

JUN 23 £700K estimate of reduction in swap loss.

Total is £5,146,002 reduction in swap loss resulting in an increase to profit of £5,146,002

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.6683

ANGUS PAYMENT TO MERCURIA = £44,754

PROFIT on SWAP is £6,116 (made up from a loss on swap 1 £16,894 and a profit on swap 2 £23,010)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 0

SPOT PRICE per THERM £0.6683

GAS SALES PAYMENT BY SHELL TO ANGUS = £0

GAS SALES gross profit = £6,116

Month to date GAS SALES PROFIT £363,986

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

Mercuria are a energy derivatives trading company just like a mm that trades shares. They would have

had another client to take the other side of the trade. In August and September JAN and FEB futures were

trading at over £5 a therm.

Whats confusing?

9,272 x £3.15 we receive per day from Mercuria.

9,272 x spot price we pay per day to Mercuria

It won't continue past the end of June as we lose swap 2.

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.6753

ANGUS PAYMENT TO MERCURIA = £45,221

PROFIT on SWAP is £5,649 (made up from a loss on swap 1 £17,296 and a profit on swap 2 £22,945)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 103,198

SPOT PRICE per THERM £0.6753

GAS SALES PAYMENT BY SHELL TO ANGUS = £69,692

GAS SALES gross profit = £75,341

Month to date GAS SALES PROFIT £357,870

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.5888

ANGUS PAYMENT TO MERCURIA = £39,428

PROFIT on SWAP is £11,442 (made up from a loss on swap 1 £12,305 and a profit on swap 2 £23,747)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 102,895

SPOT PRICE per THERM £0.5888

GAS SALES PAYMENT BY SHELL TO ANGUS = £60,585

GAS SALES gross profit = £72,027

Month to date GAS SALES PROFIT £282,529

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

NO.

Posters really should stop putting out fake gas prices. Futures prices are nothing to do with SPOT prices.

SPOT daily average prices can be found (in hindsight) on the national grid websight.

https://mip-prd-web.azurewebsites.net/DataItemExplorer

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.5793

ANGUS PAYMENT TO MERCURIA = £38,791

PROFIT on SWAP is £12,079 (made up from a loss on swap 1 £11,757 and a profit on swap 2 £23,836)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 102,705

SPOT PRICE per THERM £0.5793

GAS SALES PAYMENT BY SHELL TO ANGUS = £59,497

GAS SALES gross profit = £71,576

Month to date GAS SALES PROFIT £210,502

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0.5698

ANGUS PAYMENT TO MERCURIA = £38,156

PROFIT on SWAP is £12,714 (made up from a loss on swap 1 £11,210 and a profit on swap 2 £23,924)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 102,516

SPOT PRICE per THERM £0.5698

GAS SALES PAYMENT BY SHELL TO ANGUS = £58,414

GAS SALES gross profit = £71,128

Month to date GAS SALES PROFIT £138,926

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

MULTIPLIER 66,964

FIXED PRICE £0.7597

MERCURIA PAYMENT TO ANGUS = £50,870

MULTIPLIER 66,964

SPOT PRICE £0..5979

ANGUS PAYMENT TO MERCURIA = £40,037

PROFIT on SWAP is £10,833 (made up from a loss on swap 1 £12,830 and a profit on swap 2 £23,663)

-----------------------------------------------------------------------------------------------------------------------------------

DAILY PRODUCTION therms 95,275

SPOT PRICE per THERM £0.5979

GAS SALES PAYMENT BY SHELL TO ANGUS = £56,965

GAS SALES gross profit = £67,798

Month to date GAS SALES PROFIT £67,798

less Shell 1.5% and Ntsec 0.386p/therm

1)SAP used instead of NBP

--------------THERMS---AVE PRICE*---GAS SALES----SWAP profit (loss)---PROFIT------CUM PROFIT

SEP---------1,220,442----2.5100--------3,063,355----------(1,915,195)-----1,148,160

Q4 21/22---1,220,446---2.5100---------3,063,355----------(1,915,195)----1,148,160

OCT----------1,858,101---1.0716---------1,991,096---------(1,038,509)-------952,587

NOV----------1,984,426---1.2731--------2,526,340----------(1,315,243)----1,211,097

DEC----------1,801,043---2.7515--------4,955,520-----------(4,029,598)------925,922

Q1 22/23----5,643,570---1.6785--------9,472,956----------(6,383,350)----3,089,606

JAN----------1,908,520----1.5572--------2,971,995----------(1,086,115)----1,885,880

FEB----------1,680,025----1.3315--------2,236,879------------(555,291)----1,681,588

MAR----------1,833,369----1.0877-------1,994,119------------(145,247)----1,848,872

Q2 22/23----5,421,914----1.3285--------7,202,993---------(1,786,653)---5,416,340

H1 22/23---11,065,484----1.5070-----16,675,949----------(8,170,003)---8,505,946

APR-----------1,751,187-----0.9788------1,714,147------------(481,366)---1,232,781

MAY-----------2,604,716-----0.7109------1,851,800--------------43,389-----1,895,189-----12,782,076

1)Gas price is sap not NBP.

2)Gas sales includes Shell and NTSEC deductions.

3)Profit is gross profit.

4)*Effective price.