Advanced Financial Modeler (AFM) Exam Prep Course + Registration

0 (0 Ratings)

Enrolled:8

Level

Intermediate
Last Updated

April 19, 2025
Enrollment validity

Enrollment validity: 365 days
Certificate

Certificate of completion

About Course

Welcome to the AFM Exam Prep Course + Registration, your all-in-one solution to earning the globally recognized Advanced Financial Modeler (AFM) certification from the Financial Modeling Institute (FMI). This course is designed not only to prepare you for the rigorous AFM exam but also to handle your exam registration process seamlessly, so you can focus on what truly matters — mastering financial modeling. Whether you're looking to boost your career or validate your modeling expertise, this course gets you exam-ready and registered in one smooth experience. Let’s get started on your path to certification!

Learn how to build a complete 3-statement financial model from scratch, linking the Income Statement, Balance Sheet, and Cash Flow Statement seamlessly.
Develop a model that follows a clear, logical structure that is both audit-friendly and easy to navigate.
Understand the time-tested strategies and shortcuts needed to meet the strict time limits of the Advanced Financial Modeler (AFM) certification exam.
Gain access to professional tips and modeling techniques that not only boost your speed but improve the quality of your outputs.
Learn how to perform scenario and sensitivity analysis, enabling you to evaluate multiple business cases and make sound financial decisions.

Course Curriculum

Introduction

Course Objectives

00:00
Course Prerequisite

00:00
Why AFM Exam

00:00
Key Features of the AFM Exam

00:00
Resource download

Building the Model Structure

Building Scenarios and Linking Historical FS

Populating Assumption Sheet

Building the Schedule Sheet and Model Sheet

Revenue Schedules

00:00
Cost of Sales Schedule

00:00
Capex & Depreciation Schedule

00:00
PPE & Other Assets Balance

00:00
Updating the P&L Line Items

00:00
Tax Schedules

00:00
Deferred Income Tax Balance

00:00
Working Capital Schedules

00:00
Equity Schedules

00:00
Updating the Model Sheet

00:00
Debt Schedule

00:00
Excess Cash Balance

00:00
Revolving Cash Sweep

00:00
Net Interest Expense

00:00
Dealing with Circular Reference

00:00

Building the Summary Sheet

Finalizing the Model

Student Ratings & Reviews

No Review Yet

Advanced Financial Modeler (AFM) Exam Prep Course + Registration

About Course

What will I learn?

Course Curriculum

Introduction

Course Objectives

Course Prerequisite

Why AFM Exam

Key Features of the AFM Exam

Resource download

Building the Model Structure

Review of Case Study

Creating a Cover Sheet

Creating a Template Sheet

Printer set-up

Creating other Worksheets

Building Scenarios and Linking Historical FS

Creating useful styles

Building the Scenario Structure

Creating Scenarios for Key Inputs

Linking Historical Financials

Populating Assumption Sheet

Revenue Assumptions

Cost Assumptions

Capex and Depreciation Assumptions

Working Capital Assumptions

Tax Assumptions

Debt Assumptions

Equity Assumptions

Other Assumptions

Building the Schedule Sheet and Model Sheet

Revenue Schedules

Cost of Sales Schedule

Capex & Depreciation Schedule

PPE & Other Assets Balance

Updating the P&L Line Items

Tax Schedules

Deferred Income Tax Balance

Working Capital Schedules

Equity Schedules

Updating the Model Sheet

Debt Schedule

Excess Cash Balance

Revolving Cash Sweep

Net Interest Expense

Dealing with Circular Reference

Building the Summary Sheet

Calculating Key Ratios

Building a Linked Summary Sheet

Building Summary for 3 Scenarios

Finalizing the Model

Model Walkthrough

Final Checks

Student Ratings & Reviews