That sobering figure comes from a recent KPMG study that surveyed 540 senior executives across the world who are involved in the financial forecasting process for their businesses.
What this study indicates is that poor financial forecasting costs money. Many respondents felt that share prices had dropped by 6% over three years, representing a huge loss of market capital. Meanwhile, that tiny 1% of businesses that were accurate with their forecasting grew share prices by 46%.
The numbers don’t lie. Financial forecasting is a must-have for any organization interested in longevity. At its most basic, the process involves predicting a company’s financial future by examining historical data. This includes cash flow, expenses, sales, etc. It’s looking at business performance and there are plenty of external factors that have a hand in shaping the forecast.
In this article, we’re going far beyond the surface. We’ll show you different types of financial forecasting models so you can make an informed decision on what’s best for you. Plus, we’ll show you how you can build good financial forecasting models instead of models that could break your business.
As the KPMG study details, without proper financial forecasting, companies run the risk of losing money. But it’s not the only reason why cutting corners is a bad idea. Here are just a few to consider.
Bottom-up financial forecasting involves looking at existing financial and sales information. It’s reviewing a company’s finances from the lowest point and plotting future scenarios. Or it could be for predicting revenue by multiplying the average sales value by the potential sales per product offered.
So, put into a formula, it looks like this: Estimate of products/services expected to sell x average price = total sales.
Start-up companies or larger organizations may rely on the bottom-up financing forecasting model. Of course, there will be different requirements for every business. But the uniting factor is that the model ties directly to sales. If the forecast is inaccurate, then sales teams might not hit their targets. So, cash flow suffers and friction develops between sales, marketing and other teams.
When a company is focused on entering a new market, top-down financial forecasting might be the way to go. This is the formula to understand for this: Revenue = market size x market share assumption.
Put another way, market size refers to the complete revenue opportunity for a specific market. And market share assumption is the expected percentage of the market taken by the business.
Compared to bottom-down financial forecasting, this method is often best suited to larger organizations like Microsoft or Amazon. The reason is because they have diverse revenue channels and using a bottom-up approach would be too complicated because of the vast amount of products that are being handled.
With that said, top-down financial forecasting can offer some advantages for small companies that have only been trading for a couple of years. The lack of historical financial data can be an asset in this situation and help to identify investment opportunities.
As the name suggests, stats are an integral part of this model. It’s often used for finding and creating relationships between financial data and might be broken down into subcategories, such as:
This collaborative model focuses on gathering opinions from a panel of experts. A facilitator leads several rounds of questionnaires that analyze data and theories. After each questionnaire, the answers are aggregated and anonymous. Each participant has the chance to adjust their next set of answers based on the aggregation.
There are several advantages to doing this. First, as the answers are anonymous, participants can be completely open about their opinions without fear of negative backlash. Second, people from different teams can get together and bring new perspectives that might not have been considered before. Third, there’s a prevention of the ‘halo effect’ where the opinions of senior members are given priority over others.
On the other hand, the Delphi method can be drawn out and the value of discussion might be lessened. Other times, a live debate might be more appropriate as real-time data is broken down and assessed quickly.
This method relies on risk management strategies to reduce various risk scenarios for a business. Changes in interest caused by recession. Worker strikes damaging supply chains and product circulation. Economic shifts that are simply beyond the control of an organization.
The process is built on the timing of cash flow and the payments of liabilities. Assets must be available to pay debt and assets can be converted into cash. Let’s take a look at a specific example of this model.
Let’s say a business has a pre-defined pension plan for employees. The business carries the risk that the assets invested in the plan aren’t enough to cover all benefits promised to staff. So, the company must forecast the dollar amount of assets needed to pay the benefits. This might be a figure of $1.2 million paid to staff over ten years. The rate of return on the dollars invested must be estimated for each year before the first payments start in ten years.
All these financial forecasting models have their place. But if you’re too rigid with any of them, you can still run into problems. For instance, you could end up misinterpreting the limitations of a certain model and be left with wildly inaccurate figures that hurt your bottom line in the long term. You could also favor a more time-consuming approach over a more efficient method. Or you might rely only on the calculations and not plan for any unexpected scenarios.
If you’re leading a finance team at a company, then there are certain traits and skills you’ll need to implement better financial forecasting. Let’s explore some of these.
As the KPMG study reveals, CFOs need less time to train more finance staff in forecasting (11% see it as a priority compared to 21% at less accurate companies). Meanwhile, 87% hold managers accountable, while 25% incentivize managers to forecast accurately.
An example of this in action could be for a CFO to hold regular workshops with managers to understand their approaches and dig deeper into specific metrics like DSO, DIO and DPO. The key is to help the broader finance team get a full understanding of the impact on working capital.
The most financially stable brands have CFOs who:
Making the most of AI and automation opens a new world of possibilities. CFOs should spend time doing a thorough review of different platforms and analyzing key features. Questions to ask include:
Top-performing CFOs in the last three years have worked to make forecasting a key part of lowering the decline of share prices. This is a reminder that financial forecasting can’t just be left with one person or a team. Shareholders must be invited into the process. They need to see what’s going on as early as possible.