Introduction to Financial Modeling

The objective of this program is to equip delegates with the knowledge and skills to forecast financial statements for a public or private company using Excel tools.

Learning objectives

Learn and apply excel tools useful in financial forecasting
Understand and design the layout of a flexible model
Forecast financial statements of a public or private company
Apply scenario analysis to the forecasted financial statements
Prepare charts for data presentation

Who should attend

Financial accountants, finance controllers, corporate bankers
Professionals and graduate students working or aspiring to work in the field of:

Asset management
Investment banking
Sovereign wealth funds
Private equity
Corporate finance
Portfolio management
Equity research

Agenda

Day 1

Overview of Financial Modeling

Excel tools used in financial modeling

Basic Math Functions:
- SUM
- AVERAGE
- MAX
- MIN
- SUMIF
- COUNTIF
- LARGE
- SMALL and many more
Logical Functions:
- IF and nested IFs
- AND
- OR
Date functions:
- EOMONTH
- EDATE
Absolute and Relative cell referencing
Cell styles and quick access tool bars

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

Incorporating historical financial statements of the subject company

Building Balance Sheet error check in the model

Day 2

Forecasting financial statements:

Forecasting revenue
Forecasting key operating expenses and margins

Projecting key schedules:

debt & interest
capex & depreciation
Working capital and more

Stepwise projection of income statement, balance sheet and cash flows

Incorporating scenario analysis

Charting to present the forecasted data:

Different chart types – Single axis and combo charts
Using dynamic chart titles and data labels

Case Study: Developing the model from scratch using an interactive case study

Upcoming dates

Currently there are no public classes/sessions scheduled for this course yet. For any in-house or private training, please contact us.

+97145546184