How to calculate mutual fund XIRR (with a worked SIP example)

A ₹10,000 monthly SIP, twelve months on

Invested12 × ₹10,000₹1,20,000
Worth todaythe ₹10,000 gain is what both numbers below describe₹1,30,000

Same SIP, two very different numbers

Absolute returntotal gain ÷ total invested8.3%
XIRRannualised, date-weighted~15%

Absolute return understates a growing SIP because the later instalments have barely had time to grow.

A worked example: two payments in, one value out

1 Jan 2025−₹50,000
1 Jul 2025−₹50,000
1 Jan 2026, value today+₹1,08,000

XIRR finds the single annual rate at which −50,000 held one year and −50,000 held six months grow to ₹1,08,000: roughly 11.6% per annum. There is no clean formula; it is solved by iteration.

Doing it yourself in a spreadsheet

01
List every SIP date with the amount as a negative number.
Money leaving your pocket is negative.
02
Add today’s date with the current value as a positive number.
03
Call =XIRR(values, dates) in Excel or Google Sheets.
One flipped sign and the answer is nonsense. Miss one instalment, top-up or redemption and the rate is wrong.

Multiply this by five funds, three family members and a few years of instalments and the spreadsheet becomes its own job. Hundo computes XIRR per fund and across the whole portfolio, marking each holding to the latest AMFI/Kite NAV, so the date-weighted return is simply there.

See your family’s whole picture in one ledger.