energy balancing credit committee pack

Distribution list - Mark CockayneSandra DworkinLinda WhitcroftLoraine O'Shaughnessy

Energy Balancing Credit Committee Operational Stats

Created Date - 4th July 2014 Pack No. - 06/14Created By - Zar Suleman

0

1

2

3

4

Jan Feb Mar Apr

Energy Balancing Credit Committee Pack

Confidential of 17

Best viewed in slide show mode (F5)

ContentsEnergy Balancing Credit Committee Pack

Confidential of 17

Click on each link to be taken to the page. (in slide show view only)

• Page 3 - Summary Page

• Page 5 - Cash Collection Stats

• Page 7 - Cash Call Stats - Monthly & Yearly Analysis

• Page 8 - Cash Call Stats - Issued & Paid

•Page 9 - Cash Call Stats - Failure to Pay Cash Call Notices

•Page 10 - Cash Call Stats - Failure to Pay Cash Call Notices Unpaid

•Page 11 - Cash Call Stats - Yearly Analysis + Issued & Withdrawn

•Page 12 - Cash Call Stats - Re-issued Cash Calls

•Page 13 - Cash Call Stats - Revised Cash Calls

•Page 14 - Cash Call Stats - % Cash Calls Issued

•Page 15 - Security Renewals Monthly Performance

•Page 16 – Late Paid Interest

•Page 17 – FI Aggregate Limits


Confidential

Summary Page

of 17

Click on xoserve logo to return to the contents page

(in slide show view only)

Last Months Pack:- May-14

Last Months Cash Calls - Last Months Cash Collected - May-14 - Network Invoices Paid Late

Total Issued 0 % of Cash Collected at PDD- 100.00% Value No. Paid Late

Issued & Appealed 0

Re-Issued 0 100% <£10,000 0

Withdraw n 0 <£100,000 0

Revised 0 <£500,000 0

Issued & Paid on due date 0 Number of FTPN's Issued - 0 >£500,000 0

FTPN CCN Paid 0 Total 0

FTPN CCN Unpaid 0

CCN Unpaid (No FTPN issued) 0

This Months Pack:- Jun-14Current Months Cash Calls - Current Months Cash Collected - Jun-14 - Network Invoices Paid Late

Total Issued 2 % of Cash Collected at PDD- 100.00% Value No. Paid Late

Issued & Appealed 1

Re-Issued 0 100% <£10,000 0

Withdraw n 1 <£100,000 0

Revised 0 <£500,000 0

Issued & Paid on due date 1 Number of FTPN's Issued - 0 >£500,000 0

FTPN CCN Paid 0 Total 0

FTPN CCN Unpaid 0


Year to Date Cash Call Position - Jun-14 - Further Security Requests Year to Date Network Invoices Paid Late

Total Issued 7 Associated name Value No. issued 0

Issued & Appealed 5 <£10,000 £0.00

Re-Issued 0 <£100,000 0

Withdraw n 5 <£500,000 0

Revised 0 <£1,000,000 0

Issued & Paid on due date 2 >£1,000,000 0

FTPN CCN Paid 0 Total 0 0

FTPN CCN Unpaid 0


Count Ntw k B

% of Cash Collected PDD +2

Count Ntw k E

Count Ntw k D

% of Cash Collected PDD +2

Count Ntw k C

Total Paid Late

Total Value Paid Late

Count Ntw k A

Section 1 - Cash Collection


Confidential of 17



Energy Balancing Credit Committee Pack Cash Collection Stats

Confidential of 17



98%

99.61%

98%

99.36%

98%

99.26%

98%

99.73%

98%

99.90%

98%

99.97%

95%

96%

97%

98%

99%

100%

% O

f C

ash

Co

llecte

d

2009 2010 2011 2012 2013 2014

Yearly Cash Collection Targets Payment Due Date

Target PDD Collected PDD

The above graph is a yearly breakdown of cash collection against target on payment due date. The data is collated as a rolling 12 month figure.

100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100%

0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

% O

f C

ash

Co

llec

ted

Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14

Monthly Breakdown Of Cash Collected At Payment Due Date +2


99.92% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%99.75%

100.00% 100.00%

97%

98%

98%

99%

99%

100%

100%

% O

f Cas

h C

olle

cted


Monthly Breakdown Of Cash Collected At Payment Due Date


The graph above is a breakdown of cash collected against target at payment due date + 2 days.

This graph provides a breakdown of the monthly figures that were collected against target on payment due date.* All f igures rounded to 2 decimal places

The above graph shows a breakdown of the number of Failure To Pay Notices issued year to date.

21

28

14

18

8

5

0

5

10

15

20

25

30

No

. O

f F

TP

N's

2009 2010 2011 2012 2013 2014

Yearly Breakdown of Failure to Pay Notices for Cash Collection

Section 2 - Cash Calls


Confidential of 17



Energy Balancing Credit Committee Pack Cash Call Stats

Confidential of 17

Monthly & Yearly Analysis Click on xoserve logo to return to the contents page

(in slide show view only)Monthly Total Of Cash Calls Issued

6

1

7

6

5

4

2

0

1

2

0

2

0

1

2

3

4

5

6

7

8


No

. O

f C

ash

Cal

ls

This graph provides a monthly breakdown of the number of cash calls issued.

This Graph provides a yearly breakdown of cash calls issued.

Yearly Total Of Cash Calls Issued

56

64

55

7

103

0

20

40

60

80

100

120

2010 2011 2012 2013 2014

No.

Of C

ash

Cal

ls

This graph is a year To Date breakdown by financial value and should be viewed in conjunction with the yearly breakdown of cash calls issued.

Yearly Total Value Of Cash Calls Issued

£13,034,000

£42,595,000

£20,582,000

£17,998,000

£216,000£0

£5,000,000

£10,000,000

£15,000,000

£20,000,000

£25,000,000

£30,000,000

£35,000,000

£40,000,000

£45,000,000

2010 2011 2012 2013 2014

Valu

e (£

's)

This graph should be viewed in conjunction with the monthly breakdown as this is a breakdown by month but of financial amounts.

Monthly Total By Value Of Cash Calls Issued

£3,091,000

£18,000

£1,640,000

£2,831,000

£37,000

£4,096,000

£77,000 £0 £54,000 £76,000 £0 £9,000£0

£500,000

£1,000,000

£1,500,000

£2,000,000

£2,500,000

£3,000,000

£3,500,000

£4,000,000

£4,500,000


Val

ue

(£'s

)


Confidential of 17

Issued & Paid Click on xoserve logo to return to the contents page


This graph should be viewed alongside the monthly breakdown of cash calls issued and paid, as this is a breakdown by month again but provides financial values of the cash

calls.

Monthly Total Value Of Cash Calls Issued & Paid on Original Due Date

£666,000

£18,000

£306,000

£35,000 £20,000 £68,000 £0 £0 £54,000 £0 £0 £2,000£0

£500,000

£1,000,000

£1,500,000

£2,000,000

£2,500,000

£3,000,000

£3,500,000

£4,000,000

£4,500,000


Valu

e (£

's)

This Graph provides a yearly breakdown of cash calls issued and paid. To assess the total no. of cash calls issued and paid read in conjunction with total no. of FTPCCN's issued and

paid on page 9.

Yearly Total Of Cash Calls Issued & Paid On Original Due Date

38

44

33

2

80

0

10

20

30

40

50

60

70

80

90

2010 2011 2012 2013 2014

No

. Of C

ash

Cal

ls

This graph is a yearly breakdown by financial value of cash calls issued and paid.

Yearly Total Value of Cash Calls Issued & Paid On Original Due Date

£8,358,000

£6,542,000

£22,000,000

£7,873,000

£5,697,000

£56,000£0

£5,000,000

£10,000,000

£15,000,000

£20,000,000

£25,000,000

2009 2010 2011 2012 2013 2014

Val

ue

(£'s

)

This graph is a monthly breakdown of the amount of cash calls issued and paid by the shipping community.

Monthly Total Of Cash Calls Issued & Paid on Original Due Date

2

1

3

2

3

2

0 0

1

0 0

1

0

0.5

1

1.5

2

2.5

3

3.5


No.

Of C

ash

Cal

ls


Confidential of 17

Failure to Pay Cash Call NoticesClick on xoserve logo to return to the contents page


This graph provides a breakdown by month of the number of Failure To Pay Cash Call Notices that have been issued and paid.

Monthly No. Of FTPCCN's Issued & Paid

0 0

1

0 0

1

0 0 0 0 0 00

0.2

0.4

0.6

0.8

1

1.2


No.

Of C

ash

Cal

ls

This graph should be viewed alongside the monthly breakdown as this is the financial values of the Failure to Pay Cash Call Notices issued and paid.

Monthly Value of FTPCCN's Issued & Paid

£0 £0

£407,000

£0 £0£24,000

£0 £0 £0 £0 £0 £0£0

£50,000

£100,000

£150,000

£200,000

£250,000

£300,000

£350,000

£400,000

£450,000


Val

ue

(£'s

)

This graph is a yearly breakdown of Failure to Pay Cash Call Notices issued and paid. To assess the total no. of cash calls issued and paid read in conjunction with total no. of cash

calls issued and paid on page 8.

Yearly Total of FTPCCN's Issued & Paid

9

4

1 1

2

00

1

2

3

4

5

6

7

8

9

10

2009 2010 2011 2012 2013 2014

No

. o

f C

as

h C

all

s

This graph should be viewed alongside the yearly breakdown of Failure To Pay Cash Call Notices issued and paid as this graph provides the financial vales of the cash calls.

Yearly Total Value of FTPCCN's Issued & Paid£1,201,000

£101,000

£16,000

£431,000

£0£0

£200,000

£400,000

£600,000

£800,000

£1,000,000

£1,200,000

£1,400,000

2010 2011 2012 2013 2014

Val

ue

(£'s

)

Failure to Pay Cash Call Notices Unpaid

Energy Balancing Credit Committee Pack Cash Call StatsClick on xoserve logo to return to the contents page


Confidential of 17

This graph provides a breakdown by month of the number of Failure To Pay Cash Call Notices that have been issued and unpaid.

Monthly No. Of FTPCCN's Issued & Unpaid

0 0 0 0 0 0 0 0 0 0 000

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1


No.

Of C

ash

Cal

ls

Graph should be viewed with monthly breakdown as this is the financial value of the Failure to Pay Cash Call Notices issued and unpaid.

Monthly Value of FTPCCN's Issued & Unpaid

£0 £0 £0 £0 £0 £0 £0 £0 £0 £0£0 £0£0

£0

£0

£0

£0

£1

£1

£1

£1

£1

£1


Val

ue (£

's)

This graph is a yearly breakdown of Failure to Pay Cash Call Notices issued and unpaid. To assess the total no. of cash calls issued and unpaid read in conjunction with total no. of

cash calls issued and paid on page 8.

Yearly Total of FTPCCN's Issued & Unpaid

5

0

1

0 00

1

2

3

4

5

6

2010 2011 2012 2013 2014

No

. of

Cas

h C

alls

This graph should be viewed alongside the yearly breakdown of Failure To Pay Cash Call Notices issued and Unpaid as this graph provides the financial values of the cash calls.

Yearly Total Value of FTPCCN's Issued & Unpaid

£35,000

£0

£76,000

£0 £0£0

£10,000

£20,000

£30,000

£40,000

£50,000

£60,000

£70,000

£80,000

2010 2011 2012 2013 2014

Val

ue (£

's)


Confidential of 17

Yearly Analysis + Issued & Withdrawn Click on xoserve logo to return to the contents page


This graph provides a breakdown by month of cash calls issued and withdrawn after appeal data was agreed.

Monthly Number Of Cash Calls Issued & Withdrawn

4

0

3

4

2

1

2

0 0

2

0

1

0

0.5

1

1.5

2

2.5

3

3.5

4

4.5


No.

Of C

ash

Cal

ls

This graph should be viewed alongside the monthly breakdown of cash calls issued and withdrawn after appeal data was agreed as this graph provides a breakdown by financial

value.

Monthly Value Of Cash Calls Issued & Withdrawn

£2,425,000

£0

£927,000

£2,796,000

£17,000

£4,004,000

£77,000 £0 £0 £76,000 £0 £7,000£0

£500,000

£1,000,000

£1,500,000

£2,000,000

£2,500,000

£3,000,000

£3,500,000

£4,000,000

£4,500,000


Val

ue (£

's)

This graph provides a breakdown by year of the cash calls that have been issued and withdrawn after appeal data was agreed.

Yearly Breakdown Of Cash Calls Issued & Withdrawn

£20,043,000

£12,503,000 £11,854,000

£5,256,000

£160,000

19

17

9

20

5

£0

£5,000,000

£10,000,000

£15,000,000

£20,000,000

£25,000,000

2010 2011 2012 2013 2014

Val

ue

(£'s

)

0

5

10

15

20

25

No

. O

f C

ash

Cal

ls

Value No. Of Cash Calls

This graph shows the teams performance in issuing the cash call notices before the 3pm deadline.

YTD Cash Calls Issued & Withdrawn

58 56

103

64

50 0 0 0 0

55

00.00%

0.00%0.00%0.00%0.00%0.00%

0

20

40

60

80

100

120

2009 2010 2011 2012 2013 2014

No.

Of C

ash

Cal

ls

0.00%

10.00%

20.00%

30.00%

40.00%

50.00%

60.00%

70.00%

80.00%

90.00%

100.00%

% Is

sued

Afte

r 3p

m

No. Of CashCallsNo. Issuedafter 3% IssuedAfter 3


Confidential of 17

Re-Issued Cash Calls Click on xoserve logo to return to the contents page


This graph is a monthly breakdown of cash calls that were re-issued as a result of unsuccessful appeal data.

Monthly No. Of Cash Calls Re-Issued

0 0 0 0 0 0 0 0 0 0 0 00

1


No.

Of C

ash

Cal

ls

This graph needs to be viewed alongside the monthly breakdown of re-issued cash calls as a result of unsuccessful appeal data as this graph provides a breakdown by financial

value.

Monthly Value Of Cash Calls Re-issued

£0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0£0

£25,000


Val

ue

(£'s

)

This graph is a yearly breakdown of cash calls that were re-issued as a result of unsuccessful appeal data.

Yearly Breakdown Of Cash Calls Re-issued

£0 £0 £0 £0 £00 0 0 0 0£0

£25,000

2010 2011 2012 2013 2014

Val

ue

(£'s

)

0

1

No

. O

f C

ash

Cal

ls



Confidential of 17

Revised Cash Calls Click on xoserve logo to return to the contents page


This graph is a monthly breakdown of cash calls that were revised as a result of successful appeal data.

Monthly No. Of Cash Calls Revised

0 0 0 0 0 0 0 0 0 0 0 00

1

2


No

. O

f C

as

h C

all

s

This graph needs to be viewed alongside the monthly breakdown of revised cash calls as a result of successful appeal data as this graph provides a breakdown by financial value.

Monthly Value Of Cash Calls Revised

£0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0£0

£50,000

Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14

Va

lue

(£

's)

This graph is a yearly breakdown of cash calls that were revised as a result of successful appeal data.

Yearly Breakdown Of Cash Calls Revised

£0 £0

£451,000

£114,000

£16,000£0

0 0

2

0

11

£0

£500,000

2009 2010 2011 2012 2013 2014

Val

ue

(£'s

)

0

5

10

15

20

No

. O

f C

ash

Cal

ls



Confidential of 17

Issued Cash Calls % Click on xoserve logo to return to the contents page


Number of Cash Call Notices:IssuedAppealed, Withdrawn 0 0% 0 0% 1 25% 0 0% 2 40% 1 17%Appealed, Reissued & Paid 0 0% 0 0% 0 0% 0 0% 0 0% 0 0%Appealed, Revised & Paid 0 0% 0 0% 0 0% 0 0% 0 0% 0 0%Unpaid 0 0% 0 0% 0 0% 0 0% 0 0% 1 17%Paid in Full 2 100% 2 100% 3 75% 1 100% 3 60% 4 67%Issued after 3pm 0 0% 0 0% 0 0% 0 0% 0 0% 0 0%





Dec-13 Jan-144 2

4 7

2 00 1Feb-14 Mar-14 Apr-14 May-14

10 1Dec-12 Jan-13

7 2Feb-13 Mar-13

5 64 1

Apr-13 May-13

Jun-12 Jul-122 2

Aug-12 Sep-12 Oct-12 Nov-12

Jun-13 Jul-13 Oct-13 Nov-13Aug-13 Sep-132 6

Oct-14 Nov-14

1 7

Aug-14 Sep-14

6 5

0 0Jun-14 Jul-14

2 0 0 0

Energy Balancing Credit Committee Pack Security Renewals Monthly Performance

Confidential of 17



Month

Issued

No. of Securities renewed After Expiry

0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0%

No. of Securities Renewed Before Expiry

8 100% 9 100% 3 100% 2 100% 7 100% 7 100% 11 100% 20 100% 7 100% 2 100% 16 100% 10 100%

Securities still pending 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0%

Month

Issued


0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0%


4 100% 11 100% 3 100% 1 100% 6 100% 7 100% 15 100% 19 100% 17 100% 6 100% 6 100% 12 0%

Securities still pending 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0%

Month

Issued


0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0%


3 100% 14 100% 3 100% 5 100% 8 100.0% 8 100% 13 100% 16 100% 17 100% 1 50% 0 0% 0 0%

Securities still pending 0 0% 0 0% 0 0% 0 0% 0 0.0% 0 0% 0 0% 0 0% 0 0% 1 50% 6 100% 0 0%

Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14

3 14 3 5 8 8 13 16 17 2 6 0


8 9 3 2 7 7 11 20 7 2 16 10


12661719157613114


Late Paid Interest

Confidential of 17



2013 2013 2013/14 2013/14 2014 2014

Interest charged to Users from April

2013 to September 2013

Recovery charges charged to Users from April 2013 to September 2013

Interest charged to Users from October 2013 to March 2014

Recovery charges charged to Users from October 2013

to March 2014

Interest charged to Users from April

2014 to September 2014

Recovery charges charged

to Users from April 2014 to

September 2014

ADHOC £0.10 £40.00 £0.31 £40.00 £33.92 £100.00EBI £31.44 £310.00 £0.36 £160.00 REC UNI

TOTAL £31.54 £350.00 £0.66 £200.00 £33.92 £100.00

- Figures are cumulative and calculated by Reference Rate + 8% as per Late Payment of Commercial Debt Act 1998

- Plus Recovery charge based on original value of invoice paid late (Not charged for Late Credit Payment to Users)

* Charges upto March 2014 will be applied to the May 2014 Energy Balancing Invoice

Energy Balancing Credit Committee PackFinancial Institution Aggregate

Limits

Confidential of 17



Data Correct as of: 04/07/2014

BankAvailable

Head room %BNP Paribas 3.38%Deutsche Bank AG 9.61%HSBC Bank plc 11.33%Mizuho Bank, Ltd. 11.50%Bank of Tokyo-Mitsubishi UFJ, Ltd. (The) 20.60%Credit Agricole Corporate and Investment Bank 22.44%ING Bank N.V. 22.79%JPMorgan Chase Bank, NA 34.27%Lloyds Bank Plc 34.71%Barclays Bank PLC 39.21%Sumitomo Mitsui Banking Corporation 53.92%Rabobank Nederland 57.72%Societe Generale 60.16%Santander UK PLC 60.95%Svenska Handelsbanken AB 61.29%DZ BANK AG 73.74%SEB 74.09%DNB Bank ASA 83.21%Citibank, N.A. 84.96%Nordea Bank Finland Plc 86.61%Macquarie Bank Limited 90.24%Standard Chartered Bank 90.35%DBS Bank Ltd. 94.35%Bank of Nova Scotia 95.31%Bank of America, N.A. 97.66%

energy balancing credit committee pack

Documents

cash collection stats

contents page

summary page page

stats revised cash callspage

cash calls issuedpage

stats failure

xoserve logo

stats yearly analysis