Cash Flow Forecast Calculator — Free 12-Month Projection with AI Insights
Used by small business owners to project their cash position 6-24 months ahead and catch shortfalls before they become emergencies.
Your cash flow inputs
Enter your current balance and average monthly figures — one-off transactions are optional.
What is a Cash Flow Forecast Calculator?
A cash flow forecast calculator projects your business's future cash balance month by month, based on your starting cash, expected income, and expected expenses. It works by carrying a running balance forward: each month's balance equals the previous month's balance plus that month's net cash flow (and any one-off amounts). The result is a simple table or chart that shows whether your balance is expected to grow, shrink, or dip below zero at any point — and exactly which month that happens in, if it does.
Here's a simplified example showing how the running balance builds month over month for a business starting with $50,000, earning $20,000 a month, and spending $18,000 a month (a net cash flow of +$2,000 per month):
| Month | Starting balance | Net cash flow | Ending balance |
|---|---|---|---|
| 1 | $50,000.00 | +$2,000.00 | $52,000.00 |
| 2 | $52,000.00 | +$2,000.00 | $54,000.00 |
| 3 | $54,000.00 | +$2,000.00 | $56,000.00 |
| 4 | $56,000.00 | +$2,000.00 | $58,000.00 |
That's the entire model: a starting number, a repeated monthly addition or subtraction, and a running total. The calculator above does this automatically for 6, 12, or 24 months, layers in any one-off transactions you specify, and surfaces the key numbers — ending balance, lowest point, and runway — without you needing a spreadsheet.
How the Cash Flow Forecast Calculator Works — The Formula
The calculator runs a simple recurrence relation for each month of your forecast period. The formula is:
Balance(month n) = Balance(month n−1) + Revenue − Expenses + One-off transactions in month n
Balance(month 0) = Starting balance
Each variable in this formula maps directly to the inputs above:
- Balance(month n)
- The projected cash balance at the end of month n — this is the number plotted on the chart and used for the ending balance, lowest balance, and runway calculations.
- Balance(month 0)
- Your starting cash balance — the amount currently in your bank account(s) when the forecast begins.
- Revenue
- Your average monthly revenue or income, assumed constant across every month of the forecast.
- Expenses
- Your average monthly expenses, also assumed constant across the forecast period.
- One-off transactions in month n
- Any irregular amounts you've specified for that specific month — positive for extra income (like a tax refund) or negative for extra expenses (like a new laptop or annual insurance premium).
Worked example
Suppose you start with a $50,000 balance, expect $20,000 in monthly revenue and $18,000 in monthly expenses (a net of +$2,000/month), and you're forecasting 6 months. In month 3, you also have a one-off equipment purchase of −$6,000. The running balance would be:
- Month 0 (start): $50,000.00
- Month 1: $50,000 + $2,000 = $52,000.00
- Month 2: $52,000 + $2,000 = $54,000.00
- Month 3: $54,000 + $2,000 − $6,000 (one-off) = $50,000.00
- Month 4: $50,000 + $2,000 = $52,000.00
- Month 5: $52,000 + $2,000 = $54,000.00
- Month 6: $54,000 + $2,000 = $56,000.00
The ending balance after 6 months is $56,000, the lowest point is $50,000 (months 0 and 3, tied), and because cash flow is positive throughout, the runway is "healthy."
A common mistake is forgetting irregular or seasonal expenses — annual insurance renewals, quarterly tax payments, equipment replacements, or holiday-season inventory buildups — and assuming revenue arrives exactly on schedule and in full. If your customers typically pay 30-60 days late, your "average monthly revenue" figure should reflect cash actually received, not invoices issued, or your forecast will look healthier than your bank balance actually is.
How to Use the Cash Flow Forecast Calculator
- Enter your Starting cash balance — the amount currently in your business bank account(s).
- Enter your Average monthly revenue/income and Average monthly expenses based on recent bank statements or invoices.
- Choose a Forecast period of 6, 12, or 24 months.
- (Optional) Open One-off transactions and add up to 3 irregular amounts — like a planned equipment purchase or tax payment — with the month they'll occur, the amount, and a short label.
- Click Calculate to see your results instantly.
- Scroll to the AI Insights section to understand what your result means.
How to Interpret Your Cash Flow Forecast Results
What a Good Result Looks Like
A healthy forecast shows a positive net monthly cash flow (revenue consistently exceeds expenses), a runway that extends well beyond your forecast period (or shows as "healthy — growing"), and a comfortable buffer between your lowest projected balance and zero. If your ending balance is meaningfully higher than your starting balance and the lowest point in the forecast never gets close to $0, your plan has room to absorb a bad month without a crisis.
Warning Signs in Your Results
Watch for any month where the projected balance goes negative — this means that, on your current assumptions, you'd run out of cash before that month ends. Also be cautious if your runway is shorter than your forecast period (you're on track to hit zero before the forecast even finishes), or if your lowest balance is only slightly above zero — a single missed payment, late invoice, or surprise bill could be enough to tip you into a shortfall even if the headline numbers look "okay."
How to Improve Your Result
- Build a cash reserve. If your starting balance covers less than 3 months of expenses, prioritize setting aside a portion of each month's net cash flow until you reach that buffer.
- Stagger large expenses. If a one-off transaction causes a sharp dip, see whether it can be split into installments or moved to a month with a higher starting balance.
- Follow up on receivables faster. If your "average monthly revenue" assumes invoices are paid on time but customers often pay late, tightening payment terms or sending earlier reminders can pull cash forward and lift every month's balance.
- Trim discretionary costs. Even a 10% cut to non-essential monthly expenses compounds over a 12 or 24-month forecast — use the "Expenses −10%" scenario in the comparison table to see the effect on your ending balance and runway.
Cash Flow Forecast Calculator Examples
12-Month Cash Flow Forecast for a Small Business
A consulting business wants to plan a full year ahead.
- Starting cash balance: $50,000
- Average monthly revenue: $20,000
- Average monthly expenses: $18,000
- Forecast period: 12 months
Result: ending balance of $74,000, with a net monthly cash flow of +$2,000 and a "healthy — growing" runway.
What this means: the business is on track to grow its cash cushion by $24,000 over the year, assuming revenue and expenses stay roughly constant.
What to do next: use the extra cushion to build a 3-6 month expense reserve, or evaluate a planned investment with the ROI Calculator to see if it's a good use of the surplus.
Cash Flow Projection with a One-Time Equipment Purchase
The same business plans to buy $15,000 of new equipment in month 4.
- Starting cash balance: $50,000
- Average monthly revenue: $20,000
- Average monthly expenses: $18,000
- One-off transaction: month 4, −$15,000, "New equipment"
- Forecast period: 12 months
Result: ending balance of $59,000, with the lowest projected balance of $43,000 occurring in month 4.
What this means: the purchase causes a one-month dip but the balance never goes negative, so the equipment is affordable within this plan.
What to do next: if the dip feels too tight, consider financing the equipment over several months instead of paying the full amount at once, and re-run the forecast with smaller monthly payments.
How Long Will My Cash Last? (Runway Calculation)
A startup is pre-revenue and burning cash every month.
- Starting cash balance: $50,000
- Average monthly revenue: $5,000
- Average monthly expenses: $18,000
- Forecast period: 12 months
Result: balance turns negative in month 4, with a runway of approximately 3-4 months.
What this means: at the current burn rate of −$13,000/month, the business has roughly 3-4 months before it runs out of cash entirely.
What to do next: use the "Expenses −10%" scenario to see how much extending runway by trimming costs helps, and start fundraising or revenue-generating activities well before month 3.
This calculator provides estimates only, based entirely on the assumptions you enter. It is not financial, accounting, or tax advice. Your actual cash flow will depend on factors this model cannot account for — the exact timing of customer payments, unexpected costs, seasonal fluctuations, financing changes, and more. This tool is not a substitute for proper bookkeeping, accounting software, or professional financial planning. For decisions that affect your business's finances, consult a qualified accountant or financial advisor.
Frequently Asked Questions about the Cash Flow Forecast Calculator
What is a cash flow forecast and why does my small business need one?
A cash flow forecast is a month-by-month projection of the cash moving in and out of your business, showing your expected balance over time. Small businesses need one because profit on paper doesn't guarantee cash in the bank — a forecast helps you spot a potential shortfall (for example, three months before rent is due) so you can act early instead of being surprised.
What is the difference between cash flow and profit?
Profit is revenue minus expenses on an accounting basis, regardless of when cash actually changes hands. Cash flow tracks the real timing of money in and out of your bank account. A business can be profitable on paper but run out of cash if customers pay late or large expenses fall due before income arrives — which is exactly the scenario this calculator helps you spot.
How do I account for irregular or one-off expenses in this forecast?
Use the optional one-off transactions rows. Enter the month number (1 to your forecast period), the amount (negative for an expense like a $5,000 equipment purchase, positive for a one-time payment received), and a short label. The calculator adds that amount to the running balance only in the month you specify, so a single large expense in month 5 will show up as a dip in your projected balance for that month onward.
What does "runway" mean in a cash flow forecast?
Runway is the number of months your business can keep operating before its cash balance hits zero, assuming current revenue and expense trends continue. If your net monthly cash flow is positive and your balance never goes negative, your runway is effectively unlimited ("healthy"). If cash flow is negative, runway tells you roughly how many months you have left to fix the trend, raise funding, or cut costs.
How often should I update my cash flow forecast?
Most small businesses benefit from updating their forecast monthly, right after closing the books for the previous month. Replace projected figures with actual revenue and expenses, then re-forecast the months ahead. If your business has volatile revenue (e.g., seasonal sales or large irregular contracts), updating every two weeks gives you more time to react to changes.
How accurate is this cash flow forecast calculator?
This calculator is only as accurate as the assumptions you enter. It assumes your monthly revenue and expenses stay constant (aside from any one-off transactions you add), which simplifies real-world variability like seasonal sales, late-paying customers, or unexpected costs. Treat the output as a planning estimate, not a guarantee — for a 12-month forecast, expect actual results to drift from the projection as the months progress.
What should I do if my forecast shows a cash shortfall?
First, identify the month the shortfall starts and how large it is — this calculator highlights both. Then look for ways to close the gap: delay non-essential spending, negotiate longer payment terms with suppliers, follow up on overdue invoices, arrange a line of credit before you need it, or temporarily reduce owner draws. Acting 2-3 months before the projected shortfall gives you far more options than waiting until the balance is already negative.
Does this calculator replace accounting software or a bookkeeper?
No. This tool is a quick planning aid for projecting future cash positions based on simple assumptions — it does not track actual transactions, reconcile bank accounts, calculate taxes, or generate financial statements. Accounting software (like QuickBooks or Xero) and a bookkeeper or accountant remain essential for accurate records, tax compliance, and detailed financial reporting.