Monday, August 23, 2010

Annualized S&P 500 Growth Rate

I talked before about the annualized inflation rate since 1913, and how this is a good number to use in modeling the future. This time, I'll be looking at the annualized return of the stock market as a representative of investments in general.

Once again, my efforts started by trying to find everything I needed online. I came much closer this time around than before. I found an excellent CAGR calculator for the S&P 500 going back to 1871. Again, this is good to get a final answer for a given time period, but I'd like the time period to be less arbitrary. The problem is that historic price data is readily available, but that doesn't include dividends. We really need data reflecting the total return seriously, visit this link - 44% of the total return is dividend reinvestment - amazing!). After a lot of searching for raw data, I found some detailed monthly data for the S&P 500 going back to 1970, much of which was reconstructed. While not raw, it's at least data!

The graph below (click for full size) shows the 1970-2009 data - individual monthly total returns, trailing 12-month total returns, trailing 20-year annualized total returns, and cumulative total returns since 01/1970. The overall total return from 1970-2009 was 9.44%-9.93% depending on what month you end on. The average 20-year annualized return was 13.31%, and the average 12-month return was 11.33%. It's not included in the graph or the table below, but the average 30-year annualized return over 1871-2009 was 9.36%, while the overall annualized return was 8.89% for that range. (NOTE: The average of a sliding window is not a great statistic - the time periods on each end are under-weighted. I include them because if any readers are like me, taking the average of a series of numbers is one of the first things you try to do. I am simply saving them a bit of work. ;)

For modeling my future investments, I use a more conservative 8% growth rate. However, I have a column in my spreadsheet that projects a 10% growth goal from when I first created it. Of course, the financial crisis and recession means I have a lot of catching up to do, even to my original 8% plan.

Display S&P 500 Data Table

Friday, August 20, 2010

Annualized Inflation

Knowing the current inflation rate is helpful in making short term decisions. Seeing a table of historical inflation rates is only slightly productive. For long term planning, what we're really interested in is the annualized inflation over a period of time. Sure, some years inflation may skyrocket to 20%, but other years it's flat or even negative. Taken together, they should be equivalent to one inflation rate applied each year. This annualized inflation rate (or geometric mean, or Compound Annual Growth Rate [CAGR]) is probably a good value to use when modeling inflation far into the future.

I found some great information over at InflationData.com, but I couldn't find any information on average or annualized inflation. I found a calculator at MeasuringWorth.com, but that also wasn't terribly useful except to give me a single final result. Then I found Peter Dolph on average inflation, but that was unclear whether it gave an average year-over-year inflation, which didn't make as much intuitive sense, or the geometric mean. So, I decided to compute it myself.

Since I love data, I started with the raw CPI data (see one of the tables below). I then computed the annualized inflation rate from 1913 up until each data point using the same month (or average, in the annual case) in each year. Looking at the table, things appeared to level out, so I decided to verify that with a graph! Not content with that, I then added the year-over-year inflation data for comparison purposes. Not content with that, I then computed and added a sliding 20-year window of annualized inflation rates.

The graph above (click for full size) shows the year-over-year inflation rate, a sliding 20-year annualized inflation rate, and an overall annualized inflation rate. Below, you can toggle between the raw CPI data and the overall annualized inflation rate table. The month of July was used for the graph for the simple reason that it was the most recent month data was available for this year. Also, the average 20-year annualized inflation rate was 3.236% compared to the overall annualized rate of 3.239% at the end of July, 2010, and compared to the 3.26% Peter Dolph found to be the average. Things seem to be pretty consistent.

"What about the risk of hyperinflation?" you may ask. Hyperinflation would indeed be bad, but I don't think it's particularly useful to worry about. If hyperinflation hits us, the world economy is likely completely broken and no amount of planning will help. You could argue that real goods like precious metals would hold their value, but I think owners of gold, for example, will have a hard time taking possession of that gold. Just a theory.

So, 3.3% is a pretty reasonable assumption for long term inflation, arrived at using various methods. This should give us some confidence when we create long term models and/or plans!

Display Annualized Inflation Table

Monday, July 26, 2010

Weaver's Auto Center Review

Weaver's Auto Center is where I've taken my car for it's oil change the last couple of times. The first time I also had a lot of brake work done.

While waiting for my car's oil leak to be diagnosed today, I witnessed something remarkable. If nothing else, it goes against the stereotype of car repair places. A woman was waiting on her car, too, and from what I could tell, her door handles weren't working reliably. The representative came out and talked to her about how online reports indicate that this is a common problem for her car, and that while they don't think it is anything related to what they previously worked on, they would go ahead and take care of it. So, he had already ordered the parts, would paint the handles if necessary, and install them when they arrived just to make sure there was no possibility that the car was in any way worse than when it was originally brought it. I was impressed.

The only problem I have with them so far is that they have Fox News playing on the TV. Perhaps they are just catering to the average Kansas customer, for which I can't really blame them. ;)

Wednesday, June 16, 2010

Old Technology Hurts Everyone

This week, I was shown an example of how some companies refusing to join the 21st century can impact other companies. WaterOne and the City of Olathe each handle a part of my water, sewer, and trash bills. As part of my plan to close my Merrill Lynch brokerage and checking accounts, I have been transferring my various bill payments to my credit card or my Bank of America checking account, depending on whether they offer free credit card payments or not.

Now, KCP&L and Atmos Energy at least allowed me to manage my payment methods online. They both required me to cancel automatic payments, wait two days, and then initiate automatic payments again with the new account information, but it was straightforward enough. WaterOne and City of Olathe, however, require a printed form to be mailed or faxed (ha!) along with a voided check for the new account.

I really don't write many checks. Just about the only time I write checks is when someone offers a discount for paying with "cash." So, I paid for my storm door and my furnace by check, and that's it for the past three years. Except for the homeowners' association dues, but I really shouldn't go into my complaints with them right now. Basically, I don't write checks. When I opened my Bank of America checking account, I didn't get checks with it because...I don't write checks. And I have checks for my E*TRADE brokerage account for those one or two checks a year I do write.

Ah ha! But Waterone and the City of Olathe require voided checks. So, in order to not have to write checks, I had to order checks and void them out. Really, that's what I had to do. The minimum order was 150 checks (thankfully free to me because Bank of America bought my mortgage). I tore out two, wrote "VOID" on them, and put the rest back in the box they came in. What a waste!

WaterOne and the City of Olathe make changing account information a hassle. It cost me time, two stamps, and two envelopes; it cost Bank of America 150 useless checks plus shipping; it cost WaterOne and City of Olathe personnel time to process the hand-written form. You know what's even worse? WaterOne still doesn't even offer paperless billing!

Monday, May 17, 2010

Thoughts on Marriage - The Screwtape Letters: XVIII

In The Screwtape Letters, by C.S. Lewis, specifically in letter XVIII, Screwtape describes how they have undermined the institution of marriage:
We have done this through the poets and novelists by persuading the humans that a curious, and usually short-lived, experience which they call "being in love" is the only respectable ground for marriage; that marriage can, and ought to, render this excitement permanent; and that a marriage which does not do so is no longer binding.
And later:
... thanks to us, the idea of marrying with any other motive [than being in love] seems to them low and cynical. Yes, they think that. They regard the intention of loyalty to a partnership for mutual help, for the preservation of chastity, and for the transmission of life, as something lower than a storm of emotion.

I have rejected many (many being highly relative) people that are good matches on paper simply because I didn't feel that spark. Having felt that spark - sometimes incredibly intensely, I really do feel that is the way it should be. I want to marry someone whose presence is all I desire. I want my first thought upon seeing her to be "I want to hold her hand." I think the key is the second half of the first quote: "...marriage can, and ought to, render this excitement permanent; and that a marriage which does not do so is no longer binding." That attitude is a major problem for the institution of marriage. It's not reasonable to expect a feeling to last, unchanged, forever. Still, I think marriage should definitely start with that excitement.

On the other hand, I understand the pressure to find someone so as to not be alone, or because your biological clock is ticking, or both, or other. There are also plenty of stories of arranged marriages resulting in two people loving each other very much. In short, it does not appear that that excitement is necessary for a successful, happy marriage. "[T]he intention of loyalty to a partnership for mutual help, for the preservation of chastity, and for the transmission of life" might really be a sound basis for marriage. I think that feeling of being completely in love might be necessary for me, though.

It really boils down to whether or not I feel like I'm settling, I think. Having felt that intense love, would it ever be OK for me to marry someone I simply love? Having dated someone, would it be fair to either me or another person if I married someone I didn't think was quite as spectacular? Having merely known someone I can find no fault in, have I limited myself to the 0.00001% of the population I find absolutely perfect? Or do I just find these people perfect because I'm already in love?

I think I only have more questions left, so I will open this up for discussion. Do you think love is necessary before marriage, or do you trust that it will develop? How intensely should love be felt at various stages in the relationship? When do you move your standards up or down when single? I've been assuming so far that monogamous marriage is the goal because it's my goal, but feel free to discuss alternatives to traditional marriage, too.

Monday, May 10, 2010

Get 10% off at Home Depot: Part II

I don't think I need to feel bad about gaming the system, or anything like that, when I bought a gift card for bonus rewards. So far, I've used my gift card twice and still have $30.64 left. I'm assuming that gift cards are accounted for in-house, so my small purchases with the gift card will save Home Depot a bit of money on the credit card transaction fees. There was the initial transaction fee when I bought the card, but after that each purchase should save them $0.25 or so.

More than that, having the gift card in my wallet encourages me to shop at Home Depot for things I might not normally go there for. The more you bring someone in, the more likely they are to buy something they didn't really want.... Even more important, this has gotten me to write two whole posts on this now, so I've advertised for them to... what, two or three people? ;)

Also, in addition to Chase's Rewards Plus program, Bank of America has their Add It Up program. It seems to offer similar deals on the big stores, but has its own collection of smaller merchants. One that was heavily featured when I just now looked at it was 50% off match.com. I'm sure the fine print makes it hard to use, but that's definitely not available through Chase. Check your banking institution or credit card supplier, and let me know if you find any good deals!

Wednesday, May 5, 2010

Get 10% off at Home Depot!

Thanks to an email from Chase advertising their Rewards Plus program, coupled with several recent trips to Home Depot making their logo catch my eye, I clicked through and looked at the extra rewards for HomeDepot.com. At the time, they were offering 10% bonus rewards! It has since dropped to 5%, but that's still better than nothing, for sure. What makes this special is that their offer includes the following: "Eligible on the purchase of gift cards." Most merchants include the word "Not" at the beginning, and so I was fearing it was a typo.

Honestly, I don't think that I'd ever shop at HomeDepot.com. I think I'll always want to see the hardware-type products first. However, I'm happy to buy gift cards online - especially the kind you can print off yourself! So, I went ahead and bought a $50 gift card to see if it actually worked. Today, I got the notification that I earned $5 in bonus rewards! Gift cards work just like cash, so this is in addition to any other sales or coupons you take advantage of. Not too shabby.

I'll be keeping my eye out for other merchants that offer bonus rewards on gift cards. In fact, the Chase Rewards Plus site has a link at the top called "Gift Cards." It's not clear if this list is 100% accurate or exhaustive. Nothing else really stood out to me, either. Ah well!