Right on schedule, the Bureau of Labor Statistics has released the Consumer Price Index numbers for January 2008 today, which means that we've officially updated our signature tool The S&P 500 at Your Fingertips with all the data you need to find the rates of return that you might have received from investing in the S&P 500 between any two months since January 1871!
But that's yesterday's news! If you're like us, you want the picture of what's going on right now. Or even tomorrow! And since we only recently figured out that our view of the future was flawed, we've been working to capture the full picture that we should have been using in the first place.
In doing that, we've projected a new future for where corporate dividends are expected to go and, to avoid the situation that we found ourselves in where we didn't catch on for several weeks that we were missing important parts of our data, we're opening our books to you to show how we did it. After all, what's a blogosphere for if not to provide very smart people with the opportunity to point out where the problems in your analysis might be?
We began with by taking what S&P projects the year-over-year dividends per share will be for 2008, $30.30. Since this value represents an increase of 9.3% over the full year dividends per share of $27.73 for 2007, we'll use this annualized growth rate in our projections for dividends per share for each quarter this year.
Our next step is to take this growth rate and apply it to each of the year-over-year dividends per share for each quarter of 2007 to get the corresponding value for 2008. Our intermediate results are presented in the table below:
| S&P 500 Year Over Year Dividends per Share for 2007 and Projected for 2008 | ||
|---|---|---|
| Quarter | 2007 [Actual] | 2008 [Projected] |
| First (Ending in March) | 25.49 | 27.86 |
| Second (Ending in June) | 26.17 | 28.60 |
| Third (Ending in September) | 26.97 | 29.48 |
| Fourth (Ending in December) | 27.73 | 30.30 |
The next step is to fill in the months in between these quarterly figures, for which we'll use the same linear interpolation method utilized by Robert Shiller for his S&P 500 data. The table below summarizes our projected dividends per share results for 2008:
| S&P 500 Projected Dividends per Share by Month for 2008 | ||||||
|---|---|---|---|---|---|---|
| Month | Jan | Feb | Mar | Apr | May | Jun |
| Dividends per Share | 27.77 | 27.82 | 27.86 | 28.11 | 28.35 | 28.60 |
| Month | Jul | Aug | Sep | Oct | Nov | Dec |
| Dividends per Share | 28.89 | 29.19 | 29.48 | 29.75 | 30.03 | 30.30 |
So that's how we determine the dividends per share data that we use in our tool. We expect that we'll need to revise these figures in the future, which we'll do in the course of our regular monthly updates, preferably when S&P releases the actual dividends paid for each of the quarters that we've projected or perhaps if they revise their annual projection for the S&P 500's dividends per share.
We use a similar technique for the earnings per share data but here, S&P provides quarterly projections of the earnings data so we only need to perform the linear interpolation step to get the values for each month.
And now, finally, what you've been waiting for, we'll combine the average monthly index value of the S&P 500 with our anticipated dividend per share data to produce the picture of where the S&P 500 is today!
It really is that easy, and anyone with a little bit of math know-how can do it!
Labels: dividends, SP 500, update
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
CSS Validation
RSS Site Feed
JavaScript
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.
Other Cool Resources
Blog Roll
