CHAPTER INTRODUCTION
This chapter will focus on projections that estimate performance over a 3‐ to 18‐month period, including budgets, operating plans, and forecasts. Many of the techniques and practices utilized in this chapter were introduced in Chapter 12.
In spite of its shortcomings, the budgeting process lives on in many organizations. In some cases, it is required by charter or statute. In other cases, it either suffices or has not been evaluated against new tools, and against best practices and techniques in financial management. We will review the typical budget process and tools in this section to serve as a foundation for improved planning tools for the twenty‐first century.
In chapter 12 we described the traditional budget process that became a cornerstone of management systems in the twenty‐first century. While many organizations have adopted more evolved methods of developing business projections explored later in this chapter, others continue to use the traditional budget process.
The traditional budget process follows an annual cycle. The budget for next year would be developed several months before the new year begins. It is characterized by a very detailed and financially oriented process illustrated in Figure 13.1.
Departmental managers complete budget forms for their respective areas of responsibility as illustrated in Table 13.1.
TABLE 13.1 Traditional Departmental Budget
Maugham Distributors | ||||||
Company: | $000's | Inside Sales | ||||
Q1 | Q2 | Q3 | Q4 | Year | ||
Labor and Related Costs | ||||||
Salary | 145.0 | 145.0 | 145.0 | 160.0 | 595.0 | |
Bonus | 40.0 | 40.0 | ||||
Commissions | 0.0 | |||||
Total | 145.0 | 145.0 | 145.0 | 200.0 | 635.0 | |
Fringe Benefits | 36.3 | 36.3 | 36.3 | 40.0 | 148.8 | |
% to Total Labor | 25% | 25% | 25% | 20% | 23% | |
Total Labor and Related Costs | 181.3 | 181.3 | 181.3 | 240.0 | 783.8 | |
Other | Travel | 4.0 | 4.0 | 4.0 | 4.0 | 16.0 |
Meetings | 2.0 | 2.0 | 2.0 | 2.0 | 8.0 | |
Consultants | 2.0 | 2.0 | 2.0 | 2.0 | 8.0 | |
Professional Services | 2.0 | 2.0 | 2.0 | 2.0 | 8.0 | |
Telecommunications | 0.0 | |||||
Materials | 8.0 | 8.0 | 8.0 | 8.0 | 32.0 | |
Contract Services | 0.0 | |||||
0.0 | ||||||
0.0 | ||||||
Depreciation | 0.0 | |||||
Allocations In | 5.0 | 5.0 | 5.0 | 5.0 | 20.0 | |
Other | 2.0 | 8.0 | 30.0 | 35.0 | 75.0 | |
Total Other Expenses | 25.0 | 31.0 | 53.0 | 58.0 | 167.0 | |
Total Expense | 206.3 | 212.3 | 234.3 | 298.0 | 950.8 | |
Year to Year Growth | 2.9% | 10.4% | 27.2% | 219.0% | ||
Sales | 1100.0 | 1125.0 | 1135.0 | 1200.0 | 1300.0 | |
Selling % of Sales | 18.8% | 18.9% | 20.6% | 24.8% | 73.1% | |
Labor Detail (000's) | ||||||
Manager | 38.0 | 38.0 | 38.0 | 38.0 | 152.0 | |
Admin | 10.0 | 10.0 | 10.0 | 10.0 | 40.0 | |
New Hire | 15.0 | 15.0 | ||||
Lead Internal Sales | 25.0 | 25.0 | 25.0 | 25.0 | 100.0 | |
Sales Assistant | 35.0 | 35.0 | 35.0 | 35.0 | 140.0 | |
Internal Sales (3) | 37.0 | 37.0 | 37.0 | 37.0 | 148.0 | |
0.0 | ||||||
Total ($000's) | 145.0 | 145.0 | 145.0 | 160.0 | 595.0 | |
Year to Year Growth % | 0.0% | 0.0% | 10.3% | 271.9% | ||
Year to Year Growth $ | 0.0 | 0.0 | 15.0 | 435.0 |
These are then rolled up into cost summaries and ultimately profit and loss (P&L) projections as shown in Figure 13.2. After a series of reviews and revisions, the budget would be presented to senior executives and the board of directors for approval. The budget then served as the basis for operating and evaluating actual performance against these budget expectations.
Annual plans and budgets have been the subject of criticism for years. While many organizations have made substantial improvements, most organizations do not extract the potential utility out of this very time‐consuming activity.
One of the major problems with budgeting is the focus on finance, including general ledger accounts and financial statement captions, rather than processes, activities, customers, projects, and critical assumptions. Department managers often had to create “shadow” planning tools to develop budget estimates from an operating perspective and link to their processes and activities.
The output of a traditional budget process would often lock into a single‐scenario document; the emphasis was on the document rather than the potential value of the process. As President Dwight Eisenhower said, “Plans are useless, but planning is essential.”1 In other words, the value is not in the plan document itself or in a single course of action set forth in the plan. Once the battle begins, the conditions and circumstances will depart from those used in developing the plan. The value in planning lies in the thought process, including assessing strengths and weaknesses, evaluating critical assumptions, and developing potential scenarios and contingency plans. Budgets tend to be numbers driven and tend not to focus attention on issues and opportunities, on risks and upsides, or on execution planning.
Traditional budgets do not adequately identify and test critical assumptions and performance drivers. The financial focus often means that assumptions are buried in the details and not adequately identified and tested.
Budgets were useful for a time, when business was more static. Their utility has declined significantly, resulting from the development of the global economy, the accelerated rate of change, and significant geopolitical events that reshape markets dramatically and frequently. Traditional budget processes are very labor intensive. Due to the level of detail and the typical need for multiple revisions, the budget process can often lead to a substantial investment (or waste) of time by finance and operating managers alike. Many companies issue planning guidelines and boundaries (discussed in Chapter 12) to establish goals and targets in order to create a starting point and to minimize the number of revisions.
In most cases, the organization would be better served by developing an operating plan as described in the next section.
A key distinction between a budget and an operating plan is that the latter is a complete execution plan for the coming year whereas the former has a focus on the financial projections. The financial projections are an essential aspect of the plan, but not the only objective or focus of the process. An effective operating plan will:
Before a plan can be effectively developed for the coming year, management must assess the current situation. Has the external environment changed? Has the competitive landscape changed? Are we meeting or exceeding strategic goals? Are we meeting current performance targets? This assessment should include a review and an evaluation of recent financial results as well as key performance indicators (KPIs). Many organizations find it useful to benchmark competitors and customers (refer to Chapter 11, The External View: Benchmarking Performance and Competitive Analysis) as part of this situational analysis.
The annual operating plan should be an installment of the company's strategic plan. The operating plan process should include a review of the strategy. Are the critical assumptions supporting the strategic plan still valid? Where do we stand on the implementation or attainment of strategic objectives?
The operating plan is an opportunity to develop an execution plan for the strategic objectives for the next year. It should ensure that the objectives are still valid, and plan for human and financial resources to execute and achieve those objectives.
Prior to turning the troops loose on developing the operating plan, the leadership team and board should develop performance goals and targets. In establishing goals and targets, the organization should consider the following:
Next, managers should develop a preliminary execution or game plan for the coming year. This should be based on the situational analysis and preliminary goals. In order to prevent the chaos of a bottom‐up wish list, it is useful to establish parameters or high‐level targets of revenue growth and expense and investment levels, and communicate to all involved in developing the plan.
The organization should develop a preliminary model of projections for the plan year. Not all revenues, costs, and expenses are created equal. The team should focus on the most significant and most variable, using the Pareto rule introduced in Chapter 3.
This phase will be very easy if the organization uses rolling forecasts or an on‐demand business outlook (DBO), discussed later in this chapter, since the team has already developed and evaluated projections for the plan year. In fact, most organizations utilize the DBO model to develop the preliminary projections for the operating plan. These preliminary projections must identify and present key assumptions.
The operating plan for next year has hundreds of assumptions. These assumptions likely include everything from general economic conditions to weather, from inflation to pricing, and from the availability of critical materials to their cost. In many plans, these assumptions are buried in the details and are not explicitly identified. Key assumptions should be identified and reviewed. Managers should understand how sensitive the planned results are to changes in critical assumptions. These assumptions should be tracked over the plan horizon, and any signals indicating that the assumptions may not be valid should trigger a review and a response. Identifying and reacting to changes in significant assumptions early will allow you to minimize the impact of downside events and trends and to fully capitalize on the upsides.
Successful plans place significant attention on the activities required to achieve the planned results. For example, sales growth arising from the introduction of a new product in the next year requires a series of activities related to the development, production, marketing, and selling of the product. Each of these activities must be thoroughly planned out and adequately resourced to ensure that the planned sales are achieved. In addition, each of the responsible managers must be committed to the completion dates to support the product introduction and revenue plan.
Owing to the rate of change and uncertainty that exists in the current environment, the use of a single‐point plan generally is not valid or meaningful. A single plan estimate, by definition, must reflect a position on the probability and estimated impact of numerous events, transactions, and conditions. Managers should set the expectation that a base projection should be the best estimate of the outcome under the present strategy and expected market and economic conditions. Some organizations clarify this expectation by using language such as “most probable” or establishing desired confidence levels. This base plan includes a multitude of assumptions, including the probability and estimated impact of potential events. It is useful to identify and present how these potential events have been reflected in the plan. For example, if the plan assumes a continued favorable economic expansion, then a potential downside would be an economic recession. Other downside events may include competitive threats or loss of a major customer or contract.
In addition to assessing the potential impact on the financial projections, this analysis allows management to monitor these potential factors and to develop preliminary contingency and response plans. The development of multiple scenarios and upside/downside events was discussed in detail in Chapter 12.
The objectives and targets set during the plan process must be communicated throughout the organization. Failure to communicate is the equivalent of a coach not sharing the game plan with the team prior to the start of the game. Of course, the specific content shared will depend on several factors such as the need for confidentiality and the level and role within organization.
A good test of the organization's understanding of the plan is to ask: Can our managers and employees list the five critical priorities for the coming year? Significant leverage is possible by communicating key objectives and activities included in the plan. For example, imagine the potential benefits to a critical project if all finance, human resources, and procurement teams recognized and supported the project as the number one priority for the company. Even more effective results can be achieved if the objective setting and performance management process for individual managers and employees is a part of the annual planning process, instead of an independent, subsequent drill.
In many companies, performance tracking and monitoring are focused on financial results. This is problematic since financial results are lagging measures of business activities and processes. If you wait until trends or problems are visible in the financials, it is already too late to correct for that period. Many problems are easily addressed at an early stage, but grow and compound as time passes. Dashboards should be developed to track performance on leading indicators that will alert managers to unfavorable trends in near real time so that corrective action can be taken.
You can't manage financials; you can manage people, processes, transactions, and projects. The financials are a result of these business activities and inputs. For example, if you want to improve accounts receivable days sales outstanding from 75 to 60 days, it won't happen unless you focus on the critical business processes that impact receivables. Create a plan that identifies improvement opportunities on critical drivers of receivables: revenue hockey sticks, improving quality and on‐time delivery, and resolving customer problems faster. Establish targets and then monitor KPIs covering revenue linearity, quality, past‐due orders and collections, and problem resolution. KPIs were discussed in greater detail in Chapter 8, Dashboards and Key Performance Indicators.
Each year, the annual plan process should be evaluated to identify potential improvement opportunities. Start by reviewing the current planning and forecasting processes and products. Measure the duration of the entire planning process. Document the process flow, including required inputs, processing, review and revision, and presentation. Identify the most critical assumptions and most significant revenue and cost drivers. Identify time spent in major stages of the process. Review the critical output/presentations of the plan. Do a postreview of the planning process, identifying impediments, issues, and improvement opportunities. Also review actual performance against the original plan, identifying the root causes of any variances. This will highlight bottlenecks, identify redundant and inefficient aspects, and provide a recap of critical assumptions and performance drivers.
Figure 13.3 is a dashboard summarizing KPIs for the planning process. This team started with some significant issues including a long plan duration, multiple revisions and ineffective results in the form of large variances to plan. By identifying and addressing root causes, the team implemented changes to make the process both more efficient and effective. The two most important changes were the use of planning guidelines and boundaries at the start of the process and the implementation of a rolling forecast.
Due to the rapidly changing business conditions, it has become increasingly important to be able to recast expected performance periodically during the year, and even on demand. In many organizations, the rolling forecast or business outlook has become the cornerstone of the planning, projecting, and management control activities. The forecast or outlook model must be robust enough to easily reflect changes in key assumptions, performance trends, events, or management decisions.
Forecasts emerged because of the need to update or recast the budgets. As business became more complex and the pace of change increased, the original budgets often were outdated early in the year. These updates were often done at a higher level than the original budget projections.
Many organizations began preparing an update to the budget on a monthly or quarterly basis. As the actual results were available, the remaining forecast period was evaluated to reflect known trends and any additional information that had surfaced since the original plan or budget had been prepared. Companies with stock owned by the public were pressured to confirm or adjust annual estimates. The forecast horizon ended abruptly at the end of the company's fiscal year (see Figure 13.4).
In the 1980s a number of companies began extending the forecast horizon as they progressed through the year. For example, as the first quarter actual results were known, the forecast was extended to include the first quarter of the following year. Described as a “rolling forecast,” this methodology provided a full‐year future outlook on the financial results, as illustrated in Figure 13.5. This became extremely helpful in the final several months of a fiscal year, providing a view into the next year before the budget process had been complete.
My first encounter with rolling forecasts occurred in 1985. At that time, I was a division CFO of a technology unit of a large publicly traded company, and the corporation began requiring us to provide rolling forecasts. At first this was simply a mechanical exercise by the folks in finance to extrapolate or extend the current forecast one additional quarter. The projections were based on the prior‐year actuals and adjusted for any significant expected changes. Of course, we were not excited by the additional work and the perceived difficulty in developing an extended estimate of performance.
The true value of the rolling forecast became apparent after several months. A few major changes to our business had become apparent. We had several major nonrecurring sales that needed to be reflected as “one‐timers” and not built into our run rate or trend for setting expectations for the following year. We also recognized a serious competitive threat that would have a significant impact on our performance in the next fiscal year, now seven to eight months away. We included our initial estimated impact of these factors into our extended projections. More important, the management team developed a plan to address the threats, including the introduction of new products, revisions to pricing, and other actions to respond to the competitive threat well ahead of the annual planning timeline.
Additional value was realized during the annual planning process for the subsequent year. When we began this process in August, we had already begun to internalize and estimate these factors into projections for the first six months of the following year. This greatly simplified the preparation of our annual plan/budget.
The rolling forecast has gained wide acceptance and serves as the cornerstone of planning and projections for many organizations. It provides a good starting point for a more rigorous annual planning process, long‐term projections and scenarios, and “what if?” analysis. By far its greatest value is in providing an early view into future trends, upsides, and risks, thereby affording management more time to react to changes and drive performance.
Many organizations think of the forecast as a “business outlook” or “continuous business outlook.” Describing the forecast as a business outlook changes the view from a financial exercise to a business or operating process. Adding “continuous” or “on‐demand” signifies that it can be updated as required by the organization. We will explore the use of rolling forecasts and on‐demand business outlooks (DBOs) for the remainder of this chapter.
Despite the compelling case for using some form of rolling forecast/business outlook, surveys indicate many organizations have not adopted them. These organizations cite limited resources, capabilities, or enabling software. Many organizations envision the need to repeat the annual planning process four times per year! Getting started with rolling forecasts is much less formidable than most imagine.
To overcome the inertia inherent in starting a DBO initiative, I have found that a practical, phased approach is the best way to get started. Utilizing Microsoft Excel is recommended, especially since it is hard to define needs and evaluate and procure other software products without prior experience in using DBO models.
A clear statement of objectives will focus attention on developing a process that meets important needs and requirements. Most organizations point to one or more of the following objectives:
Start by reviewing the current planning and forecasting activities and products as described earlier in the chapter. What are the major problems and improvement opportunities? What are the most significant performance drivers? What issues give rise to variances from the plan?
Identification of critical business drivers is a critical step in developing a more effective and efficient forecast process, with the intent to extend the horizon of the projections. The key is to move away from a process that affords equal attention to all costs, expenses, and revenues. Identify the most significant drivers of performance. Here we can apply the 80/20 rule: 20% of the line items will represent 80% of the value. For example, the top 20% of products or programs will typically account for 80% of total revenues. The top 20% of line items of expenses (labor, facilities, materials, etc.) will typically account for 80% of all expenses.
Another important analysis is to identify those significant drivers that are most likely to fluctuate – that is, are most variable. Examples include revenues from new products or contracts, contract services, commodity prices, foreign currency fluctuations, and new home starts. These can be contrasted with drivers that are relatively stable and are more easily predicted by aggregation and extrapolation using trend analysis, such as salaries, facilities, and other costs. Critical assumptions should also be identified, including macroeconomic factors such as gross domestic product (GDP), political policy, and interest rates.
As we construct a DBO process and model, we will ensure that these critical drivers and assumptions are fully considered and emphasized, and that less important factors are deemphasized. Figure 13.6 highlights typical drivers that are emphasized in the development of business outlooks.
After stating the objectives and identifying critical performance drivers, we can begin to visualize an overview of the model. Most organizations should define the product (output) of the model to include the three basic financial statements (income statement, balance sheet, and statement of cash flows), analysis, and a presentation summary. Beginning with this end in mind, we can lay out the supporting schedules to forecast key elements of financial performance. For example, the revenue and product (or service) margin projections are of critical importance in all organizations. These supporting schedules should be constructed to incorporate the most significant and most variable business drivers and assumptions identified above.
This is a critical step in the process. We must be careful not to replicate the annual planning process here. Instead we need to be disciplined and thoughtful to construct a working model that incorporates the key drivers and assumptions, without resorting to the lowest level of detail. (See Figure 13.7.)
TABLE 13.2 Rolling Forecast Method
At the center of any outlook is a performance trend schedule (typically quarterly). This trend schedule should include prior year history, the current year plan/outlook, and provision for the next year's outlook. Table 13.2 illustrates a trend schedule for Thomas Technologies, Inc. The company has just closed out the second quarter of 2017. Under a traditional approach, the forecast horizon is compressed to the rest of 2017 (i.e. Q3 and Q4). To implement a rolling outlook, we simply need to extend the projections to include Q1 and Q2 for the subsequent year (2018). What is the minimal information we need to make reasonable estimates? We can start by reviewing the actual results of Q1 and Q2 of 2017. What items can be extrapolated from the previous periods or trends? What significant factors will shape the performance for these future periods? For example, for revenue, the projection must consider major product introductions and contract wins and losses.
For each income statement caption, I like to construct a one‐page supporting schedule that provides a capsule of information, including actual and projected financial results (presented in a way that is meaningful to the responsible operating manager) and includes all major assumptions and key drivers. By focusing on a one‐page summary at this level, we are forced to identify the most significant factors and drivers. It is important to tailor these schedules to each specific situation. Supporting schedules for product margins, gross margins, and marketing are illustrated in Tables 13.3 to 13.5. A complete, fully integrated forecast model is illustrated in the book's companion website.
TABLE 13.3 DBO Supporting Schedule: Product Margins
Thomas Technologies, Inc. | ||||||||||||
Product Margins | Trend Schedule | |||||||||||
2016 | 2017 | 2018 | ||||||||||
Product/Product Line | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 |
Product 1 | ||||||||||||
Average Selling Price | 4,850 | 4,850 | 4,850 | 4,850 | 4,900 | 4,900 | 4,900 | 4,900 | 4,900 | 4,900 | 4,900 | 4,999 |
Product Cost | 2,500 | 2,500 | 2,500 | 2,500 | 2,517 | 2,517 | 2,517 | 2,517 | 2,532 | 2,532 | 2,532 | 2,532 |
Unit Volume | 800 | 1,000 | 1,100 | 2,000 | 1,000 | 1,100 | 1,300 | 2,200 | 1,300 | 1,500 | 1,600 | 2,300 |
Revenue | 3,880,000 | 4,850,000 | 5,335,000 | 9,700,000 | 4,900,000 | 5,390,000 | 6,370,000 | 10,780,000 | 6,370,000 | 7,350,000 | 7,840,000 | 11,497,700 |
Product Costs | 2,000,000 | 2,500,000 | 2,750,000 | 5,000,000 | 2,517,000 | 2,768,700 | 3,272,100 | 5,537,400 | 3,291,600 | 3,798,000 | 4,051,200 | 5,823,600 |
Product Margin | 1,880,000 | 2,350,000 | 2,585,000 | 4,700,000 | 2,383,000 | 2,621,300 | 3,097,900 | 5,242,600 | 3,078,400 | 3,552,000 | 3,788,800 | 5,674,100 |
% | 48.5% | 48.5% | 48.5% | 48.5% | 48.6% | 48.6% | 48.6% | 48.6% | 48.3% | 48.3% | 48.3% | 49.3% |
Product 2 | ||||||||||||
Average Selling Price | 5,600 | 5,600 | 5,600 | 5,600 | 5,800 | 5,800 | 5,800 | 5,800 | 6,000 | 6,000 | 6,000 | 6,000 |
Product Cost | 2,912 | 2,912 | 2,912 | 2,912 | 2,950 | 2,950 | 2,950 | 2,950 | 3,200 | 3,200 | 3,200 | 3,200 |
Unit Volume | 4,000 | 3,800 | 3,700 | 4,000 | 3,600 | 3,700 | 3,500 | 3,800 | 3,050 | 3,000 | 3,100 | 3,050 |
Revenue | 22,400,000 | 21,280,000 | 20,720,000 | 22,400,000 | 20,880,000 | 21,460,000 | 20,300,000 | 22,040,000 | 18,300,000 | 18,000,000 | 18,600,000 | 18,300,000 |
Product Costs | 11,648,000 | 11,065,600 | 10,774,400 | 11,648,000 | 10,620,000 | 10,915,000 | 10,325,000 | 11,210,000 | 9,760,000 | 9,600,000 | 9,920,000 | 9,760,000 |
Product Margin | 10,752,000 | 10,214,400 | 9,945,600 | 10,752,000 | 10,260,000 | 10,545,000 | 9,975,000 | 10,830,000 | 8,540,000 | 8,400,000 | 8,680,000 | 8,540,000 |
% | 48.0% | 48.0% | 48.0% | 48.0% | 49.1% | 49.1% | 49.1% | 49.1% | 46.7% | 46.7% | 46.7% | 46.7% |
Product 3 | ||||||||||||
Average Selling Price | 1,575 | 1,575 | 1,575 | 1,575 | 1,575 | 1,575 | 1,575 | 1,575 | 1,575 | 1,575 | 1,575 | 1,575 |
Product Cost | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 |
Unit Volume | 1,500 | 1,550 | 1,600 | 1,650 | 1,550 | 1,600 | 1,700 | 1,750 | 1,950 | 1,950 | 2,100 | 2,050 |
Revenue | 2,362,500 | 2,441,250 | 2,520,000 | 2,598,750 | 2,441,250 | 2,520,000 | 2,677,500 | 2,756,250 | 3,071,250 | 3,071,250 | 3,307,500 | 3,228,750 |
Product Costs | 1,200,000 | 1,240,000 | 1,280,000 | 1,320,000 | 1,240,000 | 1,280,000 | 1,360,000 | 1,400,000 | 1,560,000 | 1,560,000 | 1,680,000 | 1,640,000 |
Product Margin | 1,162,500 | 1,201,250 | 1,240,000 | 1,278,750 | 1,201,250 | 1,240,000 | 1,317,500 | 1,356,250 | 1,511,250 | 1,511,250 | 1,627,500 | 1,588,750 |
% | 49.2% | 49.2% | 49.2% | 49.2% | 49.2% | 49.2% | 49.2% | 49.2% | 49.2% | 49.2% | 49.2% | 49.2% |
Product 4 | ||||||||||||
Average Selling Price | 2,900 | 2,900 | 2,900 | 2,900 | 2,900 | 3,000 | 3,000 | 3,000 | 3,000 | |||
Product Cost | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,600 | 1,600 | 1,600 | |||
Unit Volume | 400 | 500 | 600 | 800 | 900 | 900 | 1000 | 1300 | 1500 | |||
Revenue | – | – | – | 1,160,000 | 1,450,000 | 1,740,000 | 2,320,000 | 2,610,000 | 2,700,000 | 3,000,000 | 3,900,000 | 4,500,000 |
Product Costs | – | – | – | 600,000 | 750,000 | 900,000 | 1,200,000 | 1,350,000 | 1,350,000 | 1,600,000 | 2,080,000 | 2,400,000 |
Product Margin | – | – | – | 560,000 | 700,000 | 840,000 | 1,120,000 | 1,260,000 | 1,350,000 | 1,400,000 | 1,820,000 | 2,100,000 |
% | 48.3% | 48.3% | 48.3% | 48.3% | 48.3% | 50.0% | 46.7% | 46.7% | 46.7% | |||
Product 5 | ||||||||||||
Average Selling Price | 4,000 | 4,000 | 4,000 | 4,000 | 4,200 | 4,200 | 4,200 | 4,200 | ||||
Product Cost | 2,200 | 2,200 | 2,200 | 2,200 | 2,200 | 2,200 | 2,200 | 2,250 | ||||
Unit Volume | 100 | 200 | 300 | 400 | 800 | 1,000 | 1,100 | 1,500 | ||||
Revenue | – | – | – | – | 400,000 | 800,000 | 1,200,000 | 1,600,000 | 3,360,000 | 4,200,000 | 4,620,000 | 6,300,000 |
Product Costs | – | – | – | – | 220,000 | 440,000 | 660,000 | 880,000 | 1,760,000 | 2,200,000 | 2,420,000 | 3,375,000 |
Product Margin | – | – | – | – | 180,000 | 360,000 | 540,000 | 720,000 | 1,600,000 | 2,000,000 | 2,200,000 | 2,925,000 |
% | 45.0% | 45.0% | 45.0% | 45.0% | 47.6% | 47.6% | 47.6% | 46.4% | ||||
Total | ||||||||||||
Revenue | 28,642,500 | 28,571,250 | 28,575,000 | 35,858,750 | 30,071,250 | 31,910,000 | 32,867,500 | 39,786,250 | 33,801,250 | 35,621,250 | 38,267,500 | 43,826,450 |
Product Cost | 14,848,000 | 14,805,600 | 14,804,400 | 18,568,000 | 15,347,000 | 16,303,700 | 16,817,100 | 20,377,400 | 17,721,600 | 18,758,000 | 20,151,200 | 22,998,600 |
Product Margin | 13,794,500 | 13,765,650 | 13,770,600 | 17,290,750 | 14,724,250 | 15,606,300 | 16,050,400 | 19,408,850 | 16,079,650 | 16,863,250 | 18,116,300 | 20,827,850 |
% | 48.2% | 48.2% | 48.2% | 48.2% | 49.0% | 48.9% | 48.8% | 48.8% | 47.6% | 47.3% | 47.3% | 47.5% |
Y/Y Growth Rate | 5.0% | 11.7% | 15.0% | 11.0% | 12.4% | 11.6% | 16.4% | 10.2% |
Thomas Technologies, Inc. | |||||||||||||
Gross Margin | |||||||||||||
2016 | 2017 | 2018 | |||||||||||
Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | ||
Sales | 28,642,500 | 28,571,250 | 28,575,000 | 35,858,750 | 30,071,250 | 31,910,000 | 32,867,500 | 39,786,250 | 33,801,250 | 35,621,250 | 38,267,500 | 43,826,450 | |
Product COGS | 14,848,000 | 14,805,600 | 14,804,400 | 18,568,000 | 15,347,000 | 16,303,700 | 16,817,100 | 20,377,400 | 17,721,600 | 18,758,000 | 20,151,200 | 22,998,600 | |
Product Margin | 13,794,500 | 13,765,650 | 13,770,600 | 17,290,750 | 14,724,250 | 15,606,300 | 16,050,400 | 19,408,850 | 16,079,650 | 16,863,250 | 18,116,300 | 20,827,850 | |
% to Sales | 48.2% | 48.2% | 48.2% | 48.2% | 49.0% | 48.9% | 48.8% | 48.8% | 47.6% | 47.3% | 47.3% | 47.5% | |
Other Costs | |||||||||||||
Production Variances | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | |
Warranty | 1.0% | 286,425 | 285,713 | 285,750 | 358,588 | 300,713 | 319,100 | 328,675 | 397,863 | 338,013 | 356,213 | 382,675 | 438,265 |
Inventory Provisions | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | |
Royalty | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | |
Scrap | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | |
Sustaining Engineering | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | |
Other | 24,535 | 24,392 | 24,400 | 38,967 | 27,392 | 31,070 | 32,985 | 46,822 | 34,852 | 38,492 | 44,285 | 54,902 | |
Total Other COGS | 343,710 | 342,855 | 342,900 | 430,305 | 360,855 | 382,920 | 394,410 | 477,435 | 405,615 | 427,455 | 459,710 | 525,917 | |
% to Sales | |||||||||||||
Total COGS | 15,191,710 | 15,148,455 | 15,147,300 | 18,998,305 | 15,707,855 | 16,686,620 | 17,211,510 | 20,854,835 | 18,127,215 | 19,185,455 | 20,610,910 | 23,524,517 | |
Gross Margin | 13,450,790 | 13,422,796 | 13,427,700 | 16,860,446 | 14,363,396 | 15,223,380 | 15,655,990 | 18,931,416 | 15,674,036 | 16,435,796 | 17,656,590 | 20,301,934 | |
% to Sales | 47.0% | 47.0% | 47.0% | 47.0% | 47.8% | 47.7% | 47.6% | 47.6% | 46.4% | 46.1% | 46.1% | 46.3% | |
Headcount | 2,864 | 2,857 | 2,858 | 3,586 | 3,007 | 3,191 | 3,287 | 3,979 | 3,380 | 3,562 | 3,827 | 4,383 |
TABLE 13.5 DBO Supporting Schedule: Marketing
Thomas Technologies, Inc. | |||||||||||||
Marketing | Trend Schedule | ||||||||||||
2016 | 2017 | 2018 | |||||||||||
Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | ||
People Costs | |||||||||||||
Salary | 745,000 | 745,000 | 745,000 | 745,000 | 782,250 | 785,138 | 785,138 | 900,138 | 939,395 | 939,397 | 939,397 | 939,397 | |
Bonus | 195,000 | 150,000 | 221,000 | ||||||||||
Other | |||||||||||||
Total | 745,000 | 745,000 | 745,000 | 940,000 | 782,250 | 785,138 | 785,138 | 1,050,138 | 939,395 | 939,397 | 939,397 | 1,160,397 | |
Fringe Benefits | 17% | 126,650 | 126,650 | 126,650 | 126,650 | 132,983 | 133,473 | 133,473 | 153,023 | 159,697 | 159,697 | 159,697 | 159,697 |
Total Labor and Related Costs | 1,616,650 | 1,616,650 | 1,616,650 | 2,006,650 | 1,697,483 | 1,703,749 | 1,703,749 | 2,253,299 | 2,038,487 | 2,038,491 | 2,038,491 | 2,480,491 | |
Travel | 6,000 | 6,000 | 6,000 | 6,000 | 8,500 | 8,500 | 10,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | |
Meetings | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | |
Consultants | – | 2,000 | 1,500 | 5,000 | – | 2,000 | 1,500 | 5,000 | – | 2,000 | 1,500 | 5,000 | |
Professional Services | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | |
Materials | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | 4,200 | |
Contract Services | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | 1,200 | |
Advertising | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | |
Trade Show | 15,000 | 17,000 | 22,000 | ||||||||||
Product Launch | 15,000 | 25,000 | |||||||||||
Depreciation | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | |
Allocations In | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | |
Other | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | |
Total Other Expenses | 48,400 | 65,400 | 64,900 | 53,400 | 75,900 | 69,900 | 53,900 | 59,400 | 76,400 | 56,400 | 55,900 | 59,400 | |
Total Marketing | 1,665,050 | 1,682,050 | 1,681,550 | 2,060,050 | 1,773,383 | 1,773,649 | 1,757,649 | 2,312,699 | 2,114,887 | 2,094,891 | 2,094,391 | 2,539,891 | |
Year to Year Growth | 6.5% | 5.4% | 4.5% | 12.3% | 19.3% | 18.1% | 19.2% | 9.8% | |||||
Sales | 28,642,500 | 28,571,250 | 28,575,000 | 35,858,750 | 30,071,250 | 31,910,000 | 32,867,500 | 39,786,250 | 33,801,250 | 35,621,250 | 38,267,500 | 43,826,450 | |
Marketing % of Sales | 5.8% | 5.9% | 5.9% | 5.7% | 5.9% | 5.6% | 5.3% | 5.8% | 6.3% | 5.9% | 5.5% | 5.8% | |
Salaries | |||||||||||||
CMO | 1 | 145,000 | 145,000 | 145,000 | 145,000 | 152,250 | 152,250 | 152,250 | 152,250 | 159,863 | 159,863 | 159,863 | 159,863 |
Advertising Manager | 1 | 125,000 | 125,000 | 125,000 | 125,000 | 131,250 | 131,250 | 131,250 | 131,250 | 137,813 | 137,813 | 137,813 | 137,813 |
Web Techs | 2 | 180,000 | 180,000 | 180,000 | 180,000 | 189,000 | 189,000 | 189,000 | 189,000 | 198,450 | 198,450 | 198,450 | 198,450 |
Advertising Manager | 1 | 125,000 | 125,000 | 125,000 | 125,000 | 131,250 | 131,250 | 131,250 | 131,250 | 137,813 | 137,813 | 137,813 | 137,813 |
Marketing Manager | 1 | 115,000 | 115,000 | 115,000 | 115,000 | 120,750 | 120,750 | 120,750 | 120,750 | 126,788 | 126,788 | 126,788 | 126,788 |
Admin | 1 | 55,000 | 55,000 | 55,000 | 55,000 | 57,750 | 60,638 | 60,638 | 60,638 | 63,670 | 63,670 | 63,670 | 63,670 |
New Hire Web Manager | 1 | 115,000 | 115,000 | 115,000 | 115,000 | 115,000 | |||||||
Total Salaries | 745,000 | 745,000 | 745,000 | 745,000 | 782,250 | 785,138 | 785,138 | 900,138 | 939,395 | 939,397 | 939,397 | 939,397 | |
Headcount | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 |
The supporting schedules roll up to an income statement presenting the forecast for the extended forecast horizon in Table 13.6.
TABLE 13.6 DBO Income Statement
To provide a complete view of expected financial performance, financial projections in the rolling forecast should include the P&L statement, balance sheet, and statement of cash flows. Many forecasts focus only on the P&L, which does not provide a complete picture of the financial performance of the organization.
There are two reasons for this. First, the focus for many companies is on earnings per share (EPS) and therefore all attention is directed to the P&L. Even where the CEO is primarily focused on the P&L and EPS, finance should continue to prepare and present the key balance sheet and cash flow projections. Most competent finance and general managers understand that profit must be evaluated in the context of the investment levels required. Therefore, measures such as asset turnover and return on investment should be presented. Attention to cash balances, liquidity, intermediate financing, and loan covenants are all important responsibilities of financial management and should be incorporated into all projections.
The second reason is that finance teams are much more comfortable in the mechanics of revenue and expense projections. However, once key models are established, it is relatively easy to project key balance sheet and cash flow information. An illustration of a balance sheet and cash flow model is provided in Table 13.7. Techniques to project the balance sheet and cash flow are found in Chapters 17 and 18.
TABLE 13.7 DBO Supporting Schedule: Balance Sheet and Cash Flow
Thomas Technologies, Inc. | |||||||||||||
Balance Sheet Cash Flow | |||||||||||||
2016 | 2017 | 2018 | |||||||||||
Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | ||
Cash | 3,200,000 | 5,357,998 | 7,766,628 | 1,424,420 | 11,386,158 | 11,388,505 | 12,720,574 | 7,591,316 | 16,594,076 | 16,246,931 | 15,631,502 | 12,252,044 | |
Receivables | 90.0 | 28,642,500 | 28,571,250 | 28,575,000 | 35,858,750 | 30,071,250 | 31,910,000 | 32,867,500 | 39,786,250 | 33,801,250 | 35,621,250 | 38,267,500 | 43,826,450 |
Inventories | 3.0 | 19,797,333 | 19,740,800 | 19,739,200 | 24,757,333 | 20,462,667 | 21,738,267 | 22,422,800 | 27,169,867 | 23,628,800 | 25,010,667 | 26,868,267 | 30,664,800 |
Other | |||||||||||||
Current Assets | 51,639,833 | 53,670,048 | 56,080,828 | 62,040,503 | 61,920,075 | 65,036,771 | 68,010,874 | 74,547,432 | 74,024,126 | 76,878,847 | 80,767,269 | 86,743,294 | |
PP&E | 25,000,000 | 25,750,000 | 26,150,000 | 27,250,000 | 28,250,000 | 29,250,000 | 30,250,000 | 31,250,000 | 32,250,000 | 33,250,000 | 34,250,000 | 35,250,000 | |
Accumulated Depreciation | 12,000,000 | 13,000,000 | 14,000,000 | 15,000,000 | 16,000,000 | 17,000,000 | 18,000,000 | 19,000,000 | 20,000,000 | 21,000,000 | 22,000,000 | 23,000,000 | |
Net Fixed Assets | 13,000,000 | 12,750,000 | 12,150,000 | 12,250,000 | 12,250,000 | 12,250,000 | 12,250,000 | 12,250,000 | 12,250,000 | 12,250,000 | 12,250,000 | 12,250,000 | |
Net Goodwill and Intangibles | 24,000,000 | 23,500,000 | 23,000,000 | 22,500,000 | 22,000,000 | 21,500,000 | 21,000,000 | 20,500,000 | 20,000,000 | 19,500,000 | 19,000,000 | 18,500,000 | |
Other Noncurrent Assets | |||||||||||||
Total Assets | 88,639,833 | 89,920,048 | 91,230,828 | 96,790,503 | 96,170,075 | 98,786,771 | 101,260,874 | 107,297,432 | 106,274,126 | 108,628,847 | 112,017,269 | 117,493,294 | |
Accounts Payable | 20.0% | 5,728,500 | 5,714,250 | 5,715,000 | 7,171,750 | 6,014,250 | 6,382,000 | 6,573,500 | 7,957,250 | 6,760,250 | 7,124,250 | 7,653,500 | 8,765,290 |
Notes Payable, Bank | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | 1,000,000 | |
Accrued Expenses & Taxes | 18.0% | 5,155,650 | 5,142,825 | 5,143,500 | 6,454,575 | 5,412,825 | 5,743,800 | 5,916,150 | 7,161,525 | 6,084,225 | 6,411,825 | 6,888,150 | 7,888,761 |
Current Liabilities | 11,884,150 | 11,857,075 | 11,858,500 | 14,626,325 | 12,427,075 | 13,125,800 | 13,489,650 | 16,118,775 | 13,844,475 | 14,536,075 | 15,541,650 | 17,654,051 | |
Long‐Term Debt | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | 12,000,000 | |
Other | ‐ | ||||||||||||
Stockholders' Equity | 64,498,658 | 65,805,948 | 67,115,303 | 69,907,153 | 71,485,975 | 73,403,946 | 75,514,198 | 78,921,632 | 80,172,626 | 81,835,747 | 84,218,594 | 87,582,218 | |
Total Liabilities and Equity | 88,382,808 | 89,663,023 | 90,973,803 | 96,533,478 | 95,913,050 | 98,529,746 | 101,003,848 | 107,040,407 | 106,017,101 | 108,371,822 | 111,760,244 | 117,236,269 | |
Proof | 257,025 | 257,025 | 257,025 | 257,025 | 257,025 | 257,025 | 257,025 | 257,025 | 257,025 | 257,025 | 257,025 | 257,025 | |
Operating Capital | 37,555,683 | 37,454,975 | 37,455,700 | 46,989,758 | 39,106,842 | 41,522,467 | 42,800,650 | 51,837,342 | 44,585,575 | 47,095,842 | 50,594,117 | 57,837,199 | |
Total Debt | 13,000,000 | 13,000,000 | 13,000,000 | 13,000,000 | 13,000,000 | 13,000,000 | 13,000,000 | 13,000,000 | 13,000,000 | 13,000,000 | 13,000,000 | 13,000,000 | |
Invested Capital | |||||||||||||
Cash Flow | |||||||||||||
Net Income | 1,355,725 | 1,319,290 | 1,321,355 | 2,803,850 | 1,590,822 | 1,929,971 | 2,122,252 | 3,419,434 | 1,262,994 | 1,675,121 | 2,394,847 | 3,375,624 | |
D&A | 1,400,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | |
Capital Expenditures | 600,000 | (750,000) | (400,000) | (1,100,000) | (1,000,000) | (1,000,000) | (1,000,000) | (1,000,000) | (1,000,000) | (1,000,000) | (1,000,000) | (1,000,000) | |
(Inc) Decrease in OC | 500,000 | 100,708 | (725) | (9,534,058) | 7,882,917 | (2,415,625) | (1,278,183) | (9,036,692) | 7,251,767 | (2,510,267) | (3,498,275) | (7,243,082) | |
OCF | 3,855,725 | 2,169,998 | 2,420,630 | (6,330,208) | 9,973,738 | 14,346 | 1,344,069 | (5,117,258) | 9,014,761 | (335,146) | (603,428) | (3,367,458) | |
Dividends | (2,000) | (2,000) | (2,000) | (2,000) | (2,000) | (2,000) | (2,000) | (2,000) | (2,000) | (2,000) | (2,000) | (2,000) | |
Share Proceeds (Repurchases) | (10,000) | (10,000) | (10,000) | (10,000) | (10,000) | (10,000) | (10,000) | (10,000) | (10,000) | (10,000) | (10,000) | (10,000) | |
Other | |||||||||||||
Debt (Payments) Borrowing | |||||||||||||
Cash Flow | 3,843,725 | 2,157,998 | 2,408,630 | (6,342,208) | 9,961,738 | 2,346 | 1,332,069 | (5,129,258) | 9,002,761 | (347,146) | (615,428) | (3,379,458) | |
Sales | 28,642,500 | 28,571,250 | 28,575,000 | 35,858,750 | 30,071,250 | 31,910,000 | 32,867,500 | 39,786,250 | 33,801,250 | 35,621,250 | 38,267,500 | 43,826,450 | |
DSO | 90.0 | 90.0 | 90.0 | 90.0 | 90.0 | 90.0 | 90.0 | 90.0 | 90.0 | 90.0 | 90.0 | 90.0 | |
Inventory Turns | 3.0 | 3.0 | 3.0 | 3.0 | 3.0 | 3.0 | 3.0 | 3.0 | 3.0 | 3.0 | 3.0 | 3.0 | |
DSI | 121.7 | 121.7 | 121.7 | 121.7 | 121.7 | 121.7 | 121.7 | 121.7 | 121.7 | 121.7 | 121.7 | 121.7 | |
Asset Turnover | 1.3 | 1.3 | 1.3 | 1.5 | 1.3 | 1.3 | 1.3 | 1.5 | 1.3 | 1.3 | 1.4 | 1.5 | |
Debt to Total Capital (Book) | 16.8% | 16.5% | 16.2% | 15.7% | 15.4% | 15.0% | 14.7% | 14.1% | 14.0% | 13.7% | 13.4% | 12.9% |
The most effective way to review and present the results of a revised forecast or outlook is to incorporate a presentation summary directly into the forecast model. This will facilitate review, discussions with managers, and revisions. It enables a high‐level quality control review of the projections, since the presentation summary will include key variables. Key items that are typically included are major assumptions, changes from prior outlook, key performance metrics, and major risks and upsides. An example of a presentation summary is provided in Figure 13.8.
The frequency and timing of forecasts will depend on several factors. A very dynamic environment will require more frequent updates than a stable environment. Companies that report earnings and provide earnings or other guidance to public capital markets typically use a quarterly cycle. Private companies typically update the outlook around management or board of directors meetings. Significant events, such as contract awards or losses, may dictate a special revision to the business outlook.
In Chapter 12, we introduced tools for analyzing and evaluating projections. These tools should be incorporated into the DBO model. For short‐term projections, revenue and expense levels can be compared to current run rates and results from the prior period. It is vital to identify and evaluate critical assumptions included in the projections.
The pace of change in the world today requires most organizations to create more effective planning and forecasting processes. Most organizations have developed an operating plan to replace the financially focused budget process of old. Due to the pace of change, organizations must frequently update business projections. Organizations need a process to project financial performance periodically, as well as on demand, to perform what‐if analysis to evaluate the impact of potential changes and strategic alternatives.
The on‐demand business outlook is yet another evolution in planning and forecasting. On‐demand refers to the ability to update the business projections at any time. The term business outlook shifts the perception from a financial drill to an outlook of business trends and factors.