1. Getting Started
00:50:00
FOLLOW ALONG MATERIALS
- The AFM tutorial videos illustrate, step by step, how to build a model from scratch, as required for the AFM exam.
SUPPLEMENTARY READING
VIDEOS
1.a VIDEO
Welcome
00:05:00
- What is the AFM?
1.b VIDEO
Program Overview
00:09:00
- What will the AFM Video Tutorial Series cover?
- What learning resources are available?
1.c VIDEO
Modeling as a Discipline
00:08:00
- What is a financial model? What it is used for?
- What makes a good financial model?
1.d VIDEO
Henderson AFM Case Study
00:11:00
- What can you expect on the AFM exam?
1.e VIDEO
Model Planning
00:07:00
1.f VIDEO
Tab Structure
00:10:00
1.g VIDEO
Optimal Model Flow
00:12:00
2. Financial Model Design
01:00:00
VIDEOS
2.a VIDEO
Cover Page
00:11:00
2.b VIDEO
Executive Summary
00:08:00
2.c VIDEO
Centering Tiles
00:07:00
2.d VIDEO
Headers and Footers
00:10:00
2.e VIDEO
Model Assumptions
00:11:00
2.f VIDEO
Custom Formatting
00:09:00
2.g VIDEO
Model Scenarios
00:10:00
2.h VIDEO
The Live Case
00:14:00
2.i VIDEO
Combo Box
00:11:00
2.j VIDEO
Data Validation
00:10:00
3. The Revenue Schedule
00:45:00
VIDEOS
3.a VIDEO
The Engine
00:09:00
3.b VIDEO
Scenario Tag
00:10:00
3.c VIDEO
Revenue Schedule
00:12:00
3.d VIDEO
Volume and Capacity
00:11:00
4. Cost Schedule
5. Financial Statements
6. Depreciation
7. Income Tax
8. Working Capital
9. Debt and Equity
10. Outputs and Troubleshooting
11. Practice Exams & Checklist
11.a FOLDER
Practice Exam 1
11.b FOLDER
Practice Exam 1 Solution
11.c FOLDER
Practice Exam 2
11.d FOLDER
Practice Exam 2 Solution
11.e FOLDER
Practice Exam 3
11.f FOLDER
Practice Exam 3 Solution
11.g PDF
Exam Readiness Checklist
12. Mock Exam