Remember Me


Conducting Scenario Analysis

Asked on 20 June

We are looking at doing more high level scenario planning of our financials, but we are limited by the current set of tools at our disposal. As a result, we are looking at what tools other companies use to conduct scenario analysis. We would be particularly interested in getting responses to the following questions:

1) Do you conduct scenario analysis on your financials?
2) What type of scenario analysis do you do? On the P&L, Cash Flow, etc?
3) What tools or applications do you use to conduct this analysis?
4) Would you recommend the tools you have?

Key Takeaways:

6 peers participated in this discussion.

1) All the respondents conduct scenario analysis on their financials.

2) Five respondents conduct scenario analysis on all  types of financial statements including P&L, Balance Sheet, Cash Flow, Liquidity and Credit Metrics. Interestingly a respondent limits the analysis to individual product segments, and then make changes only in the main drivers such as revenue and cost units.

3) Tools to conduct this analysis include Hyperion Strategic Finance/Crystal Ball, and complex Excel models.

4) Respondents recommend the use of Hyperion products.

Recommended Resources
1) Learn how borrowing techniques from scenario planning can better prepare managers for multiple outcomes.
2) Check out this Vendor Profile on Scenario Planning Software.
3) Access exclusive CFO comments on Scenario Plans



About the CEB Financial Planning and Analysis Forum

This peer group allows finance professionals to discuss challenges around forecasting and planning, target-setting, and business analytics.

> Go to the CEB Financial Planning & Analysis Leadership Council Website


2446 Replies to 350 Questions
9504 Members


Andrew Matz
Research Analyst

Related Questions

<< Back to the Questions list
Edit Response