Learning resources AFM

1. Getting Started

00:50:00

FOLLOW ALONG MATERIALS

PDF AFM Exam Case Study - Henderson

XLSX AFM Exam Horizontal Model - Henderson

XLSX AFM Exam Vertical Model - Henderson

XLSX AFM Exam Worksheet - Henderson

PDF AFM Exam Vertical Model - Henderson

The AFM tutorial videos illustrate, step by step, how to build a model from scratch, as required for the AFM exam.

SUPPLEMENTARY READING

PDF AFM Body of Knowledge

PDF AFM Body of Knowledge Summary

VIDEOS

1a VIDEO Welcome

00:05:00

What is the AFM?

1b VIDEO Program Overview

00:09:00

What will the AFM Video Tutorial Series cover?
What learning resources are available?

1c VIDEO Modeling as a Discipline

00:08:00

What is a financial model? What it is used for?
What makes a good financial model?

1d VIDEO Henderson AFM Case Study

00:11:00

What can you expect on the AFM exam?

1e VIDEO Model Planning

00:07:00

1f VIDEO Tab Structure

00:10:00

1g VIDEO Optimal Model Flow

00:12:00

2. The Front End

01:00:00

VIDEOS

2a VIDEO Cover Page

00:11:00

2b VIDEO Executive Summary

00:08:00

2c VIDEO Centering Tiles

00:07:00

2d VIDEO Headers and Footers

00:10:00

2e VIDEO Model Assumptions

00:11:00

2f VIDEO Custom Formatting

00:09:00

2g VIDEO Model Scenarios

00:10:00

2h VIDEO The Live Case

00:14:00

2i VIDEO Combo Box

00:11:00

2j VIDEO Data Validation

00:10:00

3. Revenues

00:45:00

VIDEOS

3a VIDEO The Engine

00:09:00

3b VIDEO Scenario Tag

00:10:00

3c VIDEO Revenue Schedule

00:12:00

3d VIDEO Volume and Capacity

00:11:00

4. Costs

01:30:00

VIDEOS

4a VIDEO Operating Costs

00:14:00

4b VIDEO Cost Schedule

00:13:00

4c VIDEO Backing into Costs

21:00

4d VIDEO Operating Leverage

00:17:00

4e VIDEO Semi Variable Costs

00:14:00

4f VIDEO Build it, then Link it

00:11:00

5. Depreciation

01:45:00

VIDEOS

5a VIDEO Forecasting Depreciation

00:09:00

5b VIDEO Depreciation Schedule

00:17:00

5c VIDEO Capex with HLOOKUP

00:11:00

5d VIDEO Automating HLOOKUP

00:10:00

5e VIDEO Capex with SUMIF

00:06:00

5f VIDEO Capex with TRANSPOSE

00:10:00

5g VIDEO Depreciation Waterfall

00:15:00

5h VIDEO Fully Depreciating Assets

00:13:00

5i VIDEO Declining Balance Method

00:10:00

5j VIDEO Including PP&E

00:07:00

6. Income Tax

00:45:00

VIDEOS

6a VIDEO Forecasting Income Tax

00:12:00

6b VIDEO Current versus Deferred Tax

00:14:00

6c VIDEO Tax Calculation Example

00:10:00

6d VIDEO Income Tax Schedule

00:12:00

7. Working Capital

00:60:00

VIDEOS

7a VIDEO Forecasting Working Capital

00:07:00

7b VIDEO Working Capital Days

00:05:00

7c VIDEO Working Capital Schedule

00:14:00

7d VIDEO Automating Days per Year

00:12:00

7e VIDEO Deriving Working Capital Days

00:12:00

7f VIDEO Calculating Working Capital Balances

00:12:00

8. Capital Structure

01:20:00

VIDEOS

8a VIDEO Forecasting Debt and Equity

00:14:00

8b VIDEO The Debt Schedule

00:07:00

8c VIDEO Forecasting Cash

00:08:00

8d VIDEO Long Term Debt

00:11:00

8e VIDEO Revolving Credit Facility

00:08:00

8f VIDEO Modeling the Revolver

00:20:00

8g VIDEO The Equity Schedule

00:14:00

9. Financial Statements

00:60:00

VIDEOS

9a VIDEO Income Statement

00:13:00

9b VIDEO Cash Flow Statement

00:20:00

9c VIDEO Balance Sheet

00:26:00

10. Outputs and Troubleshooting

00:60:00

VIDEOS

10a VIDEO Model Troubleshooting

00:32:00

10b VIDEO Outputs and Summary

00:10:00

10c VIDEO Model Printing

00:24.00

11. Practice Exams & Checklist

11a FOLDER Practice Exam 1

11b FOLDER Practice Exam 1 Solution

11c FOLDER Practice Exam 2

11d FOLDER Practice Exam 2 Solution

11e FOLDER Practice Exam 3

11f FOLDER Practice Exam 3 Solution

11g PDF Exam Readiness Checklist

12. Mock Exam

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.