• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Start Here
  • Work with David
  • Our Services
  • Contact
Young Adult Money

Make more. Save more. Live better.

  • Blog
  • Credit Cards
    • Rewards
    • Cash Back
    • Travel
    • Airlines
    • Hotels
    • Balance Transfer
    • Student
    • Business
  • FREE Budget Spreadsheet
  • FREE Student Loan Spreadsheet
This Just In... Check out the latest travel rewards credit card offers

Use This Spreadsheet to Analyze your 401k Options

By David Carlson / Last updated: September 29, 2019 / Download, How To, Investing, Personal Finance

We may receive compensation from companies mentioned within this post via affiliate links. Read our full advertiser disclosure. Opinions, reviews, analyses & recommendations are the author’s alone, and have not been reviewed, endorsed or approved by any of these entities.
Pin237
Share51
Tweet
Email
Buffer14
Share
302 Shares

 
The number of investment options within your 401k can be overwhelming. Use this free spreadsheet to analyze and filter out the bad from the good options.A 401k is a great way to start working towards retirement. If you’re lucky, your company may even match your contributions up to a certain percent.

Taking advantage of a 401k is usually a good idea. Even if you have a lot of debt, a 401k match is something that you shouldn’t pass up.

One thing is true regardless of whether you just started to invest in a 401k or have a sizable nest egg built up: you want to have your 401k exposed to the best investments.

The mutual fund options available to you will largely depend on who is servicing your employer’s 401k. You likely will have anywhere from 10-30 mutual funds to chose from, and the variety of options can be overwhelming.

My wife started a new job within the past year at a nonprofit, which offers a 403b (virtually the same as a 401k). When I was looking at the mutual fund options, it was clear that a large majority of the options were bad. Why? Because most were actively managed funds that had expense ratios of more than 1.0%.

I’m not a Certified Financial Planner and this should not be construed as investment advice, but one of the first things I recommend people do when they are investing, within a retirement account or otherwise, is to keep it simple.

Two things to avoid (in general) are actively managed funds and high expense ratios, which typically go hand-in-hand. There are many reports that indicate actively managed funds do not, over time, outperform the benchmark they are comparing against. Some do, but a majority do not.

With that in mind, an investor is better off picking funds that are passively managed with low expense ratios compared to actively managed funds. If you buy a mutual fund outside of a retirement account there are many great options available to you, including some with expense ratios of 0.00% (yes, zero!). But if we are talking about a retirement account like a 401k, you will be limited to what the servicer offers.

When it comes to analyzing 401k options, the first thing I recommend people do is drop all the mutual funds into a spreadsheet and filter based on expense ratio, lowest to highest. Ideally there is at least one fund available to you that gives you broad exposure to the United States stock market that has a low expense ratio.

Let’s look at a hypothetical 401k. Using the 401k spreadsheet, I’ve dropped in the fund symbols in the left-hand column and the Name and Expense Ratio automatically populate (the actual spreadsheet has more data in columns to the right, but let’s focus on expense ratio for now).

 
401k Spreadsheet to Analyze Options - Funds

 
Now let’s sort by expense ratio:

 
401k Spreadsheet to Analyze Options - Funds Filtered

 
My eyes immediately go to the top three options because it’s clear by looking at the expense ratio that these are passively managed. Pulling in a full view of the 401k spreadsheet (click the image below for a larger view), you can see that these three funds have very high ratings from Morningstar, which is a financial services company that analyzes funds. The Morningstar Rating is a measure of a fund’s risk-adjusted return, relative to similar funds. Again, all the information in the 401k spreadsheet is automatically pulled in once you drop in the fund’s symbol.

 
401k Spreadsheet to Analyze Options Full View

 
You may be interested in reading more about each fund. Within the spreadsheet there is a link to the Morningstar page for the fund as well as the Yahoo Finance page. All you have to do is hover over the cell and the URL will pop up. The Morningstar page for the fund has a ton of useful information and I encourage you to take a look for each of the funds you are considering investing in.

 
401k Spreadsheet to Analyze Options URLs

 

What About Target Date Funds?

 
Most retirement accounts offer a variety of target date funds. These funds essentially try to balance your risk exposure depending on when your target retirement date is. For example, someone who is planning on retiring in five years will generally want a more conservative portfolio than someone whose planned retirement date is still thirty years out. These target date funds do some of the work for you by adjusting how much of the portfolio is in stocks, bonds, cash, etc.

Target date funds have their place, but I hate the high expense ratio that they typically come with, as can be seen below. Morningstar is the go-to for fund research, so it says something when the rating is low, which is the case for these funds in particular.

 
401k Spreadsheet to Analyze Options Target Date Funds

 
While not everyone will agree with this, there is a growing sentiment that target date funds may not have it right after all. Let’s say you retire at 60 or 65. You could potentially live another 30+ years. You also may have very expensive health care in your later years. Why miss out on 10, 20, 30, or more years of exposure to the stock market? The historical sentiment that you should move almost all your assets into ultra-conservative holdings like cash and bonds may not make sense anymore.

 

What About Global Exposure?

 
There’s differing opinions on whether you need exposure to funds that specifically exposure emerging markets and/or the global economy. Some investors will argue that having broad exposure to the US market is enough. They definitely have a point that many US companies operate globally and, in turn, you have global exposure by default. But others will want some portion of their portfolio exposed to funds that are specifically targeting emerging markets, Europe, or the global economy as a whole.

Through my 401k and Health Savings Account (yes, you can invest a portion of your HSA similar to other tax-differed accounts), I have some of my portfolio in funds that are focused on investments outside the United States. I personally think having a small portion of your portfolio in these funds is useful, but it’s a personal choice and I understand the argument against it.

 

The 401k Spreadsheet

 
Ready to analyze your 401k? You can get a copy of my 401k spreadsheet sent to your inbox by entering your email below. You will be added to our email list, but you can unsubscribe at any time.

Didn’t see the email? Check your spam folder.

 

Join our Online Community to Receive your FREE 401k Analysis Spreadsheet


 

Good luck filtering through all your 401k options so you are invested in only the best mutual funds. There are many in the financial services industry who over-complicate things because it’s how more money can be made, but keeping it simple is usually the best approach.

Don’t hesitate to reach out with questions!
 

Check out some of our favorite personal finance resources:

Are you getting the best credit card rewards? Check out the top cash back credit card offers (updated daily)

Make extra money: 15 ways to make money from your computer

  • Get our FREE Automated Budget Spreadsheet and our Student Loan Spreadsheet

Get the First Chapter Free!

Student Loan Solution Cover - 3D

Join our online community and get the first chapter of the book Student Loan Solution absolutely FREE!

Pin237
Share51
Tweet
Email
Buffer14
Share
302 Shares

David Carlson

David Carlson is the founder of Young Adult Money. He is a nationally recognized speaker and the author of Student Loan Solution (2019) and Hustle Away Debt (2016). His opinions have been featured on such media outlets as The New York Times, The Washington Post, Cheddar, NBC's KARE11, and more.
Connect:

Comments Policy

Comments, responses, and other user-generated content is not provided or commissioned by this site or our advertisers. Responses have not been reviewed, approved, or otherwise endorsed by this website or its advertisers. It is not the responsibility of advertisers or this website to ensure that all comments and/or questions are answered. With all that being said, please comment away!

Primary Sidebar

Credit Cards

  • Best Travel Rewards Cards
  • Best Balance Transfer Cards
  • Best Cash Back Credit Cards
  • Best Business And Side Hustle Credit Cards
  • Best Student Credit Cards

Start a Blog:

How to Start a Blog that Makes Money
 

Top Posts

  • 15 Ways You Can Make Money From Your Computer Right Now
  • When You Should and Shouldn’t Refinance Student Loans
  • How Much Money You Will Need to Make $1,000 in Dividends

Free Spreadsheets & Downloads

  • Free Automated Budget Spreadsheet
  • Student Loan Repayment Spreadsheet
  • The Ultimate Personal Finance Checklist
  • 401k Spreadsheet to Analyze your Options
  • Wedding Budget Spreadsheet
  • 52 Week Money Challenge Spreadsheet and Printable

First Chapter Free!

Join our online community and receive the first chapter of Student Loan Solution absolutely FREE.

If you don't see the email in your inbox, please check your spam folder.

Connect:

Categories:

Search:

Get the New Book!

Student Loan Solution: 5 Steps to Take Control of Your Student Loans and Financial Life is available on Amazon by clicking here, or by clicking on the graphic below.

Make more. Save more. Live better.

Site Directory:

  • About
  • Contact
  • Advertise
  • Recommendations
  • Finance Tools
  • Credit Cards
  • Insurance
  • Banking
  • Investing

Disclaimer | Privacy Policy

Feedback? Questions?
Contact us and let us know what you think.

Connect:

Search This Site:

Copyright © 2012–2024 Young Adult Money, LLC / All Rights Reserved
Designed by LizTheresa.com / Developed by Nuts and Bolts Media

Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Statistics

Marketing

Features
Always active

Always active
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}
Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}