Who can benefit?

•  financial managers and analysts, controllers and treasurers
• directors of planning and corporate/business development, mergers
• Acquisitions executives, operations analysts and budget managers.

Course objective

•  Make more dependable financial forecasts for your organization
•  Discover underlying patterns in your data
• Select and apply the appropriate forecasting model
•  Gain a thorough grounding in basic financial models utilizing Excel - and move on to more advanced Excel modeling techniques such as Monte Carlo
• Create your own models from real-world examples and apply testing diagnostics
•  Employ risk management modeling tools that help you identify uncertainty in your model and design methods to address it
•  Present your models with confidence to both team members and senior management
•  Better understand your business and its environment
•  Use new forecasting expertise to contribute to improved corporate decision making

Course outline

•  To use mainstream financial concepts and terminology
•  Approaches for describing fundamental statistical methods
• To develop existing financial models in Excel
• To view more advanced Excel modeling techniques such as Monte Carlo Add-Ins
• To create your own model and provide diagnostics
• To analyze your model and provide diagnostics
•  To identify uncertainty in the model and design methods to address it
• To present your models to a brand management audience