The Scenario
A Cape Town-based graphic design studio with three staff has been profitable on paper for two years but keeps running out of cash at month end. The owner needs a 12-month cash flow forecast she can actually use, not a generic template.
The Brief
Build the forecast. You do not need a spreadsheet file, a Markdown table is fine. You do need to think carefully about timing: when cash actually comes in and goes out, not when invoices are raised.
Deliverables
- A month-by-month cash flow table (opening balance, inflows, outflows, closing balance) for 12 months
- Your assumptions (client payment terms, seasonality, tax timings) listed explicitly
- The months with the tightest cash position and one concrete action the owner could take in each
- One scenario variation (for example: what if the biggest client pays 30 days late) and its impact
Submission Guidance
You can invent the numbers. They just need to be internally consistent and plausible for a 3-person design studio in South Africa.
Submit Your Work
Your submission is graded against the rubric on the right. If you pass, you get a public Badge URL you can share on LinkedIn. There is no draft save, so work offline first and paste your finished response here.