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?
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.
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
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 Questions9504 Members
Andrew Matz Research Analyst
Your email, , has been unsubscribed from the forum.
Thank you for voting. Feel free to provide a more detailed response or any additional
votes (if applicable) on the question page.