Built for you: 13-week cashflow forecast template
Need to forcast your cash flow for the next 13 weeks? Plus users can download this usable template, and fill it in with their own business information to better plan ahead.
The cashflow template is built off a set of assumptions for your business. All numbers and cells in blue are inputs to the spreadsheet. Everything else is an output – try to not to edit those at the risk of breaking the model.
How to use the sheet
Start by entering the expenses via the “Assumptions Sheet”. It’s important to remember that this is on a weekly basis, so you’ll need to think about when your expenses fall within each week.
Forecast your revenue in the ‘revenue section’ of the Assumptions Sheet. This template is built for a product-based business. If you’re in services, think about what drivers of your revenue. It may be hours in a week, or perhaps it’s easier because you have a retainer based model.
Once you have completed all the assumptions in Step 1 and 2 above, turn your attention to the “Cash Flow Statement” tab of the model and enter your current bank account balance in Cell C8. This will ensure you’re reflecting the current cash at bank and the forecasted position.
