Free cash flow forecast calculator. Project monthly inflows, outflows, and balances for 12 months. Identify negative cash months before they happen.
The Cash Flow Forecast Calculator projects your business cash position month by month for up to 12 months. Enter your opening balance, expected monthly inflows, and monthly outflows to see when cash gets tight — or when you'll have surplus to invest.
Cash flow is the lifeblood of any business. Profitable companies go bankrupt due to cash flow problems, and this tool helps you see potential crunches months in advance. Negative balance months are flagged immediately so you can arrange financing or adjust spending.
The forecast supports growth and seasonality adjustments, letting you model realistic scenarios with increasing revenue or varying expense patterns. By modeling multiple scenarios, you can see how changes in payment timing, seasonal revenue dips, or unexpected expenses affect your cash position weeks or months into the future. This proactive approach replaces last-minute scrambling with deliberate planning, giving you time to arrange credit lines or adjust spending before shortfalls materialize.
This calculator gives you forward visibility into your cash position so you can pressure-test hiring, purchasing, and borrowing decisions before a shortfall appears. It is most useful when you update it regularly with actual inflows, outflows, and one-time payments instead of treating one forecast as fixed truth.
Ending Balance[n] = Opening Balance[n] + Inflows[n] − Outflows[n] Opening Balance[n+1] = Ending Balance[n] Net Cash Flow = Inflows − Outflows Cumulative Net = Σ Net Cash Flow
Result: Month 12 ending balance: $81,319
Starting with $50,000, receiving $30,000/month (growing 2%/month) and spending $28,000/month, cash grows steadily. No negative months occur. The 2% growth compounds inflows from $30,000 to $33,471 by month 12.
Cash enters through customer payments, loans, and investments. It exits through payroll, rent, suppliers, taxes, and debt service. The timing mismatch between inflows and outflows creates the cash flow cycle. Managing that timing is often more important than looking at profit alone.
Start with a conservative base case, then model optimistic and pessimistic scenarios. Update monthly with actual figures. Separate recurring from one-time items. Track forecast accuracy over time to improve your assumptions.
If the forecast shows a negative cash period, compare the timing of receipts, payables, and discretionary spending before assuming debt is the only answer. A line of credit, slower hiring, supplier negotiation, or staged purchases can all change the outcome depending on the business.
Last updated:
This page projects the ending cash balance for each month by starting with the opening cash balance, adding expected inflows, subtracting expected outflows, and then carrying the ending balance forward as the next month's starting point. When a monthly inflow growth rate is entered, the forecast applies that growth assumption to future inflows while leaving the outflow assumptions unchanged unless the user edits them directly.
The forecast is a planning worksheet, not an accounting statement. It does not automatically model receivables timing, inventory swings, financing draws, taxes, or accrual accounting adjustments unless the user builds those items into the monthly cash assumptions.
Cash flow forecasting projects future cash inflows and outflows to estimate your cash balance over time. It helps businesses anticipate cash shortages, plan investments, and make informed operational decisions weeks or months in advance.
Profit is an accounting concept (revenue minus expenses). Cash flow is actual money moving in and out. You can be profitable on paper but cash-poor if customers pay slowly, or cash-rich but unprofitable due to depreciation. Cash flow forecasting tracks real money movement.
Most businesses benefit from a rolling 12-month forecast, updated monthly. Short-term (1-3 months) forecasts are most accurate. Longer forecasts are useful for strategic planning but should be revisited frequently as conditions change.
Common causes include: seasonal revenue dips, large quarterly payments (taxes, insurance), customer payment delays, inventory buildup, equipment purchases, and payroll for new hires before revenue catches up. Identifying these in advance is the whole point of forecasting.
Yes. Large one-time expenses (equipment, deposits, annual payments) should be included in the specific month they occur. This is where many forecasts fail — they model only steady-state flows and miss lumpy payments.
Use your own recent collections trend as the starting point, then test a base case and a weaker case. Early-stage businesses should be careful with aggressive growth assumptions unless the expense side and collection timing are modeled just as explicitly.