Lesson 1
Financial Modeling Introduction (PDF)
Graphs & Pivot Tables (PDF)
VLOOKUP Function - Working with Historical Prices (PDF)
Time Value of Money (PDF)
Lesson 2
Pro Forma Financials (PDF)
IMAX Corporation (Yahoo Finance) - Macro-Enabled Workbook (.xlsm)
IMAX Corporation (Yahoo Finance) - Excel File (.xlsx)
IMAX Corporation (WSJ) - Macro-Enabled Workbook (.xlsm)
IMAX Corporation (WSJ) - Microsoft Excel File (.xlsx)
Lesson 3
Weighted Average Cost of Capital (WACC) & Capital Asset Pricing Model (CAPM) (PDF)
IMAX Corporation (WSJ) - WACC & CAPM - Macro-Enabled Workbook (.xlsm)
IMAX Corporation (WSJ) - WACC & CAPM - Microsoft Excel File (.xlsx)
Lesson 4
Valuation (PDF)
IMAX Corporation (WSJ) - Valuation - Macro-Enabled Workbook (.xlsm)
IMAX Corporation (WSJ) - Valuation - Microsoft Excel File (.xlsx)
Supplementary Materials
Full Lecture Series (PDF)
IMAX Corporation Live Stock Chart
VBA script for MsgBox Pop-Up
VBA script for getformula functions
VBA script for Wall Street Journal Pro-Forma Alignment Macro
VBA script for removing alpha characters from a string of alphanumeric text