Index Fund Selection Checklist (Excel Download)

Index Fund Selection Checklist

Evaluate your prospective index mutual fund against these 20 objective criteria.

Completed 0 / 20

Selection Score 0%

📊 Golden Principles of Index Investing:

The success of index funds does not depend on fund manager predictions; rather, it hinges on a Low Total Expense Ratio (TER), Low Tracking Error, and Disciplined Long-Term Monthly SIPs. Review all 20 criteria across these 6 essential categories before investing in any fund.

📗 Download all 20 criteria as a structured Excel workbook:

Plan Type & Growth Option

Eliminating distributor commissions and ensuring direct compound compounding

Core Plan Selection

Always Select Direct Plan (Never Regular Plan): Critical

Verify that you are investing in the 'Direct Plan' rather than a 'Regular Plan'. Paying 0.50% to 1.00% annual commissions to intermediaries on an index fund erodes compounding wealth unnecessarily.

Choose Growth Option (Avoid IDCW / Dividend Payout): Critical

Opt for the 'Growth Option' so dividends declared by constituent companies are automatically reinvested into the fund's NAV, maximizing tax-efficient compounding.

Use Direct AMC Portals or Official Direct Platforms: High

Invest directly via MF Central, official AMC websites, or authorized zero-commission direct mutual fund platforms with zero brokerage.

Total Expense Ratio (TER)

Keeping administrative and management fees at bare minimums

Cost Control

NIFTY 50 Low Expense Ratio (TER ≤ 0.20%): Critical

Ensure the Total Expense Ratio (TER) of a Nifty 50 direct index fund is between 0.10% and 0.20%. Avoid funds charging more than 0.25% to 0.30% for a standard large-cap index.

NIFTY NEXT 50 Reasonable Expense Ratio (TER ≤ 0.35%): High

Because Nifty Next 50 involves higher transaction turnover and market impact cost, a direct plan TER between 0.20% and 0.35% is acceptable.

Historical TER Consistency across Past 2-3 Years: Medium

Examine past 2-3 years of factsheet data to confirm the AMC did not introduce an artificially low teaser TER (e.g., 0.05%) only to hike it significantly later.

Tracking Factors (Tracking Difference & Tracking Error)

Measuring how accurately the fund mirrors the total return of the benchmark index

Precision

Low Tracking Difference (Tracking Difference ≤ TER + 0.10%): Critical

Check that the net return gap between the benchmark TRI (Total Returns Index) and the fund's NAV over 1 and 3 years closely mirrors its expense ratio (TER).

Low Tracking Error (Tracking Error < 0.05% - 0.10%): Critical

Verify from AMFI or monthly factsheets that annualized daily tracking error volatility is under 0.05% to 0.10%, indicating prompt index replication by the fund manager.

Minimal Cash Drag (Cash Holdings < 2%): Medium

Confirm the fund holds no more than 1% to 2% in cash/derivatives for redemption liquidity, preventing cash drag during bull markets.

Assets Under Management & Liquidity

Protecting large transactions from high impact cost and liquidity mismatches

Stability

Substantial Assets Under Management (AUM ≥ ₹1,000 Crore): Critical

Choose Nifty 50 index funds with an AUM of at least ₹1,000 crore. Very small funds (e.g., under ₹100 crore) suffer higher tracking error during institutional inflows and redemptions.

Reputable AMC with Proven Passive Track Record: High

Select established fund houses (e.g., HDFC, UTI, ICICI Prudential, SBI, Nippon) with 5+ years of institutional passive fund management experience and automated trading execution.

Zero or Minimal Exit Load: Medium

Ensure the fund has zero exit load or a minimal restriction (e.g., 0.25% only if redeemed within 7 days) to retain investment flexibility.

Portfolio Allocation Strategy

Structuring core and satellite portfolio ratios for stability and growth

Asset Allocation

70% Core Portfolio Foundation in Index Funds: Critical

Allocate at least 70% of total equity exposure to low-cost Nifty 50 and Nifty Next 50 passive funds to establish a robust, low-maintenance foundation.

Choosing 70:30 or 50:50 Large:Next Allocation: High

Adopt a 70% Nifty 50 + 30% Next 50 allocation for balanced stability, or 50:50 for younger investors with a 15+ year horizon seeking higher growth.

30% Optional Satellite Portfolio Allocation: Medium

Limit active mutual fund bets (e.g., quality midcap or smallcap funds) to the remaining 30% satellite portion if seeking potential alpha.

Annual Portfolio Rebalancing Discipline: High

Review your asset allocation annually and rebalance back to target weights if market movements push Next 50 or midcaps significantly above targets.

Disciplined SIP Execution

Removing emotion and automating long-term rupee-cost compounding

Discipline

Minimum 7 to 10+ Year Investment Horizon: Critical

Index investing is not short-term speculative trading. Maintain a disciplined 7-10+ year perspective to capture the full trajectory of economic growth.

Automated Monthly Auto-Debit SIP: High

Set up an automated bank auto-debit SIP scheduled 2-3 days after salary day, eliminating attempts to time market highs and lows.

Never Pause SIPs during Market Corrections: Critical

Continue regular monthly investments during 10% to 20% market corrections; lower NAVs enable accumulation of more units, accelerating rupee-cost averaging.

100% Nominee Registration & Tax Awareness: High

Ensure nominees are active across all folios. Note that long-term capital gains (LTCG) beyond 1 year currently enjoy an annual exemption up to ₹1.25 lakh under Section 112A.

Guide · English