Free tool

Cash flow forecast

A cash flow forecast projects your cash balance month by month from expected money in and money out. It is calculated as the opening balance plus income minus spending for each month, carried into the next. This calculator projects twelve months and shows 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
Oct€28,000€52,000−€24,000€156,000
Nov€29,400€52,000−€22,600€133,400
Dec€30,870€52,000−€21,130€112,270
Jan€32,414€52,000−€19,587€92,684
Feb€34,034€52,000−€17,966€74,718
Mar€35,736€52,000−€16,264€58,454
Apr€37,523€52,000−€14,477€43,976
May€39,399€52,000−€12,601€31,375
Jun€41,369€52,000−€10,631€20,744
Jul€43,437€52,000−€8,563€12,181
Aug€45,609€52,000−€6,391€5,790
Sep€47,890€52,000−€4,110€1,680
See a 12-month cash projection that updates live.Build your modelTry the live demo

How a cash flow forecast works

A cash flow forecast starts from your current balance and applies one formula twelve times: each month closes with what it opened with, plus cash in, minus cash out, and that closing balance becomes the next month's opening balance. People underrate the carry-forward: one negative month is survivable, but twelve compound, and the forecast shows which month it becomes real.

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?

Use a calculator unless your model is unusual. Every Excel or Google Sheets template is the same model: a row per month with opening balance, cash in, cash out and closing balance carried forward. A calculator like the one above runs identical arithmetic without the download, so there is no file to lose and no formula to break when next month's numbers change.

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.

Keep the forecast tied to current inputs

Use this calculator to test a revenue growth assumption over twelve months. Plainhub provides the ongoing flat-rate view, recalculating runway from income and costs you record while holding current monthly rates constant. Use a draft plan to check another recurring cost before committing to it.