Certified Financial Modeler(CFM-UK)

Financial modeling is the process of building excel based decision-making tool to solve real world financial and operational problems of any business and to make informed decisions.

APPLICATIONS OF FINANCIAL MODELING

Valuing public or private companies
Making credit or capital decisions Budgeting and forecasting (planning for the years ahead)
Making mergers and acquisition decisions
Making credit or capital decisions
Performing financial feasibility analysis of a new project

WHO SHOULD ATTEND

Certified Financial Modeler (CFM) UK is targeted to professionals working in the following fields:

Chief Executive Officers
Chief Financial Officers
Professionals dealing with Strategic planning
Financial Analysts
Financial Planning & Analysis Manager (FP&A)
Accounting and Finance Managers
Portfolio managers
Corporate accountants
Credit analysts

Private equity managers
Corporate finance analysts
Risk managers
Investment bankers
Bank lending Professionals
Compliance Manager
Management consultants
Corporate Finance lawyers

LEARNING OUTCOMES

By the end of this training you will be able to:

Understanding of the advanced Excel functions required for financial modeling
Identification and application of advanced excel functions essential for Financial Modeler.
Financial modelling best practices for preparation of a model.
How to design a robust model structure.
How to perform sensitivity and scenario analysis.
Apply best practices in capital structure modelling and financial appraisal methods.
Build and incorporate Operating & Financial Schedules. Auditing Techniques in Excel to check the integrity and errors.
Calculation of project appraisal tools like NPV, IRR, Profitability Index (PI), ROI and Payback period.
Power Query to get data from multiple sources like excel, text, pdf & databases.
Creating connections among all sources using data modeling
Use of Power Pivot to create interactive dashboards

Build and incorporate Operating & Financial Schedules. Auditing Techniques in Excel to check the integrity and errors.
Calculation of project appraisal tools like NPV, IRR, Profitability Index (PI), ROI and Payback period.
Power Query to get data from multiple sources like excel, text, pdf & databases.
Creating connections among all sources using data modeling
Use of Power Pivot to create interactive dashboards
Creating connections among all sources using data modeling
Use of Power Pivot to create interactive dashboards
Use of Power Pivot to create interactive dashboards

PROGRAM DELIVERABLES

-Practice Workbooks -Case studies -Financial Modeling Book

-Comprehensive Notes -Recording of each session -LEXICON E-Certiﬁcate

Course Outline

Introduction

What is financial modeling?
Why you should learn financial modeling skills
Scope of financial modeling
Job prospects with financial modeling skills
Will the financial model tell us?

Excel Functions and Features Required for Financial Modeling

Understanding of function syntax
Date and time Functions
Logical functions
Array formulas
NPV, XNPV, IRR, XIRR, MIRR
PMT, IPMT, PPMT
Index, Match, Choose
Absolute and Relative Cell references

Defined Names

How to define name of cells and ranges
How to use name manager
Defining names from selection
Pros and cons of defined names

What if Analysis in Excel

How to perform What if Analysis in Excel
Use of Goal Seek
Data Table Option for more than one variable
One way and two way data tables

Model Structure

Understanding Workbook, Worksheet and Cell formatting for model
A detailed discussion on how to arrange workbook
Best tabs structure for worksheets
How to format a sheet for a financial model
Cell formatting
Color coding of cells for easy understanding

Financial Modeling Best Practices & Revenue Drivers

Financial Modeling Best Practices
Strategies to build financial model
Data Flow to integrate the model
Strategies to forecast revenue for existing organizations and Startups.

Scenarios Analysis and Integration with model

What is Scenario Analysis
Selection of Economic and other indicators for scenarios
Scenarios List i.e Base, Best and Worst
Use of Combo Box and Data Validation for Scenario analysis
How to build scenario switch
Scenario switch integration with the model
Summary of each scenario

Sensitivity Analysis

What is sensitivity Analysis
How to perform sensitivity Analysis
Use to Data table to perform sensitivity analysis

Preparation of Schedules for Financial Model

Revenue and pricing
Cost of Sales
HR and Payroll
Operating Costs
Working Capital
PPE Lapsing & Depreciation • Debt and Loan Amortization • Equity – Common and Preferred Equity • Income Tax – Current and Deferred Tax

Preparation of Valuation Model - Case Study

Understanding of Discounted Cash Flow (DCF) Model
Practical Case Study of DCF model
From case study Calculation of
NPV
IRR
Profitability Index (PI)
Return on Investment (ROI) and Payback period

Model Auditing

How to use built in checks in audit
Financial Modeling Auditing techniques
Understanding of Formula Auditing tools

Data Analysis and Dashboard Reporting using Power Excel

Use of Power Query, Data Modeling and Power Pivot
Getting and connecting data from multiple sources like excel, text, web, pdf and databases
Data Modeling to create relationship of multiple data sources
Preparation of Pivot tables using power pivot
Use of Pivot Charts to prepare dashboards
How to create connection among multiple pivot charts
Principles of Dashboard Reporting
Use of slicers and timelines in dashboard
Preparation of a dynamic and integrated dashboard from a case study

International Trainer

Abdul Shakoor

CMA USA, FFA UK, AFM

Abdul currently working as Chief Financial Ofcer (CFO) for TOSHIBA TV and BOSS Home Appliances is an experienced professional having diversied experience in the eld of accounting, nance, Financial Modeling, Data Analysis in Powe Excel, Power BI, teaching, and training. He is also serving as Regional Director of Institute of Financial Accountants (IFA)-UK for Pakistan and heading LEXICON Global organization as well.

Previously he had been teaching as an adjunct faculty member in University of the Punjab and PAC Group. Academically he is an Advanced Financial Modeler (AFM) by Financial Modeling Institute (FMI) Canada, Fellow Member of Institute of Financial Accountants (IFA) UK, Bachelor of Law (LLB), Master of Science in Economics and Master of Philosophy in Management Sciences He has provided open house and on-premises training on Financial Modeling, Data Analysis in Power Excel, and Data Analysis in Power BI to leading organizations in Pakistan and Auditor General Ofce of Papua New Guinea. He has trained hundreds of professionals from UK, Canada, South Africa Saudi Arabia, Dubai, Kuwait, Ghana, Nigeria

He is an approved Trainer for Financial Modeling Institute (FMI) Canada, National Business Development Program of Small and Medium Enterprises & Development Authority (SMEDA) Pakistan