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