The 12-Month Cash Flow Forecast: A Worked Example
Consider a realistic Dubai SME: a B2B marketing-services company in a JLT-style free zone, founded January 2026. AED 50,000 average monthly invoiced revenue, two visa-holding employees plus the founder, AED 8,000/month rent on a serviced desk, salaries of AED 25,000/month combined (founder draws separately), and a tax-registered LLC with quarterly VAT filings.
Here is what an honest 12-month rolling cash flow forecast looks like — net cash position at the end of each month, starting with AED 75,000 in the bank.
| Month |
Cash collected (AED) |
Cash paid out (AED) |
Net month (AED) |
Closing cash (AED) |
| Jan |
0 (no clients collected yet) |
38,000 |
-38,000 |
37,000 |
| Feb |
25,000 |
38,000 |
-13,000 |
24,000 |
| Mar |
50,000 |
38,000 |
+12,000 |
36,000 |
| Apr |
50,000 |
45,500 (incl. Q1 VAT) |
+4,500 |
40,500 |
| May |
50,000 |
38,000 |
+12,000 |
52,500 |
| Jun |
50,000 |
38,000 |
+12,000 |
64,500 |
| Jul |
50,000 |
45,500 (incl. Q2 VAT) |
+4,500 |
69,000 |
| Aug |
35,000 (summer lull) |
38,000 |
-3,000 |
66,000 |
| Sep |
50,000 |
38,000 |
+12,000 |
78,000 |
| Oct |
50,000 |
45,500 (incl. Q3 VAT) |
+4,500 |
82,500 |
| Nov |
50,000 |
38,000 |
+12,000 |
94,500 |
| Dec |
50,000 |
85,500 (licence renewal + Q4 VAT) |
-35,500 |
59,000 |
That December cliff — minus AED 35,500 in a single month — is the founder-killer. It is not low revenue. December collected the same AED 50,000 as ten other months. It is the combined hit of the AED 40,000 trade licence renewal lump sum, the Q4 VAT outflow, and the routine monthly costs all landing at once. Without a forecast that pointed at December eleven months in advance, the founder would have spent excess cash through the year and arrived at December with AED 20,000 in the bank against AED 85,000 of obligations.
Now layer in two realities the table glosses over: a 60-day payment delay on half the customer base (cash collected drops to AED 25,000–40,000 for the first three months until receivables mature), and an EOSB accrual of around AED 900–1,000/month sitting silently on the balance sheet against the day either employee leaves. Suddenly the AED 75,000 opening cash position is the difference between trading through December and shutting the doors in October.