FactorPad's video: Calculate monthly returns on stocks in Excel Financial Modeling Tutorials

A financial modeling tutorial on calculating stock returns monthly from sources such as Yahoo Finance including stock prices, stock splits and corporate actions like special dividends in Quant 101. For the full video script plus formulas see: https://factorpad.com/fin/quant-101/calculate-stock-returns.html For the Outline to Quant 101 see: https://factorpad.com/fin/quant-101/quant-portfolio-management.html Zoom to the specific sections here: 01:55 Step 1 - Our Sample Data Set 03:57 Step 2 - Which Return Calculation is Appropriate? 05:06 Step 3 - The Daily Process 11:35 Step 4 - Pricing Sources 15:06 The Math 15:44 Exercise 1 Daily Prices 18:05 Exercise 2 Regular Dividends 19:52 Exercise 3 Special Dividends 20:52 Exercise 4 Splits 22:33 Summary 23:06 Step 5 - Next: Return Distributions See what else you can learn here: https://factorpad.com Happy Learning!