Appendix 6
Worthing and Southlands Hospitals NHS Trust
2006/07 CASH-FLOW FORECAST (£000) - as at November 2006, in line with 06/07 Plan - £16.689m DEFICIT
incorporates actual April to November 2006 cashflow Forecast EFL: Net Loans Received/(Repaid): Planned PDC: 2006 2007 -1236 17005 -1236 15769
APR
06/07 TOTALS Receipts Income from W Sussex Health Economy/SACS Other NHS Income - I&E Capital receipts Recoverable VAT RTA Income Bank Interest Southlands Bankings Worthing Bankings Direct Bank Credits CTF Reimbursement Loans received (to cover revenue & capital) Loans repaid PDC Receivable/(Repayable) Temporary PDC during the year 113934 8172 2200 508 307 172 1472 1639 1405 275 17005 0 -1236 0 11151 Payments Pay - Monthly Pay - Weekly PAYE/NI Superannuation Pensions Non-Pay (AP & Cashiers), incl. VAT & CTF Non-Pay: Creditor reduction Payments re Capital Schemes PDC Dividends (3.5%) Loan interest paid 53750 2366 23368 11208 305 38774 3979 7294 4752 57 4693 104 866 35 0 3554 0 0 0 9252 Brought Forward (PGO, Main, Imprest, Salaries accounts) Monthly Movement Overall Cash Balance 347 1899 2246 10246 463 0 0 0 13 197 148 84 0
MAY
actual
JUN
actual
JUL
actual
AUG
actual
SEP
actual
OCT
actual
NOV
actual
DEC
forecast
JAN
forecast
FEB
forecast
MAR
forecast
actual
10823 1101 0 13 22 23 87 152 165 0
10106 544 0 84 0 16 355 174 99 0
10131 378 0 92 40 14 88 202 92 50
12027 1366 0 49 56 12 93 153 132 0
10259 602 0 120 0 18 90 53 159 121
10233 718 0 25 39 25 112 57 174 0
11924 652 0 64 77 25 94 173 132 0 0
7100 587 0 16 19 7 90 132 92 0 0
7100 587 0 15 18 7 90 132 92 25 0
7100 587 0 15 18 6 90 132 92 25 0 0 11000 19065
6885 with £10.623m RAB removed 587 2200 from capital disposal programme 15 contras Non-Pay (Rev) below 18 6 86 131 92 54 contras Non-Pay (Rev) below 17005 -1236 -17005 8838
2027 12386 11378 11087 15915
3559 14981 11383 13141 8043
419 8485
4664 345 2124 1034 0 3235 400 0 0 11802 2246 584 2830
4700 107 2117 1054 215 4673 300 0 0 13166 2830 -1788 1042
4695 255 2157 1060 28 2808 300 0 0 11303 1042 -216 826
4560 208 2189 1075 0 4840 300 0 0 13172 826 2743 3569
4607 219 2076 1042 0 2514 800 2376 0 13634 3569 1347 4916
4610 149 2087 1032 0 2843 1700 0 0 12421 4916 -1038 3878
4612 179 2081 1065 48 3015 1447 0 0 12447 3878 694 4572
4200 200 1932 966 0 2818 353 0 0 10469 4572 -2426 2146
4100 200 1917 943 0 2818 335 0 0 10313 2146 -1828 318
4100 200 1886 943 14 2818 335 0 0 10296 318 8769 9087
4209 200 1936 £1.2m prepaid in 05/06 959 £1.0m prepaid in 05/06 0 2838 3979 1024 2376 57 17578 9087 -8740 347
Actual income & expenditure is displayed evenly over November 06 to March 07 unless specific factors exist
06/07 - I&E Income I&E benefit from Donated Asset Reserve Pay expenditure - NHS employees Pay (05/06 PAYE & superannuation prepayments) Non pay expenditure/ Agency staff Provisions - arising & reversed Non-pay 05/06 prepayments EBITDA Depreciation Profit/(loss) on fixed assets Interest receivable (+) Interest payable (-) Unwinding discount PDC dividends payable(-) I&E forecast 137552 with £10.623m RAB reduction 278 137830 -90692 -2205 -48867 -59 -2682 -6674 -5813 449 172 -57 -14 -4752 -16689
EFL & CRL Forecast EFL -1236 CRL 7294 7294 126929 278
PDC RECEIVABLE/(REPAYABLE) Arising from: Block Operational Capital Allocation Other Capital Allocations Capital brokerage repayment 05/06 EFL undershoot Revenue brokerage repayment Payment re Depreciation RAB
1167 4795 -1700 63 -10473 -5711 10623 -1236
Assumes level of prepayments/accruals remains constant unless stated and also that RAB will be deducted via future months SLA income
-90692 -2205 -38296 0 -2682 -5813 449 172 -57 Summarised as: -14 -4752 Brokerage Repayment -16683 I&E RAB Capital proceeds 05/06 EFL undershoot Cap Prog/repayment of depreciation Reduction in creditors
LOAN REQUIREMENT Arising from: Cash Earnings before Int, Tax'n, Dep'n & Amortisation (EBITDA) PDC Dividend payable Capital programme expenditure (allocations within net PDC repayment) PDC Repayment (see opposite) Loan Interest Payable Creditor reduction set against: Net Capital proceeds Interest received
-2397 -4752 -7294 -1236 -57 -3,641 2200 172 -17005
-12173 -7034 10623 2200 63 -7043 -3641 -17005
06/07 FORECAST EBITDA (Earnings Before Interest Taxation Depreciation & Amortisation)
I&E Donated Dep'n Transfer Net Transactions RAB EBITDA Depreciation Total Operating Deficit Profit/(loss) on disposals Interest Received Unwinding discount PDC Dividends Loan Interest Payable I&E Deficit 278 3670 -10623 -6674 -5813 -12487 449 172 -14 -4752 -57 -16689 -16689
Cash
8616 -10623 -2007
Cash greater as prepayments have been made in 05/06 Payment to AAW (see below) -10623 net of £6m RAB NHS & Donated, plus accelerated depreciation
-2007 2200 172 0 -4752 -57 -4444 see Note 4
Income RAB Donated Dep'n Transfer Pay Non-Pay, incl. utiled provisions Provisions - arising & reversed
137552 0 278 137830 -92897 -51549 -59
137552 0 137552 -90692 -48867
treated as deducted so that deficit remains at £16.689m rather than £6.066m Prepayments: -2205 -2682
per FIMS T12, m6 balancing figure
EBITDA
-6674
-2007
Assumptions on Loan as at 12th October 2006, per conversation with June Harrison, SHA: Loan repayment Loan interest Message left for June to phone me
06/07 Forecast EFL & CRL
CRL £000 Brought forward Block Capital Allocation Less: Top slicing by SHA Mortuary (part of IHS Part 2) Other net allocations Capital brokerage repayment deferred from prior year 4239 3209 -2042 2294 2421 -2827 EFL £000 63 3209 -2042 2294 2501 -1700
per 05/06 accounts as per Note 3 as per Note 3 as per Note 3 as per Note 3 as per Note 3
7294 Revenue brokerage repayment 7294 Depreciation 7294 RAB
4325
-10473 £4.7m to NHS Bank, £1.773m to SHA, furth -6148 -5711 as per Note 7 -11859 per m8 FIMS return
10623 assumes that RAB is not funded to the PCT -1236 17005 7294
Revenue Loans received/receivable
Charge against the CRL Gross Capital Expenditure Less: Book value of assets disposed of Add: Loss on disposal of donated assets Less: Capital Grants Less: Donations Charge against the CRL Capital Resource Limit (Over)/Underspend against the CRL 7569 -1340 0 0 -275 5954 7294 1340
per 05/06 accounts as per Note 3 as per Note 3 as per Note 3 as per Note 3 as per Note 3
£4.7m to NHS Bank, £1.773m to SHA, further £4m to SHA
as per Note 7 per m8 FIMS return assumes that RAB is not funded to the PCT, requiring an EFL adjustment
14,005 per Balance Sheet