On this page
- 12-month editable forecast
- Automatic net cash flow and ending balance
- Rows saved locally in your browser
- No cash-flow values uploaded
Cash Flow Forecast
Model monthly revenue and expenses in the browser and see how your cash balance changes over the next year.
Excel
Download Excel
Extend the forecast to 24 months in Excel
The spreadsheet gives you a 24-month offline forecast with editable monthly revenue and expenses and automatic ending balances.
In the Excel version
- 24-month planning horizon
- Monthly revenue and expense inputs
- Automatic net cash flow and ending balance
- Offline file for long-term planning
- Currency selector (USD, EUR, RUB, GBP) without exchange-rate conversion
What is a cash flow forecast?
A cash flow forecast estimates how money moves through a business over time. It focuses on when cash is received and spent, which can reveal a future cash shortage even when the business looks profitable on paper.
How to use it
- Enter the cash balance you have at the start.
- For each month, estimate incoming revenue.
- Enter expected cash expenses for the same month.
- Watch net cash flow and the rolling ending balance.
- Download Excel when you need a longer forecast or a file to keep.
Why use it
- Spot negative cash periods before they happen.
- Test lower revenue or higher expense scenarios.
- Keep browser data local and use Excel for longer planning.
How the calculation works
For each month, net cash flow equals revenue minus expenses. Ending balance equals the previous month’s ending balance plus the current month’s net cash flow.
FAQ
Is my data uploaded?
No. Calculator values stay in your browser. Analytics sends only the tool name, language and a fixed event type.
Does the Excel file contain macros?
No. The workbook uses normal cells, formulas and formatting only.
Can I use the Excel file offline?
Yes. Download it once and keep using it without this website.
Can I change the currency?
Yes. Select USD, EUR, RUB, or GBP on the page or in the Excel workbook. Changing the currency only changes the unit label, not the amounts or exchange rate.