Welcome!

Agile Computing Authors: Liz McMillan, Pat Romanski, Elizabeth White, John Basso, Kevin Benedict

Related Topics: @CloudExpo, Microservices Expo

@CloudExpo: Article

Cloud Finance: Best Practices for Implementing Rolling Forecasts

How rolling forecasts can enable sound Business Decisions

Everyone wants a crystal ball to be able to peer into the future. For businesses, that desire becomes a necessity because having a vision of the future allows for better and more strategic decision making in the present.

Rolling forecasts built on driver-based and project-based planning do just that, creating a framework that supports better decision making. A rolling forecast simply means that each quarter or month, a company projects four to six quarters or 12 to 18 months ahead.

This allows executives and key decision-makers to see both a financial and operational vision of the future. It also helps them assess next steps in their execution of their plan, understand critical pivot points in the plan and better judge the impact the economy may have on their plan.

We have seen rolling forecasts can replace annual planning cycles with a continual planning process that results in more regular business reviews that look to the future. These reviews enable managers to understand problems, challenges and trends sooner and improve their proactive approach to those problems, challenges and trends.

Here are the top 10 best practices for implementing them:

1. You need a system and Excel is not a system (it's a personal productivity tool). In the next nine best practices we will outline functionality and practices that will outstrip the capability of Excel spreadsheets. The challenge we have seen arises when companies start rolling forecasts in Excel and then can't keep them up to date because it isn't just a single forecast. Once a baseline forecast is created, additional analysis/versions will be required to:

  • Understand the impact of major and minor alterations to the plan
  • Run the plan against different drivers
  • Copy the plan as a baseline for other plans
  • Perform variance and sensitivity analysis

To get the most out of rolling forecasts you need a system that can provide the necessary functionality to accommodate your budget, forecasting, planning, strategic management and measurement needs. Excel will be to labor intensive, prone to error and too difficult to provide the reporting.

2. Understand your objectives of creating a rolling forecast. This will drive all of the other best practices related to rolling forecasts. While the overall objective of planning is to a) create a financial view of the vision for the future and to know the decisions you need to make and b) understand the financial impact of those decisions before you need to make them, your objectives and focus for the rolling forecast will dictate the areas of the plan that need more detail. As an example:

  • If your strategic plan calls for acquisitions you may consider building the plan with a high-level summary input of drivers that help plan for acquisitions.
  • If you want to better manage finished goods inventory you may focus more on customer/product forecasts and inventory management.
  • If cash is tight you will want to focus on timing of events around cash, i.e., payables and receivables policies, cash borrowings, line of credit.

The challenge is, there isn't one overriding holistic model format that allows you to account for all of these in a first pass rolling forecast implementation.

3. Identify the rolling forecast duration. The challenge with rolling forecast duration is it sounds easy until you put pen to paper and begin to implement it. There are a number of questions:

  • Will you re-forecast every month or every quarter? (many of our customers re-forecast monthly)
  • Will you add a new month to every forecast or just add a new quarter at quarter end? (our customers either add new periods quarterly or start planning for a two year time frame)
  • How long should the rolling forecast be--12 months 15 months 18 months, or should you start by forecasting out two years and at the end of the first year tack on another year?
  • How will the mechanics work of rolling in actual?

As a starting point, make sure your forecasting time frames are consistent with your business cycle and business needs. If sales 15 months from now are dependent on capital expenditures today, it is important to create rolling forecasts out past 15 months. It is also important to have a minimum of quarterly bias to the rolling forecast. That is, don't tack on an additional month to a rolling forecast at the end of every month, wait until quarter end and then add a new quarter, otherwise each month you are making preparers think about a new forecast period.

4. Identify the rolling forecast comparison periods. While this sounds relatively straightforward, it gets tricky when you consider the need for comparison columns in reporting. It is tricky because you need to compare to multiple periods/combinations of actual and forecast. With annual plans we compare the combination current year actual for closed periods and forecast for remaining periods to last year actual. We think in terms of annual sales and annualized expenses. With rolling forecasts we need to also roll in the actual and shift the comparison periods. We must be able to not only provide annual comparisons, (i.e. How will this year compare to last year?, Where will we end up for this year?) but we also need to provide how this 12/15/18 month rolling plan compares to the 12/15/18 actual results. This requires access to roll the forecast periods but also roll the comparison periods, for not just actual, but also for prior year actual.

5. Understand/analyze the dynamics of revenue and expense in your business and their related drivers. Rolling forecasts won't work if you create them from a bottom up forecast every quarter--they need to be driver based. This provides flexibility in the planning process and agility when you re-plan or create alternate plans. It also helps managers focus on what is really important. Over time, some of the drivers will be replaced if they are found as an inconsistent predictor of results and the stronger drivers will evolve to KPIs and used for goal setting. In addition, over time forecasts will also start to use consistent models and model drivers.

As an example, sales units should drive production volumes. Price increases could drive (or be driven by) material and labor cost increases.

To help understand what drives your business you can ask these questions:

  • How does this line item affect our bottom line?
  • Will $1 (pick appropriate unit of measure, thousands, millions, billions) in sales affect this account?
  • How does this number change our bottom line?

To be successful doing rolling forecasts it is important to use drivers to eliminate detail while creating a realistic expectation about the future.

6. Plan capital and strategic projects separately from the rolling forecast. Capital and strategic projects should be layered separately into the plan. Projects have two unique characteristics that require this:

  • They are time independent of a typical rolling forecast. Projects can last months to years and treating them with the same duration as a forecast doesn't provide the complete story around the projects.
  • They typically have a lot of dependencies which means project expenditures can be moved out or in a plan for a variety of reasons.

Projects should be treated as separate entity/profit center and have the ability to be move in and out of rolling forecasts. In addition they should have the ability to move time frames and adjust for changes in project scope.

7. Start with a small select group of key department/operations managers, plan on increasing the scope over time and plan on continual improvement over time. While conventional wisdom is to involve as many participants as possible, many companies find it easier to start with a small group that cuts across the major departments and gradually involve more executives, lines of business managers and operational managers as processes, methods are refined. Let the small group get some practice with the process. It will help flush out the process and the more practice they have at preparing forecasts, the better they will become and the more mentoring they can provide as you add additional participants. Typically there is a risk (including career risk) if you roll something out that isn't totally baked or based on theory, which could result in confusion, especially if you are doing it with a large group within the company.

As you expand the scope of the plan and the more people share in the plan the closer to reality the plan will be and the better the execution.

In addition you should plan for and build in a process of continual improvement. Managers should learn from their forecast accuracy record by carrying out postmortems on forecast. The objective is not to punish the guilty but to better understand how to do better, what changed, what were we surprised about, where what should we do differently to turn out better forecasts. To improve forecast, it is important to understand the cause for variability and learn to reduce them through postmortems.

8. Consider the rolling forecast as your baseline plan. Once you have the completed rolling forecast for the period/month, use it as your baseline plan. From this plan finance can massage drivers, adjust values and analyzing alternate scenarios, black swan events and potential significant events, to create a picture of alternate futures and be prepared to make decisions if situations arise.

This does requires the flexibility in the tool you are using to "mash up" scenarios and compare scenarios from different sources.

9. Tie your rolling forecast to your strategic plan. Rolling forecasts, if well prepared, form the backbone of a new and much more useful information system that connects all the pieces of the organization and gives senior management a continuous picture of both the current position and the short term outlook.

10. Analyze/understand how external conditions impact your performance. Business does not operate in a vacuum. Plan on qualifying the key external drivers of your business.

Do not confuse rolling forecasts with targets you receive your bonus on. Regarding targets and profitability, is it better to hit your target or gain targeted market share? Leading organizations are placing forecasting at the center of the management process. It becomes the essential tool for business managers to support their decision making, not just another management chore that needs to be done and they are basing targets not on fixed revenue numbers but rather percentages based on external market indicators.

Adaptive organizations focus less on annual budgets targets or long-term views/targets generated from within the company based on incremental sales and income year over year and focus more on rolling views and goals based on market conditions like achieving market share or achieving cost efficiencies over the competition by benchmarking against competition or similar public companies.

One Caution
As you consider implementing rolling forecasts remember the purpose is to provide a vision for the future and support better decisions. If you try to motivate behavior based on this forecast the results and plans get skewed and the usefulness of the solution is compromised. Forecasts should not be used by executive management as a tool for questioning or reassessing performance targets. This means forecasts and targets must be independent if you want to obtain both relevant action plans and reliable forecasts that allow risks and opportunities to be identified and corrective action taken in the best interest of the company (which may be in conflict with the target). If you do merge the two, the term "sandbagging" comes to mind.

Conclusion
Many businesses have yet to discover the full benefits of evolving their planning process to include complete and accurate rolling forecasts. With so many external factors that affect the bottom line for these businesses, including the volatility of the economy, creating rolling forecasts is a sound way to ensure strategic decisions are made. Businesses need an accurate picture of a future in order to chart a course towards it.

More Stories By Jon Kondo

Jon Kondo is president and CEO at Host Analytics, a leading provider of Software-as-a-Service (SaaS) based Corporate Performance Management (CPM) solutions. As CEO, he has led the company to record growth, partnerships, and industry accolades. Jon holds an MBA from Thunderbird School of Global Management and a BA in Business Economics from UC Santa Barbara.

@ThingsExpo Stories
Early adopters of IoT viewed it mainly as a different term for machine-to-machine connectivity or M2M. This is understandable since a prerequisite for any IoT solution is the ability to collect and aggregate device data, which is most often presented in a dashboard. The problem is that viewing data in a dashboard requires a human to interpret the results and take manual action, which doesn’t scale to the needs of IoT.
Internet of @ThingsExpo has announced today that Chris Matthieu has been named tech chair of Internet of @ThingsExpo 2016 Silicon Valley. The 6thInternet of @ThingsExpo will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA.
CenturyLink has announced that application server solutions from GENBAND are now available as part of CenturyLink’s Networx contracts. The General Services Administration (GSA)’s Networx program includes the largest telecommunications contract vehicles ever awarded by the federal government. CenturyLink recently secured an extension through spring 2020 of its offerings available to federal government agencies via GSA’s Networx Universal and Enterprise contracts. GENBAND’s EXPERiUS™ Application...
What does it look like when you have access to cloud infrastructure and platform under the same roof? Let’s talk about the different layers of Technology as a Service: who cares, what runs where, and how does it all fit together. In his session at 18th Cloud Expo, Phil Jackson, Lead Technology Evangelist at SoftLayer, an IBM company, spoke about the picture being painted by IBM Cloud and how the tools being crafted can help fill the gaps in your IT infrastructure.
SYS-CON Events announced today the Enterprise IoT Bootcamp, being held November 1-2, 2016, in conjunction with 19th Cloud Expo | @ThingsExpo at the Santa Clara Convention Center in Santa Clara, CA. Combined with real-world scenarios and use cases, the Enterprise IoT Bootcamp is not just based on presentations but with hands-on demos and detailed walkthroughs. We will introduce you to a variety of real world use cases prototyped using Arduino, Raspberry Pi, BeagleBone, Spark, and Intel Edison. Y...
Much of IT terminology is often misused and misapplied. Modernization and transformation are two such terms. They are often used interchangeably even though they mean different things and have very different connotations. Indeed, it is somewhat safe to assume that in IT any transformative effort is likely to also have a modernizing effect, and thus, we can see these as levels of improvement efforts. However, many businesses are being led to believe if they don’t transform now they risk becoming ...
SYS-CON Events announced today that LeaseWeb USA, a cloud Infrastructure-as-a-Service (IaaS) provider, will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. LeaseWeb is one of the world's largest hosting brands. The company helps customers define, develop and deploy IT infrastructure tailored to their exact business needs, by combining various kinds cloud solutions.
The best-practices for building IoT applications with Go Code that attendees can use to build their own IoT applications. In his session at @ThingsExpo, Indraneel Mitra, Senior Solutions Architect & Technology Evangelist at Cognizant, provided valuable information and resources for both novice and experienced developers on how to get started with IoT and Golang in a day. He also provided information on how to use Intel Arduino Kit, Go Robotics API and AWS IoT stack to build an application tha...
Whether your IoT service is connecting cars, homes, appliances, wearable, cameras or other devices, one question hangs in the balance – how do you actually make money from this service? The ability to turn your IoT service into profit requires the ability to create a monetization strategy that is flexible, scalable and working for you in real-time. It must be a transparent, smoothly implemented strategy that all stakeholders – from customers to the board – will be able to understand and comprehe...
It’s 2016: buildings are smart, connected and the IoT is fundamentally altering how control and operating systems work and speak to each other. Platforms across the enterprise are networked via inexpensive sensors to collect massive amounts of data for analytics, information management, and insights that can be used to continuously improve operations. In his session at @ThingsExpo, Brian Chemel, Co-Founder and CTO of Digital Lumens, will explore: The benefits sensor-networked systems bring to ...
SYS-CON Events announced today that Venafi, the Immune System for the Internet™ and the leading provider of Next Generation Trust Protection, will exhibit at @DevOpsSummit at 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Venafi is the Immune System for the Internet™ that protects the foundation of all cybersecurity – cryptographic keys and digital certificates – so they can’t be misused by bad guys in attacks...
"Tintri was started in 2008 with the express purpose of building a storage appliance that is ideal for virtualized environments. We support a lot of different hypervisor platforms from VMware to OpenStack to Hyper-V," explained Dan Florea, Director of Product Management at Tintri, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Identity is in everything and customers are looking to their providers to ensure the security of their identities, transactions and data. With the increased reliance on cloud-based services, service providers must build security and trust into their offerings, adding value to customers and improving the user experience. Making identity, security and privacy easy for customers provides a unique advantage over the competition.
Is your aging software platform suffering from technical debt while the market changes and demands new solutions at a faster clip? It’s a bold move, but you might consider walking away from your core platform and starting fresh. ReadyTalk did exactly that. In his General Session at 19th Cloud Expo, Michael Chambliss, Head of Engineering at ReadyTalk, will discuss why and how ReadyTalk diverted from healthy revenue and over a decade of audio conferencing product development to start an innovati...
For basic one-to-one voice or video calling solutions, WebRTC has proven to be a very powerful technology. Although WebRTC’s core functionality is to provide secure, real-time p2p media streaming, leveraging native platform features and server-side components brings up new communication capabilities for web and native mobile applications, allowing for advanced multi-user use cases such as video broadcasting, conferencing, and media recording.
Large scale deployments present unique planning challenges, system commissioning hurdles between IT and OT and demand careful system hand-off orchestration. In his session at @ThingsExpo, Jeff Smith, Senior Director and a founding member of Incenergy, will discuss some of the key tactics to ensure delivery success based on his experience of the last two years deploying Industrial IoT systems across four continents.
There will be new vendors providing applications, middleware, and connected devices to support the thriving IoT ecosystem. This essentially means that electronic device manufacturers will also be in the software business. Many will be new to building embedded software or robust software. This creates an increased importance on software quality, particularly within the Industrial Internet of Things where business-critical applications are becoming dependent on products controlled by software. Qua...
SYS-CON Events has announced today that Roger Strukhoff has been named conference chair of Cloud Expo and @ThingsExpo 2016 Silicon Valley. The 19th Cloud Expo and 6th @ThingsExpo will take place on November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. "The Internet of Things brings trillions of dollars of opportunity to developers and enterprise IT, no matter how you measure it," stated Roger Strukhoff. "More importantly, it leverages the power of devices and the Interne...
"There's a growing demand from users for things to be faster. When you think about all the transactions or interactions users will have with your product and everything that is between those transactions and interactions - what drives us at Catchpoint Systems is the idea to measure that and to analyze it," explained Leo Vasiliou, Director of Web Performance Engineering at Catchpoint Systems, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York Ci...
The Internet of Things will challenge the status quo of how IT and development organizations operate. Or will it? Certainly the fog layer of IoT requires special insights about data ontology, security and transactional integrity. But the developmental challenges are the same: People, Process and Platform. In his session at @ThingsExpo, Craig Sproule, CEO of Metavine, demonstrated how to move beyond today's coding paradigm and shared the must-have mindsets for removing complexity from the develo...