OquiliaOquiliaOquilia — India's Financial Intelligence Platform
HomeCalculatorsInvestigationsNews
View All CalculatorsSIP CalculatorEMI CalculatorIncome TaxFD CalculatorPPF CalculatorAll 150+ Calculators
View All CompareHome Loan RatesPersonal LoansCredit CardsHealth InsuranceTerm InsuranceMutual FundsFD RatesEducation Loan
View All GuidesTax: Old vs New RegimeIncome Tax SlabsITR Filing GuideNRI Investment GuideNRI Tax GuideInsurance HubLoans HubLoan App Harassment HelpRetirement PlanningInvest HubHNI WealthFinancial Glossary
View All ToolsAm I Underinsured?Policy AuditJargon DecoderMutual Fund CategoriesBlog & Explainers
View All MoreAbout OquiliaReport FraudRefund TrackerContactBrand ConnectElection AdvertisingFor BusinessFAQ
  • Home
  • Latest
  • Live
  • Enforcement
  • Courts
  • Markets
  • Market X-Ray
  • Banking & Loans
  • Insurance
  • Tax
  • NRI
  • Startups
  • Investigations
  • Bribe Tracker
  • Elections
  • Data Audit
  • हिन्दी
Report fraud
  1. Home
  2. Calculators
  3. Investment
  4. XIRR Calculator
Investment

XIRR Calculator

Calculate the annualised return (XIRR) on investments with irregular cashflows. Add multiple investments and redemptions with their exact dates.

Regulators: SEBI and the Reserve Bank of IndiaMethodology
Reviewed byOquilia Research Desk·17 November 2026

Cashflows

DateAmount (negative = investment)
₹
₹
₹
₹
₹
₹
₹
₹
₹
₹
₹
₹
₹

Enter negative amounts for investments (outflows) and positive amounts for redemptions or current value (inflows). For a holding not yet sold, the last entry is its current value with today's date.

Your XIRR

23.78%

Annualised return on your cashflows

Total Invested

₹1,20,000

Total Received

₹1,35,000

Net Profit/Loss

+₹15,000

Benchmark Comparison

Your Portfolio
23.8%
Nifty 50 (10yr avg)
12.5%
Bank FD
7.0%
PPF
7.1%

What Is XIRR and How Is It Used for SIP Returns?

XIRR stands for extended internal rate of return. It measures the annualised return on investments with cashflows on irregular dates. Simple return and CAGR suit a single lumpsum; most portfolios have several transactions on different dates: monthly SIPs, occasional top-ups, partial withdrawals and final redemptions. XIRR takes all of these and gives one annualised figure.

Technically, XIRR is the rate at which the present value of all cashflows, money paid in (investments) and money received (redemptions and the current value), adds up to zero. This calculator finds it with the Newton-Raphson method, an iterative method that refines an estimate step by step. Because it uses the date of every cashflow, not only the amount, it handles irregular investment patterns that CAGR cannot.

Why CAGR Does Not Fit SIPs

CAGR (compound annual growth rate) applies to one investment made on one date and measured on another, with nothing added or taken out in between. Rs 1 lakh that becomes Rs 2 lakh in 5 years has a CAGR of 14.87%. If Rs 1 lakh was invested, Rs 50,000 added after 2 years and Rs 30,000 withdrawn after 4 years, CAGR cannot express the return; XIRR can.

In a SIP, each monthly instalment is invested for a different length of time: the first for the longest, the last for perhaps a month. XIRR weights each cashflow by its time in the investment and gives one annualised return across all of them.

A fund factsheet may show a 5-year CAGR of 15% while an investor's own XIRR in the same fund is 9%. Both can be accurate: the CAGR describes a lumpsum held for the whole period, and the XIRR describes the investor's own dates and amounts.

How to Calculate XIRR: The Mathematics

Each transaction needs an amount and a date. Money paid in is entered as a negative amount, and money received, including the current value, as a positive amount. For a holding not yet sold, the last entry is its current market value with today's date, as if it were redeemed today.

The calculator finds the rate r that satisfies: sum of [cashflow_i / (1 + r)^(t_i)] = 0, where t_i is the number of days from the first cashflow divided by 365, the same day count as the XIRR function in spreadsheets. It stops when successive estimates differ by less than 0.000001%, within at most 200 steps.

XIRR vs IRR

IRR (internal rate of return) assumes cashflows at equal intervals: monthly, quarterly or yearly. XIRR works with any dates, which is why it is called “extended”. For a SIP with equal monthly instalments and no gaps or extra transactions, IRR and XIRR give nearly the same result.

When an instalment is missed, an extra lumpsum is added, a partial withdrawal is made or a step-up changes the amount, the cashflows are no longer regular. XIRR still measures the return correctly in these cases; an IRR that assumes equal intervals does not.

Interpreting XIRR

A positive XIRR means the money received and the current value are worth more than the money invested, after allowing for timing; it is a nominal return, before inflation. There is no standard XIRR for a fund category: it depends on the fund, the market over the period and the investor's own cashflows, and past results do not set future ones.

A fair comparison uses the same dates and cashflows: for example, the XIRR of the same SIP in an index fund or the fund's benchmark over the same period. Comparing an XIRR with a figure for a different period or cashflow pattern can mislead.

Over short periods, annualising can give large numbers. A 5% gain in 3 months annualises to about 21.6%, and a short-term loss to a large negative figure. Neither says much about what a longer period would show.

XIRR for Property and Other Investments

XIRR works for any investment with dated cashflows: property (purchase, rent, maintenance, sale), shares bought on several dates with dividends received, portfolio management services, and deposits with partial withdrawals.

For property, enter the purchase price and costs such as stamp duty, brokerage and renovation as negative cashflows; rent received as positive cashflows on the dates received; maintenance and property tax as negative cashflows when paid; and the sale proceeds or current value as the final positive cashflow. The XIRR then reflects both the change in value and the rent, with the timing of each.

Getting the Inputs Right

Transaction dates and amounts are in the Consolidated Account Statement or the broker's transaction history. XIRR depends on dates as well as amounts, so exact dates give a more accurate result than approximate ones.

For the current value, use the value at the latest declared NAV on the date of the calculation. Running the calculation again later, with the new cashflows and value, shows how the annualised return has changed.

Frequently Asked Questions

Related Calculators

Explore other tools on related topics — each one is free to use and built for Indian financial contexts.

investment

CAGR Calculator

Open calculator
investment

SIP Calculator

Open calculator
investment

Lumpsum Calculator

Open calculator
investment

Mutual Fund Returns Calculator

Open calculator
Oquilia

India’s financial newsroom: enforcement, courts, markets and your money, in English and Hindi, from the official record.

Report fraud to our desk

Sections

  • Latest news
  • Fraud & Enforcement
  • Courts
  • Markets
  • Banking & Loans
  • Insurance
  • Tax
  • NRI
  • Elections
  • हिन्दी समाचार

Trackers & data

  • Investigations
  • Bribe Tracker
  • Police bribery cases
  • Report a bribe demand
  • Loan-app enforcement tracker
  • Refund Tracker
  • Data Audit
  • Markets Lab

Tools & guides

  • 150+ calculators
  • Compare loans & cards
  • Compare insurance
  • Tax guides
  • NRI guides
  • Loan app harassment help
  • Topics
  • Glossary

The newsroom

  • About Oquilia
  • Editorial policy
  • Corrections
  • Our journalists
  • Report fraud
  • Contact
  • Syndication
  • Brand Connect
  • Election advertising

Policies

  • Privacy
  • Terms
  • Disclaimer
  • Advertiser disclosure
  • Grievance redressal
  • Cookie policy
  • Legal hub
  • Security
Sections
  • Latest news
  • Fraud & Enforcement
  • Courts
  • Markets
  • Banking & Loans
  • Insurance
  • Tax
  • NRI
  • Elections
  • हिन्दी समाचार
Trackers & data
  • Investigations
  • Bribe Tracker
  • Police bribery cases
  • Report a bribe demand
  • Loan-app enforcement tracker
  • Refund Tracker
  • Data Audit
  • Markets Lab
Tools & guides
  • 150+ calculators
  • Compare loans & cards
  • Compare insurance
  • Tax guides
  • NRI guides
  • Loan app harassment help
  • Topics
  • Glossary
The newsroom
  • About Oquilia
  • Editorial policy
  • Corrections
  • Our journalists
  • Report fraud
  • Contact
  • Syndication
  • Brand Connect
  • Election advertising
Policies
  • Privacy
  • Terms
  • Disclaimer
  • Advertiser disclosure
  • Grievance redressal
  • Cookie policy
  • Legal hub
  • Security

Newsletter

Monthly digest

Policy moves, deadline reminders, and the most-used calculators each month.

We report fromRBISEBIIRDAIPFRDAIBBIIncome Tax DeptAMFI

© 2026 Oquilia. Not investment advice.SitemapRSSX @oquiliaBuilt by QX137