3 Essentials of Cash Flow Forecasting

One step that is often overlooked in managing the small business is forecasting Cash Flow. Even if budgets are created the critical step of translating the budget to a cash flow forecast is avoided. Why? Lack of time, lack of resources, and lack of knowledge regarding how are the most cited reasons. It often seems like an overwhelming process, even for accountants who are not focused on Management Accounting. However, this critical step that we provide for many of our clients is what has allowed them to reassess their business practices in time to make the necessary changes to keep them out of financial trouble.

Cash Flow forecasts are by definition rolling forecasts. I like to prepare a higher level 12 month cash flow forecast to see the larger picture and then a more detailed short term weekly forecast that runs for just as long as you reasonably can predict what will occur. That might be 4-12 weeks depending upon how quickly you collect your receivables and how predictable your sales are. I revisit the short-term forecast as often as necessary (daily, weekly, or monthly) depending upon the needs of the business and only reassess the higher level 12 month forecast if something has changed drastically.

1. In order to begin you need to know a few key facts about your business. The first is when you expect the revenue to come in. If you do not offer any terms and are paid up front, then your revenue forecast will be the same as your weekly sales forecast. If you do offer terms, then you need to continually keep a pulse on 2 items, the percent of your sales that are credit sales and your average days to collect your outstanding Accounts Receivable (A/R turns in financial terms). You will need to determine if these factors change significantly at various times of the year or if you can analyze them only occasionally. Initially I would look at them monthly to get a feel for what they are doing and how they are reacting to the economy. Besides being necessary for your Cash Flow forecast, watching these two numbers can also be an indicator of how your customers are reacting to larger economic events and what is happening in their businesses. Further, it can be an indication of whether you are being too lax in your own collection policy.

2. Secondly you need to do some analysis of your expenditures. You need to analyze when your own payments are due (how far ahead do you have to purchase to fill your sales demand, what percent of your inventory terms are prepaid, net 30, net 60?). Add to this the various weekly and monthly payments that are due such as payroll, insurance, rent, interest and loan payments, tax payments, distributions to owners, to give you a comprehensive layout of when your cash needs to be spent.

3. The third piece is your sources of funds outside of collections. If you have a line of credit that you can tap into or a loan you can draw upon, then you need to factor the limits of that into your equation.

Build a spreadsheet using all of these parts and I guarantee that you will more effectively stay on top of your cash flow needs. You will see the shortfalls before they occur. You will know how much cash you need to have each week and can then work on the various strategies to bring in cash more quickly, extend the time needed to pay your vendors, and plan your capital expenditures more wisely. Cash Flow Forecasting is one ore tool to allow you to run your business, not have it run you.