1. Getting Started
00:50:00
Follow Along Materials
Supplementary Reading
VIDEOS
1.a VIDEOWelcome
00:05:00
- What is Foundations in Financial Modeling?
1.b VIDEOCourse Overview
00:09:00
- What will the Foundations Video Tutorial Series cover?
- What learning resources are available?
1.c VIDEOModeling as a Discipline
00:08:00
- What is a financial model? What it is used for?
- What makes a good financial model?
1.d VIDEOOptional - Henderson AFM Case Study
00:11:00
- What can you expect on the AFM exam?
1.e VIDEOModel Planning
00:07:00
1.f VIDEOTab Structure
00:10:00
1.g VIDEOOptimal Model Flow
00:12:00
2. Financial Model Design
01:00:00
VIDEOS
2.a VIDEOCover Page
00:11:00
2.b VIDEOExecutive Summary
00:08:00
2.c VIDEOCentering Tiles
00:07:00
2.d VIDEOHeaders and Footers
00:10:00
2.e VIDEOModel Assumptions
00:11:00
2.f VIDEOCustom Formatting
00:09:00
2.g VIDEOModel Scenarios
00:10:00
2.h VIDEOThe Live Case
00:14:00
2.i VIDEOCombo Box
00:11:00
2.j VIDEOData Validation
00:10:00
3. The Revenue Schedule
00:45:00
VIDEOS
3.a VIDEOThe Engine
00:09:00
3.b VIDEO Optional - Scenario Tag
00:10:00
3.c VIDEORevenue Schedule
00:12:00
3.d VIDEOOptional - 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. FMI Foundations Exam
11.a FOLDERPractice Exam 1
11.b FOLDERPractice Exam 1 Solution
11.c FOLDERPractice Exam 2
11.d FOLDERPractice Exam 2 Solution
11.e FOLDERPractice Exam 3
11.f FOLDERPractice Exam 3 Solution
11.g PDFExam Readiness Checklist