Charting stock portfolios with a scatter plot in Excel | Financial Modeling Tutorials

A financial modeling tutorial on charting stock portfolios in Excel after changing weights and monitoring average portfolio returns and portfolio variance using covariance and variance for two stocks.
Find the full transcript and Excel cell formulas here:
factorpad.com/...
Zoom straight to the section you are interested in here:
00:50 - Tutorial Outline
01:25 - Step 1 - Review the Inputs
06:19 - Step 2 - Create Eleven Two-Stock Portfolios
12:08 - Step 3 - Create a Risk and Return Plot
13:45 - Step 4 - Looking Forward
15:20 - Step 5 - Next: Portfolio Theory
For the outline to all tutorials see:
factorpad.com/...
For our other Finance and Technology tutorials see:
factorpad.com
Happy Learning!

[@kylebuchbach8647]

Hi Paul - first, thanks for all you do. I’m capitalizing on tremendous value add through your videos and greatly appreciate your efforts.
Q: L10 and M10...instead of completing these cells using free-hand mathematical calculations, would we be able to use our excel formulas to derive the same result? Or did you not use them for a specific reason? Thank you!