XIRR Calculator – Extended internal rate of return
Rupee-cost averaging via SIP remains popular, yet once instalments spill across different dates—or you want one maturity cheque at the finish—simple "difference ÷ invested" summaries stop telling you how fast money truly compounded through time.
Spreadsheets answer that need with extended internal rate of return (XIRR): a single annualised rate tuned so discounted cashflows add up cleanly. MFReturns exposes a tightened version geared to equal installments on a regular cadence and one maturity payoff—useful sketches, but not full portfolio accounting.
Treat every figure below as illustrative: life brings fees, taxes, skipped installments, withdrawals, dividends, or multiple exits that your own sheet can model column by column.
What is XIRR—and what does this calculator do?
XIRR is the annual percentage that balances every dated rupee flowing in or out across an investment horizon. One searches for a rate r such that present value of the assembled cashflows is about zero—matching the intuition in the Formula panel for this calculator.
This webpage auto-builds those flows when you supply a calendar start date, equal installment amount, maturity date and maturity corpus, plus an installment rhythm. That matches how analysts bolt schedules into spreadsheets, only narrower: instalments stay uniform unless you graduate to fuller models.
How to use this XIRR calculator
Match the widgets from top to bottom inside the calculator card:
1. Set the start date and maturity date—the schedule must end after it begins.
2. Use the sliders (or keyed values) for amount each installment and total amount expected at maturity.
3. Choose how frequently installments occur: Every two weeks, Monthly, Quarterly, Half-yearly, or Yearly.
4. Read the headline XIRR together with invested amount, estimated returns, and amount at maturity on the breakdown card—values refresh briefly after edits settle.
Computing XIRR in Excel
General-purpose modelling usually lives inside spreadsheets:
– Place every dated cash movement in one column (purchases or contributions often coded negative; redemptions or money back positive per your bookkeeping).
– Pair adjacent dates beside each movement.
– Optionally append today's mark-to-market with today's date when you emulate open-ended holdings.
– Call Excel's XIRR(values, dates, [guess]); LibreOffice/Google Sheets offer similar functions.
Because spreadsheets allow skips, tapered instalments, SWPs and windfalls row by row, continue there whenever MFReturns' condensed inputs cease to resemble your storyline.
When XIRR tends to matter
Whenever rupees arrive in more than one dated chunk before redemption, CAGR-style shorthand that stitches only opening and closing balances omits sequencing effects. Scheduled SIP deposits highlight the mismatch: older instalments experience more calendar length than freshly added ones.
XIRR (and related IRR tooling) honours those intermediate dates rather than wiping them away. Outside this condensed UI advisers still cite rolling returns, benchmarks, glide paths and taxes—rates alone remain one slice of stewardship.
XIRR versus CAGR
The MFReturns CAGR experience expects one starting corpus, one ending corpus, and years elapsed under smooth-compounding mythology—ideal quick math when nobody sneaks mid-flight contributions between those marks.
Equal instalments before a payout already define a timetable; juggling separate CAGR guesses per instalment would scatter answers yet still bury interaction effects. Feeding every dated flow into XIRR restores a single cohesive annualisation.
Neither construct forecasts the future—they only echo the choreography you keyed in.
Benefits of using an XIRR calculator
– Highlights annualised experience after timing is baked in—not just brute totals.
– Helps compare stylised savings plans ahead of richer statements pulled from AMC portals.
– Complements spreadsheets: brainstorm here, then extend offline when nuances multiply.
– Makes it obvious that results depend entirely on the story you typed; contradictory stories still yield awkward rates.
What to remember—and where this tool stops
Equal installments plus one maturity story is what we optimise for; uneven withdrawals, dividends, stepped contributions, staggered payouts, dense tax choreography, or many exit checkpoints demand broader ledgers elsewhere.
Small shifts to maturity, frequency, ticket size or maturity cheque can swing the headline XIRR sharply.
If maths resists unrealistic pairings, massage inputs—the narrative and the spreadsheet line items should agree.
Whenever only two anchors matter with no intermediary flows, the CAGR calculator on MFReturns stays lighter-touch.
Understanding SIP-like behaviour favours timed cashflow metrics, yet diversification, glide paths and counsel still sit outside whichever percentage prints on screen.