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/c...
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/q...
See our other learning resources at:
https://factorpad.com
Happy Learning!