TEMPLATE
Free Cash Flow Forecasting Template
Download your copy of our cash flow forecasting and projection template for small businesses.
Download your copy
By sharing your email with us, you’ll receive exclusive insights and updates directly to your inbox.
How to Prepare a Cash Flow Projection
For your convenience, Mondo Advisory has prepared a template to help you create a cash flow projection for your business for the next 12 months. To use this template effectively, follow these steps:
- You start with an opening bank balance – the current amount of cash on hand.
- Then add all the cash inflows from different sources.
- Next, deduct the cash outflows for each period. We have prepared multiple aspects of business expenses to be aware of.
- The number at the end of each period is referred to as the closing cash balance. This will be the opening cash balance for the next period.
Once your cash flow forecast is complete and the period passes, go back and compare the estimated amounts against the actual cash flows for the period.
This is essential as any differences between estimated and actual can highlight discrepancies and create more accurate projections for the following months.
