Skip to main content
Home
The Online Resource for Modern FP&A Professionals
Please register to receive the latest FP&A news, updates and tips Login

Main menu

  • Home
  • FP&A Insights
    • FP&A Trends Digest
    • FP&A Trends Research
    • FP&A Trends Insight Paper
    • FP&A Trends Survey
    • Short Videos
    • Our Contributors
  • FP&A Events
    • International FP&A Board
    • FP&A Trends Webinars
    • Digital FP&A Circles
  • AI/ML Committee
    • Introduction
    • Members
    • Resources
    • Meetings
  • FP&A Tools
    • FP&A Trends Maturity Model
  • About Us
    • Company Policy
    • Privacy Policy
    • Editorial Guidelines
    • Our Ambassadors
    • Our Sponsors & Partners
    • Contact Us
image
Developing and Managing Scenarios and Sensitivity Analyses
July 9, 2020

By John Sanchez, Keynote Speaker, Corporate Trainer and Author

FP&A Tags
FP&A Scenario Planning
Modelling and Forecasting
Financial Planning and Analysis

Financial modellingFP&A (Financial Planning & Analysis) professionals and others who are responsible for developing financial projections are not in a one and done business. I can’t remember the last time I created a projection, forecast or anything else that wasn’t quickly the subject of some ‘what if’ conversations.

What if we increase prices by 10% across the board?

What if our biggest competitor cuts prices?

What impact would these things have on our projections?

If you’ve built your model properly, your life will be much easier when these questions arise, because not much in life doesn’t change. Anticipating likely scenarios and building your model in a way that provides quick answers to different changes will go a long way towards making your life in planning more successful. 

Define Key Decision Factors

Every business has a small number of key decision factors. These are not necessarily the business drivers you identify when you look at an 80/20 analysis.

For example, you may have a certain product mix that is fairly consistent based on trend analysis. This helps you identify the 20% of the variables that are drivers of your business, so you can use this to build your model accordingly.

A key decision factor may be that when the product mix changes beyond some predetermined threshold some action will be taken. Maybe when sales of product X drop below $X volume the company wants to evaluate certain promotions or implement pre-determined promotions. This is a key decision factor. It’s not based strictly on historical analysis, but on actual or projected events or metrics. 

Identify Areas of Uncertainty

Identifying areas of uncertainty with the biggest potential impact is one step that helps identify how to develop scenarios to model. Both uncertainty and potential impact should be considered, not just one or the other.

For example, if your business operates in an industry where your raw materials prices are highly volatile because of supply chain issues, it would be wise to build a variety of scenarios that allow you to see outcomes based on different supply assumptions.

Depending on the complexity of the scenarios, you may want to use Excel or you may want to use a different tool. There are lots of planning and analysis tools available that are much better suited to complex scenario analysis than Excel, so know its limitations and don’t let it hold you hostage.

Design the Model

You now have three key things identified that will help you build your model right. The desired end goal, the 20% of drivers that will drive 80% of results, and the key decision factors you need to take into consideration. Having these clearly identified will help you understand how you need to build your model. 

Before you start your design, decide on the tool you will use. Will you build your model in Excel or some other tool? This is no small decision because while most of the planning and analysis tools import data from Excel, you’ll do unnecessary work if you start in Excel and later migrate to another tool.

If you choose a tool other than Excel, make sure you factor in any necessary training so you have the time and resources to learn the new tool in time to meet whatever deadlines you have. Scenario management is one of the big strengths of some of the software tools available today, so don’t overlook this option. Also, remember that the number and type of scenarios you will likely need to use may steer you towards a particular technology tool. 

 

When you have the ability to answer questions driven by changing variables, you shorten the time between thinking of questions and answering them. Being in a position to answer questions on the spot instead of having to schedule a follow-up meeting is a great outcome derived from effectively developing a model that can deal with multiple scenarios effectively and efficiently.
 

The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register

Related articles

Sensitivities, Scenarios, What-if Analysis – What’s the Difference?
November 22, 2019

Scenario analysis, sensitivity analysis and what-if analysis are very similar concepts and are really only slight...

Read more
Modern FP&A and The Power of Scenario Planning
June 13, 2019

Most recently, I have been observing significant changes in business models in many organisations around the...

Read more
Financial Modeling Innovation: Predictive Analytics vs Financial Modeling
May 17, 2018

Although there are some substantial differences between Financial Modelling and Predictive Analytics, both help us cope...

Read more
Financial Modeling: Types of Models and How to Design Them
March 12, 2020

Starting with the end in mind is one of the simplest ideas that is frequently ignored...

Read more
Financial Modelling and Automation
December 6, 2018

Disclaimer: Financial Modelling has no strict “right” or “wrong” method of application. It does, however, have...

Read more
The Evolution of Scenario Planning
July 26, 2018

We live in a world of uncertainty. But in that uncertainty lies a great deal of...

Read more
+

Subscribe to
FP&A Trends Digest

We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.

Create new account

image

Event Calendar

Pagination

  • Previous
  • May 2025
  • Next
Su Mo Tu We Th Fr Sa
27
28
29
30
1
2
3
 
 
 
 
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Transforming FP&A Together: Human & AI Synergy
 
18
19
20
21
22
23
24
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
Five Critical Roles for Building a World-Class FP&A Team
 
25
26
27
28
29
30
31
FP&A Business Partnering and AI: A New Era
 
All events for the year

Future Meetings

The Face-to-Face Milan FP&A Board
The Face-to-Face Milan FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)

May 20, 2025

The Face-to-Face Frankfurt FP&A Board
The Face-to-Face Frankfurt FP&A Board Five Critical Roles for Building a World-Class FP&A Team

May 22, 2025

BPAI
The FP&A Trends Webinar FP&A Business Partnering and AI: A New Era

May 28, 2025

The Face-to-Face London FP&A Board: Data Management & Analytics: Unlocking FP&A Value
The Face-to-Face London FP&A Board Mastering Data in FP&A: Smarter Analytics, Better Decisions

June 5, 2025

FP&A Trends Webinar The Evolving Role of FP&A: From Number Cruncher to Strategic Advisor
The FP&A Trends Webinar Making FP&A Teams Fit for the Future

June 11, 2025

The Face-to-Face New York FP&A Board
The Face-to-Face New York FP&A Board From Insight to Impact: FP&A Business Partnering in Action

June 17, 2025

FP&A Trends Webinar Practical Steps for FP&A Analytical Transformation.
The FP&A Trends Webinar Unlocking FP&A Analytical Transformation

June 18, 2025

The FP&A Trends Webinar How AI is shaping the future of Financial Planning & Analysis (FP&A)
The FP&A Trends Webinar Transforming FP&A with AI: Maturity, Impact, and Future Roles

June 25, 2025

The Face-to-Face Sydney FP&A Board
The Face-to-Face Sydney FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

June 26, 2025

The Face-to-Face Singapore FP&A Board: Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
The Face-to-Face Singapore FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

July 8, 2025

AI/ML FP&A
AI/ML FP&A
Data and Analytics
Data & Analytics
FP&A Case Studies
FP&A Case Studies
FP&A Research
FP&A Research
General
General
Integrated FP&A
Integrated FP&A
People and Culture
People and Culture
Process
Process
Technology
Technology

Please register to receive the latest FP&A news, updates and tips.

info@fpa-trends.com​

              

Foot menu

  • FP&A Insights
  • FP&A Board
  • FP&A Videos

Footer countries

  • Amsterdam
  • Austin
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Helsinki
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London (Circle)
  • Melbourne
  • Miami
  • Milan
  • Munich
  • New York
  • Paris
  • Perth
  • Riyadh
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2025 fpa-trends.com. All rights reserved.

0