Message Font: Serif | Sans-Serif

No. of Recommendations: 0
I sort of have two answers for you. The first is the mathematically precise answer you're looking for and the second is a real world answer that will probably not excite you all that much.

1. First answer. The way to find the compounded average return for any time period is to use this formula:

1 - ((ending value/beginning value)^1/compounding periods)

So if we plug things in we get:

1- ((\$109.50/\$100)^1/12) = 0.76% monthly return

That's a little bit less than the 0.79% return if you simply divided 9.5% by 12. That makes sense because the way I figured it takes into effect compounding. You can double check things by doing this:

((1 + 0.76%)^12) - 1 = 9.5%

2. Second answer. My first answer is total false precision. If you look at the last 60 years, I think the number of times the market has returned the average compounded return of those 60 years in any one year was something like 2 years out of 60. In other words, though the average compounded annual return of the S&P 500 index might be something like 8% (not 9.5% as far as I know), the chance that it actually returned pretty much exactly 8% in any one of those 60 years was exceedingly low. More often it was up 20%, down 15%, flat, down 40%, up 50%, and that all averaged out to something like 8%.

So that said, trying to get even more granularity to see what monthly compounding would be on the S&P 500 index seems not so useful. When you're looking at spans of time of around 2 years or less the returns are largely unpredictable noise.

Mike