Free Cash Flow Statement Templates

The template shows ending balances for specific accounts, as well as total amounts for the activity period and the overall difference. This is a simple worksheet that you can customize to reflect your business type and the products or services it offers. Use this statement of cash flows template to track and assess cash flows over a three-year period.

• In other words, it helps your company make the most out of its cash position, whether it’s in a cash shortage or surplus.
• The template would help you make quick and easy cash flow projections, gauge your progress toward positive net cash flows, and confirm that you have the cash to meet your upcoming obligations.
• You can make cash flow projections for a month, a quarter, a year, or longer.
• With a 3-year cash flow projection template, a financial forecast can be made that estimates the anticipated inflows and outflows of cash for a business over a three-year period.
• A projected 3-year cash flow is a financial statement that outlines the anticipated cash inflows and outflows for a business over a specific three-year timeframe.
• You want to do this because the tax money collected isn’t yours – it’s the government’s money and you’ll eventually end up paying it to them.

The absence of these projections in critical decision-making is a key reason why many mid-sized companies struggle to sustain steady growth. You plug your current cash balance, fixed monthly payments, expected cash receipts, and budgeted expenses into a cash flow projection template for the next three months. Ideally, you should create a cash flow statement that is similar to a cheque register. Once you have an idea of these numbers, you’d use the data in your sales and P&L forecasts to create a cash flow projection. If carrying this position increases your cash flow month-over-month, you should probably move forward with the hire.

How to Create Your Cash Flow Projection

Based on the projection, the company can decide to choose not to buy expensive equipment and opt for leasing instead. On the flip side, you might be doing well, and you’re considering expanding into new markets, investing in new products, taking on bigger premises, or recruiting new staff. Having accurate cash flow projections will help you see if you can afford to take the plunge. Just input or upload your entries for each account, and let the software do the heavy lifting. Before making projections, thoroughly review the cash that’s flowing out of your business.

Alternatively, you might want to consider rescheduling some of your payments, particularly if the shortfall is caused by seasonal fluctuations in your business. Managing cash flow can be a bit tricky in the early stages of starting a business, as you can’t really predict – with accuracy – how many customers simple cash flow projection you’re going to have or sales you’re going to make. As the year progresses, you could use the variances between your actual and project results to improve the accuracy of each cash flow forecast. Use Bench’s simple, intuitive platform to get all the information you need to project your cash flow.

Additional resources

Use this basic template to gain monthly insight into your company’s cash flow and ensure you have sufficient funds to continue operating. Fill in your information for beginning balance (cash on hand), cash receipts and disbursements (R&D), operating expenses, and additional expenses. The template will auto-tally the monthly net cash change and month ending cash position columns. Use this information to forecast how long your cash will last, and whether you need to obtain additional financing. Use this template to create a cash flow forecast that allows you to compare projections with actual outcomes. This template is designed for easy planning, with a simple spreadsheet layout and alternating colors to highlight rows.