What does the Three Statement Modeling Program Cover?

This program equips candidates with the knowledge and tools required to build models from scratch, hence equipping you with the skills required to develop a fully integrated three statement financial model and perform equity valuation.

Learning Objectives

icon

Understand how to plan the model design and structure

icon

Forecast financial statements

icon

Develop consistent and review friendly models

icon

Understand how to perform a flexible DCF valuation

icon

Perform scenario and sensitivity analysis

Program Agenda

Financial Modeling

Overview of Financial Modeling
Key Excel tools used in financial modeling (Logical & Date functions, Data Tables, Index & Match, Choose, etc.)

Introducing the case study company

Model design and structure for the case study company
Know the key model outputs and their drivers
Understand the requisite inputs
Developing cell styles for model transparency and review

Financial Statements

Extracting, cleaning and normalizing historical financial statements from annual reports
Building error checks in the model

Interest during construction & controlling circular referencing

Repayment waterfall

Reserve accounts, cash sweeps

Forecasting Financial Statements

Revenue modeling or different types of industries
Forecasting key operating expenses and margins
Stepwise projection of income statement, balance sheet, and cash flows

Projecting and Key Schedules

Debt & interest, capex & depreciation and working capital, etc.

Equity Valuation

Understanding and forecasting Free Cash Flows to the firm (FCFF)
Understanding the key inputs and calculating WACC
Calculating and performing sanity check for the terminal value
Developing DCF Valuation

Analysis

Performing sensitivity analysis using data tables
Scenario analysis

Developing the model from scratch for a large global/ regional public company

Our Expert Trainers

What Our Students Say

Upcoming Dates

Course Title Level Term Location Course Date Duration / Days Price*
5 Level I CFA® Program – Complime... Level I June 18, 2021 Dubai June 25, 2021 34 days (Sun,Tue,Fri) AED 1
7CMA – Part 2 – Revision Pro Level 1 June 28, 2021 Ajman June 30, 2021 34 days (Sun,Tue,Fri) AED 1500

Request a Call Back

The answer to your doubts is just a click away! Simply fill in your details in the form, and we will get in touch with you shortly.