This article is the first of a series on cash forecasting and it explores the benefits to an organisation of producing cash forecasts.
Cash forecasting (identifying short-, medium- and long-term liquidity requirements) is a key element in managing liquidity risk and a valuable aid to the organisation as a whole. But the benefits (or otherwise) of cash forecasting have long been debated by organisations of all sizes. In the ‘good old days’ when there was plenty of liquidity for all, the view frequently adopted was that the resources required to deliver an accurate forecast in a timely manner could not be justified (the cost or benefit analysis just didn’t stack up). Arguably, this has never been the case, but particularly in the post-Lehman environment, cash has reverted to centre stage and efficient use of internal resources has become much more important given scarce external resources.
A reliable cash forecasting system is seen by many companies as essential to manage liquidity risk effectively. Knowledge of funding required, given a range of scenarios, is important when planning any timescale. By predicting shortfalls and surpluses, the cash manager can optimise the use of cash and facilities to improve investment returns, negotiate better borrowing terms and conditions, and minimise external borrowing.
For cash management purposes, there are usually three timescales for forecasting, each serving a different purpose:
Cash forecasts can be generated by two principle forecasting methods over the different time periods – the long-term, strategic forecast, commonly generated from the management accounting statements in an organisation; and the short- to medium-term forecast based on a receipts and disbursements methodology.
The objectives of a long-term forecast are to identify structural cash shortages and surpluses (including requirements for committed facilities) by identifying the potential impact of strategic initiatives or business changes on the company’s:
For companies planning a corporate transformation, such as a merger or acquisition, or even ‘just’ significant capital expenditure, long-term forecasting is essential to identify the size and tenor of any funding requirement.
Moving money cross-border can be expensive and time-consuming
Potential investors, such as banks or bond holders, may also require long-term forecasts to ensure that sufficient cash is generated to enable the company to make loan and interest payments on long-term debt without jeopardising other activities of the business.
Short-term forecasts are used to manage day-to-day cash requirements by identifying the amount and timing of expected cash receipts and payments.
The objectives of short-term forecasts are to:
Generating a short-term forecast, which tells treasury that funds are required in advance, gives the cash manager time to:
Having to produce liquidity at short notice means that cost of funds may well be higher and can be difficult in certain market conditions.
Intra-group funding, practised by most large groups, is more effective if it is based on forecast positions, rather than as a reaction to short-term situations, and the use of forecasts minimises the amount of unnecessary transfers. This is particularly important where cross-currency and/or cross-border liquidity management are concerned. Moving money cross-border can be expensive and (in the context of daily cash management) time-consuming due to the accounting and regulatory requirements that must be complied with.
Short- or medium-term cash forecasts can also be used in FX risk management, since, by producing both local currency and foreign currency cash forecasts, a cash manager can identify the size and timings of currency flows to:
There are several challenges associated with generating a cash forecast. And treasurers often cite forecasting as the most difficult element of cash management for the following reasons:
For a cash forecasting system to work successfully, it is important that operating units understand the importance of forecasts and buy in to the process. This requires clear communication and, frequently, an education process to ensure that the preparers of forecasts know that their forecasts are being used and that they are not merely a control imposed from the centre. The operating companies need to understand how important accurate forecasts are in helping to ensure that the business has sufficient funding to be able to continue functioning; regular feedback from treasury can also help here.
Of those companies that do prepare cash forecasts, few use sophisticated computer software. Various studies have found that more than half of the companies surveyed use spreadsheets as their primary forecasting tool. Even larger companies are not heavy users of technology, such as treasury workstations, for forecasting. But the use of spreadsheets should not be dismissed out of hand as their simplicity and widespread use makes them a simple solution for finance teams to provide information.
Like all forecasting, cash flow forecasting is only useful if the data is accurate and it is regularly updated and refined. All information supplied needs to be concise, on time and in an agreed format. Poor-quality data – in particular, inaccurate sales figures or misreported intercompany items – can be a major hurdle as they can skew the entire process. It is an ongoing challenge to obtain realistic, rather than aspirational, numbers from sales and marketing teams, and is one of the major areas of tension between treasury and central finance teams.
Cash forecasting can be an invaluable tool for cash managers, but it will only be useful if it is tailored to meet the needs of the business by being:
This will ensure that the time and money cost of preparing each forecast is justified.
Sarah Boyce is associate director of education at the ACT