Fidelity Offers Index Fund-Based Target Retirement Funds

Here’s some good news for the many 401(k) participants with Fidelity as their plan provider. Fidelity announced that they plan to launch a series of Fidelity Freedom Index Funds to complement their current Freedom Funds as soon as September. From this WSJ Article*:

Fidelity Investments, for example, plans to launch the Fidelity Freedom Index Funds, a series of target-date index funds in five-year increments, from 2000 to 2050, in September. Strategic Advisers Inc. will invest each of the target-date funds in a combination of Fidelity index funds. Fidelity wants to provide some of its group retirement plan customers with an index alternative to its Freedom Funds, a spokeswoman said.

Jonathan Kreider, a fiduciary research analyst at Lipper Inc., said, “Especially with the market downturn over the past year, expenses are really starting to be a selling point for a lot of investors.”

It’s good to see that mutual fund companies are feeling the pressure to provide low-cost fund options to the common investor. Costs matter! Fidelity would not have done this unless they felt they were losing significant market share to Vanguard.

For comparison, check out how many funds are in their Fidelity Freedom 2040 Fund (FFFFX) below (with percentages). I just looks messy and unfocused to me, with a high probability of style overlap. The expense ratio ends up at 0.79%.

Fidelity Disciplined Equity 12.09%
Fidelity Series Large Cap Value 10.86%
Fidelity Growth Company 10.1%
Fidelity Equity-Income 10.05%
Fidelity Series All-Sector Equity 9.43%
Fidelity Series 100 Index 8.07%
Fidelity Diversified International 5.72%
Fidelity Overseas 5.7%
Fidelity High Income 4.64%
Fidelity Capital & Income 4.63%
Fidelity Series Investment Grade Bond 4.14%
Fidelity Blue Chip Growth 3.03%
Fidelity Europe 3.01%
Fidelity Small Cap Opportunities 1.69%
Fidelity Strategic Real Return 1.29%
Fidelity Series Emerging Markets 1.19%
Fidelity Total Bond 1.16%
Fidelity Small Cap Growth 1.01%
Fidelity Small Cap Value 1.01%
Fidelity Japan 0.94%
Fidelity Southeast Asia 0.25%

(I laughed at the name Fidelity Disciplined Equity. There’s Value vs. Growth, Large vs. Small, but who’d invest in Fidelity Undisciplined Equity?)

This is only an educated guess based on their new 529 portfolios, but their Fidelity Freedom Index 2040 Fund holdings might look like this, with a combined expense ratio of ~0.14%:

Fidelity Spartan Total Market Index Fund 67%
Fidelity Spartan International Index Fund 17%
Fidelity US Bond Index Fund 16%

Fidelity 529 Plan Also Add Indexed Age-Based Portfolios
The reason I found out about this change was actually via my Fidelity 529 Plan (California). Previously, they had an age-based actively managed portfolio for a total annual expense ratio of 0.50%. However, sometime in the last year or so they added an extra age-based portfolio using index funds. This is good, but I never heard it publicized (my fault probably for missing out on some fine print) and this gave them the ability to jack up the price on the actively-managed portfolio to over twice the original amount, with me paying 1.07% in fees annually. Check your statements!

* WSJ requires a paid subscription to view certain articles, but you can usually view them for free if you come from Google. If you’re not seeing the entire article, bisit this link and click on the appropriate article title.

P2P Lending Update: LendingClub Loan Performance

Here’s an update for my person-to-person (P2P) lending activity, which for me are unsecured loans between U.S. residents. It could be for credit card debt consolidation, car financing, business financing, or even buying a house. You can think of it as taking out the bank middleman, which pays tiny interest on checking account balances and then charges high interest to borrowers.

LendingClub Portfolio
I do my P2P Lending at LendingClub, where you can loan as little as $25. You can read more background in my previous update. Although they do have a service to pick for you, I tend to pick my own loans to try and find both a combination of good risk profile and also a person who I want to help out. It’s kind of a hobby of mine.

I now have a total of 49 active loans with $1,548.42 in outstanding principal. Most are A grade, with a decent spattering of Bs. Keep in mind that a borrower has to have a 660 credit score as well as other additional requirements just to make their lowest G grade. (Only about 10% of loan applications are accepted.) Here is a screenshot from my account page:

Performance & Commentary
According to LC, my “Net Annualized Return on Investment” based on my interest payments received so far is 9.06%. The bad news is that I now have two late loans in my portfolio. One has negotiated a temporary reduced payment plan, while the other seems to be dodging phone calls. Also, one loan was paid off early. But I suppose this is par for the course, you get late payments and defaults. If your interest rate is high enough and you have enough diversification in loans, you’ll still end up ahead. We’ll see what happens, even with a default my rate of return so far is still higher than what I’d have gotten with an online savings account. But the risk is still certainly there for more downside.

What really baffles me is that both of my late loans are A-rated. According to the LC stats page, out of all the A loans issued so far, there are only 12 late loans out of 943 still active. That’s a tiny 1.3% late rate with zero defaults for LendingClub in general, and yet I managed to invest in 2 out of the 12 late ones. So either I’m very unlucky or I stink at picking loans, or… both. 😛

$25 New Lender Bonus
If you are interested trying P2P lending with no risk, you can still use this special $25 lender sign-up link to get a free $25 to try it out with no future obligation. There is no credit check and you don’t even have to deposit anything. After you are approved, the $25 will show up in your account balance, and you can lend it out immediately.

If you’re looking to borrow at LendingClub, it’s relatively straightforward. Send in your information, and see what interest rate they offer you. Compare it with your credit card or other financing options. If you like it, fill out your application carefully (verify income if possible) and go for it. If you don’t like the rate or the full amount is not funded, you can either accept partial funding or walk away with no obligation.

Scottrade Brokerage Cash Management Tips

If you have an account with online broker Scottrade, or are thinking of getting one, this post is about moving funds in and out of your account. Like many brokers, the interest paid on idle cash sweep balances is very low at Scottrade, so it doesn’t pay to keep cash there. Here’s a current interest rate schedule from my account page:

Many other online brokers I’ve used like Zecco or TradeKing have online ACH deposits/withdrawal systems similar to online banks, but moving money around with Scottrade is a bit different, although in some ways it is also better.

Deposits
Scottrade has a service called MoneyDirect for electronic deposits. It is similar to most online bank transfer systems in that you just need the routing and account numbers for setup, but only allows one-way transfers from external bank to Scottrade.

However, a useful feature about the MoneyDirect system is that you can make instant, same-day deposits. So I can leave minimal cash in Scottrade, but if I wake up one day and want to make a trade, I can move up $100,000 into my account with just a few clicks during market hours. From the site:

New and existing clients will be given credit for the transfer the day it is requested, as long as the request is made prior to 8:45 p.m. (ET) Monday through Friday. Transfer instructions received on a non-business day or after the specified cutoff time will be processed the next business day around 6:00 a.m. (ET).

Restrictions: Funds deposited through Money Direct cannot be used to purchase stocks under $4, any unlisted stocks, any options, or any stocks that are deemed non-marginable by Scottrade until the third business day after the deposit.

Withdrawals
I’ve had an account with Scottrade for years, but despite vague promises, moving money out electronically through them is still unavailable. However, there is a workaround. If your account has a minimum account equity (cash + stock value) of $5,000, you can request checkwriting capability on your account. With checkwriting, you’ll have a checking account number and routing number that you can use to link to other financial institutions.

If you use certain banks using CashEdge, you can look for the “investment accounts” options as shown here. Scottrade is one of the participating brokers, although you still need your checking account number.

Scottrade will provide you a free Visa debit card and 50 free checks. My checks are through UMB Bank. I’ve gone below the $5,000 level and kept my check writing ability, so even if your account is usually smaller, it may be worth it to reach $5k temporarily to qualify for this feature. In addition, you can now access your money by writing yourself a check, using the debit card for a purchase, or making an ATM withdrawal.

Read my Scottrade review for more tips and my account opening experience.

The Power of Passive Index Fund Investing: An Example

The other day, I was trying to explain to a friend why I invest in index funds. I came up with this example, which I’m not sure is perfect but I thought I’d share it.

Background: Market Cap Indexes
When you hear “index funds”, it traditionally means mutual funds that follow an index which holds companies proportionally to their market capitalization. If a company has 1,000,000 shares and each share is trading at $25, then its total market capitalization is $25 million.

Let’s take the S&P 500 Index. The market cap of Starbucks (SBUX) is $14 billion dollars, while Exxon Mobil (XOM) is worth $334 billion. So an index fund tracking the S&P 500 would hold 24 times as much Exxon as Starbucks.

The index fund is “passively managed” in that it does not make any of its own decisions on the value of each company, it simply accepts the value of the each company as determined by each day’s market trading between millions of investors.

An Alternate Universe

Let’s imagine an alternate universe where we only have two companies, AAA and ZZZ, that make widgets, the one thing people there buy. Both have a million shares outstanding. Company AAA makes widgets and has earnings of $1 million a year. It’s been around a while and is fairly boring, so the price/earnings ratio is 10, making the market cap $10 million. Thus, each share is worth $10.

Company ZZZ also makes widgets and has earning of only $500,000 per year. But it’s newer and makes stylish widgets that attract young people. People seem to think it has greater potential for earnings growth, so the P/E ratio is 20. Thus, the market share is also $10 million, or $10 per share.

An index fund is created to track this alternate universe, and based on market-cap it holds 50% AAA and 50% ZZZ.

So what happens in the future?

Scenario #1
ZZZ could keep taking market share from AAA with their cool and stylish widgets. AAA’s earnings go down to $500,000, and the P/E stays constant at 10, leading to a new market cap of $5m. ZZZ starts earning $1,000,000 per year, and with a P/E of 20 grows to a market cap of $20m.

What happens to the shares in your index fund? Nothing. No trades are made, because only the share values have changed. You hold the same number of shares of each. However, your fund’s value has grown 25% because the value of ZZZ has doubled, while the value of AAA has been cut in half. Your holdings based on market value are now 20% AAA and 80% ZZZ.

Scenario #2
Things are going along, but then a new medical study finds that ZZZ’s widgets cause cancer, and it turns out the CEOs have been covering this up for years. ZZZ tanks, and is now trading at a penny per share, while everyone is switching to AAA’s reliable widgets. AAA goes up to a market cap of $25m ($25 per share).

What happens to the shares in your index fund? Still nothing, even though you now own 99.96% AAA. Meanwhile, your fund has grown another 20% because of AAA’s growth, even with ZZZ’s collapse.

Summary
You don’t know what is going to happen in the future. There are a million different possible scenarios I could have chosen. AAA could have split off a small division called BBB and it could have taken over the world. The most important point is, whatever happens, with a market-cap index fund, you are guaranteed to own all the winners.

You’ll also have owned the losers, but remember you won’t know who they are beforehand. Buggy whip manufacturers used to be huge. Now, iPhone-making companies are growing. One day iPhones will be in landfills, and we’ll be onto downloading knowledge directly into our brains or something. Or maybe we’ll run out of oil and be back to buggy whips. Who knows.

“Don’t look for the needle in the haystack. Just buy the haystack.” – John C. Bogle

This is the power of passively-managed index funds. With low-cost index funds, you’ll even be guaranteed to beat the average investors’ performance because of investment expenses eating into their return.

OptionsXpress $100 New Account Bonus via Referral

Here’s another solid opening account bonus for an online broker. OptionsXpress is offering new customers a $100 bonus if they open an account with a referral from a current customer. You must maintain an average balance of $500 for 6 months, and make at least one trade. That’s a pretty sweet return on $500 in exchange for you trying out their service.

OptionsXpress offers $14.95 trades, free real-time and streaming quotes, and has lots of features for options traders. There are no minimum account balances, no account maintenance fees, and no inactivity fees.

If you’re looking for something safe to buy, the new WisdomTree Current Income Fund ETF (USY) is designed to have very low volatility and currently yields 1.03%. Another option I like is PowerShares VRDO Tax-Free Weekly (PVI), which also has a stable NAV from VRDOs and currently yields 2.62% tax-free. These would also work well with the TradeKing $50 bonus if you’re low on stock ideas.

I have an account, so if you’d like a referral just contact me with OptionsXpress in the subject, and I’ll be happy to send you one. I only need your e-mail address. You must open your account with the same e-mail you give me, and also use the promotional code FRIEND on your application.

Here’s the complete fine print:

$100 in your account and $100 in your friend’s account
Offer limited to one $100 bonus per referrer and referred friend, for each unique referral resulting in a newly activated, funded optionsXpress account meeting the terms and conditions of the refer a friend program. To qualify for the $100 bonus, the referred account must maintain a per account average balance of $500 for 6 months, and the account must trade at least once. The $100 bonus will be deposited into the referrer and referred accounts within 45 days after the referred friend meets the terms and conditions of the offer. To qualify, the referrer must enter the referred friend’s email address through this page, and the referred friend must enter the promo code “FRIEND” through the new account application form when opening the new account. A referred customer can only qualify for the $100 bonus a total of one time. A customer can only qualify for a total of $500 from any combination of optionsXpress cash promotions per calendar year. Deposits of new funds or securities from existing optionsXpress accounts are not eligible for this offer. Qualified (IRA), linked and shared accounts are not eligible for this offer. This offer is not valid for optionsXpress associates, non-U.S. residents, certain referring parties, and where otherwise prohibited. Customers can not exchange the $100 for other offers, cash or credit. We reserve the right at our sole discretion, to cancel, modify or suspend this offer program at any time without notice.

Historical Net Worth & Goal Chart Updates

I finally got around to updating all my net worth charts and graphics. Here is my net worth since I started tracking it on this blog in December 2004:

You can also view my net worth since graduating from college in my Net Worth page. You can download my tracking template here.

Since I had all the data handy, I also put together a chart of the value of my retirement portfolio. This is simply the sum of all the money in our 401k/IRA/403b’s over the years, including any gains/losses and contributions. Since I did a Traditional-to-Roth IRA conversion a while back, I normalized all the values by taking 30% off of any pre-tax account values. Therefore, the chart is of (estimated) after-tax balances.

As you can see, my portfolio is small enough that regular contributions have been able to counter the rather mediocre returns over the last 5 years so. The swings in our property value is also contributing to making our overall net worth very volatile recently.

Goal Tracker Chart
I also wanted to update my little goal meter on the top-right of every page. I updated our 401k contribution progress; we are on track to max them out for 2009. My first long-term goal is pay off my home mortgage, so I won’t have a house payment anymore. My second is to build a $750,000 investment portfolio. More details here.

At a 4% inflation-adjusted withdrawal rate, a very rough rule-of-thumb, $750k would create an annual income of $30,000 per year ($2,500 monthly). This should cover all our non-housing expenses. At the current $140,000 value, I’d theoretically be able to produce about $467 of “passive” income per month.

I’d like to come up with a better graphic to track these things, but for now I’ll stick with the progress bar. Any creative ideas out there?

Monthly Net Worth Update – August 2009

Net Worth Chart 2009

Credit Card Debt
For newer readers, I have taken money from credit cards at 0% APR and placed it into online savings accounts, bank CDs, or savings bonds that earn 4-5% interest (much less recently), and keeping the difference as profit. I even put together a series of step-by-step posts on how to make money off of credit cards in this way. However, given the current lack of great no fee 0% APR balance transfer offers, I am mostly waiting on existing offers to end. I just paid off a large-ish balance this month.

Retirement and Brokerage accounts
Besides watching another market rally, we made a bunch of retirement contributions this month. Wife’s 401k is now maxed out at $16,500 for 2009. I made a $5,000 contribution to my Solo 401k. This makes us about 65% done with our goal of maxing out both our 401ks for 2009.

Early in the month, I also decided to go ahead and make our IRA contributions for 2009 (non-deductible due to income limits). So that’s another $10,000.

Cash Savings and Emergency Funds
We still have a little over a year’s worth of expenses in our emergency fund. I was supposed to use up some of the cash to make a principal prepayment this month, but didn’t do it due to a variety of reasons. Mainly, I wanted to do things in order and do the retirement contributions above first. We also found that we have a roof leak that may require some cash.

In addition, we have gotten some quotes on a solar hot-water system for the house, which seems like it would have a fast payback period of 2-3 years. A photovoltaic system would cost significantly more and have a payback period of around 8-9 years depending on size. Still researching this.

Home Equity
Using four different internet valuation tools – Zillow, Cyberhomes, Coldwell Banker, and Bank of America (old version) – I again took the average and took off 5% to be conservative and 6% for real estate agent commissions. The bloodshed slowed a bit this month. 🙂

All in all, more steady progress. I feel like I’m not learning a lot from these updates, but it seems to be a good habit to keep an eye on things.

Stock Market Timing Using Historical Moving Averages

In the wake of the recent stock market drops, there has been a increased amount of interest in certain market timing systems that would have told an investor to be “out” of the market during late 2008 and early 2009. Below are a sample of the more popular mechanical systems, which have clear parameters and are easy to follow using basic investing tools.

100-Day Moving Average (FundAdvice.com)
FundAdvice.com is run by Merriman Capital, which provides money management services using both buy-and-hold and market timing models. I’ve mentioned them before for their index fund model portfolios and the related “Ultimate” Buy-and-Hold Portfolio. The website has an entire market timing section, and I am specifically referencing the articles here and here from 2001 and 2002.

Merriman recommends something called the 100-day moving average. For any given asset or mutual fund, you calculate the average of the most recent 100 days of closing prices. Each day, you’ll have a new average by adding the newest price and dropping the oldest price from the average. Then, you compare the current price of the fund with this simple moving average (SMA).

Each day the market is open, if the current price is above the 100-day SMA, you should buy the fund or hold it if you already own it. If the current price is below the 100-day SMA, sell it. After you sell, place your proceeds in cash (money market fund) until the fund price is once again above the average.

200-Day Moving Average (Faber)
The 2006 paper A Quantitative Approach to Tactical Asset Allocation by Mebane Faber explores a very similar but even simpler mechanical system. Here you take the 200-day simple moving average of any index, for example the S&P 500. But this time, you only calculate this at the end of each month. If the current price is greater than the 200-day SMA, then you buy. If the current price is less than the 200-day SMA, then you sell and move to cash (90-day T-Bills). This results in some impressive backtested results, but with much fewer trades than other systems.

By the way, you can track the 100-day and 200-day SMAs easily using most stock quote websites like Yahoo Finance. Here’s the chart for the S&P 500:

As you can see where the S&P 500 is below the green and red lines, you would have been told to “sell” and stay in cash during some of the big drops.

10-Year Trailing Average P/E Ratio (Shiller)
Prof. Shiller of Yale University is well-known for his book Irrational Exuberance. From Wikipedia: “Published at the height of the dot-com boom, it put forth several arguments demonstrating how the stock markets were overvalued at the time. Shiller was soon proven right when the Nasdaq peaked on the very month of the book’s publication, and the stock markets collapsed right after.”

Part of his argument was based on historical price-to-earning ratios, or P/E ratios. This indicator went throw some iterations and became known as PE10, which takes the current price of the S&P 500 and divides it by the average inflation-adjusted earnings for the past 10 years. Essentially, it is a 10-year moving average of the P/E ratio. If the current P/E ratio is significantly higher than the 10-year average, the market is overvalued.

You can find updated numbers and more at his Yale website.

Warnings about Market Timing
I haven’t taken the time to deeply analyze any of these systems, I am only presenting them here for debate. However, I think I should throw out a few quick warnings.

Depending on which stock market index you track, and the time period you track, all of the methods above reduce risk (volatility) without significantly reducing overall returns as compared to buy-and-hold. However, there have also been long stretches where timing underperformed buy-and-hold, which can make it a hard strategy to implement over the long run. The main reason we are talking about them now is only due to recent hot performance. In addition, market timing requires regular attention to stock market activity, increased trading costs, and tends to be much less tax-efficient.

Even Merriman states: “we have concluded that relatively few investors have the tenacity, discipline and faith required to be successful market timers.” But perhaps the same is true for Buy-and-Hold? It is possible that these market timing systems will outperform in the future as well. Or they may not, and you’ll be jumping in only after a recent hot run. I don’t have a well-composed argument either way right now, but I can say that I currently am not using any of the above systems.

TradeKing New Account $50 Bonus

Online broker TradeKing.com has brought back their $50 sign-up bonus for new accounts as part of celebrating National Friendship Day. If you get a referral from an existing account holder, fund it with at least $1,000, and make a trade, both people will get $50.

Simply enter your friends’ email addresses below between now and August 27, and press Send. As soon as your friend deposits $1,000 and executes a trade, we’ll deposit $50 into both of your accounts. Isn’t friendship grand? Please note that your friends must click the link in the email for us to track them and for you to receive your reward. But don’t worry. We tell them that in the email they’ll receive.

[..]You must have a regular non-retirement investment account, and you must leave the account open, with your referral money in there, for at least 6 months. Your friends must open a non-IRA account by August 31st, fund their account with at least $1,000 within 30 days of opening the account, and make a minimum of one trade within 180 days of account opening to receive their $50. But even if they act on it later, you’ll still receive your $50. So what are you waiting for? Start entering email addresses!

I have an account, so if you’d like a referral just contact me, and I’ll be happy to send you one. I only need your e-mail address. There is no promotion code, but you’ll need to click on the specific link on the e-mail for tracking purposes.

TradeKing offers $4.95 trades with no minimum balance requirement. For more information, please check out my TradeKing Review.

Dangerous Personal Finance Magazine Headlines: The Attraction of High Yields

With money market fund and savings account yields still pitifully low, it is very tempting to look for investments with higher yields. Indeed, the personal finance magazines know this all too well, dangling teasers on their covers like:

  • Stocks That Pay 8% (Kiplinger’s Personal Finance, Oct 2008)
  • How to Get 8% on Your Money (SmartMoney, Dec 2008)
  • Grab These Bonds For 10% Yields (SmartMoney, Feb 2009)
  • Stocks That Pay You 5% Or More (Kiplinger’s Personal Finance, Feb 2009)

I know that they need to attract casual readers to buy their issues off the crowded magazine rack, but I fear that these articles can hurt readers by focusing primarily on yields.

From tankers to pipelines to real estate stocks, we’ve uncovered the investments with the best yields.

Stock dividends and bond yields are certainly a very important component of return. But with such significantly higher yields, the real question should be why the yields are high, as there is definitely higher risk. If your investment spits out 5%, but the actual investment decreases in value by 5%, um… you don’t make any money. You would have made more money at a bank. And if it does worse…

“Earn 8% or More” becomes “Earn 8% or a LOT LESS”
I bring this up because I was just reading the June 2009 issue of Kiplinger’s with an article entitled (surprise!) Where to Find Top Yields. But as I read, they first meekly admit that their last “yieldfest” article missed the mark. So I found it, and did a little before-and-after comparsion:

In Earn 8% or More (July 2008), they wrote:

Shares of First Industrial Realty trust (FR), a national developer and operator of warehouses and light industrial buildings, more than doubled between November 2002 and November 2006 but have since fallen 33%, to $30, over concerns about flat rents and the firm’s high debt. The stock trades below First Industrial’s net asset value per share and pays 10%, one of the highest yields among long-established REITs. There is still ample cash flow to maintain dividends.

Pays 10% yield, ample cash flow, a long-established REIT. Almost sounds stodgy and safe. Fast forward to June 2009:

Credit-market chaos wreaked havoc with the recommendations in our previous “yieldfest”. Our best picks, emerging-markets bond funds such as Fidelity New Markets Income and Pimco Emerging Markets Bond, dropped about 10% over the past year through April 9. Pipeline stocks, such as Kinder Morgan Energy, also held up reasonably well. But we had our share of disasters. For example, First Industrial Realty Trust cratered by nearly 90%, while Genco Shipping & Trading dived 73%.

Their best picks still dropped 10%? Most were in the disaster category. Another pick from July 2008:

For example, look at First Trust Strategic High Income (symbol FHI), which borrows to invest in bank loans, mortgage-related securities and junk bonds. Its share price plunged from $20 in early 2007 to less than $10.50 eight months later, as its underlying assets fell victim to the credit crunch and the real estate recession. But the shares have rebounded to $12.25, and the fund’s net asset value per share, now $10.38, has stopped crumbling (unless otherwise noted, all figures are to May 12).

But even as the fund was collapsing, it kept paying out 16 cents a month. Based on the current share price, the payout (which doesn’t require borrowed money or represent a return of capital) comes to a yield of 15%. We generally don’t recommend closed-end funds selling at 18% premiums to NAV, but First Trust’s yield is too luscious to pass up.

From a share price of $12.25 at the time of recommendation, the share price of FHI as of 7/13/09 was $3.38. Including those “luscious” dividends, the 1-year total annualized return was -57.3%

They also neglected to mention the fact that FHI has management fees of 2.21% plus “other fees” of 2.11% for total annual expense ratio of 4.32%. Ouch.

Both of these are extreme examples, but an important lesson can be learned by reading the entire 2008 article first, and then reading the 2009 article. The story is always very convincing. You’ll get high yields, historical stability, and some sort of reason why things are looking up. It will be tempting. But remember, this part of your $5 magazine is selling sizzle, and won’t reimburse your losses when there’s no steak.

* p.s. Don’t get me wrong, I don’t think that these magazines are all bad. They often have very useful articles, which I read and link to regularly. I am a paying subscriber, after all. However, I do think that these “yieldfest” articles are written primarily to increase their own revenue, not the investment returns of their readers.

Tracking Investment Portfolio Using Google Docs

I spent a little time tinkering with Google Docs Spreadsheets today, trying to use it to track the asset allocation of my investment portfolio.

GoogleFinance() Function
This function allows you to import data from Google Finance like current stock prices, p/e ratios, or performance. Here is the Google Docs Help page. For example, if you want to pull up the price of a share of Google stock, you’d enter this into a cell.

=GoogleFinance("GOOG"; "price")

Importing Personal Data
I could not find an easy way to import my actual holdings into Google Docs, but I’m not sure if you want that capability due to privacy concerns. Google Docs does allow you to import from RSS or XML feeds. I ended up just manually entering the ticker symbols and number of shares I held for each mutual fund. This means I will have to update my 401(k) funds after each paycheck, and my other holdings when I make a transaction or when a dividend is paid.

Shared Example
Below is a shortened version of my online file, as a quick example.

You can view the full version more easily here. To edit, go to File and click on “Create a copy…”. You can then poke around and change the ticker symbols to your own.

In the full version, I have columns that compare my current asset allocation percentages to my target percentages. This can help people who wish to rebalance when their allocations are off by a certain amount. I can see that I am currently overweight in Emerging Markets due to their recent run-up, and underweight in TIPS. Everything else seems close enough.

The pie charting function seems a little buggy, I couldn’t get it to show the proper labels.

Monthly Net Worth Update – July 2009

Net Worth Chart 2009

Credit Card Debt
I have taken money from credit cards at 0% APR and placed it into online savings accounts, bank CDs, or savings bonds that earn 4-5% interest (much less recently), and keeping the difference as profit. I even put together a series of step-by-step posts on how to make money off of credit cards in this way. However, given the current lack of great no fee 0% APR balance transfer offers, I am mostly waiting on existing offers to end. My credit score remains high enough that I haven’t seen any negative actions.

Retirement and Brokerage accounts
Markets most went sideways this past month. 401k contributions are still going regularly, and I want to make my 2009 non-deductible IRA contributions soon. I still think the best thing to do is to keep investing regularly, although it is quite boring to watch.

Cash Savings and Emergency Funds
We still have a year’s worth of expenses in our emergency fund, and it is still growing. Possible uses for extra cash might include capital improvements to the house, including a solar hot-water system to reduce electricity bills, or a photovoltaic system to possibly eliminate them! I love the idea of selling electricity back to the city.

Home Equity
Using four different internet valuation tools – Zillow, Cyberhomes, Coldwell Banker, and Bank of America (old version) – I took the average and took off 5% to be conservative and 6% for real estate agent commissions.

We remain “underwater”, with our outstanding mortgage balance greater than what we probably would net after selling our home. Home equity variations continue to dwarf all other activity, which is somewhat annoying since it’s not that important. Just gotta shrink that mortgage!