Finance & Risk Certifications

AFM Prep Programme (Advanced Financial Modeler)

The Financial Modeling Institute's flagship accreditation, where the exam is not a quiz: four hours, closed book, and you build a dynamic three-statement model of a real company from a blank file. This follows FMI's own curriculum and the skills checklist it marks against.

Three-statement modelling · Revenue and cost schedules · Depreciation · Deferred tax · Working capital · Debt and revolver · Audit trails

Enrol or enquire See the curriculum
How it is built

The curriculum and the checklist, both of them

FMI publishes two things and they are not the same list: a tuition curriculum of ten modules, and a skills checklist in four sections that the exam marks against. Both are carried here, module by module and item by item, so you can work the curriculum to learn it and the checklist to test whether you are ready.

Exam access. This is the eligible route to a financial modelling credential. Registration carries 12 months of access to FMI's own self-study resources and the exam sitting, and the handbook is explicit that using those resources is not mandatory. No prerequisites. The exam runs four times a year, in February, May, July and October: four hours, online, virtually proctored, closed book and with no multiple choice. You are given a case study and an Excel file of three years of historical statements, and you build the model from scratch. AFM holders grade it, which takes around eight weeks. FMI suggests 25 hours or more of preparation. Fees and dates are FMI's to state.

Curriculum · FMI AFM handbook 2026-27

2 structures · 14 modules · 98 chapters

Both of the things FMI publishes for the AFM: the tuition curriculum, ten modules from planning a model through to troubleshooting it, and the skills checklist the exam marks against. 14 modules and 98 chapters in all.

Syllabus edition. Built against the FMI Accreditation Program Handbook, Advanced Financial Modeler, 2026-27 edition. Module, section and topic names are FMI's; the handbook text is not reproduced. FMI revises the handbook each year, so check the current edition before you register.

The AFM curriculum10 modules · 37 chapters · around 13 hours of tuition
M1 Introduction Ch 1-5 · 5 chapters · ~1 hr
  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 lay out your model clearly and logically
M2 The Front End Ch 6-9 · 4 chapters · ~2 hr
  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
M3 Revenues Ch 10-12 · 3 chapters · ~1 hr
  1. Various methodologies to forecast revenues
  2. How to build a revenue schedule
  3. How to incorporate capacity constraints in your revenue schedule
M4 Costs Ch 13-15 · 3 chapters · ~1.5 hr
  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
M5 Depreciation Ch 16-19 · 4 chapters · ~2 hr
  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 the depreciation schedule outputs to your financial statements
M6 Income Tax Ch 20-23 · 4 chapters · ~1 hr
  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
M7 Working Capital Ch 24-27 · 4 chapters · ~1 hr
  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
M8 Capital Structure Ch 28-31 · 4 chapters · ~1.5 hr
  1. The common features of various types of debt and equity
  2. How to build a debt and equity schedule
  3. Why we model cash in the debt schedule
  4. Key considerations when modelling the revolver
M9 Financial Statements Ch 32-34 · 3 chapters · ~1 hr
  1. How to build an income statement
  2. How to build a cash flow statement
  3. How to build a balance sheet
M10 Outputs and Troubleshooting Ch 35-37 · 3 chapters · ~1 hr
  1. The most common reasons why the balance sheet does not balance
  2. How to build the executive summary
  3. How to format your model for printing
The AFM skills checklist4 modules · 61 chapters · the exam-readiness list FMI marks against
M1 Excel Ch 1-25 · 25 chapters

1.1 Formatting and Shortcuts

  1. Custom formatting techniques
  2. Keyboard shortcuts (hotkeys)
  3. Keyboard shortcuts (menus)

1.2 Logical Functions

  1. Math and rounding functions
  2. IF
  3. AND
  4. OR

1.3 Lookup and Reference Functions

  1. CHOOSE
  2. VLOOKUP
  3. HLOOKUP
  4. OFFSET
  5. INDEX
  6. MATCH
  7. XLOOKUP

1.4 Working with Text and Dates

  1. Date functions
  2. CONCATENATE
  3. TEXT

1.5 Scenario Analysis

  1. Run scenario analysis to manage risk
  2. Drop-down menus and data validation

1.6 Circular References

  1. Model circularity, and why some 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 and Formatting

  1. Create dynamic headers and footers
  2. Set the print area and print titles
M2 Accounting Ch 26-31 · 6 chapters

2.1 Accounting Fundamentals

  1. Structure of the financial statements
  2. The income statement
  3. The cash flow statement
  4. The balance sheet
  5. Key linkages between the financial statements
  6. Business activities
M3 Model Design and Checking Ch 32-44 · 13 chapters

3.1 Financial Modelling Design

  1. Identify relevant information in a company's financial statements and notes
  2. Develop reasonable assumptions
  3. Create the ability to run different scenarios
  4. Incorporate good modelling practices
  5. Build models with different styles and layouts
  6. Use clean model design that is easy to follow on screen or 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
  6. Use Excel tools to help with integrity checking
  7. Perform audit trails
M4 Finance Ch 45-61 · 17 chapters

4.1 Operating and Financial Schedules

  1. Build a detailed revenue forecast based on price per unit and units sold
  2. Ensure the business is not operating above capacity
  3. Project operating costs across fixed and variable costs
  4. Fixed assets schedule, including capital expenditure and depreciation
  5. Intangible assets
  6. Working capital schedule
  7. Income tax schedule, and the deferred tax that the accounting-to-taxable difference creates

4.2 Capital Structure Modelling

  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. Differences between authorised, issued and outstanding shares
  8. Calculate coverage and leverage ratios

4.3 Three Statement Modelling

  1. Build three-statement projections
  2. Construct the income statement, cash flow statement and balance sheet
How it is delivered

Three ways to take AFM Prep Programme (Advanced Financial Modeler)

Self-paced is a document-and-media programme with lifetime access - no live sessions. Cohort and enterprise add live instructor-led training. Mentorship is not offered in any tier.
Feature Self-paced Cohort Enterprise
Format Written chapters, video explainers and podcasts Everything in self-paced, plus scheduled live sessions Everything in cohort, delivered privately to your team
Live sessions None Scheduled, instructor-led Scheduled, instructor-led, private
Mentorship Not offered Not offered Not offered
Access Lifetime Lifetime Lifetime for every enrolled seat
Pace Entirely your own Guided schedule with a peer group Agreed with your desk
Tailoring Fixed curriculum Fixed curriculum Sequenced to your markets, systems and governance
Best for Individuals learning around a job Individuals who want structure and deadlines Desks building the same capability together
For individuals

Get the programme guide

The full chapter list, what each module covers, and how the tiers compare - sent to your inbox as a PDF.

Request the programme guide
For teams

Run this for my desk

Private delivery for your desk, sequenced to your markets and systems. Tell us the team and we will scope it.

Run this for my desk

Bring this to your desk

Download the full curriculum, or talk to us about running it for a team.

Enrol or enquire See the whole track

AFM, Advanced Financial Modeler, CFM and Financial Modeling Institute are trademarks of the Financial Modeling Institute. This is independently written preparation: Durga Analytics is not an FMI partner, is not affiliated with or endorsed by FMI, uses no FMI courseware, video series or practice exams, and awards no accreditation. The handbook is FMI's copyright and its text is not reproduced here. Check FMI's current handbook and exam dates before you register.