workers-collab

AMA's Advanced Financial Forecasting and Modeling Workshop

Build more powerful and more accurate forecasting models to better analyze financial data, predict revenues and costs, assess risks—and justify critical business decisions.

In this course, 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.

Seminar Number: 01276

5
(145 reviews)
  • Live Online
  • At Your Company Location

Course Scheduling & Pricing

Home>Course Topic>Analytical Skills>AMA's Advanced Financial Forecasting and Modeling Workshop

Who Should Attend

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

Note: Please bring a PC laptop equipped with Excel 2019 or 365.

Those with minimal finance experience should attend AMA’s Fundamentals of Finance and Accounting.

  •   Live Online2 Day(s)
    13.6 CCM, 1.2 CEU, 12 CLP, 14 CPE, 13.6 CTP, 13.6 FP&A, 12 PDU, 18 PMU
 
 

In this course, 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.

  • 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
  • Working with advanced Excel modeling techniques such as simulation add-ins
  • Creating your own model from real-world examples
  • Analyzing and applying diagnostics to validate your forecast
  • Understanding how Monte Carlo simulations handle uncertainty

Special Feature

AMA Blended Learning combines instructor-led training with online pre- and post-seminar assessments, tune-up courses, and other resources to maximize your training goals. Through a blend of proven instructor-led seminars and powerful online technology, AMA Blended Learning provides a compelling and more comprehensive experience for the learner—producing a greater return-on-investment for the employer and the seminar participant.

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

Download Extended Seminar Outline PDF

Learning Objectives 

  • Improve Model Design Efficiency
  • Expand Your Tool Kit for Building Effective Models
  • Learn, Practice, and Apply Sensitivity Tools to Your Models 

LESSON ONE

Finance Theory as used in Modeling 

  • Articulate the Concepts of Modern Finance
  • Identify Key Tips for Preparing Financial Models 
  • Determine the Appropriate Rates of Return for Financial Models 

Creating Financial Models and Using Advanced Tools in Microsoft Excel® 

  • Describe Best Practices for Preparing Financial Models in Microsoft Excel®
  • Use Microsoft Excel® Functions That Will Aid in Preparing Models 

LESSON TWO

Creating Financial Models and Using Advanced Tools in Microsoft Excel®(cont’d) 

  • Describe Best Practices for preparing Financial Models in Microsoft Excel®
  • Use Microsoft Excel® Functions That Will Aid in Preparing Models 

LESSON THREE 

Design Effective Models Using Proven Tips and Techniques 

  • Identify the Key Points Necessary to Problem-Solve Using Models
  • Explain the Powerful Sensitivity Analysis Tools Available in Microsoft Excel®
  • Create a New Model Solving a Complex Business Problem 

LESSON FOUR 

Presenting Your Findings and Modeling Risk and Uncertainty 

  • Prepare an Effective Presentation of a Financial Analysis for Nonfinancial Decision Makers
  • Explain Several Monte Carlo Simulation Add-Ins
  • Identify Uncertainty as It Exists in the Business World 
  • Develop Simple Techniques to Handle Uncertainty
  • Use Monte Carol Simulations to Handle Uncertainty
  • Use Option Pricing Models to Handle Uncertainty 
     

Download Extended Seminar Outline PDF

Live Online FAQs

View a Sample of Our Reviews

5

145 reviews

 
Great instruction, theory, and practical information.
5
Dennis T.
 
Vice President
 
Industry: Manufacturing
This was an excellent course. The small class size and the openness of the facilitator made for a great learning experience. The environment was also quite comfortable and conducive to learning.
5
Delano M.
 
Engineer New Business
 
Industry: Energy, Utilities & Waste
The instructor is very resourceful and knowledgeable. Clearly delivered the messages. But the pace is a bit too fast at certain point.
5
Chloe Y.
 
Assistant Controller
 
Industry: Consumer Services
The course is very well structured which allows me to absorb the materials easily. The instructor applied some real life experience that makes the course more interesting.
5
Michelle C.
 
Asst Vice President
 
Industry: Finance
Very good, and engaging. Great tools. Nice teacher and facilitator.
5
William T.
 
Vice President
 
Industry: Telecommunications

This course is valid for 18 PMUs.
Classroom 18 Business Acumen [BA]
Live Online 12 Business Acumen [BA]

AMA has been reviewed and approved as a provider of project management training by the Project Management Institute (PMI).

Talent Triangle PDUs

[S&B] 18 Classroom/12 Live Online 

Project Management Institute (PMI) Talent Triangle, 2015. Reproduced with the permission of PMI. Copyright and all rights reserved.

Approved for up to 22.8 for classroom and 13.6 for live online FP&A recertification credits by the Association for Financial Professionals at the rate of one credit for each 50 minutes of attendance.

 

American Management Association is accredited by the International Association for Continuing Education and Training (IACET) and is accredited to issue the IACET CEU.

Approved for up to 22.8 for classroom and 13.6 for live online CTP recertification credits by the Association for Financial Professionals at the rate of one credit for each 50 minutes of attendance.

AMA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org. For additional information or for more information regarding administrative policies such as complaints and refunds, please contact Martha Leon at 212-903-8173.

Recommended CPE Credit: Recommended CPE Credit: Classroom – 21 hours/Advanced
Live Online – 14 hours/Advanced
Prerequisites: Familiarity with fundamentals of financial analysis, or the concepts covered in Financial Forecasting
Advance Preparation: Online pre- and post-seminar assessments
Delivery Method: Group Live/Group Internet-Based
Field of Study: Technical – Accounting, Finance, Management Services, Specialized Knowledge

Live Online Schedule

2 Sessions Available

Great instruction, theory, and practical information.
5
Dennis T.
 
Vice President
 
Industry: Manufacturing
This was an excellent course. The small class size and the openness of the facilitator made for a great learning experience. The environment was also quite comfortable and conducive to learning.
5
Delano M.
 
Engineer New Business
 
Industry: Energy, Utilities & Waste
The instructor is very resourceful and knowledgeable. Clearly delivered the messages. But the pace is a bit too fast at certain point.
5
Chloe Y.
 
Assistant Controller
 
Industry: Consumer Services
The course is very well structured which allows me to absorb the materials easily. The instructor applied some real life experience that makes the course more interesting.
5
Michelle C.
 
Asst Vice President
 
Industry: Finance
Very good, and engaging. Great tools. Nice teacher and facilitator.
5
William T.
 
Vice President
 
Industry: Telecommunications
Close