Scenario Modelling for Better Forecasting in Excel

It is critical for FP&A practitioners to be able to apply scenarios to their forecasts, especially while operating during periods of uncertainty. This session demonstrates techniques to reduce uncertainty in decision-making by using practical examples and applying standard spreadsheet functionality already at your fingertips to build scenarios, data tables and Monte Carlo simulations. Additionally, this session provides attendees with best practices to reduce volatility, mitigate risk, and deal with unknowns that may impact decision-making.

Learning Objectives

• Gain Insights into defining the “uncertainties” that affect an organization’s ability to produce accurate forecasting models.
• Learn to manage risk and uncertainty by creating scenarios and performing sensitivity analysis

This recording was originally delivered as a live event and is now available to you as a convenient and cost-effective way to support your learning and development while also earning CTP, CCM and/or FPAC credits.

Credits Confirmation
At the conclusion of the recording the accompanying quiz will appear. Once you’ve successfully completed the quiz, you will be prompted to complete a brief Credits Request Form. Following the completion of this form, an email confirmation of credits earned and directions to post your credits in the Recertification Reporting Tool will be sent to you for your records. If you attended the live version of this webinar, you cannot earn credit for the recorded as well.

Watch Other Videos in the AFP FinNext Asia Series