Business Cash Flow Forecasting Calculator
A cash flow forecast projects your cash balance by adding expected inflows and subtracting expected outflows each month. Enter starting cash, average monthly inflow and outflow, and the horizon to see the ending balance.
Cash Flow Forecast
Forecasting & Planning
Fill all inputs
Your result appears here automatically as you type.
How the Cash Flow Forecast Works
Profit and cash are not the same thing. A business can be profitable on paper and still run out of cash if customers pay late or inventory ties up money. This calculator multiplies net monthly flow by the forecast period and adds it to starting cash, producing a month-by-month path. A positive trend means you can fund operations; a negative one warns of a shortfall before it happens. For accuracy, layer in irregular items: quarterly tax payments, annual insurance, loan repayments, and seasonal revenue dips. A common mistake is using an average that hides the worst month. Build the forecast conservatively, then stress-test it with slower collections and higher costs. The ending balance is only as good as the assumptions behind it, so update the forecast monthly with actuals and adjust the plan before cash gets tight. Watch the lowest projected balance rather than the year-end total, because a single tight month can force expensive borrowing or missed payments.
Formula Used
Ending Cash = Starting Cash + (Monthly Inflow - Monthly Outflow) x Months
Starting cash $10,000, monthly inflow $3,000, monthly outflow $2,500, 12-month horizon. Net flow is $500 per month, so ending cash = $10,000 + $6,000 = $16,000.
When to Use This Calculator
- Planning whether you can cover payroll next quarter.
- Timing large purchases around strong cash months.
- Stress-testing slower collections or higher costs.
Common Mistakes
- Confusing profit with cash: Revenue is not cash until it is collected, and expenses often leave before payment arrives.
- Using averages that hide bad months: Seasonal dips and quarterly tax bills must appear in the month they hit.
- Forgetting owner draws and loan payments: These are real cash outflows and can turn a positive forecast negative.
Frequently Asked Questions
What is the difference between profitability and positive cash flow?
Profit is revenue minus expenses over a period, regardless of when cash moves. Cash flow tracks money actually entering and leaving. A profitable business can still run short if customers pay slowly or inventory builds up. Both matter, but cash keeps the doors open.
How do you build an accurate 12-month cash flow forecast?
Start with the opening balance and list expected receipts by month based on payment terms. List all outflows, including irregular ones, in the month they occur. Sum net flow month by month and watch the lowest point, not just the year-end total.
How can businesses manage cash runway during revenue dips?
Delay discretionary spending, negotiate longer supplier terms, invoice faster, and follow up on overdue accounts. Build a cash buffer during strong months and arrange a credit line before you need it, since lenders move slowly in a crisis.
What is the formula for net operating cash flow?
Net operating cash flow is cash collected from customers minus cash paid for operations, including suppliers, payroll, and taxes. It differs from profit because it tracks timing, not accrual. Positive operating cash flow funds growth without borrowing.
What causes cash flow shortfalls in growing companies?
Growth consumes cash: inventory, receivables, and new hires are paid before customers pay. Profitable businesses can still run short. Watch the lowest projected balance and tighten collection terms before a gap appears.
How This Page Is Reviewed
Written by the Recapflow Editorial Team and last reviewed . Every formula and worked example is cross-checked against the live calculator engine and a hand-worked example. This page is educational and does not replace professional financial, tax, or legal advice.