Cash Flow Forecast Calculator
Closing balance over the next months.
Enter your values
ⓘ Live results
Results
- Closing balance
- $63,680.34
- Lowest balance
- $51,405.00
- Net change
- $3,680.34
- Cash negative?
- No
| Month | In | Out | Balance |
|---|---|---|---|
| Month 1 | $42,000.00 | $47,000.00 | $55,000.00 |
| Month 2 | $44,100.00 | $47,000.00 | $52,100.00 |
| Month 3 | $46,305.00 | $47,000.00 | $51,405.00 |
| Month 4 | $48,620.25 | $47,000.00 | $53,025.25 |
| Month 5 | $51,051.26 | $47,000.00 | $57,076.51 |
| Month 6 | $53,603.83 | $47,000.00 | $63,680.34 |
Quick answer
Cash flow forecasting projects the closing balance each month from expected inflows and outflows.
Closing = opening + inflow − outflow
How to use the Cash Flow Forecast Calculator
- 1Enter your opening cash balance.
- 2Enter typical monthly inflow and outflow.
- 3Set the projection window and growth.
Worked example
Using the values the calculator loads with:
Inputs
- Opening cash60000 $
- Monthly inflow42000 $
- Monthly outflow47000 $
- Months to project6
- Inflow growth5 %
Results
- Closing balance$63,680.34
- Lowest balance$51,405.00
- Net change$3,680.34
- Cash negative?No
Frequently asked questions
Why watch the lowest point?
You need financing before the trough, not at the end of the year.
Should VAT be included?
Yes — treat it as an outflow in the month you pay it.
About this calculator
- Built and reviewed by James Whitfield · How we build and test calculators
- Report an error
Results are estimates for general information. For medical, legal, structural or financial decisions, confirm with a qualified professional.