Cash flow forecasting

Cash flow forecasting or cash flow management is a key aspect of financial management of a business, planning its future cash requirements to avoid a crisis of liquidity.

Cash flow forecasting is important because if a business runs out of cash and is not able to obtain new finance, it will become insolvent. Cash flow is the life-blood of all businesses—particularly start-ups and small enterprises. As a result, it is essential that management forecast (predict) what is going to happen to cash flow to make sure the business has enough to survive. How often management should forecast cash flow is dependent on the financial security of the business. If the business is struggling, or is keeping a watchful eye on its finances, the business owner should be forecasting and revising his or her cash flow on a daily basis. However, if the finances of the business are more stable and 'safe', then forecasting and revising cash flow weekly or monthly is enough.^[1] Here are the key reasons why a cash flow forecast is so important:

• Identify potential shortfalls in cash balances in advance—think of the cash flow forecast as an "early warning system". This is, by far, the most important reason for a cash flow forecast.
• Make sure that the business can afford to pay suppliers and employees. Suppliers who don't get paid will soon stop supplying the business; it is even worse if employees are not paid on time.
• Spot problems with customer payments—preparing the forecast encourages the business to look at how quickly customers are paying their debts. Note—this is not really a problem for businesses (like retailers) that take most of their sales in cash/credit cards at the point of sale.
• As an important discipline of financial planning—the cash flow forecast is an important management process, similar to preparing business budgets.
• External stakeholders such as banks may require a regular forecast. Certainly, if the business has a bank loan, the bank will want to look at the cash flow forecast at regular intervals.

Corporate finance

Definition

In the context of corporate finance, cash flow forecasting is the modeling of a company or entity's future financial liquidity over a specific timeframe. Cash usually refers to the company's total bank balances, but often what is forecast is treasury position which is cash plus short-term investments minus short-term debt. Cash flow is the change in cash or treasury position from one period to the next period.

Methods

The direct method of cash flow forecasting schedules the company's cash receipts and disbursements (R&D). Receipts are primarily the collection of accounts receivable from recent sales, but also include sales of other assets, proceeds of financing, etc. Disbursements include payroll, payment of accounts payable from recent purchases, dividends and interest on debt. This direct R&D method is best suited to the short-term forecasting horizon of 30 days or so because this is the period for which actual, as opposed to projected, data is available.^[2]

The three indirect methods are based on the company's projected income statements and balance sheets.

• The adjusted net income (ANI) method starts with operating income (EBIT or EBITDA) and adds or subtracts changes in balance sheet accounts such as receivables, payables and inventories to project cash flow.
• The pro-forma balance sheet (PBS) method looks straight at the projected book cash account; if all the other balance sheet accounts have been correctly forecast, cash will be correct, too.

Both the ANI and PBS methods are best suited to the medium-term (up to one year) and long-term (multiple years) forecasting horizons. Both are limited to the monthly or quarterly intervals of the financial plan, and need to be adjusted for the difference between accrual-accounting book cash and the often-significantly-different bank balances.^[3]

• The third indirect approach is the accrual reversal method (ARM), which is similar to the ANI method. But instead of using projected balance sheet accounts, large accruals are reversed and cash effects are calculated based upon statistical distributions and algorithms. This allows the forecasting period to be weekly or even daily. It also eliminates the cumulative errors inherent in the direct, R&D method when it is extended beyond the short-term horizon. But because the ARM allocates both accrual reversals and cash effects to weeks or days, it is more complicated than the ANI or PBS indirect methods. The ARM is best suited to the medium-term forecasting horizon.^[4]

Uses

A cash flow projection is an important input into valuation of assets, budgeting and determining appropriate capital structures in LBOs and leveraged recapitalizations. ₳

Entrepreneurial

Definition

In the context of entrepreneurs or managers of small and medium enterprises, cash flow forecasting may be somewhat simpler, planning what cash will come into the business or business unit in order to ensure that outgoing can be managed so as to avoid them exceeding cashflow coming in. Entrepreneurs need to learn fast that "Cash is king" and, therefore, they must become good at cashflow forecasting.

Methods

The simplest method is to have a spreadsheet that shows cash coming in from all sources out to at least 90 days, and all cash going out for the same period. This requires that the quantity and timings of receipts of cash from sales are reasonably accurate, which in turn requires judgement honed by experience of the industry concerned, because it is rare for cash receipts to match sales forecasts exactly, and it is also rare for customers all to pay on time. These principles remain constant whether the cash flow forecasting is done on a spreadsheet or on paper or on some other IT system.

A danger of using too much corporate finance theoretical methods in cash flow forecasting for managing a business is that there can be non cash items in the cashflow as reported under financial accounting standards. This goes to the heart of the difference between financial accounting and management accounting.

References

1. "Should I do Monthly, Weekly or Daily Cash Flow Forecasting?". simplycashflow.com.
2. Tony de Caux, "Cash Forecasting", Treasurer's Companion, Association of Corporate Treasurers, 2005
3. Cash Flow Forecasting, Association for Financial Professionals, 2006
4. Richard Bort, "Medium-Term Funds Flow Forecasting", Corporate Cash Management Handbook, Warren Gorham & Lamont, 1990