Financial Evaluation and Modeling

Course CodeFI00081

Available Dates & Locations

This course is available in multiple locations and online. Choose the most suitable date and delivery method.

London

Dates

London

Venue / Hotel

82 - 83 Eccleston Square, Pimlico, London SW1V 1PS, UK

Duration
1 Week
Price
€5,775
Kigali

Dates

Kigali

Venue / Hotel

-

Duration
1 Week
Price
€6,350
Manama

Dates

Manama

Venue / Hotel

Diplomatic Area 317, Manama | | Bahrain

Duration
1 Week
Price
€4,725
Madrid

Dates

Madrid

Venue / Hotel

-

Duration
1 Week
Price
€5,775
Singapore

Dates

Singapore

Venue / Hotel

-

Duration
1 Week
Price
€6,250
Rome

Dates

Rome

Venue / Hotel

Piazza Sallustio, 18, 00187 Roma RM, Italy

Duration
1 Week
Price
€6,050
Amman

Dates

Amman

Venue / Hotel

-

Duration
1 Week
Price
€4,200
Milan

Dates

Milan

Venue / Hotel

-

Duration
1 Week
Price
€5,775
Amsterdam

Dates

Amsterdam

Venue / Hotel

Vijzelstraat 68, 1017 HL Amsterdam, Netherlands

Duration
1 Week
Price
€5,775
London

Dates

London

Venue / Hotel

82 - 83 Eccleston Square, Pimlico, London SW1V 1PS, UK

Duration
1 Week
Price
€5,775
Madrid

Dates

Madrid

Venue / Hotel

-

Duration
1 Week
Price
€5,775
Sharm El-Sheikh

Dates

Sharm El-Sheikh

Venue / Hotel

Sheraton Sharm Hotel

El-Salam, Qesm Sharm Ash Sheikh, South Sinai Governorate, Egypt

Hotel Website
Duration
1 Week
Price
€4,350
Barcelona

Dates

Barcelona

Venue / Hotel

La Rambla, 128, 08002 Barcelona, Spain

Duration
1 Week
Price
€5,775
London

Dates

London

Venue / Hotel

82 - 83 Eccleston Square, Pimlico, London SW1V 1PS, UK

Duration
1 Week
Price
€5,775
Sharm El-Sheikh

Dates

Sharm El-Sheikh

Venue / Hotel

Sheraton Sharm Hotel

El-Salam, Qesm Sharm Ash Sheikh, South Sinai Governorate, Egypt

Hotel Website
Duration
1 Week
Price
€4,350
Amman

Dates

Amman

Venue / Hotel

-

Duration
1 Week
Price
€4,200
Vienna

Dates

Vienna

Venue / Hotel

-

Duration
1 Week
Price
€6,050
Casablanca

Dates

Casablanca

Venue / Hotel

-

Duration
1 Week
Price
€4,725
Bangkok

Dates

Bangkok

Venue / Hotel

-

Duration
1 Week
Price
€6,350

Course Overview

By distilling key information regarding cash flow levels and risks, financial modeling helps decision-makers make informed choices based on data analytics that move their firms forward.

In this training program, learn how to build financial models that can be used in corporate finance, investment banking, commercial banking, and portfolio management. The instructor covers financial statement models, investment banking models, M&A models, buyout models, and DCF models—all using Microsoft Excel.

Course Objectives

  • Develop a strong understanding of financial modeling concepts and their practical applications.
  • Enable participants to build and interpret three-statement financial models in Excel.
  • Strengthen the ability to forecast financial performance using historical and projected data.
  • Equip participants with skills to evaluate companies using valuation techniques such as DCF models.
  • Develop proficiency in sensitivity analysis, scenario analysis, and stress testing models.
  • Enhance understanding of investment banking, corporate finance, and equity valuation models.
  • Build practical skills in designing and maintaining financial models for real business use.
  • Improve decision-making skills related to capital raising, investment, and business growth strategies.
  • Provide hands-on experience in buyout, banking, and portfolio investment models.
  • Strengthen the ability to analyze financial performance and assess business value creation.
  • Apply financial modeling techniques across different industries and business environments.
  • Develop Excel-based financial modeling skills for professional financial analysis and reporting.

Who Should Attend

  • Investment Banking professionals and analysts
  • Equity Research analysts and associates
  • Corporate Finance and Financial Planning & Analysis (FP&A) professionals
  • Portfolio and Investment Management professionals
  • Credit analysts and financial risk professionals
  • Project Finance specialists
  • Professionals working in commercial and corporate banking
  • Graduates and junior professionals seeking careers in finance and financial modeling
  • Anyone interested in developing advanced Excel-based financial modeling skills

Course Outline

Financial Modeling Basics

  • What is financial modeling?
  • Why is financial modeling important?
  • Business questions and financial models
  • Data for a model
  • Sources of data
  • Gathering data from FRED for Excel
  • Getting started with the project
  • Excel tips for financial modeling

Corporate Financial Modeling: Three-Statement Financial Model

  • Linking financial statements
  • Setting source parameters
  • Three-statement financial model
  • Assumptions in financial statements
  • Forecasting in financial statements
  • Improving model quality
  • Putting it all together