Complete Guide to XIRR Calculator for Indian Stock Portfolios
What is XIRR?
XIRR (Extended Internal Rate of Return) calculates the annualised return on investments when cash enters or leaves your portfolio on irregular dates — the standard metric for Indian investors who buy stocks on dips, book partial profits, receive dividends and reinvest bonuses across years. Unlike simple profit percentage, XIRR weights when each rupee was deployed.
If you invested ₹1 lakh in March 2020 crash, added ₹50,000 in December 2021 rally, and portfolio is worth ₹2.1 lakh today, headline "110% gain" misleads — XIRR annualises the true investor experience. Master Calc's XIRR calculator India mirrors Excel XIRR using iterative solving on dated cash flows plus terminal portfolio value.
XIRR vs CAGR vs simple return
Simple return: (Current value − Net invested) ÷ Net invested. Ignores timing. CAGR: smooths growth between single start and end value over years — ideal for one lumpsum buy-and-hold. XIRR: handles multiple dated flows — ideal for staggered NSE purchases and SWP-like withdrawals.
Use CAGR Calculator for "I bought once in 2015 and still hold." Use XIRR when contract notes span dozens of dates. Mutual fund SIP investors compare statement XIRR against SIP Calculator assumptions to see if actual beat projection.
How to enter cash flows correctly
Convention: negative for money invested (outflow from your pocket), positive for money returned (sell proceeds, dividends taken as cash). Final row is current portfolio market value as positive terminal flow on today's date — or omit separate terminal if calculator has dedicated "current value" field.
Reinvested dividends stay inside portfolio — do not count as positive cash flow; they increase ending value instead. Each stock buy on Zerodha or Groww is separate negative flow on trade date. Partial sells are positive flows on sell date.
Comparing your XIRR to Nifty 50
Download Nifty 50 total return index values for same calendar window. Approximate index XIRR with lumpsum at start — or use index fund factsheet CAGR as benchmark. Beating Nifty consistently over 5+ years is difficult; underperforming after fees suggests index fund core via Mutual Fund Calculator may suit passive portion.
Mid-cap and small-cap portfolios show higher historical XIRR in bull runs but deeper drawdowns — risk-adjusted comparison matters. A 18% XIRR with 60% max drawdown differs from 14% XIRR with 25% drawdown for salaried investors nearing goals.
XIRR for direct stocks vs mutual funds
AMCs publish point-to-point CAGR in factsheets — your personal XIRR includes actual SIP dates, missed months, redemption for EMI and tax harvesting sells. Direct stock pickers with 15–20 positions should run portfolio-level XIRR quarterly, not just admire winners on screen.
Combine equity XIRR with debt allocation returns for holistic household net worth tracking. After major life events — home purchase, marriage — restart measurement from new baseline rather than blending unrelated goals in one XIRR series.
Practical example: three-year investing journey
- Jan 2022: −₹75,000 (initial buys in HDFC Bank, ITC)
- Aug 2022: −₹40,000 (averaging after correction)
- Feb 2023: +₹15,000 (partial profit booking)
- Nov 2023: −₹25,000 (new position in Tata Motors)
- Jun 2024: +₹8,000 (dividend received in bank)
- Today: portfolio value ₹1,42,000 entered as terminal value
XIRR might read 14–16% annualised while simple return looks different — calculator resolves exact figure from your inputs.
Limitations of XIRR
XIRR assumes reinvestment of intermediate flows at the same rate — unrealistic in volatile markets. Very short periods annualise to extreme percentages — a 5% gain in one month is not sustainably "60% CAGR." Negative XIRR means net destruction of wealth after timing effects.
Does not measure risk, drawdown or tax drag. Post-tax XIRR requires adjusting flows for Capital Gains Tax paid — advanced users export net figures after each sell.
Step-by-step: using XIRR Calculator
- Export trade history from broker or gather contract notes.
- List each investment date and amount as negative flows.
- Add sell and dividend dates as positive flows.
- Enter today's total portfolio market value.
- Review annualised XIRR percentage output.
- Compare same-period Nifty benchmark.
- Re-run quarterly after major trades.
Related calculators
ROI Calculator for simple trade profitability. Portfolio Rebalancing Calculator when allocation drifts. Stocks & Trading calculators for full toolkit. Plan taxes with Income Tax Calculator.
Disclaimer
XIRR is a historical performance metric, not a forecast. Equity markets on NSE and BSE fluctuate; past XIRR does not guarantee future returns. Cash flow entry errors materially change results — verify dates and amounts. Educational content only, not SEBI-registered advice.