KodjoFinance & Data
  1. Projects
  2. Cash-flow plan with three scenarios
Demo project · fictional data

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

  1. We import open invoices and recurring costs.
  2. We set three assumptions per scenario: growth, payment terms, hires.
  3. The chart and the low point update instantly.

File extract

Tresorerie_2027.xlsxExtract: cautious scenario, summer 2027
MonthCash inCash outNet for the monthClosing 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.