Institutional ETF Constituent Overlap Engine

Phase 4 Weights

Dual-Fund Constituent Intersection · Capital Duplication Risk · Blended True Look-Through

MR-007 Statutory Observations

Popular Institutional Pairings

Primary Fund (A)ETF

Expense Ratio9 bps

30D Spread1.2 bps

Holdings31 stocks

Secondary Fund (B)UIT

Expense Ratio9.45 bps

30D Spread1.0 bps

Holdings503 stocks

Weighted Portfolio Overlap

0.0%

Constituent-weighted capital intersection: Σ min(w_A, w_B)

Shared Constituent Names

503stocks

100% of XLRE · 100% of SPY

Unique Capital in XLRE

100.0%

Holdings exclusive to XLRE not tracked by SPY

Unique Capital in SPY

100.0%

Holdings exclusive to SPY not tracked by XLRE

Adjust portfolio weighting between XLRE and SPY to simulate effective expense drag and capital look-through.

XLRE: 70%Portfolio SplitSPY: 30%

Blended Expense Ratio

9.1 bps

0.091% annual asset-weighted drag

Annual Cost per $10k Invested

$9.13 / year

Baseline statutory dollar drag

Look-Through Holdings

50 tracked

Constituent look-through aggregate

Capital Duplication Alert

High concentration risk: PLD (Prologis Inc.) accounts for 8.3% of the blended portfolio look-through.

Ticker & Company	XLRE Weight	SPY Weight	Overlap Contribution	Blended Weight (70/30)

Want full 10-axis factor and fee drag analysis?

Loading Overlap Engine…