In this section of the chapter, we will move beyond the sales forecast and look at the general nature, length, and timeline of forecasts and the risks associated with using them. We’ll look at why we use them, how long they generally are, what the key variables in a forecast are, and how we pair those variables with common-size analysis to develop the forecast.
As mentioned earlier in the chapter, forecasts serve different purposes depending on who is using them. Our focus here, however, is the world of finance. In this realm, the key purpose of pro forma (future-looking) financial statements is to manage a firm’s cash flow and assess the overall value that the firm is generating through future sales growth. Growing just for the sake of growing doesn’t always yield favorable income for the firm. A larger top-line sales figure that results in lower net income doesn’t make sense in the grand scheme of things. The same is true of profitable sales that don’t generate enough cash flows at the right time. The firm may make a profit, but if it doesn’t manage the timing of its cash flows, it could be forced to shut down if it can’t cover the costs of payroll or keep the lights on. Forecasting helps assess both cash flow and the profitability of future growth. Managers can forecast cash flow using data from forecasted financial statements; this allows them to identify potential gaps in cash and plan ahead in order to either alter collection and payment policies or obtain funding to cover the gap in the timing of cash flows.
Review the video Business Plan and Pro-Forma Financial Statements to learn about the basics of pro forma financial statements and why they are helpful.
Forecasts can generally be for any length of time. The length generally depends on the user’s needs. A one-year forecast, broken down by month, is quite typical. A firm will often go through a formal budgeting process near the end of its calendar or fiscal year to project financial plans and goals for the coming year. Once that is done, a rolling financial forecast is then done monthly to adjust as time moves on, more information becomes available, and circumstances change.
To be useful, the future forecast for financial planning purposes is almost always calculated as monthly increments rather than one total figure for the next 12 months. Breaking the data down by month allows finance managers to more clearly see fluctuations in cash flows in and out, identify potential gaps in cash flow, and plan ahead for their cash needs.
Forecasts can also be done for several years into the future. In fact, they commonly are. However, once the firm is looking out beyond 12 months, it gets difficult to forecast items with a great degree of accuracy. Often, forecasts beyond a year will be completed only to quarterly or even annual figures rather than monthly. Forecasts that far into the future are often strategic in nature, made more to communicate future plans for the firm than for more detailed decision-making and cash flow planning.
As we saw earlier in the chapter, common-size analysis involves using historical financial statements as a basis for future forecasts. Financial statements provide a great starting point for analysis, as we can see the relationships between sales and costs on the income statement and the relationships between total assets and line items on the balance sheet.
For example, in Figure 18.6, we saw that for the past two years, cost of goods sold has been 50% of sales. Thus, in the first draft of a forecast for Clear Lake, it’s likely that managers would estimate cost of goods sold at 50% of their forecasted sales. We can begin to see why forecasting sales first is crucial and why doing so as accurately as possible is also important.
A simple way to begin a full financial statement forecast might be to simply use the common-size statements and forecast every item using historical percentages. It’s a logical way to begin a very rough draft of the forecast. However, several variables should be taken into consideration. First, managers must address the cost of an account and determine if it’s a variable or fixed item. Variable costs tend to vary directly and proportionally with production or sales volume. Common examples include direct labor and direct materials. Fixed costs, on the other hand, do not change when production or sales volume increases or decreases within the relevant range. Granted, if production were to increase or decrease by a large amount, fixed costs would indeed change. However, in normal month-to-month changes, fixed costs often remain the same. Common examples of fixed costs include rent and managerial salaries.
So, if we were to approach our common-size income statement, for example, we would likely use the percentage of sales as a starting point to forecast variable items such as cost of goods sold. However, fixed costs may not be accurately forecast as a percentage of sales because they won’t actually change with sales. Thus, we would likely look at the history of the dollar values of fixed costs in order to forecast them.
Big 5 Sporting Goods announced record earnings in the third quarter of 2020, attributing its huge success that quarter to the impact of people’s reactions to the COVID-19 pandemic. With so many people in quarantine still wanting to make healthy lifestyle choices, sporting goods stores were making record sales. Record-breaking sales, however, are not certain in the future. The impacts of the pandemic are extremely difficult to predict, making it a challenge for Big 5 Sporting Goods and other companies to assemble pro forma financial statements.
(sources: https://www.globenewswire.com/news-release/2020/10/27/2115470/0/en/Big-5-Sporting-Goods-Corporation-Announces-Record-Fiscal-2020-Third-Quarter-Results.html; https://finance.yahoo.com/news/investors-want-big-5-sporting-054658521.html; https://www.cpapracticeadvisor.com/accounting-audit/news/21206691/four-ways-covid19-will-impact-2021-financial-forecasting-and-planning)
So far, we have focused on using historical common-size statements to create a draft (not a final version) of the forecast. This is because the past isn’t always a perfect indicator of the future, and our finances don’t always follow a linear pattern. We use the past as a good starting point; then, we must assess what else we know to fine-tune and make adjustments to the forecast.
Many items impact the forecast, and they will vary from one organization to another. The key is to do research, gather data, and look around at the market, the economy, the competition, and any other factors that have the potential to impact the future sales, costs, and financial health of the company. Though certainly not an exhaustive list, here are a few examples of items that may impact Clear Lake Sporting Goods.
We will use all of this data later in the chapter when we are ready to compile a complete forecast for Clear Lake.
This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.
Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.
Access for free at https://openstax.org/books/principles-finance/pages/1-why-it-matters
Access for free at https://openstax.org/books/principles-finance/pages/1-why-it-matters
© Jan 8, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.
OpenStax is part of Rice University, which is a 501(c)(3) nonprofit. Give today and help us reach more students.