XIRR calculator
Enter each investment and each withdrawal with its date, and the calculator returns XIRR, the yearly return that makes all the cash flows balance to zero. Use it for monthly SIPs, top-ups and part withdrawals where a simple growth rate does not fit. Days are counted from the first date, the same way spreadsheet XIRR does.
Enter your dated cash flows
Result
How it was worked out
Fill in the fields above to see the result and every step here.
Worked example
Three equal investments of ten thousand rupees at six-month intervals, followed by a single payout of 33,000 a year after the last one, give an XIRR of 6.52 percent. Days are counted exactly. The same ten percent gain gives 10 percent over an ordinary year and 9.97 percent over a year that includes a leap day.
How XIRR is solved
XIRR is the yearly rate r at which all your dated cash flows balance out. Each flow is divided by (1 + r) raised to the power t, where t is the number of days from the earliest date divided by 365, and the results are added up. The rate that makes this sum exactly zero is the XIRR. Counting days from the first date and dividing by 365 is the same convention spreadsheet XIRR uses, so a year with a leap day counts as slightly more than one year.
No formula gives r directly, so it is found step by step. The solver starts from a guess of 10% and uses Newton's method: it measures how far the sum is from zero and how fast the sum changes with the rate, and jumps to a better rate. It stops when a step moves the rate by less than one billionth. If that does not settle, it falls back to bisection, halving a range of rates until it closes on the answer. The working under the result shows each try.
You need at least one outflow and one inflow. Enter the current value of an investment you still hold as a positive amount on today's date. When the signs switch more than once, for example invest, withdraw, invest again, more than one rate can balance the sum and the calculator warns you. XIRR describes what your past cash flows earned. It is not a forecast, and charges, taxes and exit loads count only if you enter them as cash flows.
XIRR finds the rate at which the sum of every cash flow, each divided by one plus the rate raised to the number of days since the first date over three hundred and sixty-five, equals zero. The solver uses Newton's method from your starting guess and falls back to bisection if it does not settle. You need at least one outflow and one inflow with dates.
Common questions
What is an XIRR calculator?
An XIRR calculator gives the annualised return on investments made and received on different dates. Unlike a simple growth rate, it uses the exact date of each cash flow. For example, three investments spread over a year and a half and one payout later give 6.52 percent a year in the stored example. It suits SIPs and part withdrawals.
XIRR kitna hona chahiye?
Koi ek sahi XIRR nahi hota. XIRR sirf yeh batata hai ki aapke dated cash flows ne kitna kamaya. Achha hai ya nahi, yeh aapke goal, samay aur risk par depend karta hai. Apna XIRR usi avadhi ke us return se compare kijiye jo aapko chahiye tha. Yeh calculator sankhya deta hai, yeh nahi batata ki kitna hona chahiye.
Related calculators
Find the future value of a lump sum, regular deposits or both at a chosen rate, with compounding, deposit timing, step-up and inflation-adjusted value.
Average price and charges on a share tradeEnter buy price, sell price and quantity for delivery or intraday to see every charge, net profit or loss, break-even sell price and average price.
Estimate your yearly income taxCompare income tax under the old and new regime on one salary, with standard deduction, rebate, marginal relief, surcharge and cess shown step by step.
Results follow the rules named above and are estimates for planning. They are not tax, legal or investment advice and do not replace your payslip, Form 16, loan statement or a chartered accountant.