📋 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
7
Debt & Interest Schedules
Debt tranches, interest calculations, repayment schedules, circular references
Data Files (CSV)
lecture-07-debt-schedule-data.csv
Debt schedule data for practice
lecture-07-debt-schedule-template.csv
Debt schedule template
Practice Guide
Lecture-07-Practice-Exercises-Guide.md
Step-by-step exercises with solutions
Data Files (CSV)
lecture-08-integration-data.csv
Integration exercise data
lecture-08-integration-template.csv
Integration template
Practice Guide
Lecture-08-Practice-Exercises-Guide.md
Step-by-step exercises with solutions
9
Scenario & Sensitivity Analysis
Data tables, scenario manager, goal seek, sensitivity dashboard
Data Files (CSV)
lecture-09-scenario-template.csv
Scenario analysis template
lecture-09-sensitivity-data.csv
Sensitivity analysis data
Practice Guide
Lecture-09-Practice-Exercises-Guide.md
Step-by-step exercises with solutions
Data Files (CSV)
lecture-10-dcf-data.csv
DCF valuation practice data
Practice Guide
🎯 Exercises Included
- Calculate FCFF from EBIT and EBITDA
- Terminal value: Gordon Growth vs Exit Multiple
- Discount FCFF at WACC to get Enterprise Value
- Bridge from EV to Equity Value
13
Precedent Transactions Analysis
M&A multiples, control premiums, synergy analysis, football field
Data Files (CSV)
lecture-13-precedent-transactions.csv
Complete transaction data (in-class)
lecture-13-precedent-transactions-practice.csv
Practice exercise data
lecture-13-premium-analysis.csv
Premium analysis template
Practice Guide
Lecture-13-Practice-Exercises-Guide.md
Step-by-step exercises with solutions
Data Files (CSV)
lecture-14-ma-modeling.csv
Complete M&A data (in-class case study)
lecture-14-sources-uses.csv
Sources & Uses exercise template
lecture-14-ppa-template.csv
Purchase Price Allocation template
lecture-14-pro-forma-bs.csv
Pro Forma Balance Sheet template
Practice Guide
Lecture-14-Practice-Exercises-Guide.md
Step-by-step exercises with solutions
🎯 Exercises Included
- Sources & Uses of Funds (CloudNine–ByteVerse)
- Purchase Price Allocation & Goodwill
- Pro Forma Balance Sheet construction
- Premium Sensitivity Analysis (advanced)
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.