Investing in a Three Fund Portfolio Across Numerous Accounts. Get the Spreadsheet!
There’s a slight problem, though. Nobody, and I mean nobody, has a portfolio this simple.
For one thing, your money is necessarily kept in multiple accounts. You might have a 401(k) or 403(b), perhaps a 457(b), a Roth IRA, SEP or SIMPLE IRA, solo 401(k) and maybe even a cash balance plan. You also invest in a taxable brokerage account once you’ve maxed out those other ones.
Plus, those passive index funds don’t exist as options in all of your accounts. You could be stuck with a Retirement Date fund in one account and some lackluster selection of actively managed funds in another.
And that’s just you. Your spouse has a similar stack of accounts and there’s just no way you can keep track of it all. Well, you can. That’s what the free service offered by Personal Capital is for, but even they can’t compete with the versatility of your very own spreadsheet.
That’s where I come in.
Investing in a Three Fund Portfolio When You Have Numerous Accounts
Many people want to start managing their own money, but they don’t know where to begin. “You need an IPS,” I say. “Build a spreadsheet,” I tell them. Which is about as helpful as telling someone who’s cold to build a sweater. Most people don’t have the time or the skills to do build a portfolio-tracking spreadsheet. Or a sweater, for that matter.
I’m not going to teach you sweater-building 101 (I think it’s actually called knitting if I’m not mistaken) or walk you through the creation of a portfolio-tracking spreadsheet. Sometimes it’s easier to give a fish than to take someone fishing, so I’ve gone ahead and built a highly useful spreadsheet for you.
Balance a Three Fund Portfolio Across Many Accounts
I’m not going to argue that the three fund portfolio is the ideal portfolio — I’ll let Taylor Larimore do that — but I believe it’s a great starting point and a fine endpoint, too.
Before we get to the spreadsheet, let’s talk about asset location and tax efficiency.
A total bond fund is less than optimal in a taxable brokerage account. Bond funds typically spin off more dividends than stock funds and you will pay tax on those dividends. The only bond fund I would consider holding in a taxable account is a municipal bond fund, preferably designed for the state in which I live. I have my total bond fund in a 401(k).
A total international fund is a great option for a taxable brokerage account. The fund will pay some foreign tax on your behalf, and if you hold it in a taxable account, you get a tax credit for that foreign tax paid. When held in a tax-advantaged account like an IRA or 401(k), you will not get any benefit from that credit.
Regarding the total US stock market fund (also somewhat arrogantly known domestically in the US as a total stock market fund), it’s a fine fund to hold anywhere. It’s reasonably tax efficient with a current dividend yield around 2%, and holding some in taxable may give you some tax loss harvesting opportunities.
In summary, I recommend holding the total bond fund in tax-advantaged accounts, international in a taxable brokerage account (if you’ve got one), and the total US stock market in any or all places, with the caveat of tax loss harvesting issues which I will detail below.
You do not need to hold all three funds in each and every account you own. In fact, that makes your life more complicated and is counterproductive when simplicity is what you hope to achieve.
The Three Fund Portfolio Spreadsheet
Taking into account the fact that you are going to have numerous accounts and not all of them will offer the usual three funds, I’ve set up the spreadsheet to give you a taxable brokerage account, two Roth IRA accounts, and four other retirement accounts. You can use this as an individual or as a couple if you have combined finances.
Each account gives you the option of a fourth class, the “alternative” class with could be real estate like the REIT fund in the Ferri Core Four portfolio, crowdfunded real estate, or other alternative investments such as precious metals or angel investments.Morningstar for the percentage devoted to each class. I did not create a separate class on the spreadsheet for cash, which I usually lump in with my bond allocation.
If I made this truly a one-size-fits-all spreadsheet, it would have to be much larger and it’s big enough as-is. You will have the option to download and make any modification you wish.
The white spaces are places for you enter your information. You can also change the fund and ticker names.
Any numbers in blue or gray will be calculated for you, including the annual cost of owning your funds as long as you enter the correct expense ratios. A weighted average of the expense ratios will be calculated at the bottom.
I’ve gone ahead and entered the current (in 2018) expense ratios and tickers for a three fund portfolio from Vanguard, Fidelity, and Schwab in the first three accounts. Note that the Schwab international fund is not a true “total international” fund as it does not include emerging markets like the Vanguard and Fidelity funds.
As you will see, here at the bottom, the percentage of each asset class is calculated for you, as is the dollar amount and percentage by which your portfolio deviates from the desired allocation you set. I defaulted to 50% US / 30% Int’l / 20% Bond. Feel free to adjust those according to your risk tolerance and preference.
The same information is displayed in graphical donuts…. mmmm….. donuts.
To download this spreadsheet, enter your e-mail below and I’ll send it to you. You will be subscribed to the site and within a week, you’ll be given the option for a weekly digest rather than an e-mail with each new post.
If you are already a subscriber, enter your email to download the spreadsheet. You will not be subscribed twice or receive duplicate e-mails from me as long as you enter the same e-mail you use for your current subscription.
p.s. If you like spreadsheets, you’ll love the one I created for tracking credit card miles, perks, renewal dates, and more. You can find and download that one here.
Tax Loss Harvesting and the Three Fund Portfolio
The main reason I have personally deviated from a three fund portfolio in my own portfolio is the fact that I like to take advantage of tax loss harvesting opportunities. The process is described in detail with screenshots in this post, and I will summarize briefly here.
When you tax loss harvest, you sell one fund while simultaneously purchasing another fund that is not “substantially identical”– that’s an IRS term.
A problem can arise when you own the same funds in your tax-advantaged accounts. If you take a loss on a fund in taxable and have purchased other shares of the same fund in different accounts within 30 days before or after, the value of the purchased shares is disallowed from the loss you report. This is known as a “wash sale.”
The good news is that the entire loss is not forbidden — only the dollar amount that you invested in that window. If you’re investing biweekly or reinvesting dividends quarterly, it’s easy to inadvertently create a wash sale if you are investing in funds you own in the taxable account and plan to tax loss harvest. Trust me. I’ve done it.
To avoid this situation, I’ve chosen to own small and mid cap indexes in my tax-deferred accounts. My taxable account has the funds mentioned above and none of those are owned anywhere else in my portfolio, including our Roth IRAs, 401(k), 457(b), and even the HSA.
While it’s true that the IRS hasn’t spelled out exactly what constitutes a wash sale (although I believe they have said a purchase in your IRA or spouse’s IRA counts), I think it’s best to avoid gray areas.
If you’d prefer to stick with total stock market funds for your US stock allocation, the Vanguard fund tracks the CRSP US Total Market Index and the Schwab fund tracks the Dow Jones US Total Stock Market Index. Since the holdings are not identical, it could certainly be argued that these are not substantially identical.
For further reading on the three fund portfolio, check these out:
- He Has Read Over 250 Investing Books. He Recommends These Three Funds.
- From 28 Funds to 3: Simplifying to a Three Fund Portfolio
- A Vanguard Three Fund Portfolio Just Got Cheaper!
- Investing in a Three Fund Portfolio Across Numerous Accounts. Get the Spreadsheet!
- The Bogleheads Guide to the Three Fund Portfolio
If you’re not interested in a three fund portfolio or cannot remotely reproduce it with the funds you have available to you, I plan to help you out, too. Stay tuned in the coming weeks for another downloadable spreadsheet that will help you organize your portfolio no matter what you own in them.
Does this look like something you can handle? If you were to veer from the three fund portfolio, in what direction would you go?