Choosing an exchange-traded fund is easier when every candidate is measured against the same checklist. This guide provides a repeatable ETF comparison worksheet for estimating ongoing costs, trading friction, portfolio exposure, tax considerations, and the risks hidden behind a fund’s headline label.
Overview
An ETF can look inexpensive and diversified while still being a poor fit for a particular portfolio. Two funds may follow similar market segments but differ in index rules, concentration, liquidity, distributions, currency exposure, or how closely they track their benchmarks. A disciplined comparison helps separate the fund’s investment exposure from the cost and implementation details that affect the investor’s result.
Use this checklist before an initial purchase, when replacing an existing fund, during an annual portfolio review, and whenever market conditions change the role an asset class plays in your plan. The objective is not to identify a universally “best ETF.” It is to identify the fund whose exposure, costs, liquidity, tax profile, and risk are appropriate for your time horizon and account type.
Start by recording the fund’s name, ticker, asset class, benchmark, account type, intended holding period, and target allocation. Then compare candidate funds in the following order:
- Exposure: What does the fund actually own?
- Methodology: How does the index select, weight, and remove holdings?
- Costs: What are the expense ratio, trading costs, and likely tax effects?
- Implementation: How liquid, transparent, and easy to trade is the fund?
- Portfolio fit: Does it duplicate an exposure you already hold?
A low expense ratio is useful, but it should not override a mismatch in objective or a materially different risk profile. For broader macro context, compare your intended allocation with the economic scenarios discussed in Portfolio Positioning by Economic Scenario.
How to estimate
A simple ETF comparison worksheet can turn qualitative observations into consistent estimates. Create one column for each candidate and enter the latest information from the fund provider, prospectus, exchange data, and your brokerage platform. Avoid comparing figures reported over different periods without labeling the dates.
1. Estimate recurring fund costs
The basic annual expense estimate is:
Annual fund cost = investment amount × expense ratio
For example, a hypothetical $20,000 investment in a fund with a 0.10% expense ratio would have an estimated annual fund expense of $20 before considering changes in the balance. This is an approximation, because the fund’s actual expenses are generally based on assets through time rather than only on the opening balance.
2. Add trading friction
Trading costs include commissions, if applicable, and the bid-ask spread. The spread is the difference between the price a buyer may pay and the price a seller may receive. A rough round-trip spread estimate for a single purchase and later sale is:
Estimated spread cost = position value × spread percentage
This simplified estimate assumes the investor crosses approximately one spread when buying and another when selling, using the quoted spread as a practical approximation. Actual execution depends on order type, market conditions, time of day, and price movement, so treat the result as an estimate rather than a guaranteed cost.
3. Compare tracking results
Tracking difference measures how the fund’s return differs from its benchmark over a stated period. A fund can have a small expense ratio but still lag its benchmark by more than the published fee because of trading costs, sampling, cash balances, taxes, corporate actions, or index-rebalancing effects. Review several comparable periods when available and distinguish tracking difference from tracking error. Tracking difference is the average gap; tracking error describes the variability of that gap.
4. Check concentration and overlap
Record the number of holdings, the weight of the largest holdings, sector or country weights, and any stated limits. Then compare the fund’s holdings or exposure categories with your existing investments. A portfolio holding a broad-market ETF and a sector ETF may have more exposure to the sector than the account’s fund names suggest. Overlap is not automatically a problem, but it should be intentional.
Inputs and assumptions
Use the following inputs in your worksheet. Record the date for each figure so the comparison remains auditable.
- Investment amount: The amount you expect to invest initially and, if relevant, through recurring contributions.
- Holding period: Use a realistic period rather than an assumed exit date. A longer period makes recurring costs more important, while a short period makes spreads and execution more significant.
- Expense ratio: Enter the current published operating expense ratio. Check whether temporary fee waivers or special arrangements are included.
- Bid-ask spread: Record a representative spread during normal trading conditions. Do not rely on a single quote observed during an unusually quiet or volatile moment.
- Turnover and distributions: Note the fund’s distribution history and whether it typically distributes income, capital gains, or both. Past distributions do not predict future amounts.
- Benchmark and index rules: Identify the benchmark, weighting method, rebalancing schedule, eligibility rules, and treatment of dividends or other income.
- Tax setting: Compare the account type, expected holding period, distribution treatment, and tax consequences relevant to your jurisdiction. Tax outcomes depend on personal circumstances.
- Liquidity and assets: Review trading volume, assets, creation and redemption structure, and the fund’s age. These are indicators to investigate, not standalone quality rankings.
- Risk controls: Note concentration limits, leverage, derivatives, securities lending, currency hedging, and whether the fund uses a physical or synthetic replication approach.
For a cost comparison over several years, a simplified estimate is:
Total estimated cost = recurring fund costs + estimated trading costs + account-specific tax costs
Do not treat this as a forecast of investment performance. It excludes returns, taxes that cannot be estimated reliably, market impact, and changes in the investment balance. Use it to compare implementation choices under the same assumptions.
Worked examples
Example 1: Similar broad-market funds
Assume two hypothetical funds are being considered for a $20,000, long-term allocation. Fund A has a 0.10% expense ratio and a representative 0.04% spread. Fund B has a 0.05% expense ratio and a representative 0.14% spread.
Fund A’s estimated first-year expense is $20. Fund B’s is $10. If the investor buys once and later sells, the simplified round-trip spread estimates are $8 for Fund A and $28 for Fund B. Under these assumptions, Fund B’s lower annual fee may not compensate for its higher trading friction unless the holding period is long enough or the spread narrows during actual execution. The investor should also compare tracking difference, benchmark methodology, holdings, and distributions before deciding.
Example 2: Broad ETF plus thematic ETF
Assume an investor owns a broad-market ETF and is considering adding a thematic ETF described as a growth allocation. The thematic fund may contain fewer companies, a larger weight in its biggest holdings, and a narrower industry focus than the label implies. The correct worksheet entry is not simply “growth.” Record the actual sectors, countries, company sizes, top holdings, and overlap with the existing broad fund.
If the thematic fund increases exposure the investor already has, the purchase may be a deliberate tilt or an unintended concentration. Compare the proposed position with a target allocation and write down what would cause a future reduction. This turns an attractive theme into a defined portfolio decision.
Example 3: Distribution and tax review
Suppose two funds provide similar market exposure, but one distributes income more frequently while the other has a different distribution pattern. In a taxable account, the timing and character of distributions may affect the investor’s tax records and cash-flow preferences. In a tax-advantaged account, the comparison may focus more heavily on exposure, costs, and withdrawal rules. The appropriate choice depends on the account and the investor’s circumstances; a distribution yield should not be treated as free return.
When to recalculate
Revisit the checklist whenever a fund provider changes the expense ratio, benchmark, index methodology, investment objective, concentration limits, replication method, or distribution policy. Recalculate after a material change in the bid-ask spread, trading liquidity, or the fund’s role in your portfolio. A portfolio review is also appropriate when you open a different account type, change your time horizon, alter your contribution schedule, or move into a different tax situation.
Market conditions can change the practical importance of each input. During periods of elevated volatility, spreads and execution quality may deserve more attention. When interest rates or inflation expectations move, review whether the fund’s duration, sector exposure, real-asset allocation, or cash-flow characteristics still match your plan. The Interest Rate Outlook Dashboard and Inflation Outlook Tracker can provide context, but neither replaces a fund-level review.
Before buying, complete these five final actions:
- Confirm the fund’s objective and benchmark in its current official documents.
- Record the expense ratio, spread, tracking results, holdings, and distribution information with dates.
- Calculate estimated recurring and trading costs using the same investment amount for every candidate.
- Check overlap with your existing portfolio and write down the intended allocation.
- Save the worksheet and set a review date, such as the next annual portfolio review or the next scheduled fund update.
This process does not remove investment risk or guarantee better returns. It does make the decision clearer, more comparable, and easier to revisit when fees, market conditions, or your financial goals change.
