Question
Will we have enough cash through the summer?
The forecast falls from about $38,500 in week 1 to its lowest point of about $18,400 in week 9, then recovers to about $30,800 by week 13. The low end of the range dips below the $15,000 floor in weeks 8 to 10.
- Forecast
- Likely range
- Your cash floor
Answer: Lowest point in week 9: about $18,400, above your $15,000 floor. The low end of the range dips below it in weeks 8 to 10.
What it means
Two supplier bills and the quarterly tax payment land in the same weeks as the slowest sales. Moving one bill two weeks later, or collecting the two oldest invoices, keeps even the low end above your floor.
Based on
Your bank balance, open invoices and bills from your accounting system, purchase orders, recurring expenses, and the sales forecast.
What would make it surer
Connecting payroll, so pay dates come from the schedule instead of an average.
Checked afterward
As the weeks pass, Aptic scores this forecast against what actually happened, and that record sets how wide the next range is.