Skip to content

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:00

How to read it.

  1. Each line is money in or out. The last line is what's left at the end of the week.

  2. The floor: the sum we don't go below. Here, ₪250,000.

  3. The yellow cell: the week that drops below the floor. The page exists for it.

The page itself.

A 13-week cash forecast, in thousands of ₪. A fictional business, sample figures.
Week12345678910111213
Opening balance560680450445520655405475515370145340445
In
From customers340320330300350310250230240330360340350
Other income–––––––40–––––
Out
Salaries–380–––385–––385–––
Suppliers175170180165170175180170175170165175170
Rent and fixed costs45–––45–––45–––45
VAT and tax advances––155–––––165––––
Loan repayment–––60–––60–––60–
Closing balance680450445520655405475515370145 (below the floor)340445580

Week 10: the balance drops to ₪145k, below the ₪250k floor.

What we do about the yellow week.

  1. 01

    We ask the big customer who pays late to settle the ₪90k invoice by week 9.

  2. 02

    We move a ₪60k supplier payment from week 10 to week 12, agreed, by phone, not by letter.

  3. 03

    We open a two-week overdraft with the bank, a month before it's needed.