Course Finder

 


Select up to 4 cities, ALT + Select

View all courses
 

Print  | 

AMA’s Advanced Financial Modeling and Forecasting Workshop (Live Online)

Create more powerful and accurate financial models that steer you to business-improving decision making.
 
This highly interactive, live online seminar shows you how to build effective models to better analyze financial data, forecast revenues and costs, assess risks and justify critical business decisions. You will also have the opportunity to create your own model, and solve a complex business problem from a real-world example—all right at your desktop.
 

Learn More


Upcoming Sessions

Date City Times Course# 61276
  • Nov 6, 2017
    - Nov 15, 2017
    Live Online 2:00 PM
    - 5:00 PM
    Add to Cart

Do you need a different date or location? We offer Courses On Request.


Course Details

What You Will Learn

LESSON 1

Finance Theory as Used in Modeling

  • Using various interest and risk measures in your models
  • Developing models that are consistent with the principles of finance
  • Creating Financial Models in Microsoft Excel®
  • Developing a set of guidelines for preparing financial models in Microsoft Excel®
 
LESSON 2

Creating Financial Models in Microsoft Excel®, continued

  • Applying the Pyramid Structure to your models
  • Using various Microsoft Excel® functions that will aid in developing models
  • The Art of Building Models
  • Describing the art in creating an effective model
  • Creating new models to solve complex business problems
 
LESSON 3

Model Statistics and Forecasting

  • Presenting and analyzing data using statistical techniques
  • Forecasting financial data using regression analysis
  • Assessing the quality of a multiregression model
 
LESSON 4

Modeling Risk and Uncertainty

  • Identifying uncertainty as it exists in the business world
  • Developing simple techniques to handle uncertainty
  • Using Monte Carlo simulations to handle uncertainty
  • Using option pricing models to handle uncertainty

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

Additional Details

Four 3-hour sessions run over a 2 week period

Live Online courses are delivered in partnership with the American Management Association.

These courses offer the high-calibre faculty and quality content that Canadian Management Centre is known for, but in a live online format— delivered in easy-to-manage lesson installments that won’t disrupt your work week. Learn new skills, sharpen existing ones and enhance your career journey!

  • Interactive, instructor-led course in a user-friendly platform
  • Talk and text with faculty and peers via chat and VoIP
  • Share files and work in breakout group activities
  • Access live, 24/7 customer support throughout your AMA learning experience
  • Lessons are divided into manageable 3-hour blocks

Fee

  • $2,500 Member         
  • $2,799 non Member

    Become a Member and save
     

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.

Accreditation