EVENT DESCRIPTION

In this financial modeling course, you will learn how to perform scenario and sensitivity analysis with a focus on practical applications. You will gain a big picture outlook on a range of outcomes within a specific set of variables. Excel functions ensure you can make quick changes with a live transaction, adjusting the model as required.

LEARNING OBJECTIVES:

By the end of this course, you will be able to:

  • identify the differences between scenario and sensitivity analysis
  • build a sensitivity analysis system into your financial model
  • create a dynamic scenario manager in Excel
  • distinguish between direct and indirect methods of integration
  • organize results that automatically sort data
  • output ranking sensitivities from highest to lowest
  • present results in a tornado chart