Built for you: 13-week cashflow forecast template

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

1. 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.

2. 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.

3. 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.