📋 How to Use Practice Files
- Download the CSV data file(s) for the lecture you want to practice
- Download the Practice Guide for step-by-step exercise instructions
- Open the CSV file in Excel and follow the exercises in the guide
- Complete all exercises and verify your results against the expected outcomes
- Save your work - you'll build upon these models in future lectures
2
Excel Functions for Financial Modeling
VLOOKUP, XLOOKUP, INDEX-MATCH, Logical, Date, and Text functions
Data Files (CSV)
lecture-02-practice-data.csv
Employee database for lookup practice
sales-commission-data.csv
Sales data for IF/AND/OR practice
financial-dates-data.csv
Loan schedule for date functions
customer-data-messy.csv
Unclean data for text functions
Practice Guide
Lecture-02-Practice-Exercises-Guide.md
Step-by-step exercises with solutions
🎯 Exercises Included
- VLOOKUP & XLOOKUP employee lookups
- INDEX-MATCH two-way lookups
- IF/AND/OR commission calculations
- Date calculations for loan schedules
- Text cleaning and formatting
- Comprehensive dashboard challenge
4
Financial Statement Mechanics
Income Statement, Balance Sheet, Cash Flow inter-relationships
Data Files (CSV)
lecture-04-financial-statements-data.csv
Income Statement & Cash Flow data
lecture-04-balance-sheet-data.csv
Balance Sheet data for 3 years
Practice Guide
Lecture-04-Practice-Exercises-Guide.md
Step-by-step exercises with solutions
🎯 Exercises Included
- Build a three-statement model
- Link Net Income to Retained Earnings
- Reconcile Cash Flow to Balance Sheet
- Vertical common-size analysis
- Horizontal trend analysis
- Working capital calculations
5
Building a Historical Model
Input historicals, calculate ratios, trend analysis, quality checks
Data Files (CSV)
lecture-05-historical-model-data.csv
5-year historical financial data
Practice Guide
Lecture-05-Practice-Exercises-Guide.md
Step-by-step exercises with solutions
🎯 Exercises Included
- Build 5-year historical Income Statement
- Calculate 15+ financial ratios
- YoY growth and CAGR calculations
- Common-size trend analysis
- Error detection dashboard
- Model validation checks
6
Working Capital & Capex Modeling
NWC cycles, CAPEX depreciation, PP&E roll-forwards
Data Files (CSV)
lecture-06-nwc-data.csv
5-year NWC data for 5 companies
lecture-06-capex-data.csv
CAPEX & PP+E roll-forward data
Practice Guide
Lecture-06-Practice-Exercises-Guide.md
Comprehensive exercises with solutions
🎯 Exercises Included
- Calculate DSO, DIO, DPO for 5 companies
- Build days-based NWC forecast
- Create depreciation schedules (straight-line)
- Build complete PP&E roll-forward
- Implement quality checks & validation
- Challenge: Complete integrated model
Tip: After downloading, open CSV files in Excel and save as .xlsx to preserve formulas and formatting. The practice guides are in Markdown format - you can view them in any text editor or use a Markdown viewer for better formatting.