• Product
        • Planning Maestro
          • Product Overview
          • Watch Demo
          • Schedule a Live Demo
          • Plans
          • Service & Support
        • Capabilities
          • Consolidation
          • Budgeting
          • Forecasting
          • Scenario Planning
          • Performance Dashboards
          • Financial Reporting
  • Solutions
        • Industries
          • Nonprofit
          • Healthcare & Life Sciences
          • Finance & Insurance
          • Manufacturing & Distribution
          • Retail & Hospitality
          • Software & Technology
          • Other Industries
        • Integrations
          • QuickBooks Online
          • Microsoft Dynamics 365
          • Sage Intacct
          • NetSuite
          • Abila
          • Other Integrations
  • Resources
        • All Resources
          • Our Blog
          • Webinars
          • Whitepapers & E-Books
          • Videos
          • Customer Case Studies
  • Company
        • About Us
        • Leadership Team
        • Partners
        • Press & News
        • Awards
        • Careers
  • Contact
  • Search
  • Menu Menu
Help Hub
Search
Watch Demo Request A Quote

Our Blog

Use Your FP&A Software for Scenario Planning

April 2, 2020/ financial forecasting/By Alan Hart, Centage Guest Blog Author, Principal Consultant at Pacific Shine Group

Get a handle on your plan and budget with multiple budget versions and what-if scenarios

The first spreadsheet ever published, Visicalc, developed by Software Arts and published by VisiCorp in 1979 enabled its users to make changes to values in certain cells and have the entire electronic worksheet recalculate itself, almost instantly.  Users could enter formulas in certain cells and make references to other cells.

Financial models became very popular using this program and all subsequent releases of VisiCal and other applications in this spreadsheet category, notably Lotus 123 and Microsoft Excel which seems to be the only spreadsheet that survived and is currently dominating this category.

Why am I using a spreadsheet in this blog, where I always encourage people to not rely on spreadsheets for developing financial plans and budgets?  By now this idea has been accepted by the financial community and many companies of all sizes are actively switching to purposely built applications that fall under the FP&A (Finance, Planning and Analysis) software category.

The spreadsheet example here simply illustrates the idea that when you make changes in one area, other areas are can be affected.  For example, you change one or more values in a column of numbers that has a sum function at its bottom and the sum automatically updates.  The same concept applies to all areas of every worksheet in a workbook (a spreadsheet file with multiple worksheets or tabs).  All this is now trivial and is taken for granted by all spreadsheet users.

If we borrow this idea and apply it to FP&A software, which is the only reasonable approach to creating and maintaining a corporate plan and budget, we can explore working with drivers.  These are values or values derived from other values or data records, to affect certain budget records according to selected built-in business logic and accounting rules.

An important practice that is encouraged in using current FP&A software is scenario planning.  This entails creating different versions of the budget, applying “What-If” scenarios and analyzing the results from each budget version or “What If” scenario.  The various outputs from the different versions allow users to refine the plan and budget to arrive at desirable outputs.

This practice is especially useful when using an FP&A solution with synchronized financial statements since it allows finance management to clearly see how the future financial health of the organization is likely to be impacted by executing the different versions of the budget. See my related blogs – All About Synchronized Financial Statements – Part 1 and Part 2.

The use of scenario planning and multiple versions of the budget is especially useful when the analytics module of the FP&A software is able to display a set of financial ratios – the KPIs of the financial statements – preferably in a graphic format against a pre-defined standard where users can instantly see how the financial ratios vary from the standard, during both actual accounting periods and forecasted periods, and in which direction they move when the data of each version of the budget or each scenario is transferred to the analytics module.

Having multiple scenarios and versions of the plan and budget makes the analytics function more central in the planning process with an output that is quick and sufficiently reliable for management to make timely decisions with greater confidence.

Another great benefit of scenario planning can be had when the company continually works on planning and reforecasting.  This is especially useful when rolling forecasts are implemented and various scenarios are frequently tested in the analytics module to find the optimal changes to the budget that are needed in response to actual results and market changes.

As a reminder, implementing an FP&A solution with multiple budget versions and what-if scenarios with built in business logic and accounting rules can really free many budget process participants from  tedious programming of the budget model logic and rules plus endless troubleshooting of the model.  This in turn will allow users to spend a lot more time doing analysis, trying different versions and scenarios, and overall become much more productive.

Take advantage of your FP&A software’s scenario planning capabilities to intelligently create a corporate plan and budget that can be managed through versions and what-if scenarios.  You will be better equipped to translate a plan into a view of your company’s future financial health and analyze changes to this financial outlook as various versions are tried.

Alan Hart, MBA, is Principal Consultant at Pacific Shine Group in Portland, Oregon, with responsibility for client business development and hands-on client project implementations. Prior to starting Pacific Shine Group, he worked in various executive accounting and finance positions with technology and growth companies. Notable is his 18 years in the hi-tech manufacturing industry where he served as Controller, Vice President of Finance and CFO of several privately as well as publicly held companies in the Hi-Tech industry, such as Hybrid Arts, Inc., Hamilton Bay Associates and Syncronys Software.  In his role in management consulting, Alan has worked in diverse industries and with a variety of clients, including fortune 1000 companies such as Boeing, Delta Airlines, Intel, Wyndham Worldwide and others, as well as many mid-market organizations such as Guitar Center, Ducommun AeroStructures, Cypress Semiconductor, TriQuint Semiconductor and others.

Combining his skills and experience in engineering with deep understanding of technical accounting, he is able to assist small and medium-size manufacturing companies establish GAAP compliant accounting and reporting systems.

https://www.centage.com/wp-content/uploads/2022/10/shutterstock_352315112-scaled-1.jpg 1707 2560 Alan Hart, Centage Guest Blog Author, Principal Consultant at Pacific Shine Group /wp-content/uploads/2022/10/Group-780.svg Alan Hart, Centage Guest Blog Author, Principal Consultant at Pacific Shine Group2020-04-02 15:14:362022-12-08 15:51:19Use Your FP&A Software for Scenario Planning
Back to List

Also by This Author

  • Financial Analytics vs. Financial Reporting – Get the Real Story
  • How Analytics is Used to Predict the Future Financial Health of the Company
  • Analytics and the Financial Statements
  • Borrow Your Banker’s Mindset and Methods to Evaluate Your Own Business
  • Workforce Planning in a Manufacturing Enterprise

View Demo Video

Request a Quote

Centage Corporation
330 Cochituate Road, #807
Framingham, MA 01701
P: 800.366.5111

  • Product
  • Industries
  • Integrations
  • Resources
  • Company
  • Contact
  • Help Hub
  • Watch Demo
  • Request a Quote

© 2022 Centage

Privacy Policy

Terms of use

Sitemap

  • Product
    • Planning Maestro
      • Product Overview
      • Watch Demo
      • Schedule a Live Demo
      • Plans
      • Service & Support
      • Back
    • Capabilities
      • Consolidation
      • Budgeting
      • Forecasting
      • Scenario Planning
      • Performance Dashboards
      • Financial Reporting
      • Back
    • Back
  • Solutions
    • Industries
      • Nonprofit
      • Healthcare & Life Sciences
      • Finance & Insurance
      • Manufacturing & Distribution
      • Retail & Hospitality
      • Software & Technology
      • Other Industries
      • Back
    • Integrations
      • QuickBooks Online
      • Microsoft Dynamics 365
      • Sage Intacct
      • NetSuite
      • Abila
      • Other Integrations
      • Back
    • Back
  • Resources
    • All Resources
      • Our Blog
      • Webinars
      • Whitepapers & E-Books
      • Videos
      • Customer Case Studies
      • Back
    • Back
  • Company
    • About Us
    • Leadership Team
    • Partners
    • Press & News
    • Awards
    • Careers
    • Back
  • Contact

    Quick Links

  • Help Hub
  • Watch Demo
  • Request a Quote

Stay Informed