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

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

For More Inquiries

Esraa Mohamed

Business Development Team Leader

 +201276209989

 e.mohamed@beacon.com.eg

Esraa Mohamed

Business Development Team Leader

 +201276209989

 e.mohamed@beacon.com.eg

Course 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

Topic 1 :Introduction to Financial Model Architecting
  • 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
Topic 2 :Essential Tools & Formulas
  • Logical Functions
  • Lookup and Reference Functions
  • Working with Text and Dates
  • Macros in Financial Modelling
Topic 3 :Building Up the Financial Model
  • Main Section in every model
Topic 4 :Revenue
  • Building Up the Engine
  • Scenarios
  • Revenue Schedule
Topic 5 :Cost of Goods Sold (COGS)
  • All Different types of Costs
  • Repeat, Build and Link approach

Who Should Attend

AFM 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.

Register For Next Orientation Session

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.

Share