For buy (inflow) transaction, use minus sign (-) before the amount
Frequently Asked Questions
How to use this XIRR calculator?
For each relevant cashflow, enter transaction amount and corresponding date.
Inflow amounts should have minus sign (-)
Outflow amounts should have plus sign (+)
If the portfolio is not completed sold, add current portfolio value as an outflow
What is XIRR?
XIRR is a financial metric used to calculate growth of a portfolio (could be an investment or a liability) that involve uneven cashflow. It gives you a clearer picture of how your money is working for you over time.
Who is XIRR suitable for?
XIRR is used for understanding investment returns over time, and is suitable for:
Yes, SIP investment involved multiple transactions at different times, and XIRR is provides a precise way to measure return in such scenario. Use our free XIRR calculator to calculate returns on your mutual fund investments.
Absolute Return vs CAGR vs XIRR
In short,
Absolute returns does not consider time
CAGR calculates annualized returns, but considers that all the investments were done at the start of the duration and all withdrawals were at the end. It works best when there are only two transaction entry - one investment, one withdrawal.
IRR takes time into account, but works when all the portfolio transaction are periodic. Eg. a SIP investment, or a loan
XIRR considers timing for all individual transactions in a portfolio, including irregular timing
Understand the differences and calculations with example in our guide.
Why use our XIRR calculator?
It's a simple & free calculator that computes XIRR in your browser, with no data is sent to the server.