Loading…

Free once a day · Unlimited for Premium members

13-Week Cash Flow Forecast

The 13-Week Cash Flow Forecast shows a UAE business’s bank balance week by week for the next quarter. You enter opening cash, weekly sales, running costs and any one-off payments, and it finds the tightest week and the first week the balance goes below zero, if there is one. Owners use it before big cheques fall due, and buyers use it to size the cash cushion they need after completion.

Profit and cash are different things

A business can be profitable and still bounce a cheque. Rent is paid in a block, card sales arrive days later, and a supplier wants cash on delivery. A week-by-week view shows the pinch before it happens, when there is still time to move a payment or ask for credit.

Your weekly numbers

Starting point and sales
Only matters if customers pay later than the same week.
Costs
One-offs
Optional. A minus is money out.

Free members can run this once a day. Premium members have unlimited use.

A café in Business Bay with a rent cheque coming

The café starts with AED 95,000 in the bank, sells about AED 21,000 a week and expects sales to grow by 1% a week. Ingredients and packaging cost 34% of sales. Rent and payroll come to AED 38,000 a month, there are AED 3,200 of other weekly costs and card settlements take about a week to land. An equipment service costs AED 4,500 in week six and a catering deposit of AED 6,000 comes in during week nine.

What the tool gives back for these figures

The balance stays positive for all 13 weeks. The tightest point is AED 46,660 in week 1, and the quarter ends at AED 70,634.

Opening cash
AED 95,000
Lowest balance
AED 46,660
Closing cash, week 13
AED 70,634
Cash in, 13 weeks
AED 272,333
Cash out, 13 weeks
AED 296,699

What goes into each box

  1. Opening cash is what is in the bank today, less any cheques you have already issued that have not cleared.
  2. Weekly sales are a typical week. The growth figure raises or lowers it every week after the first.
  3. Variable costs are those that move with sales, like ingredients or stock, as a percentage of sales. Weekly fixed costs are things like utilities and delivery staff. Monthly fixed costs, such as rent and payroll, are charged in weeks 1, 5, 9 and 13.
  4. One-off payments are listed as week number, description, amount. Use a minus for money going out and a plus for money coming in.

Questions people usually ask

Why 13 weeks?

It is one quarter. Long enough to cover a rent cycle and a VAT payment, short enough that your guesses are still reasonable.

How do I handle quarterly payments like VAT?

Add them as one-off payments in the week they leave your account. The VAT Worksheet Generator can give you the figure and the due date.

What if customers pay slowly?

Use the collection delay setting. If you invoice other businesses and they take 30 days, choose four weeks and add what customers already owe you as opening receivables.

How much cash should I keep as a buffer?

Many owners aim for at least one month of fixed costs. The tool shows your lowest balance so you can compare it with that.

Can a buyer use this?

Yes. Put the cash you expect to hold on day one in the opening box, and the forecast shows whether the business can feed itself in its first quarter under your ownership.

Results rely only on what you enter. Check the figures against the seller's accounts, the lease and the trade licence, and take professional advice before you commit money. This is not a formal valuation, legal or tax advice.

Layla AISell your business free AI valuation✕
Top