Discover Classes. Earn Rewards.
Advanced Financial Forecasting and Modeling Workshop is unfortunately unavailable

Thankfully we have 2 other Financial Modeling Classes for you to choose from. Check our top choices below or see all classes for more options.

Advanced Financial Forecasting and Modeling Workshop

at American Management Association - UNION SQUARE

Course Details
Price:
$2,645
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
UNION SQUARE
780 Mission St
Btwn 4th & 3rd Streets
San Francisco, California 94103
(Map)
Description
Class Level: Advanced
Age Requirements: 21 and older
Average Class Size: 20

What you'll learn in this financial modeling training:

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.

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.

How will you 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

What You will cover

  • 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

Outline:

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

Still have questions? Ask the community.

Refund Policy
Transfer, Cancellation and Refund Policy:

For Classroom, Live Online, Express Skills Courses and Webinar programs, you may transfer to a future session, send someone to take your place or cancel without penalty at any time up to three weeks prior to your program. If you provide AMA with less than three weeks’ notice, or fail to attend, you will be liable for the entire program fee. 

Programs included in AMA On Demand offerings are not eligible for substitution, transfer, cancellation, return, or refund. We appreciate that this is an important investment for you and your company and would like to accommodate your needs the best we can. Therefore, please email CourseHorse.

Pricing, Offers, and Discounts Policy:

AMA-delivered programs are eligible for AMA member pricing, GSA pricing, special offers, and discounts as applicable, according to the terms of the specific pricing, offer and/or discount. Third party-delivered programs available through AMA and Express Skills courses are excluded from all discounted pricing, offers, and discounts offered by AMA, including but not limited to AMA member pricing, GSA pricing, AMA Seminar Savings Pass redemptions, AMA SLS Contract pricing, AMA Annual Pass/All-Access Pass, and complimentary registrations of any type.

Map

Google Map

American Management Association

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 26450 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

School: American Management Association

American Management Association

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 about American Management Association

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified SF educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

2 Top Choices

IT4IT™ Foundation (Level 1) Accredited Training

at EA Principals, Inc. - FINANCIAL DISTRICT 580 California St 12th & 16th Floors, San Francisco, California 94104

The IT4IT™ Reference Architecture is a vendor-neutral open standard Reference Architecture and value chain-based operating model for managing the business of IT. IT departments run on IT4IT™ principles and framework reap large rewards in cost savings and automation.  The IT4IT™ Reference Architecture leverages standardized activities, data...

Tuesday Sep 6th, 9am - 5pm Pacific Time

  (4 sessions)
$2,595

4 sessions

AMA's Finance Workshop for Non-Financial Executives

at American Management Association - UNION SQUARE 780 Mission St, San Francisco, California 94103

Get a complete financial education in just four days. . .and be prepared to make more powerful, informed business decisions. From understanding the essence of cash flow to learning how to create value on a corporate level, this comprehensive program covers all the principles of corporate finance. Through the effective use of actual case studies and...

Monday Sep 12th, 9am - 4:30pm Pacific Time

  (4 sessions)
$2,845

4 sessions

Loading...