Finance Calculator
Cash Flow Forecast Calculator
Project your monthly cash inflows, outflows, and closing cash position over 6 months. Identify when funding gaps are likely to occur so you can plan ahead.
Enter forecast details for each month
How does this cash flow forecast work?
This calculator uses a simple rolling balance approach. For each month, it takes the opening cash balance, adds expected inflows, and subtracts expected outflows to calculate the closing cash position.
Net Cash Flow = Inflows - Outflows
Closing Balance = Opening Balance + Net Cash Flow
Next Month's Opening = Previous Month's Closing
If the closing balance falls below zero in any month, this indicates a potential funding gap — meaning the business may need additional cash (e.g. from an overdraft, invoice finance, or loan) to cover its obligations that month.
Assumptions and caveats
- •Inflows and outflows are entered as monthly totals. Real cash flow may vary within the month.
- •This is a simplified model. It does not account for timing of individual receipts and payments.
- •One-off items such as capital expenditure, tax payments, or loan drawdowns should be included in the appropriate month.
- •The forecast does not factor in interest on cash balances or overdraft costs.
Frequently asked questions
A cash flow forecast is a projection of expected cash inflows and outflows over a future period, typically month by month. It helps businesses anticipate when cash will be short, plan for major payments, and decide when additional funding may be needed.
Cash flow is the most common reason small businesses fail. A forecast helps identify gaps before they become crises, supports better supplier and debtor management, and provides lenders with evidence of financial planning when applying for funding.
A cash flow forecast is an estimate, not a guarantee. The goal is to identify trends, timing risks, and funding gaps rather than predict exact figures. Regular updating improves accuracy over time.
Anticipating a funding gap?
Speak to the Spark team about funding options to bridge short-term cash flow gaps before they become problems.
Contact the Spark Team