Cashflow Forecast — Wishaw Care Home

Forecast cash in
£807,143
Receipts & receivables over the window
Forecast cash out
£699,350
Costs payable on terms
Projected closing balance
£107,793
From £0 opening
Lowest projected balance
£0
No dip projected

Retention

5% withheld per valuation, capped at 3% of the contract sum. Released in two halves at practical completion and end of defects.

Total held
£20,224
Outstanding £20,224 · released £0
First moiety
£10,112
Awaiting practical completion date
Second moiety
£10,112
Awaiting practical completion date

Monthly cashflow

Cash in (payments received and outstanding notified sums, then forecast valuations) versus cash out (costs paid on terms), with the running cash position. Past months are actuals; future months are forecast.

Month Cash in Cash out Movement Net Cumulative
Jun 26
£0 £0
Jul 26 £384,255
£384,255 £384,255
Aug 26 £339,707
-£339,707 £44,548
Sep 26 forecast £409,806 £181,915
£227,891 £272,439
Oct 26 forecast £13,082 £177,728
-£164,646 £107,793
Nov 26 forecast
£0 £107,793
Dec 26 forecast
£0 £107,793
Jan 27 forecast
£0 £107,793
Feb 27 forecast
£0 £107,793
Mar 27 forecast
£0 £107,793
Apr 27 forecast
£0 £107,793
May 27 forecast
£0 £107,793