I took the monthly total returns for the S&P going back to 1926 and calculated the 12-month total returns that followed each month. I know, it’s kind of hard to explain so I’m hoping the graphic I put together will explain it better. Basically, I looked at the monthly return ranges (along with the number of times that return range occured) and using the “AVERAGEIFS” Excel function, I calculated the average total returns in the 12 months that followed that range. Interesting stuff. Notice how the bulk of the returns occured in the 0% to 2% range.
Similar Posts:
- Where To Find Debt Excel Spreadsheets
- IRS: Your audit notice is in the mail
- Is real estate still a good investment?
- How to Create a Debt Ratio Formula
- Low Interest Rates and You: How to make it Work to your Advantage
