Finance template
Cash flow forecast
Project cash coming in and going out for the next 12 months and watch the closing balance. Months that dip below your safety cushion are flagged in red.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Forecast
93 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 271 filled cells in all.
Built in
- Charts
- Conditional formatting
- Named ranges
- Frozen headers
- 1 chart
- 1 conditional format rule
A look at the Forecast sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Cash flow forecast | |||||||
| 2 | Twelve months from the start month. Enter expected receipts and payments in the yellow cells. | |||||||
| 3 | ||||||||
| 4 | Starting cash | $84,000 | LOWEST BALANCE | LOWEST MONTH | ENDING CASH | |||
| 5 | First month | Jan 2027 | $73,390 | Feb 2027 | $112,904 | |||
| 6 | Safety cushion | $25,000 | ||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | Cash flow | Jan 27 | Feb 27 | Mar 27 | Apr 27 | May 27 | Jun 27 | Jul 27 |
| 10 | Opening balance | 84,000 | 77,886 | 73,390 | 73,684 | 117,226 | 120,194 | 118,492 |
| 11 | Cash in | |||||||
| 12 | Customer receipts | 50,800 | 54,000 | 61,600 | 64,200 | 67,600 | 71,000 | 63,100 |
- cash flow
- forecast
- 12 months
- runway
More finance templates
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
FinanceInvoice trackerTrack every invoice you send, what has been paid and what is overdue today. An aging summary groups open balances by how late they are.
FinanceBreak-even analysisFind how many units you need to sell to cover fixed costs, and what it takes to hit a profit goal. A chart shows revenue crossing total cost.
FinanceCap tableModel ownership through seed and Series A rounds with share prices worked out from each pre-money valuation. See fully diluted ownership and a simple payout at an exit value.
Start your cash flow forecast now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.