Teaching

Time Value of Money lectures.  The spreadsheets used in the lecture videos are here. (choose 'Watch on YouTube' to view the playlist).

This series of videos shows how to compute the weighted average cost of capital (WACC) for Bristol Myers Squibb  using market data from Morningstar Direct. 

Stock and stock valuation lectures.  The spreadsheets used in the videos are here

Estimating alpha using Fama-French 3 Factor model and WRDS data.

Risk, return, and the CAPM lectures. The spreadsheets used in the videos are here. (and below)

Risk and Return.xlsx