Beacon
FinRecruit
FinConsult
Future of Finance
Linkedin

FMI - Financial Modeling Institute

The FMI was established by The Marquee Group in collaboration with the Financial Modeling World Championships. The Marquee Group is a leading global provider of financial modeling training and consulting. Since 2012, the Financial Modeling World Championships is the world’s largest professional competition for Microsoft Excel, Financial Analysis, Investment Analysis, and Financial Modeling with a community of over 10,000 professionals and students. We recognized the skills shortage and the need for a universal, credible, accurate, and high-quality technical certification program for financial modeling. FMI collaborates with global experts and thought leaders in the field who are committed to promoting best practices, reducing risk, and improving standardization in the financial modeling profession. The FMI celebrates financial modelers across the world and our certification exams improve global skills in financial modeling.

Course Overview

Financial modeling plays an integral part in business decision-making, with modelers informing key transactions and critical business decisions. This exam is the only accreditation that validates mastery of this skill.

The Advanced Financial Modeler (AFM) is the first of three certification levels offered by the FMI. The AFM exam tests a candidate’s technical modeling ability through building an integrated three-statement model over the course of four hours. Participants who pass the exam will achieve the Advanced Financial Modeler credential.

Aya MohamedFinancial Learning Advisor TL
Customized Corporate Training
We are the 'go-to' experts when it comes to customizing financial training programs. While adhering to the set rules and regulations, we do not interrupt your day-to-day business activities and work with cooperative flexibility to fit the immersing workflow.

Learning Outcome

Build an interactive financial model of the company, including inter-related: Statement of Profit or Loss (Income Statement), Statement of Cash Flows (Cash Flow Statement), Statement of Financial Position (Balance Sheet)

Design a modern model structure based on pre-determined model outputs & requirements

Build a clear revenue schedule to forecast company sales

Recall the techniques for model auditing tax and deferred tax treatment, depreciation calculations, integrity & error checking, and more

Course Outline

  • Certification Overview
  • What Is Financial Modeling?
  • What is a Financial Model Used For?
  • What do you need to be competent at to be a financial modeler?
  • Best-Practice Principles & Model Planning & Architecting
  • Tips for creating a seamless Financial Model

  • Logical Functions
  • Lookup and Reference Functions
  • Working with Text and Dates
  • Macros in Financial Modelling

  • Main Section in every model

  • Building Up the Engine
  • Scenarios
  • Revenue Schedule

  • All Different types of Costs
  • Repeat, Build and Link approach

  • Why we need a depreciation schedule?
  • Forecasting a company’s depreciation expense
  • Building the Depreciation Schedule
  • Capex with HLOOKUP
  • Automating HLOOKUP
  • Capex with SUMIF
  • Capex with TRANSPOSE
  • Depreciation Schedule Waterfall
  • Fully Depreciating Assets
  • Declining Balance Method
  • Including PP&E: Converting depreciation schedule into a Fixed Assets Schedule

  • Building the Tax Schedule

  • Setting up Working Capital Assumptions

  • Debt Definitions
  • Building the Debt Schedule
  • Forecasting Debt and Equity
  • Forecasting Cash
  • Long Term Debt
  • Revolving Credit Facility
  • Modeling the Revolver
  • The Equity Schedule

Who Should Attend

A F M program is open to anyone who has an interest in or currently works in business analysis, business planning, and financial modeling. From entry levels to seasoned industry professionals.

FAQ

To achieve the Advanced Financial Modeler (AFM) accreditation, you need to demonstrate your superior modeling skills by building an integrated 3-statement model from scratch, within a 4-hour time allotment.


To achieve the Chartered Financial Modeler (CFM) accreditation, you are an AFM accreditation holder, and need to demonstrate that you can solve sophisticated problems in Excel to further showcase your financial modeling acumen within a fixed time allotment.

To achieve the Master Financial Modeler (MFM) accreditation, you need to demonstrate that you can expand the global financial modeling knowledge base through your unique contributions to research and insights.


No. Each level is recognised as its own standalone accreditation - although, you will need to complete the prior accreditation to achieve the next level.


Candidates are expected to build a financial model from scratch in order to demonstrate their modeling skills.


The FMI administers virtual exams several times per year. In the virtual format, you can register and write from anywhere in the world.

In order to assess true financial modeling ability, we adhere to the strictest code of integrity. All exams are:

Proctored: Candidates are supervised during exams.

Closed-book: Candidates are not permitted access to external resources during the exam.

Excel-based: All exams assess applied ability; there is no multiple-choice in an FMI exam.


Exams are graded manually by members of the FMI Grading Team using a formal grading rubric. Each exam is anonymized prior to grading. The exams are subjected to a three step process involving multiple graders. Every effort is made to ensure a fair and appropriate evaluation.


Esraa Mohamed

Financial Learning Advisor TL

  • 2025-05-24 Degla Plaza, Beacon Premises