Disha

Fix money · ~10 min

Cash flow simulator

“What does my cash position look like six months from now?”

A month-by-month table of revenue, costs and profit that keeps a running cumulative cash total as you fill it in.

MonthM1M2M3M4M5M6
Revenue
COGS
Opex
Net profit+0+0+0+0+0+0
Cumulative cash3,00,0003,00,0003,00,0003,00,0003,00,0003,00,000

six-month outlook

Cash stays positive through all six months, ending at ₹3,00,000. Keep tracking actuals against this plan monthly — the value is in catching drift early, not in the forecast being perfectly right.

the guide

Cash flow forecast: see your cash position months ahead

By Shivam Bhandari · Reviewed 31 October 2026 · How we write

A cash flow forecast estimates the money coming in and going out of your business month by month, and keeps a running total of cash in the bank. It shows problems — such as a month where cash goes negative — before they happen.

Profit and cash are not the same. Sales on credit, stock purchases, loan repayments and tax payments can make a profitable business short of cash. A six-month forecast gives you time to act.

the formula

Closing cash = Opening cash + Cash in − Cash out

  • · Cash in: customer payments actually received, loans, investment.
  • · Cash out: suppliers, salaries, rent, EMIs, taxes and other payments actually made.
  • · Each month's closing cash becomes the next month's opening cash.

Worked example: three months

  • Month 1: opening ₹2,00,000 + ₹5,00,000 in − ₹5,50,000 out = ₹1,50,000 closing.
  • Month 2: ₹1,50,000 + ₹4,00,000 − ₹5,00,000 = ₹50,000.
  • Month 3: ₹50,000 + ₹6,00,000 − ₹5,20,000 = ₹1,30,000.
  • Month 2 is the danger point — the owner can arrange credit or chase receivables in advance.

Tips

  1. 1Forecast cash when you expect to be paid, not when you invoice.
  2. 2Include irregular payments such as annual insurance, GST and bonuses.
  3. 3Compare forecast with actual every month and improve your assumptions.
  4. 4Keep a minimum cash buffer, such as one or two months of fixed costs.

Frequently asked questions

What is a cash flow forecast?

A month-by-month estimate of cash coming in and going out, used to predict future cash balances.

Why is cash flow different from profit?

Profit counts sales when made and costs when incurred; cash flow counts money when it actually moves. Credit sales, stock and loan repayments create the difference.

How far ahead should I forecast cash flow?

Most small businesses benefit from a rolling 3–6 month forecast, updated monthly.

What causes cash flow problems?

Late customer payments, excess stock, rapid growth, seasonal sales, large one-off payments and thin margins.