Cash & Liquidity ManagementCash ManagementRising rates put pressure on accuracy of cash forecasts

Rising rates put pressure on accuracy of cash forecasts

In an environment where rates are rising and are expected to do so for the foreseeable future, the direct cost of debt and the opportunity cost of holding uninvested cash both increase significantly. Therefore, the quality and accuracy of cash forecasts used to plan for future liquidity needs come into sharp focus.

At its recent monthly meeting, the US Federal Reserve increased the Federal Funds rate from 1.5% to 1.75% and indicated rates will rise faster than previously anticipated. The new federal chairman Jerome Powell has taken a more hawkish stance on rates than his predecessor Janet Yellen as he attempts to cool a US economy that is growing faster than originally forecast.

In an environment where rates are rising and are expected to do so for the foreseeable future, the direct cost of debt and the opportunity cost of holding uninvested cash both increase significantly. Therefore, the quality and accuracy of cash forecasts used to plan for future liquidity needs come into sharp focus.

In other words, as rates increase, the cost of inaccurate cash forecasting can become a significant penalty.

Measuring accuracy is a challenge

In large organizations, cash forecasting requires the collection of vast amounts of data from a wide array of sources. Because of this, measuring the accuracy of a cash forecast is not a straightforward task, simply due to the volume of data points that have to be analyzed and the amount of work involved in carrying out a thorough analysis.

As actual cash data is required to measure the accuracy of forecasts, the level of data available to a treasury and finance team will determine which elements of the forecast can be analyzed. For example, if only closing cash balances can be accessed, it is only the closing cash positions in the forecast that can be measured. Whereas if transactional cash flow data is available, other components of the forecast such as operating and investing cash flows, can also be considered for accuracy.

Decide what to measure

Choosing what to measure, and how frequently to measure it, is the first step in understanding forecast accuracy. Analyzing closing cash positions and net cash movements will provide a good gauge of overall forecast accuracy. Cash generation and working-capital based analysis will give a better understanding of cash flow performance, although this will require more forecast and actual detail.

Choosing the component of the forecast that means most to a business, and consequently measuring it, is a good starting point.

Once metrics are chosen, the time horizon will need to be selected. As with choosing a component of the forecast to focus on, it is important to select the time-period or date that matters most to the business. Whether this is month-end, year-end, or a monthly debt rollover, once the key dates/times are identified, the forecast reporting processes should be built around them.

Choose a simple method of accuracy measurement

There are various methods that can be used to measure accuracy:

  • Single period actual versus forecast

As would be expected from the name, a single period versus actual forecast is useful for single period analysis such as week-on-week or month-on-month. Forecast accuracy is best described through a percentage and can be calculated by dividing the gap between the actual and forecast figure, by the actual figure.

  • Count down accuracy analysis

A count down accuracy analysis involves measuring a number of different forecasts which are made in the approach to the target date. These forecasts can then be analyzed for accuracy as soon as the actual figure or flow on the closing date is known.

For example, the table below shows four forecasts made for December 31 closing cash position in the lead up to the target date. The actual figure for December 31 in this example is €13.5m.

 

€ 000’s Date of forecast Days to target date Forecast for December 31 Difference vs actual Forecast accuracy
Forecast 1 3rd December 28 6,650 6,850 49%
Forecast 2 10th December 21 8,260 5,240 61%
Forecast 3 17th December 14 9,500 4,000 70%
Forecast 4 24th December 7 12,000 1,500 89%

As could be expected, the accuracy percentage increases as the target date approaches.

Presenting the results of the analysis as a graph helps to give a clearer picture of trends in the forecasts. In this example, each of the forecasts was overly conservative, and achieved only 49% accuracy four weeks before year-end, rising to 89% accuracy one week before year-end.

Keep the analysis focused

To provide high-quality analysis, the forecast reporting processes should be targeted. If the methodology is overly complex, it can prove difficult to identify trends and make the necessary improvements. Choosing the most important metric, and the most relevant time horizon enables accuracy measurements that are easy to understand and straightforward to explain.

The above is an abbreviated version of a white paper issued by CashAnalytics on Cash Forecasting Accuracy measurement.

The full document, along with other resources, are available on the CashAnalytics website here.

Related Articles

Cash management systems on the rise in SME sector

Cash Management Cash management systems on the rise in SME sector

1w Abi Millar
Make way for the millennial accounts payable activist

Accounts Payable Make way for the millennial accounts payable activist

1m Nilay Banker
Burn those spreadsheets - and 4 other ways that treasurers can help their CFOs sleep better

Automation Burn those spreadsheets - and 4 other ways that treasurers can help their CFOs sleep better

4m Bob Stark
How to forecast cash flow: what software should I use?

Cash Forecasting How to forecast cash flow: what software should I use?

4m Michael McCaw
What is the function of corporate treasury?

Cash Management What is the function of corporate treasury?

4m Michael McCaw
China’s regulatory changes stimulate international interest

Asia Pacific China’s regulatory changes stimulate international interest

5m Michael McCaw
Treasury TV: Jill Harrison, Whitbread Plc

10 Minutes With The Treasury Treasury TV: Jill Harrison, Whitbread Plc

5m Victoria Beckett
Cash flow in focus for investors

Cash Management Cash flow in focus for investors

5m Conor Deegan