Financial Modeling and Forecasting Workshop

ICTD International Centre for Training and Development

What are the topics?

ICTD International Centre for Training and Development

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Who should attend

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.

About the course

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!

## Course Objectives

  • 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

## Course 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 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

Videos and materials

Financial Modeling and Forecasting Workshop at ICTD International Centre for Training and Development

This course has no confirmed dates in the future. Subscribe to be notified when it is offered.


Something went wrong. We're trying to fix this error.

Thank you

Someone from the Coursalytics team will be in touch with you soon.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.