Professional Course

AMA's Advanced Financial Forecasting and Modeling Workshop

3 days
2,695 USD
Next course start
5 August, 2024 (+2 start dates)
Virtual Classroom
3 days
2,695 USD
Next course start
5 August, 2024 (+2 start dates)
Virtual Classroom
From 2,695 USD / person

Course description

AMA - American Management Association

AMA's Advanced Financial Forecasting and Modeling Workshop

In this , you will build robust financial forecasts and models, learn tips and tools, analyze the results, and learn how to communicate key data to decision makers in your organization. Build the model. . .generate the forecast. . .drive the business. Create more powerful and accurate forecasting models that steer you to fast-track, business-improving decision making.

How You Will Benefit

  • Create effective financial models that meet your business needs
  • Quantify the uncertainty inherent in forecasting models with various risk analysis techniques
  • Make better, more profitable business decisions using advanced financial modeling methods
  • Evaluate patterns in your historical data
  • Identify and utilize key business drivers and integrate them into your forecast
  • Effectively communicate the results of your models to team members and senior management

Upcoming start dates

Choose between 2 start dates

5 August, 2024

  • Virtual Classroom
  • Online

31 October, 2024

  • Virtual Classroom
  • Online

Who should attend?

Analysts and executive-level managers who work with financial models and need a refresher on modeling methods—as well as experienced financial professionals who have not built models on a regular basis.

Training content

Learning Objectives

  • Use Mainstream Financial Concepts and Terminology
  • Describe Fundamental Statistical Methods
  • Develop Existing Financial Models in Excel
  • View More Advanced Excel Modeling Techniques, Such as Monte Carlo Add-Ins
  • Create Your Own Model from a Real-Life Example
  • Analyze Your Model and Provide Diagnostics
  • Identify Uncertainty in the Model and Design Methods to Address It
  • Present Your Models to a Broad Management Audience

Finance Theory as Used in Modeling

  • Apply the Concepts of Modern Finance
  • Use Various Interest Rates and Risk Measures in Your Models
  • Develop Models That Are Consistent with the Principles of Finance

Creating Financial Models in Microsoft® Excel

  • Develop a Set of Guidelines for Preparing Financial Models in Microsoft Excel
  • Identify Key Tips for Preparing These Models
  • Apply the Pyramid Structure to Your Models
  • Use Various Microsoft Excel Functions That Will Aid in Developing Models
  • Prepare a Basic Model Using These Techniques
  • Apply Sensitivity Analysis Tools When Evaluating Model Results

The Art of Building Models

  • Identify the Key Points Necessary to Build a Model
  • Describe the Art in Creating an Effective Model
  • Create a New Model Solving a Complex Business Problem

Model Statistics and Forecasting

  • Calculate Mean and Standard Deviation of a Dataset
  • Present Data for Manipulation
  • Analyze the Data Using Simple Techniques
  • Forecast Financial Data Using Regression Analysis

Modeling Risk and Uncertainty

  • Identify Uncertainty as It Exists in the Business World
  • Develop Simple Techniques to Handle Uncertainty
  • Use Monte Carlo Simulations to Handle Uncertainty
  • Use Option Pricing Models to Handle Uncertainty


price for:

  • Non Members: $2695
  • AMA Members: $2395

Certification / Credits

CEU: 1.8, PDU: 18, CPE: 21

AMA - American Management Association

American Management Association Company Info

The American Management Association, International (AMA) is the global leader in talent development. Founded in 1923, AMA supports the goals of individuals and organizations through a complete range of educational products and services, including instructor-led classroom and virtual seminars, webinars,...

Read more and show all training delivered by this supplier


Case Studies