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/c...
For the Outline to Quant 101 see:
https://factorpad.com/fin/quant-101/q...
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!
