A financial modeling tutorial on the CAPM model and how active portfolio managers use the Capital Asset Pricing Model to set expected return on a stock in the Quant 101 data analytics course. Find the video transcript and Excel formulas here: https://factorpad.com/fin/quant-101/capm-model.html Zoom straight to the section you are interested in here: 00:50 - Video Outline 01:37 - Step 1 - Setting Expected Returns on Stocks 03:11 - Step 2 - Find Beta with Excess Returns 07:07 - Step 3 - The CAPM Model 11:04 - Step 4 - The Active Management Process 15:27 - Summary 17:03 - Step 5 - Next: Excel's LINEST function For the Outline to the Quant 101 Series see: https://factorpad.com/fin/quant-101/quant-portfolio-management.html See our other learning resources at: https://factorpad.com/ Happy Learning!