XIRR calculator
Investing Rs 50,000 twice and redeeming at Rs 1,25,000 later gives an XIRR of 13.54% in the example below. Enter up to 8 dated amounts; investments are negative.
Results update as you type. Nothing you enter is stored.
How it works
XIRR finds the yearly rate at which the present value of all your cash flows is zero. Money in is negative, money out (or today's value) is positive. Dates matter: money invested for a short time counts less than money invested for years. This is the same calculation as the XIRR function in spreadsheets, using a 365 day year.
Formula
Find r such that sum of amount / (1 + r)^(days since first date / 365) = 0
Frequently asked questions
What is XIRR?
An annualised return for cash flows on irregular dates, such as SIP instalments and a redemption.
Why should investments be negative?
XIRR needs money going out and coming in; the sign tells the calculator which is which.
How is XIRR different from CAGR?
CAGR uses one start and one end value; XIRR handles many dated amounts.
Related
This tool is for information only and is not investment, tax or legal advice. Results depend on the inputs and assumptions you enter; check important figures with the official source or a qualified professional.