Apply Now

Global Financial Modeling Program

nse_line

A Pathway to

Advanced Financial Modeler (AFM)

A global accreditation program to validate your skills in
Financial Modeling

In collaboration with

Financial Modeling Institute (FMI)

Attain Advanced Financial Modeler Accreditation

Live Sessions with Ask-Me-Anything on AFM

FMI Community &Learning Resources Access


International Knowledge Partners

PROGRAM OVERVIEW

program_overview.png

GFMP (Global Financial Modeling Program) is a comprehensive certification program designed for professionals to pursue distinction in Financial Modeling that validates their skills at a global level.


With a growing economy and increasing demand for financial analysts, there are expanding career prospects for talented professionals in sectors like investment banking, consulting, and corporate finance, among others.


NSE Academy in partnership with Financial Modeling Institute (FMI) is offering the Global Financial Modeling Program. This program empowers finance and accounting professionals to develop and validate important modeling skills needed for creating accurate financial forecasts and supporting critical business decisions. With learner base spread over 120 countries, FMI the top accreditation body for Financial Modelers known globally will certify learners thereby equipping you with globally marketable skills.

HOW WILL THIS PROGRAM BENEFIT YOU?


The program offers a compelling catalog of payoffs for those The program offers a compelling catalog of payoffs for those who register for the course. Some of the highlights of the program include a robust learning experience with live and self-paced training, multiple certificates, a digital badge, and 12 months of access to learning materials.

Advanced Financial Modeler (AFM) Accreditation through AFM examination

Four certificates and a digital badge to exhibit your skills & knowledge

Get your credentials listed on FMI website

FMI Learning Material and live sessions on AFM exam tips & strategy

Join FMI global community of financial modelers

“Ask-Me-Anything” Sessions by FMI senior professionals

Self-Paced program on Financial Planning and Analysis & Power BI & Tableau

Access to NSE Knowledge Hub & AFM learning materials for 12 months

evaluation

WHY GLOBAL ACCREDITATION IS IMPORTANT IN FINANCIAL MODELING

Certified financial modelers who adhere to established best practices and standards enhance their career prospects by ensuring that their models are precise, consistent, and reliable. This commitment reduces the risk of errors, leading to more trustworthy financial forecasts and analyses, eventually making them invaluable assets in the finance industry. A Global Accreditation can

  • Elevate skill level and increase competence and confidence of those building models
  • Provide those who pass with an independently verified, internationally recognized modeling accreditation
  • Improve the quality of all models built internally and speed up the modeling projects.
  • De-risk the entire process and increase the likelihood that the models will be flawless to enhance optimal business decisions.

WHO IS THIS PROGRAM FOR?

The program is designed specifically for finance professionals eager to elevate their analytical prowess and learn the art of creating sophisticated financial models.


CAs/ CMAs/ CFAs, Cost Accountants, Financial Planners and Analysts seeking to enhance their modeling skills for application across industries.

Professionals in Investment Banking, Commercial Banking, Equity Research, Corporate Finance: For creating financial models, valuations, and supporting transactions.

Independent Directors, CXOs, Consultants & Business Heads: For budgeting, forecasting, and strategic decision-making.

Entrepreneurs, Mezzanine Financing, Portfolio Managers, Private Equity/ Venture Capitalists: For investment evaluation, financial planning, and business growth.

Risk Managers, Business Analysts, Real Estate Financing and Project Managers: For managing financial risks, project feasibility, and financial forecasting.

MBA Students and recent Graduates: This program suits final-year students aspiring to launch a career in Financial Modeling.

Sirmaur_building

ADVANCED FINANCIAL MODELER

(AFM ACCREDITATION EXAM)


AFM Overview

The AFM accreditation is the flagship program of the Financial Modeling Institute (FMI). This prestigious certification is renowned globally for its rigorous standards and comprehensive curriculum. AFM accreditation holders have not only learned but also demonstrated their ability to construct top-tier 3-statement financial models. These models are meticulously designed to avoid common errors, highlighting the holder’s remarkable skills and disciplined approach to financial modeling.

AFM “X” Factor: Winning Proposition

  1. Upon passing the AFM exam, successful candidates receive a digital badge to highlight and validate their financial modeling skills.

  2. Those who achieve the AFM designation can use the letters “AFM” in their signature and social media pages online

  3. Those who pass the AFM assessment will be included in FMI’s Directory of Accreditation holders

*source

Once you attain the AFM accreditation, you will be able to...

  1. Validate your ability to build a three-statement model of a company from scratch.
  2. Create a model that can be used as a critical decision-making tool, allowing users to make accurate and informed financial decisions.
  3. Use a financial model as a powerful communication tool to tell the story of a company clearly and effectively.
  4. Demonstrate the technical modeling skills most valued by employers, clients, and stakeholders.

What Makes it Unique?

  1. Credible Skill Assessment: Validate your ability to create a 3-statement model of a company from scratch in Excel

  2. Rigorous Process: Your exam is proctored, time-bound and graded by instructors - success is earned.

  3. Access to the FMI Community: A platform for financial modelers that offers access to networking opportunities, and exclusive webinars hosted by industry practitioners.

  4. Learning Resources: Receive access to highly regarded self-study learning resources with exam preparation sessions.

financemodeling

AFM LEARNING RESOURCES

Sirmaur_img

AFM candidates are provided with access to the online FMI Community which houses the learning resources used to prepare for the AFM exam & take it with confidence.


Step-by-step financial modeling tutorial of sixty videos

Live training on AFM tips & exam strategy by FMI

Sample models, practice exams and solutions

Ask-Me-Anything sessions by FMI senior instructors to answer exam related questions

Access to learning resources for 12 months

LEARNING JOURNEY

Oct - Dec’ 2024

Start Learning

with FMI Learning Resources.

Jan’ 2025

Live Sessions

on AFM tips & exam strategy.

Feb’ 2025

Live Sessions

“Ask-Me-Anything” to get your doubts cleared.

Feb 22’ 2025

Take the 4-Hour

Proctored Exam to gain AFM Accreditation.

AFM EXAM & ASSESSMENT PROCESS

AFM learners must pass a rigorous, proctored, 4-hour exam in which they are provided with a case study and are required to build a 3-statement model of a company from scratch.

1
The AFM assessment is 4-hours; closed book; no multiple choice
2
Candidates are provided with a case study and an Excel file with historical financial data
3
Candidates are required to design and build a dynamic, best-in-class 3-statement financial model of a company from scratch
4
The AFM assessment uses virtual proctoring software
5
Candidates are supervised throughout the exam: onscreen activity is recorded
6
Grading is completed by AFM accreditation holders and takes approximately 10 weeks

Candidates Provide: Computer | Excel | Internet Connectivity | Webcam | Speakers | Microphone

Lock the Exam Date: February 22, 2025

AFM LEARNING MODULES

This module covers the different sections in the "Front End" of a financial model. By completing this module, you will understand:

  1. The need for and importance of financial models

  2. The attributes of a strong financial model

  3. How to plan a financial model

  4. The two approaches to tab structure.

  5. How to design and layout your model clearly and logically.

This module covers the different sections in the "Front End" of a financial model. By completing this module, you will understand:

  1. How to build a cover page and why it is important

  2. Key attributes of an executive summary

  3. Important formatting concepts for models

  4. How to build scenarios for a financial model

The Revenues module covers how to forecast revenues and build a company’s revenue schedule. By completing this module, you will understand:

  1. Various methodologies to forecast revenues

  2. How to build a revenue schedule

  3. How to incorporate capacity constraint in your revenue schedule.

The Costs module covers how to forecast the different types of costs and build a company cost schedule. By completing this module, you will understand:

  1. The correct way to forecast fixed, variable, and semi-variable costs

  2. The implications of operating leverage

  3. A methodology to create financial statements quickly and effectively

The Depreciation module covers how to build a company’s depreciation schedule. By completing this module, you will understand:

  1. Various methodologies to depreciate fixed assets

  2. How to structure and build a depreciation schedule

  3. Excel functions that allow you to work with Capex forecasts

  4. How to link depreciation schedule outputs to your financial statements

The Income tax module covers how to build a company's income tax schedule. By completing this module, you will understand:

  1. Why it is important to build an effective income tax schedule

  2. The cause of deferred tax

  3. How to build an income tax schedule

  4. How to link the income tax schedule to your financial statements

The Working Capital module covers how to build a company's working capital schedule. By completing this module, you will understand:

  1. The differences between working capital and other assets and liabilities.

  2. The various assumptions and calculations required to forecast working capital.

  3. How to forecast working capital.

  4. How to build a working capital schedule.

The Capital Expenditure module covers how to build a company's CapEx schedule. By completing this module, you will understand:

  1. The common features of various types of debt and equity.

  2. How to build a debt and equity schedule.

  3. Why do we model cash in the debt schedule?

  4. Key considerations while modeling the revolver.

The Financial Statements module covers how to build the three financial statements: Income Statement, Cash Flow Statement, and Balance Sheet. By completing this module, you will understand:

  1. How to build an Income Statement

  2. How to build a Cash Flow Statement

  3. How to build a Balance Sheet

This section covers the steps to finalize your model: building outputs, troubleshooting errors, and formatting for printing. By completing this module, you will understand:

  1. The most common reasons why the Balance Sheet does not balance

  2. How to fix common modeling errors

  3. How to format and prepare your model for presentation

This module covers the different sections in the "Front End" of a financial model. By completing this module, you will understand:

  1. The need for and importance of financial models

  2. The attributes of a strong financial model

  3. How to plan a financial model

  4. The two approaches to tab structure.

  5. How to design and layout your model clearly and logically.

The Revenues module covers how to forecast revenues and build a company’s revenue schedule. By completing this module, you will understand:

  1. Various methodologies to forecast revenues

  2. How to build a revenue schedule

  3. How to incorporate capacity constraint in your revenue schedule.

The Depreciation module covers how to build a company’s depreciation schedule. By completing this module, you will understand:

  1. Various methodologies to depreciate fixed assets

  2. How to structure and build a depreciation schedule

  3. Excel functions that allow you to work with Capex forecasts

  4. How to link depreciation schedule outputs to your financial statements

The Working Capital module covers how to build a company's working capital schedule. By completing this module, you will understand:

  1. The differences between working capital and other assets and liabilities.

  2. The various assumptions and calculations required to forecast working capital.

  3. How to forecast working capital.

  4. How to build a working capital schedule.

The Financial Statements module covers how to build the three financial statements: Income Statement, Cash Flow Statement, and Balance Sheet. By completing this module, you will understand:

  1. How to build an Income Statement

  2. How to build a Cash Flow Statement

  3. How to build a Balance Sheet

This module covers the different sections in the "Front End" of a financial model. By completing this module, you will understand:

  1. How to build a cover page and why it is important

  2. Key attributes of an executive summary

  3. Important formatting concepts for models

  4. How to build scenarios for a financial model

The Costs module covers how to forecast the different types of costs and build a company cost schedule. By completing this module, you will understand:

  1. The correct way to forecast fixed, variable, and semi-variable costs

  2. The implications of operating leverage

  3. A methodology to create financial statements quickly and effectively

The Income tax module covers how to build a company's income tax schedule. By completing this module, you will understand:

  1. Why it is important to build an effective income tax schedule

  2. The cause of deferred tax

  3. How to build an income tax schedule

  4. How to link the income tax schedule to your financial statements

The Capital Expenditure module covers how to build a company's CapEx schedule. By completing this module, you will understand:

  1. The common features of various types of debt and equity.

  2. How to build a debt and equity schedule.

  3. Why do we model cash in the debt schedule?

  4. Key considerations while modeling the revolver.

This section covers the steps to finalize your model: building outputs, troubleshooting errors, and formatting for printing. By completing this module, you will understand:

  1. The most common reasons why the Balance Sheet does not balance

  2. How to fix common modeling errors

  3. How to format and prepare your model for presentation

AFM PARTICIPANT’S SKILLS CHECKLIST

Section 2

Accounting

Section 3

Model Design and Checking

Section 4

Finance

1.1 Formatting and Shortcuts

  1. Custom Formatting Techniques
  2. Use Keyboard Shortcuts (Hotkeys)
  3. Use Keyboard Shortcuts (Menus)
1.2 Logical Functions

  1. Math and rounding functions
  2. IF function
  3. AND function
  4. OR function
1.3 Lookup and References Functions

  1. CHOOSE function
  2. VLOOKUP function
  3. HLOOKUP function
  4. OFFSET function
  5. INDEX function
  6. MATCH function
  7. XLOOKUP function
1.4 Working with Text and Dates

  1. Use various date functions.
  2. CONCATENATE function
  3. TEXT function
1.5 Scenario Analysis

  1. Run scenario analysis to manage risk
  2. Use drop-down menus or Data Validation
1.6 Circular References

  1. Understand model circularity and why professionals use it, and others do not

  2. Locate and manage circular references

  3. Eliminate non-intentional circular references

  4. Formula error checking

1.7 Printing & Formatting

  1. Create dynamic headers and footers
  2. Set the print area and print titles
2.1 Accounting Fundamentals:

  1. Structure the financial statements
  2. Understand the Income Statement
  3. Understand the Cash Flow Statement
  4. Understand the Balance Sheet
  5. Key linkages between the financial statements
  6. Business activities
3.1 Financial Modeling Design:

  1. Identify relevant information in the company's financial statements and notes.
  2. Develop reasonable assumptions.
  3. Create the ability to run different scenarios.
  4. Incorporate good modeling practices.
  5. Build models with different styles and layouts.
  6. Use clean model design that is easy to follow electronically or if printed
3.2 Integrity and Error Checking:

  1. Identify errors using various troubleshooting techniques.
  2. Find unidentified hard codes quickly and easily.
  3. Use Excel to show the formulas underlying output.
  4. Use Excel to find inconsistencies in the model.
  5. Use Excel’s auditing tool to trace formulas Use Excel tools to help with integrity checking.
  6. Perform audit trials
4.1 Operating and Financial Schedules:

  1. Build a detailed revenue forecast based on price per unit and number of units sold
  2. Ensure business is not operating at greater than capacity
  3. Analyze and make reasonable projections for operating costs including fixed and variable costs
  4. Fixed assets schedule – includes capital expenditure and depreciation
  5. Intangible assets
  6. Working capital schedule
  7. Income tax schedule showing the difference between accounting and taxable income which gives rise to deferred income tax
4.2 Capital Structure Modeling:

  1. Model a detailed debt schedule
  2. Incorporate different types of debt including senior secured term debt and a revolving credit facility
  3. Include a cash sweep on certain types of debt
  4. Calculate interest on cash and debt balances
  5. Model Common Stock, Additional Paid-in Capital and Preferred Stock accounts.
  6. Incorporate dividends, share issues and repurchases.
  7. Understand differences between authorized, issued, and outstanding shares
  8. Calculate coverage and leverage ratios
4.3 Three Statement Modeling:

  1. Build 3-statement projections.
  2. Construct the Income Statement, Cash Flow Statement and Balance Sheet

PROGRAM DIRECTOR

director img
Ian Schnoor, CFA, CFM
Ian Schnoor is the Executive Director of
Financial Modeling Institute (FMI), the world's only financial modeling accreditation organization. Ian developed and created the Financial Modeling Practical Skills Module for CFA Institute that is available to CFA Level 1 candidates.
Ian began his career in the Investment Banking departments at Citigroup and BMO Capital Markets. He holds a Bachelor of Commerce Honours degree with academic distinction and is also a CFA charter holder. In 2002, Ian founded The Marquee Group, a leading provider of financial modeling training and consulting, which was sold to Training the Street in 2023. Ian is a passionate teacher who has trained thousands of students and professionals in practical financial modeling skills.

ELEVATE YOUR SKILLS WITH INTERNATIONAL CERTIFICATES

Enhancing your learning journey with additional certificate courses to expand your knowledge These certificate programs equip you with advanced data visualization and business intelligence skills, enabling you to transform complex data into actionable insights. They also provide a deep understanding of financial analysis techniques, helping you make informed decisions and drive strategic growth.
powerbi.png
Certificate in Power BI by NSE Academy & KPMG in India kpmg.png

Power BI Desktop is a feature-rich data mashup and report authoring tool. It combines data from disparate databases, files, and web services with visual tools that help you understand and fix data quality and formatting issues automatically. This course can help you significantly enhance your data analytics skills, to create compelling reports and dashboards. You will learn how to manage large datasets effectively while gaining knowledge of in demand skills in recent times. Additionally, it may give an edge to your career with actionable insights.


Module 1: Introduction to Power BI
Module 2: Importing data and creating reports and visualizations
Module 3: Query editor: Introduction, how to use and reuse along with data normalization
Module 4: Data modelling: Creating relationships,
calculated columns & measures
Module 5: Building hierarchies
faculty image

Certificate in Insightful Financial Analysis by NSE Academy and AICPA&CIMA AICPA _logo.webp

There are several reasons why you would conduct a financial analysis, from investment decisions to career management. It's a valuable tool used to tell a comprehensive story. The Business Learning Institute has developed this course.


Key topics include:
  1. 1. Importing data and creating reports and visualizations
  2. 2. Importing data and creating reports and visualizations
  3. 3. Corporate overview
  4. 4. DuPont analysis
  5. 5. Industry analysis
  6. 6. Horizontal and vertical analysis
  7. 7. Business strategy
  8. 8. Continuity plan
  9. 9. Ratio analysis

PROGRAM PRICE
INR 70,000 + GST 18%

REGISTER NOW!
GFMP Certificate issued by NSE Academy & Financial Modeling Institute
Exam Fee for Advanced Financial Modeler (AFM)
AFM Learning Resources & FMI Community Access for 12 months
Live Sessions on AFM Exam Guidance & Strategy
Ask-Me-Anything Sessions
NSE Knowledge Hub Access for One Year
Certificate in Power BI by NSE Academy & KPMG in India
Certificate in Insightful Financial Analysis by NSE Academy and AICPA & CIMA

Learning is more powerful when you join with your colleagues.

ABOUT THE FINANCIAL MODELING INSTITUTE (FMI)

fmilogo.png
FMI is dedicated to promoting excellence and advancing the discipline of financial modeling on a global scale with candidates in over 100 countries. Through its rigorous accreditation programs, FMI empowers finance and accounting professionals to develop and validate necessary modeling skills needed for creating accurate financial forecasts and supporting critical business decisions. In an industry where financial models drive major transactions, earning an FMI accreditation demonstrates a professional's ability to deliver high-quality results and mitigate transaction risks, providing clients and employers with increased confidence.
FMI also offers its members access to the member’s community, where they can continuously refine their skills, attend exclusive webinars led by industry consultants, and network with peers from around the globe. In partnership with prestigious organizations like AICPA & CIMA, ACCA, ICAEW, and the CFA Institute, FMI enhances the value of its accreditations, setting the global standard for financial modeling knowledge.
As the only body solely dedicated to financial modeling accreditation, FMI is committed to elevating the profession, fostering better decision-making, and advancing the finance industry by ensuring that professionals have the skills needed to excel in their roles. FMI candidates work at prestigious organizations including Amazon, EY, General Motors, Deloitte, KPMG & Mitsui & Co. among others.

FMI Community Advantage

An unparalleled online global platform for financial modelers that offers access to learning resources, networking opportunities, exam preparation sessions, and exclusive webinars hosted by industry practitioners.
The FMI Community contains learning resources like learning roadmap, preparation videos, and practice exams etc. FMI community offers:
Place to ask technical questions
Networking opportunities
Exclusive events & webinars
Exam Q&A sessions

*Source

Candidates in 100 Countries

Earn an FMI Accreditation

Attend Exclusive Webinars

SupportBusiness Decisions

ABOUT NSE ACADEMY LIMITED

nse_building
NSE Academy Ltd. is a wholly owned subsidiary of the National Stock Exchange of India Ltd. (NSEIL). NSE Academy enables the next generation of BFSI and FinTech professionals with industry-aligned skills through capacity-building programs and certification courses, powered by an online examination and certification system. The courses are well-researched and carefully crafted with input from industry professionals.
NSE Academy works closely with reputed universities and institutions across India in building a competent workforce for the future of BFSI and FinTech. NSE Academy also promotes financial literacy as an essential life skill among youngsters - a contribution towards financial inclusion and wellbeing.

Contact NSE Academy for early bird offers, special pricing and corporate nominations.

Shivkant Singhal:
shivkants@nse.co.in
Rajender Jeena:
+91 97110 40567

Disclaimer

  • It is clarified that NSE Academy does not, in any manner whatsoever, assure, warrant, guarantee, or promise any job/placement/advancement to any Participant. Under no circumstances, NSE Academy shall be held responsible/liable for failure on the part of the Participants to pass / successfully clear the interview process or the requirements to successfully secure a job.
  • The information in this document can be used only by NSE Academy Ltd. It may not be reproduced in whole, or in part, nor may any of the information contained therein be disclosed without the prior consent of the authorized representatives of "NSE Academy Ltd." except within the organization.
  • Any form of reproduction, dissemination, copying, disclosure, modification, distribution, and or publication of this material is strictly prohibited.
  • The "Global Financial Modeling Program" program is administered by the NSE Academy Ltd and Financial Modeling Institute, Canada. The participants need to complete certificate criteria independently to be eligible for the respective certificates.
  • The Course Content/Outline mentioned herein is indicative and may be modified by NSE Academy in the best interest of the participants
  • The fee paid is non-transferable and non-refundable.
  • https://fminstitute.com/