Cart

Pay Online

Certified Financial Modeler (CFM)-UK

Become UK Certified Modeler

Enjoy 50% off in this 50th batch

This batch includes lambda functions and preparation of model using dynamic array functions

Register Here Or
Pay Here
Download Brochure

Introduction

Financial Modeling & Analysis skills are most emerging and required by the industry and organizations. This program is endorsed by The Institute of Financial Accountants (IFA). After successfully completing the course the candidate will be provided with a completion certificate from the Institute of Financial Accountants (IFA) UK. 

Key Features

  • Competitive advantage with emerging skillset
  • Increased recognition with UK endorsement
  • Career Growth with most emerging skill set
  • Practical course with Hands on Practice
  • Online Interactive Instructor Led training
  • Recording of each session is provided
  • Trainer presentation and practice material is provided

Course Contents

  • What is financial modeling?
  • Why you should learn financial modeling skills?
  • Scope of financial modeling
  • Job prospects with financial modeling skills
  • What will the financial model tell us?
  • 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
  • How to define name of cells and ranges
  • How to use name manager
  • Defining names from selection
  • Pros and cons of defined names
  • Introduction to Dynamic Arrays
  • Using to Dynamic Data Tables
  • #Sign and Spilled array behavior
  • New Excel functions, LAMBDAs, Sequence, Transpose, ByRow, ByCol, Sort
  • Preparation of a complete model using dynamic array formulas
  • 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
  • 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
  • Strategies to build financial model.
  • Data Flow to integrate the model.
  • Strategies to forecast revenue for existing organizations and Startups.
  • 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
  • What is sensitivity Analysis
  • How to perform sensitivity Analysis
  • Use of Data Table in performing sensitivity Analysis
  • Revenue and pricing
  • Cost of Sales
  • HR and Payroll
  • Operating Costs
  • Working Capital
  • PPE Lapsing & Depreciation
  • Debt and Loan Amortization
  • Equity – Common & Preferred Equity
  • Income Tax – Current & Deferred Tax
  • How to integrate financial statements
  • Forecasted Income Statement
  • Forecasted Balance Sheet
  • Forecasted Cash Flow Statement
  • Understanding of Discounted Cash Flow (DCF) Model
  • Building of DCF mode with practical Case Study
  • Calculation of
    • NPV
    • IRR
    • Profitability Index (PI)
    • ROI- Return on Investment, and
    • Payback period
  • How to use built in checks to audit a financial model
  • Financial Modeling Auditing techniques
  • Understanding of Formula Auditing
  • Creating Pivot Table and analyzing data with pivot tables
  • How to add Slicers & Timeline
  • Connection of Multiple Pivot Tables
  • Getting and connecting data from multiple sources like excel, text, web, pdf and databases
  • Use of Power Query, Data Modeling and Power Pivot
  • 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

Endorsed By

The Institute of Financial Accountants has endorsed this program.  After successfully completing the course the candidate will be provided with a completion certificate from the Institute of Financial Accountants (IFA) UK.  
 
The IFA is a full member of the International Federation of Accountants.

1 New Batch Starting Details

  • Starting From: Batch 50 is starting from Dec 09, 2024 (InshaAllah)
  • Program Duration: 2 Weeks  | 8 Sessions of 2 hours each
  • Class Days: Monday, Tuesday, Wednesday & Thursday
  • Class Timing: From 8:00pm to 10:00pm (GMT+5, Pakistan Time)
  • Medium of Instruction: English, as this is an international program

2 Program Deliverables

  • Practice Workbooks
  • Case studies
  • Financial Modeling Book
  • Comprehensive Notes
  • Sample Models
  • Recording of each session
  • LEXICON E-Certificate

3 Important Note

• Training Fee includes LEXICON e-Certificate
• IFA UK Certificate fee is separate than training fee
• Delivery of hard copy certificate is free across UK & Pakistan whereas for other countries actual delivery charges will apply

Fee Schedule

Training Fee: PKR 50,000/- | IFA UK Certificate Fee: GBP65

(50% off in training fee for 50th batch)

(Note: Training fee includes soft copy of LEXICON certificate, whereas for hardcopy of IFA UK certificate one has to pay, further the dispatch of hardcopy is free in UK and Pakistan whereas for any other country actual courier charges will apply)

Download Brochure
Register Here
Customer Reviews

Participants Testimonials

It was a great pleasure to be the part of CFM-UK training session conducted by LEXICON. The delivered session had a vast learning aspects adding value to my career & Job. The trainers associated with LEXICON are highly knowledgeable professionals. I am very thankful to LEXICON for opening a professional platform with multiple certifications.

Sania Sultan, CFM
Chief Accountant, Carrefour PAK

I attended Certified Financial Modeler (CFM) UK, this is an excellent course which enhanced my financial modeling skills. I have attended Diploma in IFRS as well, which is very comprehensive program with competent trainer.

Ismail Hajeir
Managing Partner, Ismail Hajeir Auditing of Accounts, UAE

Course is an excellent opportunity for experience modelers to polish their skills and work with a recognized layout, sequence, and framework. I have been preparing and presenting Financial Models since 2015 and I was not expecting to learn this much from the course. Mr. Abdul Shakoor is an excellent teacher, having a very engaging and thought-provoking teaching methodology.

Muhammad Usman Sabir
Manager Investments, Packages Group

Over the duration of CFM course I gained a lot of knowledge and practical strategies that have enabled me to perform more efficiently. Course content was well structured and the tutor’s constructive input and guidance throughout each lesson has been very helpful. I’m looking forward to follow up with another course

Warda Niaz Chaudhry
Finance Executive, PepsiCo

I would like to say thank you to LEXICON trainer who patiently taught me new and advanced knowledge not only related to excel and financial modeling but also topics about real business scenarios. I highly recommend LEXICON to learn financial modeling and for accounting and finance professional.

Cherphil Ann Libunao, CPA, CFM-UK
Financial Planning and Analysis Lead, Philippine

#Certified Financial Modeler (CFM) #Financial Modeling Certification UK #Financial Analysis Training #Financial Planning Courses UK #Investment Analysis Certification #Financial Modeling Courses London #UK Financial Modeling Certification #Excel Financial Modeling Training #Financial Forecasting Courses #Corporate Finance Training UK #Financial Planning and Analysis (FP&A) Certification #Financial Modeling for Investors #Advanced Financial Modeling #Financial Modeling for Banking and Finance #Professional Financial Modeling Certification “Become a certified financial modeler” “Enhance your financial analysis skills” “Master financial modeling with Excel” “Advance your finance career” “Improve financial forecasting accuracy” “Gain expertise in financial planning” “Develop investment analysis skills” “Achieve professional financial modeling certification” “Stay ahead in finance with CFM certification” “Transform financial decision-making” #LEXICON a best institute for financial modeling in Pakistan CFM in Islamabad CFM in Lahore #CFM in Karachi