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

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!

·         Creative effective financial models that meet your business needs

·         Quantity 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

·         Identity and utilize key business drivers and integrate them into your forecast

·         Effectively communicate the results of your models to team members and senior management

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

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 and Provide Diagnostics

·         Analyze Your Model and Provide Diagnostics

·         Identify Uncertainty in the Model and Design Methods to Address It

·         Present Your Models to a Brand Management Audience

Finance Theory As Used in Modeling

·         Apply the Concepts of Modern Finance

·         Use Various Interest 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

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

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

 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

Course Summary

·         Prepare Models for Presentation

·         Summarize Points Learned in This Course

A variety of methodologies will be used during the course that includes:

·         (30%) Based on Case Studies

·         (30%) Techniques 

·         (30%) Role Play

·         (10%) Concepts

·         Pre-test and Post-test

·         Variety of Learning Methods

·         Lectures

·         Case Studies and Self Questionaires

·         Group Work

·         Discussion

·         Presentation

This rate includes participant’s manual, Hand-Outs, buffet lunch, coffee/tea on arrival, morning & afternoon of each day.

Daily Course Timings:

    08:00 - 08:20       Morning Coffee / Tea

    08:20 - 10:00       First Session

    10:00 - 10:20       Coffee / Tea / Snacks

    10:20 - 12:20       Second Session

    12:20 - 13:30       Lunch Break & Prayer Break

    13:30 - 15:00       Last Session