- Projects
- Cash-flow plan with three scenarios
Cash-flow plan with three scenarios
Cash in based on real payment terms, recurring costs and tax deadlines. The year's low point is flagged automatically in each scenario.
- Excel
- Scenarios
- Automatic low point
The context
A fictional 6-person B2B services company whose customers pay at 60 days. The bank balance looked comfortable until the summer.
The problem
With customers paying at 60 days, June sales only arrive in August, a month when costs stay the same. Without a plan, that dip stayed invisible.
What I built
- A 12-month plan, with each customer's receipts timed to their real payment terms.
- Recurring outgoings: salaries, rent, subscriptions, loan repayments.
- Tax and social security deadlines placed in the right month.
- Three scenarios (cautious, central, optimistic) driven by three assumptions.
- Each scenario's low point found and flagged automatically.
How it works
- We import open invoices and recurring costs.
- We set three assumptions per scenario: growth, payment terms, hires.
- The chart and the low point update instantly.
File extract
| Month | Cash in | Cash out | Net for the month | Closing cash |
|---|---|---|---|---|
| June 2027 | €41,800 | €39,800 | +€2,000 | €9,000 |
| July 2027 | €43,900 | €42,900 | +€1,000 | €10,000 |
| August 2027 | €28,900 | €33,900 | -€5,000 | €5,000 |
| September 2027 | €44,100 | €41,100 | +€3,000 | €8,000 |
Orange row: low point of the cautious scenario.
Got a project in mind?
Describe what you need in a few lines. I reply within 24 hours with a call proposal.