• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Financial Performance Management

FP&A Done Right: Five Tips for Budgeting in the Age of COVID

November 13, 2020 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, written by Gary Cokins. Cokins explains why traditional budgeting is not a fit for the volatility, complexity and uncertain times businesses face today.

The pandemic is causing boards of directors and C-suite executives to take a new look at net cash flow. Traditional budgeting is simply too slow and too rigid to keep up with the rapidly changing business environment caused by COVID-19. There is too much volatility, complexity, and uncertainty right now.

Gone are the days when budgets could be one-and-done—tied to a fixed point in time and too inflexible to adjust to quickly changing business opportunities and challenges. In today’s world, a startup can be up and running and profitable in three months and disrupt its competitors. Consider Uber and Airbnb as examples. If your company takes nearly as long to create an annual budget, which is typically out-of-date a few months later, it will be extremely difficult to fight off the upstarts or keep up with your established competitors.

The solution? A flexible and continuous budgeting and forecasting process, often referred to as a rolling financial forecast, that helps you anticipate change and focus on outcomes rather than outputs and that is derived from the drivers to determine planned spending.

Here are five tips to modernize your budget process:

1. Just say no to one-and-done

Now more than ever, December’s fiscal year-end numbers often bear little resemblance to July’s realities—meaning budgets and forecasts must become more streamlined, accurate, and responsive. Annual budgeting won’t go away, but spending weeks and months processing data and reconciling spreadsheets that are out of date soon after the consolidated master budget is published doesn’t cut it anymore.

Modern budget solution:

  • Increase the frequency of budgets and forecasts to reflect shifting business conditions
  • Make decisions and plans based on data-backed insights rather than old and stale information
  • Change how resources, employees, and assets are allocated throughout the year and how the budget incorporates real-time opportunities and challenges

2. Focus on business drivers, not cost centers

Traditional budgeting focuses on allocating resources to cost centers, but business objectives (projects, products, and service lines) result from end-to-end cross-functional processes across the org chart. So if you determine the level of resources and spend based on forecast demand, then budgets and rolling forecasts can reflect performance that is company-wide rather than specific to a cost-center department.

Modern budget solution:

  • Enable organization-wide access to reports and data, allowing everyone to have visibility into the enterprise’s performance, including into individual departments
  • Review forecasts against budgets to eliminate confusion among competing departments
  • Provide real-time information for the needed insights to support better decision-making at all levels of the organization
  • Use drivers to determine the level of needed capacity (i.e., types and numbers of employees) to match your supply of capacity with demand

3. Create rolling financial forecasts

More than ever, fluctuating market conditions make accurate forecasts of future demand load (e.g., customer orders and sales) extremely challenging. Rolling financial forecasts help manage investments or financing determined by cash flow. They provide visibility into business performance using time horizons that reflect the speed of your business.

Modern budget solution:

  • Generate rolling financial forecasts that accommodate real-time shifts in market conditions
  • Enable self-service reporting so everyone in the organization can measure their performance against company-wide KPIs
  • Help everyone in the organization understand the downstream effects of their resource allocation decisions

4. Look forward, not back

Most budgets and forecasts are outdated before you push “publish” or soon after. And some factors are impossible to take into account (natural disasters, pandemics, broken supply chains, work stoppages). The rearview-mirror orientation of traditional budgeting (e.g., last year’s actuals create this year’s budgets) often results in increased “actuals” as managers exhibit “use-it-or-lose-it” behavior by spending needlessly to attain their prior fiscal year budget. Traditional budgets can’t keep up with the speed of modern business. One needs to look forward through the windshield.

Modern budget solution:

  • Respond faster to shifts in market conditions with real-time access to financials
  • Adjust outdated budgets and forecasts as change occurs
  • Move leadership discussions toward insight, planning, and action, rather than using the budget as a cost control mechanism to punish those with unfavorable cost variances

5. Use the right tools for the job

Creating a budget process that keeps up with the pace of today’s business requires a comprehensive, collaborative, and continuous planning platform—one that gives you robust, accessible reporting and modeling capabilities; dashboards with indicators and their targets that provide visibility into overall company performance; and automated tools that streamline budgeting and forecasting processes.

Modern budget solution:

  • Enable comprehensive planning that aligns the actions and priorities of everyone across the organization around common KPIs
  • Create opportunities for collaboration by giving everyone access to the data they need and deserve
  • Adjust and update budgets and forecasts on a continuous basis so you can navigate volatile market conditions in real time

Don’t let traditional budgeting lock you into outdated assumptions and fixed targets. Those outdated targets handcuff managers when the organization changes directions. Some managers view the fiscal year budget as a “contract” that they will not deviate from to minimize unfavorable variances from their allotted cost center budget expenses. This short-term focus jeopardizes the longer-term view. The modern FP&A professional knows the truth: Aligning budgets and rolling financial forecasts with comprehensive plans lays the groundwork for proactive rather than reactive planning—a significant strategic advantage in today’s highly competitive environment.

This blog post was originally published by Workday Adaptive Planning and appeared here.

Read more guest blog posts from Workday Adaptive Planning:

FP&A Done Right: Three Driver-Based Budgeting Tips for CFOs When Change is Imminent

FP&A Done Right: Three Words for a COVID-19 World – “Flexible Budget Variance”

FP&A Done Right: Planning for What’s Next in Uncertain Times

Home » Financial Performance Management » Page 18

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Analytics, Beyond Budgeting, Budgeting, Budgeting Planning & Forecasting, enterprise performance management, Financial Performance Management, Rolling Forecasts, Workday Adaptive Planning

Workday Adaptive Planning Tips & Tricks: CAPEX Planning – Your Tool for Growth

November 11, 2020 by Mary Luchs Leave a Comment

CAPEX (capital expenditures) planning is a key feature in Workday Adaptive Planning and gives the Office of Finance and senior executives greater visibility into the company’s financial risk, while also providing a tool for measuring corporate growth. Before we go into the specifics of CAPEX in Adaptive Planning, let’s take a step back and get an understanding of CAPEX.

Capital Expenditures: Overview

Capital expenditures are expenditures within a company that are not expensed on the income statement. They are considered to be investments into the company. Companies with higher capital expenditures are said to be investing more heavily into the future of their organizations.

CAPEX to Operating Cash Ratio

The CAPEX to operating cash ratio analyzes a company’s ability to acquire long term assets using cash flows. In other words, it indicates how much of a company’s cash flows is going towards capital expenditures. It is a great tool for measuring a company’s emphasis on growth. A higher CAPEX to operating cash ratio is an indicator of high growth in a company. A company whose ratio is too high could be taking on too much financial risk. While it is beneficial to invest in CAPEX, overspending in this area can compromise a company’s ability to pay off debts or cover other operating expenses. It is vital for the Office of Finance to have accurate, up to date visibility into CAPEX data in order to assess the company’s level of risk and make appropriate adjustments.

CAPEX and Depreciation

Depreciation is important to consider for asset management, especially for companies who are putting a lot of money towards their assets in the form of capital expenditures. A company must consider how their CAPEX depreciates when looking at their assets. This is a helpful tool to consider:

CAPEX > Depreciation → Growing assets

CAPEX < Depreciation → Shrinking assets

Accumulated depreciation of capital expenditures is indicated on the Balance Sheet, so it is important to consider how this impacts the net income of the company. Depreciation reduces the taxable income of a company, which is impactful especially for companies in a high growth phase who are investing heavily in capital. In addition to the CAPEX to operating cash ratio, depreciation can also be considered when analyzing a company’s growth.

Capex Planning in Workday Adaptive Planning

In addition to having a basic balance sheet and a P&L sheet, you should create a CAPEX sheet in Adaptive Planning. The CAPEX sheet offers a more specific look at capital expenditures than the balance sheet and the P&L sheet, allowing for more targeted analysis. Generating a CAPEX sheet also allows you to drill into expenses and depreciation for budgeting and forecasting purposes on a more granular level.

CAPEX Planning in Workday Adaptive Planning

In conjunction with the balance sheet, the CAPEX sheet is important for budgeting cash and analyzing capital investments. In Adaptive Planning, the CAPEX model consists of calculated accounts in a modeled sheet. These calculated accounts include capital values and their coinciding depreciation accounts. Each modeled account is performing the same calculation based on the asset class selected by the user. Asset class is a text selector column based on the categories of capital expenditures that are specific to your business. Companies vary greatly in the ways that they calculate capital value and depreciation, but all businesses can benefit from CAPEX planning.

How to do CAPEX planning in Workday Adaptive Planning

Adding a CAPEX sheet to your Adaptive Planning implementation gives you a powerful tool for understanding the investments in your company. When you can analyze this data at a granular level, you can better assess if your company has too much financial risk, or if you are invested at an appropriate level.

The team at Revelwood has been recognized by Workday Adaptive Planning for our thought leadership in the space, commitment to our Workday Adaptive Planning practice, and our rapid achievements of milestones. Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Override Formulas in Sheets

Workday Adaptive Planning Tips & Tricks: Templates

Workday Adaptive Planning Tips & Tricks: Alternate Time Tree

Home » Financial Performance Management » Page 18

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Insights, adaptive insights tips & tricks, Analytics, Budgeting, Budgeting Planning & Forecasting, CAPEX, enterprise performance management, Financial Performance Management, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

IBM Planning Analytics Tips & Tricks: Alternative Row Formats for Excel Reports

November 10, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

In the early days of computing, printers often used paper that had alternating white and green areas which allowed the reader to easily follow a line of text across the page. This was known as “green bar” paper.  While we no longer use this type of paper, the concept is still applicable for situations where your output contains many columns that are hard to follow.

You can create this approach by using alternate row formats within your Excel reports.  This is done by combining two Excel formulas:

  • The ROW formula returns the row number for a cell reference. For example, ROW(K5) returns the number 5 since the cell is in the 5th row of the spreadsheet.
  • The MOD formula returns the remainder of two numbers after division. For example, MOD(9,2) returns the number 1.

When combined, the following formula will result in either a 1 or a 0:

=MOD(ROW(cell),2)

From there, you can use conditional formatting to define the fill colors. If you are doing this in standard Excel, then you can copy the formula throughout the applicable area.  If you are doing this within a dynamic report, then you can use it within the formatting area.

This approach allows you to make your wide reports easier to read. This also means that you can recreate the green bar format while you pull out your dot matrix printer and watch classic movies such as Wargames!

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks posts:

IBM Planning Analytics Tips & Tricks: Learn the Excel CELL Formula

IBM Planning Analytics Tips & Tricks: Excel’s IFS Function

IBM Planning Analytics Tips & Tricks: Excel’s LET Function

Home » Financial Performance Management » Page 18

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

Workday Adaptive Planning Tips & Tricks: Override Formulas in Sheets

November 4, 2020 by Michelle Song Leave a Comment

If you want to write a formula in an account in Workday Adaptive Planning, but still want to give your team the ability to override the formula and enter different data, you can use Shared Formulas to achieve that.

The Shared Formulas function of Adaptive Planning allows users to write level-specific and version-specific formulas for GL and custom accounts. Below is a screenshot of the Shared Formula page in Adaptive.

Workday Adaptive Planning: Override Formula

First, you will select the version, account, and levels that you want to write the formula. Then, you will write the formula in the “Set formula” box. Before you save the formula, you can choose to reserve/remove the user edits in the account if any. If you reserve the user edits, the formula will not override cells that already have data and only perform the formula in the cells that are blank on sheets.

Workday Adaptive Planning: How to override formulas in sheets

You can use the “Import Shared Formulas” function to import/update the formulas in multiple accounts and levels at a time.

Overrding formulas in Workday Adaptive Planning

Unlike Master Formulas, shared formula values are not locked in sheets. You can override the formula with different data directly in a sheet cell. In the example below, I overridden the formula for account 1110 Petty Cash in Mar 2019 with a different number.

Workday Adaptive Planning Tips: Override Formulas in Sheets
Workday Adaptive Planning Tricks: Override formulas in sheets

The team at Revelwood has been recognized by Workday Adaptive Planning for our thought leadership in the space, commitment to our Workday Adaptive Planning practice, and our rapid achievements of milestones. Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Templates

Workday Adaptive Planning Tips & Tricks: Trigger for a Cube Calculated Account

Workday Adaptive Planning Tips & Tricks: Alternate Time Tree

Home » Financial Performance Management » Page 18

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Insights, adaptive insights tips & tricks, Budgeting, Budgeting Planning & Forecasting, enterprise performance management, Financial Performance Management, Planning & Forecasting, Planning & Reporting, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area

November 3, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Are your member names long and hard to see in the subset editor in IBM Planning Analytics? Does it get confusing to see both the available members and the current set at the same time? Both situations can be solved by hiding one side of the subset editor.

Here is an example of the subset editor which shows both the available members and the current set.

IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area

Each of the two sections has an option to minimize the area. This is done by clicking on the minus symbol at the top of the applicable section.

IBM Planning Analytics: Minimizing the Subset Area

Once clicked, the applicable area will compress and the other area will expand. Note that you can only minimize one side at a time. Below are examples of what each screen will look like when compressed.

Minimized Available Members:

IBM Planning Analytics Tips: Minimizing the Subsea Area

Minimized Current Set:

Minimizing the subset area in IBM Planning Analytics

This approach will allow you to further customize your subset editor screen to allow you to focus only on the area you want to see.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Maintaining Subset-Drive Consolidations

IBM Planning Analytics Tips & Tricks: Sort Elements within a Subset

IBM Planning Analytics Tips & Tricks: Subset Control Dimension

Home » Financial Performance Management » Page 18

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Show Members

October 27, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that while you are doing dimension maintenance, you can quickly view an element’s parents or children in IBM Planning Analytics Workspace (PAW) via a single click? Here’s how you can do this:

Step 1: Select the dimension to be edited. This is done by either right clicking on a dimension and selecting the option to “Edit Dimension” or by dragging the dimension onto a sheet.

Step 2: Right click on an element and select the option to “Show Member.” You will then see two sub-options: one for Parents and one for Children.

IBM Planning Analytics Tips & Tricks: Show Members
  • If you select the option for Parents then you will see all of the parents associated with the selected element. In this example, there is only one parent within the dimension structure.
Show members in IBM Planning Analytics
  • If you select the option for Children then you will see all of the children associated with the selected element. In this example, there are three elements in the consolidation.
How to show members in IBM Planning Analytics

Once defined, you can then perform dimension maintenance to each of the elements on your screen.

This approach allows you to easily traverse up or down your dimension while minimizing the amount of extra elements on the screen.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Sort Elements within a Subset

IBM Planning Analytics Tips & Tricks: Editing Chores While Active

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

Home » Financial Performance Management » Page 18

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: An Approach to Strengthening your MDX Skills

October 20, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Are you new to IBM Planning Analytics and looking for a good way to learn about the various commands associated with MDX? The Planning Analytics subset editor offers a great way to teach you about MDX expressions that can be used to define elements within a dimension.

The example below shows the results of a subset that includes all descendants of Total Department. The subset was created by simply dragging Total Departments into the current set while having the member insertion defined as descendants.

IBM Planning Analytics Tips & Tricks: Subset MDX Button

Once created, I can see the MDX expression that is used by clicking the MDX button at the top, right corner of the screen. The resulting expression is:

IBM Planning Analytics Tips: Subset MDX button

However, this button is not only used to view your newly created MDX expressions. The button also allows you to edit the expression. In this case, I can change the root element to be Sales and Marketing by simply typing over the existing MDX expression.

IBM Planning Analytics Tricks: Subset MDX button

After clicking the OK button, the elements in the current set are updated.

Subset MDX button in IBM Planning Analytics

This approach can help you to learn the fundamentals of MDX expressions, which are helpful for many different components of Planning Analytics.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Sort Elements Within a Subset

IBM Planning Analytics Tips & Tricks: Editing Chores While Active

IBM Planning Analytics Tips & Tricks: Creating Groups in PAW

Home » Financial Performance Management » Page 18

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, Planning & Forecasting, Planning & Reporting, Planning analytics + MDX, Planning Analytics Tips & Tricks, Revelwood, TM1

IBM Planning Analytics Workspace (PAW) Version 2.0.57 Release

October 16, 2020 by Lee Lazarow Leave a Comment

Tech Bulletins

IBM recently released Version 2.0.57 of Planning Analytics Workspace (PAW). Version 2.0.57 is currently offered as a local-only release and will soon be available on the cloud (as version 2.0.58). This update contains many significant changes, including both new functionality and a different look and feel.

Some of these changes include:

Overall Interface

An updated Planning Analytics Workspace user interface provides a more consistent experience with other IBM products. This includes a new home page that is customized for your role within PAW and new icons that can be used to simplify the user experience.

Planning Analytics Workspace_v2.0.57

Predictive Forecasting

The introduction of Predictive forecasting allows you to easily model trends, seasonality, and time dependence in your data. If you are familiar with time series modeling then you can view details associated with the model type, model parameters, and accuracy measures. If you are not familiar with time series modeling, then AI driven model selection and tuning will assist you. The resulting data will provide both forecasted values and confidence boundaries.

IBM Planning Analytics Workspace (PAW) v2.0.57

New Organizational Approaches

Applications help you easily group together PAW assets such as books, views, and websheets. This approach can be used to help you organize assets in ways related to the structure of your organization. This is like the legacy Applications folder that exists in TM1.

IBM releases Planning Analytics Workspace v2.0.57

New Workflow Approaches

Plans allow an administrator to create a step by step walk through of your business processes. This will help end users better understand and follow the steps within your process. This will also minimize the times for users to find their required reports and templates.

Learn about IBM Planning Analytics Workspace (PAW) v2.0.57

Book and Visualization Improvements

New properties and drag-and-drop approaches give you more control over the objects within a book while still offering an easy way to create each component. IBM has also expanded the available set of visualizations, including the addition of waterfall charts and multi-line column charts.

Get info on IBM Planning Analytics Workspace (PAW) v2.0.57

Updated Administration

An updated administration page allows you to quickly see an overview of your databases, users, and groups on a single page.

Understanding IBM Planning Analytics Workspace (PAW) v2.0.57

The Ability to Enable the New Features

Version 58 will allow administrators and users to preview the new features.  Administrators will be able to enable preview mode and users will be able to “Return to Classic Experience.” Books created in the classic experience can be opened in the new experience and users can then use a “Save As” approach to update books with the new features.

Tech Bulletin: IBM Planning Analytics Workspace (PAW) v2.0.57

Further details about these new items can be found on IBM’s website.

If you have questions or would like to speak with us about these changes, please contact John Pra Sisto at jprasisto@revelwood.com.

Home » Financial Performance Management » Page 18

Filed Under: Tech Bulletins Tagged With: Financial Performance Management, IBM Cognos TM1, IBM PAW, IBM PAW v 2.0.57, IBM planning analytics tech bulletin, IBM Planning Analytics Workspace, IBM Planning Analytics Workspace v 2.0.57, lee lazarow, Revelwood, tech bulletin, TM1

FP&A Done Right: To Recover from Economic Shock, Are CFOs Envisioning Enough Scenarios?

October 16, 2020 by Revelwood Leave a Comment

This is a guest blog post from our partner Adaptive Insights, written by Bob Hansen. Hansen explains the why scenario modeling is imperative when facing disruption.

Three out of four finance executives recently acknowledged that the planning processes their companies have in place do not equip them to respond quickly to major economic and geopolitical disruption.

Published in November of last year, the survey results could hardly have been more timely. Just a few weeks later, a virus would emerge in Wuhan, China, that would touch off a global pandemic, sending shocks through virtually every business.

Few could possibly have predicted how this event could have sent recently minted plans and forecasts for 2020 into trash bins everywhere. But even before the SARS-CoV-2 outbreak, CFOs and other execs were keenly aware that business conditions were unpredictable. They were equally aware of the hurdles keeping them from the adaptability and agility needed to outmaneuver and pivot around unforeseen obstacles. The same 75% of survey respondents who said their planning processes left them vulnerable also reported that outdated legacy planning systems, siloed planning processes with limited collaboration, and a lack of relevant workforce skills were keeping them from embracing the one thing their business needed to weather the storms of disruption: agility.

If ever there was a time to marshal all the tools and technology available to help organizations meet the needs of persistent, significant change, that time is now. And as businesses figure out how to recover from the initial shocks brought by the pandemic, gaining a clearer picture of what the future could hold may well be priceless.

CFOs have known this all along

A look back shows that finance executives have long recognized the importance of agility—and the need to plan for the unexpected. A 2016 global survey found that 67% of CFOs respondents said they were concerned about economic uncertainty in their region. Those worries turned out to be prescient. Soon would come tumultuous trade wars and other global impacts, culminating eventually in an unprecedented global pandemic impacting public health, transportation, critical supply chains, and more.

Indeed, forces like digital transformation, automation, and globalization have made agility a business imperative. Though change is a constant, it continues to accelerate.

Now, with so much uncertainty in front of us, agility is more important than ever.

Scenario planning: The reality check every business needs

Back in 2016, CFOs were asked how they could add the most strategic value when managing through an economic or business contraction. Nearly half (48%) said planning for multiple scenarios could help reduce risk by allowing their organizations to respond and course-correct when conditions change.

Since then, scenario planning has become an even more critical capability for finance and beyond. For businesses, it’s helpful to understand that scenario planning isn’t about modeling the likely effects of a specific disruption, such as a pandemic. Why? Because a disrupted supply chain could result from any number of causes: a natural disaster, a fuel crisis, a regional currency crash, political unrest, a pandemic—the list is virtually endless. So it’s important to instead build scenarios based on the likely impacts and model around those. Running what-if scenarios involving possibilities like cost cutting or changes in demand helps to prepare a series of contingency plans to address the financial, operational, and cash flow impacts that could result from specific disruptions.

And companies are doing this now more than ever before. For example, one higher education institution is running scenarios around the loss of room and board revenue, the possibility of fewer returning students, and the expenses associated with remote online learning. Another example is a healthcare organization that has used multidimensional, driver-based modeling capabilities to make course corrections while managing changes in patient volumes, increased government regulations, and a decline in insurance reimbursement.

Regardless of the industry or use case, multiple scenario planning empowers organizations to isolate their drivers, model according to how those drivers might be impacted, and sharpen their foresight to know what their future selves might need to do. It’s a reality check for a reality that hasn’t yet happened.

Scenario planning beyond the bottom line

How are these companies able to conjure up a crystal ball and peer into a mix of their possible futures? They do it through active planning.

Unlike its manual, siloed, episodic, static predecessor, active planning is comprehensive, continuous, and collaborative. Active planning processes are fueled by real-time data, powerful automation, and advanced technologies like machine learning to help planners throughout the business model what-if scenarios with virtually no limits—while iterating multiple scenarios rapidly to identify the most likely outcomes and most effective actions. The most advanced platforms even help you identify erroneous predictions, so you can have more confidence in the scenarios you model. Meanwhile, monitoring results helps you to identify trends and patterns that could further refine your scenario model.

By incorporating financial and nonfinancial inputs that might be impacted by economic disruptions into your active planning model, you can draw more parallels between drivers and better understand how one affects the other. Your responding game plan will also be more comprehensive, encompassing multiple departments for swifter execution and more precise pivots. This includes financial, workforce, and salesplanning.

Are you exploring enough what-ifs?

The right platform will allow CFOs and their teams to model any number of scenarios—and modeling enough of them could mean the difference between success and failure. Just be sure these scenarios are anchored around your key business drivers so that you avoid wandering off into low-value explorations that tie up valuable resources to game out extremely unlikely events.

But do assess a wide range of outcomes, including best case, worst case, and most likely. Generating a 360-degree view of potential outcomes helps you and your organizational leaders make better decisions. And developing strong internal communications to distribute and disseminate scenarios quickly and with the right people allows you to stay on top of changing conditions and quickly shift gears.

To jump-start the what-if scenario modeling process, ask questions that will help you fully explore the possibilities of a business interruption, price war, revenue slide, or any other scenario worth planning for:

  • What do financial hits like deferred revenue or default payments do to revenue forecasts? How will they affect demand planning for things like potential location closures or inventory imbalances?
  • How will you balance your short-term workforce needs against the long-term needs of the business?
  • Is there a shortage of a certain skill set that’s currently high in demand and lacking in your area? How can you source people with those skills?
  • What if you forgo hiring until the next quarter or even the quarter after that?
  • What happens if you need to reduce employee pay or staff levels?
  • How will you adjust your goals or quotes, and what does the ripple effect of that look like throughout the sales department?
  • What if your sales pipeline freezes or shrinks?
  • How can you adjust for potential reduction of sales resources, and how will that impact bookings, productivity, and costs?
  • How will seasonality affect already disrupted cash flow?

You’re not a fortuneteller, but you can be better prepared

You may not be able to predict the next pandemic, the next recession, or the latest technological advancement that sends shockwaves through your industry. But if you model enough of the most critical what-if scenarios, you can meet disruption with agility. And that may be the most valuable outcome of all.

This blog post was originally published by Adaptive Insights.

Home » Financial Performance Management » Page 18

Filed Under: FP&A Done Right Tagged With: active planning, Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, disruption, driver-based modeling, Financial Performance Management, scenario modeling, scenario planning, what-if scenarios, Workday Adaptive Planning

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 16
  • Page 17
  • Page 18
  • Page 19
  • Page 20
  • Interim pages omitted …
  • Page 47
  • Go to Next Page »

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.