ETF Holdings Decomposer

Concentration risk is the danger that a large portion of your ETF's performance depends on just a few holdings. The more concentrated an ETF, the more it behaves like a stock pick rather than a diversified portfolio.

Key concentration metrics:

• Top 5 weight — The combined weight of the five largest holdings. If this exceeds 25-30%, the fund is significantly concentrated. For reference, the S&P 500 currently has top-5 weights around 25-30%, which is historically high.
• Top 10 weight — The combined weight of the ten largest holdings. Above 40-50% means the fund's return is largely determined by a handful of stocks.
• HHI (Herfindahl-Hirschman Index) — A standard measure of market concentration. It sums the squared weights of all holdings. An HHI below 1,500 is considered diversified, 1,500-2,500 is moderately concentrated, and above 2,500 is highly concentrated.
• Total holdings count — More holdings generally means more diversification, but only if the weights are reasonably distributed. An ETF with 500 stocks where the top 10 are 45% of the fund is less diversified than one with 100 equal-weight stocks.

Practical interpretation: Concentration is not inherently bad. Concentrated ETFs can outperform if their top holdings do well. The problem is when investors think they are diversified but aren't. Knowing the concentration level lets you make that bet intentionally rather than accidentally.

The expense ratio is the annual fee an ETF charges as a percentage of your investment. It is deducted automatically from the fund's returns, so you never see a line item on your statement — it just silently reduces your gains every year.

How expense ratios compound over time:

• Small differences compound dramatically — A 0.03% expense ratio vs. a 0.50% expense ratio might seem trivial, but on a $100,000 investment over 30 years at 8% annual returns, the cheaper fund leaves you with roughly $40,000 more. That 0.47% annual drag compounds relentlessly.
• Compare similar funds — When two ETFs track the same index (e.g., S&P 500), the lower-cost option will almost always win over time. There is very little performance difference between SPY (0.09%) and VOO (0.03%), but the fee gap adds up.
• Active vs. passive — Actively managed ETFs charge higher expense ratios (0.50-1.00%+) compared to passive index ETFs (0.03-0.20%). The data consistently shows that most active managers fail to beat their benchmark after fees.

When higher fees might be justified: Specialty ETFs covering niche markets (frontier markets, specific commodities, or complex strategies) may legitimately cost more due to the complexity of managing those holdings. The question is always whether the extra cost delivers extra value.

Our Fee Erosion Calculator lets you model this exact scenario — plug in two expense ratios and watch the gap widen over decades.

An ETF's sector breakdown shows you how the fund's assets are distributed across economic sectors like technology, healthcare, financials, and energy. This reveals the fund's true sector bets — which may differ significantly from what the name suggests.

Why sector breakdown matters:

• Hidden sector concentration — Many broad market ETFs have become technology-heavy due to the growth of mega-cap tech. The S&P 500 is roughly 30% technology by weight, meaning a "total market" fund is really a one-third tech bet.
• Cyclical vs. defensive exposure — Sectors like technology, consumer discretionary, and financials are cyclical — they perform well in expansions but suffer in recessions. Defensive sectors like utilities, healthcare, and consumer staples are more resilient. Your ETF's sector mix determines how it behaves in different market environments.
• Portfolio-level sector balance — If you hold multiple ETFs, their combined sector exposure might create unintended tilts. Three "different" growth ETFs might all be 40%+ tech, giving you a massive concentration in one sector.
• Correlation risk — Holdings within the same sector tend to be highly correlated. An ETF with 80% in technology provides less diversification benefit than one spread across 8 sectors at 10% each, even if both hold the same number of stocks.

How to use this information: Compare your ETF's sector breakdown against your overall portfolio. If you already have individual tech stocks, adding a tech-heavy ETF doubles down on that bet. Consider whether your total exposure matches your intended risk profile.

The frequency of ETF holdings changes depends on the fund's strategy, index methodology, and rebalancing schedule. Different types of ETFs update their holdings at very different rates.

By ETF type:

• Passive index ETFs — Funds like SPY or VTI track an index and only change when the index itself changes. The S&P 500, for example, adds or removes companies a few times per year based on market cap and eligibility criteria. Day-to-day, the holdings are stable but weights shift as stock prices move.
• Actively managed ETFs — Funds like ARKK can trade daily based on the manager's conviction. Holdings can change significantly from quarter to quarter. Active ETFs are required to disclose holdings daily, giving you real-time transparency.
• Factor and smart beta ETFs — These funds rebalance on a set schedule (quarterly, semi-annually, or annually) to maintain their factor exposure (value, momentum, quality, etc.). Between rebalances, the weights drift with market prices.
• Equal-weight ETFs — These rebalance periodically (usually quarterly) to reset all holdings to equal weights, which naturally involves selling winners and buying laggards.

Disclosure requirements: All US-listed ETFs must disclose their complete holdings daily. This is a significant advantage over mutual funds, which only disclose quarterly. The holdings data in this tool reflects the most recent available disclosure from the fund provider.

Weight drift: Even when holdings don't change, weights change every day as stock prices move. A stock that rallies 50% while everything else is flat will become a much larger percentage of the fund. This is why market-cap weighted ETFs naturally become more concentrated in their winning stocks over time.

The weighting methodology determines how much of each holding an ETF owns, and it has a dramatic impact on concentration, risk, and returns. The two most common approaches are market-cap weighted and equal weighted.

Market-cap weighted (e.g., SPY, QQQ, VTI):

• Each stock's weight is proportional to its market capitalization. Apple at $3T gets a much larger weight than a $10B company.
• Pros: Lower turnover, lower costs, reflects the market's collective wisdom about company value. Self-rebalancing as prices change.
• Cons: Heavily concentrated in the largest stocks. Momentum-driven — stocks that have already gone up get bigger weights, which can lead to overexposure at peak valuations.

Equal weighted (e.g., RSP, QQQE):

• Every stock gets the same weight (e.g., in a 500-stock fund, each stock is 0.2%). Regularly rebalanced to maintain equal weights.
• Pros: True diversification across all holdings. More exposure to smaller companies, which historically have higher long-term returns. No concentration in mega-caps.
• Cons: Higher turnover and trading costs due to quarterly rebalancing. Underperforms when mega-caps rally (as they have in recent years). Slightly higher expense ratios.

Bottom line: Market-cap weighted ETFs are great when large companies are leading the market. Equal-weight ETFs provide better diversification and tend to outperform over very long periods as they naturally sell high and buy low during rebalances. Many investors use a mix of both.

ETF overlap occurs when you hold the same stock in multiple funds without realizing it. This is one of the most common mistakes individual investors make, and it creates unintended concentration that undermines the diversification benefit of owning multiple ETFs.

How to identify overlap:

• Compare top holdings — The fastest check is to look at the top 10 holdings of each ETF you own. If the same names appear across multiple funds, you have overlap. Use this tool to look up each ETF separately and compare.
• Weight the overlap — It's not just about whether the same stock appears, but how much total exposure you have. If Apple is 7% of SPY and 10% of QQQ and you hold both equally, your effective Apple weight is 8.5% — a significant single-stock bet.
• Sector-level overlap — Even if the specific stocks differ, sector overlap creates correlated risk. Three ETFs each at 35% technology gives you roughly 35% tech exposure overall.

Common high-overlap pairs:

• SPY + QQQ — QQQ's top holdings are almost entirely contained within SPY. Holding both is essentially double-weighting the largest Nasdaq stocks.
• VTI + VOO — VTI contains VOO plus mid and small caps. The overlap is roughly 80%+ by weight.
• Any growth ETF + Nasdaq 100 ETF — Growth-oriented funds tend to hold the same mega-cap tech stocks that dominate Nasdaq indices.

How to fix overlap: Choose one broad market fund as your core holding, then add satellite ETFs that provide genuinely different exposure (different sectors, geographies, or asset classes). International ETFs, bond ETFs, and sector-specific funds in underweight areas add real diversification.

Once you know what's inside your ETF, the natural next step is to ask: are these holdings fairly valued? This is where DCF analysis becomes powerful — it lets you form independent views on the stocks driving your ETF's performance.

How to connect ETF analysis to valuation:

• Value the top holdings individually — If your ETF's top 5 holdings are 40% of the fund, those 5 stocks are driving your returns. Building a DCF model for each gives you a view on whether the ETF's largest positions are overvalued, fairly valued, or cheap.
• Weighted fair value — If you calculate fair value for the top holdings, you can estimate whether the ETF as a whole is trading above or below the intrinsic value of its components. This is a more rigorous approach than just looking at the ETF's aggregate P/E ratio.
• Identify the weakest links — Holdings analysis might reveal that a large-weight stock in your ETF is significantly overvalued by your DCF estimate. This is useful information for portfolio construction decisions.
• Validate your sector bets — If your ETF is 35% technology, running DCF models on the major tech holdings helps you decide whether that sector concentration is comfortable or concerning at current valuations.

Our DCF model builder generates professional Excel models with working formulas for any public company. Start with the top holdings from your ETF and build out your own valuation framework.