Widen Your Vision of Your Company's Future

Sensitivity Analysis and Scenario Planning 

- OR -

MOST POPULAR

Get this course and all other CFO Perspective courses along with downloadable tools and access to Rob for only $290/year as part of a FAST membership.

FAST Member? Click here for instant access.

Discover how sensitivity analysis and scenario planning can improve your company's decisions. You'll also learn tools to obtain and communicate the insights from this analysis.


Sensitivity analysis is the process of varying inputs to a model to assess their impact on the outcomes (i.e., outputs) of the model. This allows you to identify the model inputs that have the biggest impact on the outputs (e.g., profit). This improves decision efficiency and effectiveness. You also get a clear picture of the company's full range of potential outcomes.

Scenario planning explores projections in which multiple assumptions have been changed from the base case or current conditions. Scenario planning allows outcomes to reflect the correlation of multiple assumptions, which may cause their impact to increase exponentially versus a change by any one of the assumptions. Scenarios can explore opportunities for which the company wants to prepare or risks for which the company should take mitigation steps.

What You'll Learn ...

In this course, you'll learn:

  • How to perform sensitivity analysis and scenario planning
  • How to use bookending to set the range of possibilities
  • Ways to improve your estimates of what might happen
  • How to use a tornado diagram to identify the key assumptions about your business

Course Outline

  1. 1
    Sensitivity Analysis and Scenario Planning in Action
  2. 2
    Sensitivity Analysis Basics
  3. 3
    Scenario Planning
  4. 4
    Bookending
  5. 5
    Improving Estimates
  6. 6
    Sensitivity Analysis and Scenario Planning in Excel
  7. 7
    Tornado Diagrams
  8. 8
    Key Takeaways

Are you a CPA? Get CPE Credit for this course.

Let me be your guide

I’m Rob Stephens, founder of CFO Perspective. CFO Perspective provides continuing education courses for CPAs as well as financial management courses for business advisors and staff. During my career, I’ve been the CFO, SVP of Finance, or Director of Operations of companies from just a few employees to $3 billion in assets and hundreds of employees. 

Join with NO RISK!

There is no risk to you. I think you'll be impressed with what you receive, but if you're not, you can quit within the first month. Get a full refund in your first 30 days if it's not everything you wanted.

Are You Aware of All the Risks and Opportunities Your Company Might Have?

Get the Tips and Techniques for Sensitivity Analysis and Scenario Planning

- OR -

MOST POPULAR

Get this course and all other CFO Perspective courses along with downloadable tools and access to Rob for only $290/year as part of a FAST membership.

The sensitivity analysis course is one of the courses you get with a FAST membership.

FAST (Finance and Strategy Toolkit) is a membership program that gives you resources for better strategic financial management. You get all the CFO Perspective courses. Get direct access to me as well as tools for improved decisions that can lead to superior business performance. 

The right tools can save you time, reduce your stress, and improve your effectiveness.

FAST Member? Click here for instant access.

>
Success message!
Warning message!
Error message!