The forecast page: 13 weeks ahead.
This is the page that arrives every Sunday. The figures here are invented, for a fictional food plant of 45 people, to show how the page reads.
Book an intro meeting at 18:00How to read it.
Each line is money in or out. The last line is what's left at the end of the week.
The floor: the sum we don't go below. Here, ₪250,000.
The yellow cell: the week that drops below the floor. The page exists for it.
The page itself.
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Opening balance | 560 | 680 | 450 | 445 | 520 | 655 | 405 | 475 | 515 | 370 | 145 | 340 | 445 |
| In | |||||||||||||
| From customers | 340 | 320 | 330 | 300 | 350 | 310 | 250 | 230 | 240 | 330 | 360 | 340 | 350 |
| Other income | – | – | – | – | – | – | – | 40 | – | – | – | – | – |
| Out | |||||||||||||
| Salaries | – | 380 | – | – | – | 385 | – | – | – | 385 | – | – | – |
| Suppliers | 175 | 170 | 180 | 165 | 170 | 175 | 180 | 170 | 175 | 170 | 165 | 175 | 170 |
| Rent and fixed costs | 45 | – | – | – | 45 | – | – | – | 45 | – | – | – | 45 |
| VAT and tax advances | – | – | 155 | – | – | – | – | – | 165 | – | – | – | – |
| Loan repayment | – | – | – | 60 | – | – | – | 60 | – | – | – | 60 | – |
| Closing balance | 680 | 450 | 445 | 520 | 655 | 405 | 475 | 515 | 370 | 145 (below the floor) | 340 | 445 | 580 |
Week 10: the balance drops to ₪145k, below the ₪250k floor.
What we do about the yellow week.
- 01
We ask the big customer who pays late to settle the ₪90k invoice by week 9.
- 02
We move a ₪60k supplier payment from week 10 to week 12, agreed, by phone, not by letter.
- 03
We open a two-week overdraft with the bank, a month before it's needed.