Table of Contents

Lesson 1

1. Introduction
2. Graphs and Pivot Tables
   
3. VLOOKUP() Function - Working with Historical Prices
4. Time Value of Money
   • Example 1. Calculate Present Value where Cash Flow is constant at time t.
   • Example 2. Calculate Present Value where Cash Flow changes over time t.

Lesson 2

• Pro Forma Financials

Lesson 3

1. Weighted Average Cost of Capital (WACC) & Capital Asset Pricing Model (CAPM)
   • Example 1. Equity (x) market cap.
   • Example 2. Calculate long-term debt.
   • Example 3. Calculate the cost of debt.

Lesson 4

• Valuation

Supplementary Materials

1. IMAX Corporation (WSJ) Macro-Enabled Excel Workbook (.xlsm)
2. IMAX Corporation (WSJ) Excel Workbook (.xlsx)
3. Full Lecture Series - single PDF file
4. IMAX Interactive Stock Chart - Refreshed Daily
5. UCLA Lectures Compilation (YouTube Video)
6. UCLA Financial Modeling Course - Summer 2018 Cohort (Google Sites - external link)