Free tool

Cash flow forecast

Twelve months of projected cash, month by month, including the month your balance goes negative. No spreadsheet, no signup, nothing stored.

Cash runs out
Not in 12 months
you stay cash positive
Balance in 12 months
€1,680
if nothing else changes
MonthInOutNetBalance
Aug28,00052,00024,000€156,000
Sep29,40052,00022,600€133,400
Oct30,87052,00021,130€112,270
Nov32,41452,00019,587€92,684
Dec34,03452,00017,966€74,718
Jan35,73652,00016,264€58,454
Feb37,52352,00014,477€43,976
Mar39,39952,00012,601€31,375
Apr41,36952,00010,631€20,744
May43,43752,0008,563€12,181
Jun45,60952,0006,391€5,790
Jul47,89052,0004,110€1,680

How a cash flow forecast works

A forecast is one formula applied twelve times. Each month closes with what it opened with, plus what came in, minus what went out:

closing balance = opening balance + cash in - cash out
next month's opening balance = this month's closing balance

That carry-forward is the point. A single month of negative cash flow is survivable; twelve of them compound into insolvency, and the forecast shows you which month that becomes real while you still have time to change it.

Growth compounds the same way. Five percent monthly revenue growth is not five percent better over a year — compounded across twelve months it is close to eighty percent more. The forecast applies it from the second month on, so the month-twelve figure it shows is a little under that. Set growth to zero if you want the pessimistic case, which is usually the more useful one to plan against. To go deeper, read when will you run out of cash or check your burn rate first.

When cash is genuinely tight, professionals switch from months to weeks: the 13-week cash flow forecast runs the same arithmetic at weekly grain, which is what catches a payroll date and a late invoice landing in the wrong order inside an otherwise fine month.

One distinction worth keeping straight: forecasting projects from aggregates, while tracking is the itemized ledger the aggregates come from. If you do not yet know your monthly in and out because nobody has listed the lines, start with the cash flow tracker — track first, forecast from what the ledger shows.

Excel template or cash flow calculator?

Every cash flow forecast template for Excel or Google Sheets is the same model: a row per month, columns for opening balance, cash in, cash out and closing balance, with the closing balance carried into the next row. A cash flow calculator like the one above runs identical arithmetic without the download — you get the projection in seconds, and there is no file to lose or formula to break when the numbers change next month.

Where a template still earns its keep is a genuinely unusual model: revenue that follows contracts rather than a growth rate, or one-off costs landing in specific months. And when the forecast becomes something you rely on weekly rather than rebuild quarterly, that is the point of dedicated tooling — the cash forecasting software comparison weighs eight options, spreadsheets included, by what they need from you to stay true.

Common questions

How do you forecast cash flow?

Start with the cash you have today. For each month ahead, add the money you expect in and subtract the money you expect out, then carry the closing balance into the next month. Repeat for 12 months. The month the balance goes below zero is the month you run out.

What is the cash flow forecast formula?

Closing balance = opening balance + cash in - cash out. The closing balance of one month becomes the opening balance of the next, which is what makes a forecast compound rather than repeat.

Do I need an Excel template for a cash flow forecast?

No. A spreadsheet template works, but it goes stale the moment your numbers change and formulas break quietly. This calculator does the same 12-month projection in the browser, and nothing is stored.

How far ahead should a startup forecast cash flow?

Twelve months is the standard planning horizon, because it covers a full hiring and fundraising cycle. Anything beyond that is a guess with too many assumptions stacked on top of each other.

Should I include one-time costs in a cash flow forecast?

Yes, but put them in the specific month they land rather than in your recurring monthly spend. A one-off legal bill or hardware purchase is real cash leaving, but treating it as recurring will understate your runway badly.

A forecast is only true the day you build it

Every hire, price change and late payment moves these numbers. Plainhub keeps the forecast live: you type what happened and the projection updates with it.