13
BUDGETS, OPERATING PLANS, AND FORECASTS

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.

THE BUDGETING PROCESS

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.

Traditional Budgeting Process

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.

Flow diagram of a historical budget and control process starting from “Development of Detail Budget Estimates” to “Review and Revisions,” to “Board Approval,” then to “Actuals Compared to Budget.”

FIGURE 13.1 Traditional Budget and Control Process

Departmental managers complete budget forms for their respective areas of responsibility as illustrated in Table 13.1.

TABLE 13.1 Traditional Departmental Budget image

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.

A financial statement sheet of Mangham Distributors displaying boxes for labor and related costs and other (left), Field Sales (middle), and Profit and loss (right) linked by arrows.

FIGURE 13.2 Budget Roll‐Up Illustration image

Problems with Traditional Budgeting

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.

THE OPERATING PLAN

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:

  • Assess the current situation.
  • Review strategic objectives and initiatives.
  • Establish performance goals and targets.
  • Identify business drivers and critical assumptions.
  • Develop the game plan for next 12 months.
  • Develop multiple scenarios.

Assess Current Situation

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.

Review Strategic Objectives

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.

Establish Performance Goals and Targets

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:

  • Strategic plan
  • Business model
  • Recent performance trends
  • Benchmarking and competitor analysis
  • Objectives for value creation

Develop a Game Plan

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.

Develop Preliminary Financial Projections

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.

Identify Critical Assumptions and Key Actions

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.

Identify Upside and Downside Events and Develop Multiple Scenarios

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.

Communicate Plan Objectives and Targets

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.

Develop Process to Monitor Key Assumptions and Track Progress

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.

Evaluate the Annual Plan Process

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.

Dashboard for evaluation of operating plan with four bar graphs for plan duration, number of iterations, actual profit variance from plan, and profit change: 1st iteration to final plan.

FIGURE 13.3 Dashboard: Evaluation of Operating Plan image

BUSINESS FORECASTS AND OUTLOOKS

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.

Historical Evolution of Forecasts

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).

Horizontal stacked bars for forecast horizon with stacked bars labeled “Actual” and “Forecast” along rows for October 2016, 2017 operating plan, January 2017, April 2017, July 2017, October 2017, etc.

FIGURE 13.4 Traditional Forecast Horizon

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.

Horizontal stacked bars for rolling forecast/outlook overview with stacked bars labeled “Actual” and “Forecast” along rows for October 2016, 2017 operating plan, January 2017, April 2017, July 2017, etc.

FIGURE 13.5 Rolling Forecast: Business Outlook Horizon

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.

Continuous Business Outlook/On‐Demand Business Outlook

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.

Implementing Rolling Forecasts/Business Outlooks

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.

Getting Started: A Practical Approach

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.

Articulate the Objectives of Developing the On‐Demand Business Outlook

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:

  • Provide a view into expected performance for the next 12 months. This will engage the organization more frequently and reduce surprises that arise in one‐year planning cycles.
  • Provide a timely basis for setting future expectations with executives, boards of directors, and investors.
  • Identify performance trends and estimate future impact.
  • Identify issues and opportunities that will impact future performance.
  • Afford the greatest lead time possible to address problems and opportunities.
  • Reduce inefficiencies and effort in the annual planning process.

Document and Review Current Operating Plans, Budgets, and Forecasts

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?

Identify Critical Business Drivers

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.

Business outlooks/rolling forecast depicted by 6 boxes containing lists for Revenue and margins, Major investments, Significant cost drivers, Human capital plan, Macro economic factors, and Risks and upsides.

FIGURE 13.6 Reflect Critical Drivers in Business Outlook

Design Process and Model Architecture

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.)

Diagram with a box labeled revenue and cost projections with thick arrows pointing to a box labeled financial statements (income statement, balance sheet, and cash flow), then to analysis and presentation.

FIGURE 13.7 Business Outlook Architecture Map

TABLE 13.2 Rolling Forecast Method image

image
image

Practical Implementation Path

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 image

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%

TABLE 13.4 DBO Supporting Schedule: Gross Margins image

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 image

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 image

image
image

Comprehensive Financial Picture

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 image

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%

Summarizing and Presenting Business Forecasts and Outlooks

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.

Dashboard for DBO presentation summary with bar graphs for revenue trend and Y/Y growth, revenue trends by product, operating income, operating expenses, headcount, operation cash flow and ending cash, etc.

FIGURE 13.8 DBO Presentation Summary image

Frequency and Timing of Forecasts

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.

Analysis and Evaluation of Financial Projections

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.

SUMMARY

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.

NOTE

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset