What is an XIRR calculator?
An XIRR (Extended Internal Rate of Return) calculator finds the annualized return when money moves in and out on different dates. Unlike a simple ROI or CAGR on a single start-and-end pair, XIRR discounts every cash flow by how many days it sits in the investment.
This tool uses a dated SIP schedule: pick investment frequency, start date, maturity date, recurring contribution, and current or redemption value. It builds the cash flows and solves for the rate that sets net present value to zero—the same logic as Excel’s XIRR function.
When should you use XIRR?
Use XIRR when contributions are not a single lump sum or when you want a return figure that respects timing—not just totals.
- Measure SIP or step-up SIP performance using actual debit dates and today’s portfolio value.
- Compare mutual fund holdings after partial redemptions or top-ups.
- Check whether recurring deposits beat a fixed-rate alternative on a true annualized basis.
How does this XIRR calculator work?
Each recurring investment is treated as an outflow (negative cash flow) on its date. The maturity amount you enter is an inflow on the maturity date. The engine uses a 365-day year and Newton–Raphson iteration starting at 10%—matching common spreadsheet defaults.
Σ [ Ci / (1 + XIRR)^(di/365) ] = 0
Where –
| Ci | Cash flow on date i (investments negative, redemption positive) |
|---|---|
| di | Days from the first cash flow to date i |
| XIRR | Annualized internal rate of return |
Investments are generated from start date at your chosen frequency until the day before maturity; maturity value is applied on the maturity date.
Worked example
You invest ₹5,000 every month from 1 Jan 2021 through 1 Dec 2023 (36 debits) and value the holding at ₹2,15,396 on 1 Jan 2024. Total invested is ₹1,80,000 and wealth gained is ₹35,396. XIRR comes to about 11.98% per year—lower than the 12% headline SIP rate because each installment has less time to compound.
For a single lump sum with no interim flows, the <a href="/calculators/cagr-calculator/">CAGR calculator</a> or <a href="/calculators/roi-calculator/">ROI calculator</a> may be enough; for mixed dates, XIRR is the better fit.
How to use this XIRR calculator
Select investment frequency (14 days, monthly, quarterly, half-yearly, or yearly), enter start and maturity dates, recurring investment amount, and total maturity amount. Results and the investment breakdown chart update instantly.
XIRR vs CAGR
CAGR links one present value to one future value over whole years. XIRR handles many dated flows—essential for SIPs, SWPs, and irregular top-ups. If you only have total invested and current value without dates, use ROI or mutual fund return tools instead.
What this calculator does not include
Tax, exit load, expense ratio, and dividend reinvestment timing are not modeled. Manual one-off flows on arbitrary dates are not entered row-by-row here—only the recurring schedule plus maturity value. For projected future value at a fixed rate, use the SIP calculator.
Frequently asked questions
What is the difference between XIRR and CAGR?
CAGR is one smoothed rate between two points in time. XIRR is the annualized rate that equates all dated investments and redemptions; it is the standard metric for SIPs and irregular mutual fund cash flows.
Why are investments negative in Excel XIRR?
Spreadsheets treat money you pay in as negative flows and money you receive (redemption or current value) as positive. This calculator follows the same sign convention internally.
Which investment frequencies are supported?
You can choose 14-day (fortnightly), monthly, quarterly, half-yearly, or yearly intervals between your start date and maturity date.
How do I get the maturity amount?
Use your latest portfolio value or redemption proceeds on the maturity date from your AMC statement or app. For a forward estimate at a fixed return, run the SIP calculator first and paste the projected maturity value here.