CASH WATERFALL DATA
CFADS = Cash Flow Available for Debt Service
Month opening
Aug-22balance
Sep-22 Oct-22 Nov-22 Dec-22 Jan-23
Amount £000 £000 £000 £000 £000 £000
EBITDA 559 622 308 57 -66 -212
Working capital adjustments -71 2 13 -3 21 -15
Operating cash flows 488 624 321 54 -45 -227
Capital expenditure - development projects -50 -75 -120 -200 -240
Cash before development funding 488 574 246 -66 -245 -467
Grant funding for development capex 0 0 25 38 60 100
Debt funding 0 25 38 60 100 120
Cash after development funding 488 599 308 32 -85 -247
Routine capital expenditure 0 -100 -50 -25 -24 0
Interest income 1 1 1 1 1 1
Cash opening balance 1,000
CFADS ### 489 500 259 8 -108 -246
CFADS + cash opening cfwd 1,489 1,989 2,249 2,256 2,148 1,902
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a differe
Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 closing balance
£000 £000 £000 £000 £000 £000
-120 -209 708 623 251 -470
-6 3 15 -7 8 23
-126 -206 723 616 258 -447
-600 -700 -150 -80
-726 -906 573 536 258 -447
120 300 350 75 40 0
300 350 75 40 0 0
-306 -256 998 651 298 -447
0 -30 0 0 -50 -169
1 1 1 1 1 1
-305 -285 999 652 249 -615 2,597
1,597 1,312 2,311 2,963 3,213 2,597
in your version of Excel.
ng this workbook into a different file format will permanently break the chart.
