What is XIRR (Extended Internal Rate of Return)?

Published on November 10, 2026 • Last updated November 10, 2026

Mathematical Formula Included

Official Definition

XIRR is the annualised rate of return that makes the sum of all dated cash flows equal zero, using the actual number of days between dates divided by 365.

Detailed Explanation

In-Depth Guide

Key Takeaway

XIRR solves 0 = Σ CFᵢ ÷ (1 + r)^((dᵢ − d₀) ÷ 365), where CFᵢ is the cash flow on date dᵢ and d₀ is the first date. Investments are negative and money received is positive.

Because every cash flow is discounted by its own date, XIRR suits SIPs, top-ups and withdrawals, where money is invested for different lengths of time. It matches the convention Microsoft documents for the XIRR spreadsheet function.

A single investment and a single value give the same result as CAGR.

Mathematical Formula

0 = Σ CFᵢ ÷ (1 + r)^((dᵢ − d₀) ÷ 365)

Calculation Examples

12 monthly SIPs of 10,000 on the 5th from Jan to Dec 2023 (total 1,20,000) and a value of 1,32,000 on 5 Jan 2024: Absolute return = (1,32,000 − 1,20,000) ÷ 1,20,000 = 10.00% XIRR ≈ 18.88% a year, because the average rupee was invested for only about half a year.

Frequently Asked Questions

Only when there is one investment and one value. For several dated cash flows such as a SIP, XIRR is the correct measure and CAGR is not.

A return only exists if money goes out and comes back. If every cash flow has the same sign, no rate can balance them, and Excel reports an error.

Actual days divided by 365, so a leap year counts 366 days for that year.

What do you need to work out next?

Search 278+ free tools by name, or pick a category below. Every one runs instantly in your browser — no signup, nothing to install.

More Finance tools
AI ADVISOR & COACH

Ask AI Advisor

Ask AI