Cashflow Forecast — Hamilton Student Residences

Forecast cash in
£234,318
Receipts & receivables over the window
Forecast cash out
£170,790
Costs payable on terms
Projected closing balance
£63,528
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
£7,477
Outstanding £7,477 · released £0
First moiety
£3,738
Awaiting practical completion date
Second moiety
£3,738
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 £57,136
£57,136 £57,136
Jul 26 £33,429
-£33,429 £23,707
Aug 26 £99,923 £83,609
£16,314 £40,021
Sep 26 forecast £57,321 £27,339
£29,982 £70,003
Oct 26 forecast £19,938 £26,413
-£6,475 £63,528
Nov 26 forecast
£0 £63,528
Dec 26 forecast
£0 £63,528
Jan 27 forecast
£0 £63,528
Feb 27 forecast
£0 £63,528
Mar 27 forecast
£0 £63,528
Apr 27 forecast
£0 £63,528
May 27 forecast
£0 £63,528