Mutual Fund Comparison: How to Compare Mutual Funds Beyond Just Returns

In this article
Mutual fund comparison tool showing side-by-side analysis

To compare mutual funds properly, look past headline returns and check seven things side by side: expense ratio, holdings overlap with funds you already own, risk-adjusted return (Sharpe ratio), concentration in the top 10 holdings, turnover, tax efficiency, and minimum investment. Past returns only describe what already happened; fees and overlap are known in advance and affect every future year.

MarketXLS has two free tools for this: the mutual fund compare tool for side-by-side metrics and the mutual fund overlap calculator for shared holdings. This guide explains each metric, gives a five-step process, and covers common matchups such as VFIAX vs FXAIX.

Why Past Returns Alone Are Misleading

Past returns hide the effect of costs when you compare funds before fees. Consider two hypothetical large-cap funds over the past 5 years:

  • Fund A: 12.5% annualized return before fees, 1.20% expense ratio
  • Fund B: 11.8% annualized return before fees, 0.05% expense ratio

Fund A looks better before costs. After fees:

  • Fund A net return: 11.3%
  • Fund B net return: 11.75%

Fund B actually puts more money in your pocket. And that gap widens every year as fees compound.

The same trap appears in real fund data, where a single portfolio sold under several share classes produces several different return records. For worked figures on that, see what actually separates two mutual funds.

A side-by-side comparison of costs, holdings and risk shows what the headline return leaves out.

The 7 Metrics That Actually Matter

1. Expense Ratio

The expense ratio is the annual fee a fund charges as a percentage of assets, and it is one of the few factors you know in advance. Every dollar of fees comes out of your return, so among funds tracking the same benchmark, the cheaper fund keeps more for you.

Compare expense ratios aggressively, especially among index funds tracking the same benchmark:

FundBenchmarkExpense Ratio
VFIAXS&P 5000.04%
FXAIXS&P 5000.015%
SWPPXS&P 5000.02%

FXAIX wins on cost. On a $500,000 portfolio, the difference between VFIAX (0.04%) and FXAIX (0.015%) is about $125 a year: small, but it adds up over decades.

2. Holdings Overlap

Holdings overlap is the share of one fund's portfolio that also sits in another fund you own. Two "different" funds might hold many of the same stocks, which means less diversification than you think and two sets of fees for duplicate exposure.

The Mutual Fund Overlap Calculator shows exact overlap percentages between any two funds. Check every pair in your portfolio.

3. Risk-Adjusted Returns (Sharpe Ratio)

The Sharpe ratio measures return per unit of risk: it divides a fund's return above the risk-free rate by its volatility, and higher is better. Raw returns do not account for how much risk was taken.

A fund returning 10% with low volatility is better than one returning 12% with stomach-churning swings, especially if you're likely to panic-sell during drawdowns.

4. Holdings Concentration

Holdings concentration is the share of a fund in its top 10 holdings. A fund with 40% in 10 stocks is making a concentrated bet. That can work in bull markets but creates outsized risk in downturns.

Compare top holdings between funds to understand what you're actually buying.

5. Turnover Ratio

Turnover ratio measures how often a fund buys and sells its holdings. High turnover (100%+ annually) generates more taxable events and trading costs. Index funds typically have turnover under 10%. Actively managed funds can exceed 100%.

In taxable accounts, low turnover is a significant advantage.

6. Tax Efficiency

Tax efficiency is how much of a fund's return you keep after taxes. Capital gains distributions can create unexpected tax bills even if you didn't sell anything. Some funds are structurally more tax-efficient than others.

For tax-conscious investors, the mutual fund tax harvesting tool helps identify loss-harvesting opportunities.

7. Minimum Investment

Mutual funds often have minimums that ETFs don't:

  • Vanguard Admiral Shares (VFIAX): $3,000 minimum
  • Fidelity Index Funds (FXAIX): No minimum
  • Institutional share classes: $100,000+

If a minimum is a barrier, check if there's an ETF equivalent. VFIAX and VOO hold the same stocks, and VOO has no minimum beyond the price of one share.

How to Compare Mutual Funds: Step-by-Step

Step 1: Define What You Need

What role will this fund play in your portfolio?

  • Core US equity: VFIAX, FXAIX, VTSAX, SWTSX
  • International equity: VTIAX, FSPSX, VTMGX
  • Bonds: VBTLX, FXNAX, FTBFX
  • Target-date: VFFVX, FFFHX (set it and forget it)

Step 2: Screen for Candidates

Start with data rather than a web search. The mutual fund screener lets you filter 23,000+ mutual funds by:

  • Category and asset class
  • Expense ratio (set a max)
  • Minimum investment amount
  • Historical returns (1Y, 3Y, 5Y, 10Y)
  • Fund size and family

Narrow your list to 2-3 serious candidates.

Step 3: Run a Side-by-Side Comparison

Use the mutual fund compare tool to put your candidates side by side on the metrics above, rather than returns alone.

Step 4: Check Overlap With Your Existing Holdings

Before adding a new fund, check how much it overlaps with what you already own. This is especially important if you hold funds across different accounts (401k, IRA, taxable).

The Mutual Fund Overlap Calculator shows exact overlap between any two funds.

Step 5: Consider the Account Type

Where you hold the fund matters:

  • 401k/403b: Limited to your employer's menu. Compare what's available and pick the lowest-cost option in each category.
  • IRA: Full flexibility. Choose the best fund regardless of provider.
  • Taxable account: Prioritize tax efficiency. Consider ETFs over mutual funds for better tax treatment.

VFIAX vs FXAIX (S&P 500 Index)

The two most popular S&P 500 index funds. Both track the same index, hold the same ~500 stocks, and deliver nearly identical returns. FXAIX is slightly cheaper (0.015% vs 0.04%) and has no minimum investment. VFIAX requires $3,000.

Winner: FXAIX on cost and accessibility. But if you're already in VFIAX, the difference is so small it's not worth switching (especially in a taxable account where selling triggers capital gains).

VTSAX vs SWTSX (Total Market Index)

VTSAX (Vanguard) and SWTSX (Schwab) both track the total US stock market — about 3,500-4,000 stocks. SWTSX is cheaper (0.03% vs 0.04%) with no minimum. VTSAX requires $3,000.

Winner: SWTSX on cost and accessibility, but the difference is negligible.

VBTLX vs FXNAX (Bond Index)

Both track the Bloomberg US Aggregate Bond Index. VBTLX (0.05%) and FXNAX (0.025%) are both very cheap. Nearly identical performance and holdings.

Winner: FXNAX on cost, but the real-world difference is minimal.

Active vs Index: FCNTX vs FXAIX

This is the bigger question. FCNTX (Fidelity Contrafund) is an actively managed large-cap growth fund with a 0.39% expense ratio. FXAIX is a passive S&P 500 index fund at 0.015%.

Over long periods, most active funds underperform their benchmark index after fees. FCNTX has been an exception historically, but past outperformance doesn't guarantee future results.

Comparing Mutual Funds to ETFs

Many investors wonder whether to use mutual funds or ETFs. The holdings are often identical (VFIAX = VOO), but there are structural differences:

FeatureMutual FundETF
TradingEnd of day NAVReal-time pricing
Minimum investmentOften $1,000-$3,000Price of 1 share
Tax efficiencyLower (capital gains distributions)Higher (in-kind redemptions)
Automatic investingEasy (set dollar amounts)Harder (must buy whole shares)
Expense ratiosComparable for index fundsSometimes slightly lower

If you're comparing a mutual fund to its ETF equivalent, the ETF comparison tool can help with the ETF side of the analysis. For overlap between a mutual fund and an ETF, use the overlap calculator.

Mutual Fund Comparison for 401k Investors

Your 401k likely offers 15-30 fund options. Here's how to compare them quickly:

  1. List every fund and its expense ratio. Eliminate anything over 0.50% unless there's no cheaper alternative in that category.
  2. Identify the index funds. Most 401k plans have at least one S&P 500 or total market index fund. These should be your starting point.
  3. Check for institutional share classes. Your 401k might offer cheaper share classes than what's available to retail investors.
  4. Compare within categories. Don't compare a bond fund to a stock fund. Compare the two large-cap options against each other, the two bond options against each other, etc.
  5. Check overlap if you hold multiple. Use the mutual fund overlap calculator to make sure your 401k allocations aren't duplicating each other.

Explore More FundXLS Tools

Start Comparing Mutual Funds

Compare fees, overlap, risk, holdings and tax efficiency, not star ratings and past returns alone.

Try the Free Mutual Fund Compare Tool →

To see shared holdings between any two funds, use the mutual fund overlap calculator.

Related posts

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

Explore MarketXLS in Excel
Download a free sample workbook (.xlsx). MarketXLS is a paid subscription.
I agree to the MarketXLS Terms and Conditions

See MarketXLS in action

Bring this workflow into Excel.

Book a demo with our team to see how MarketXLS supports your market research.

Ankur
AnkurFounder & CEO, MarketXLS
Book a demo