Workspace / Financial planning tools
Investment analysis
XIRR Calculator
Estimate annualized investment returns from cash flows that happen on different dates. Enter investments as negative amounts and receipts or current value as positive amounts.
Dated cash flows
Use actual transaction dates for a more meaningful estimate.
1
2
Example: enter an investment as -10000 and a later receipt as 12000. For an investment you still hold, include its current value as a positive cash flow on the valuation date.
Your results
A result requires at least one valid negative cash flow, one valid positive cash flow, and a solvable return rate.
XIRR guide
How to use an XIRR calculator
XIRR measures an annualized return when money moves in or out on different dates. It is useful for portfolios with staggered purchases, recurring investments, partial withdrawals or a final portfolio valuation. Unlike a simple return percentage, it accounts for when each cash flow happened.
1. Enter every investment and receipt
Use one row for each transaction and enter its actual date. Record money you put into the investment as a negative amount, and money you receive as a positive amount. If you still own the investment, add its current market value as a positive cash flow dated on the day you value the portfolio.
2. Check the cash-flow signs
For example, an initial investment of 100,000 is entered as −100,000. A later additional investment of 20,000 is entered as −20,000. If the investment is worth 145,000 on the final date, enter +145,000. Reversing the signs or leaving out a contribution can materially change the result.
3. Read the annualized result carefully
XIRR is the annual rate that makes the net present value of the dated cash flows approximately zero, using a 365-day year. It is an annualized measure, not the total percentage gain and not a forecast. Compare results only when the included transactions, valuation dates and currency basis are consistent.
XIRR vs. ROI and CAGR
ROI compares a gain or loss with the starting amount. CAGR annualizes the change between a single beginning value and ending value over a period. XIRR is generally more suitable when there are multiple dated contributions or withdrawals because it accounts for their timing. For a single lump-sum investment with no intermediate cash flows, CAGR may be simpler.
Worked example
Suppose you invest 100,000 on 1 January, add 20,000 on 1 July, and value the investment at 130,000 the following 1 January. Enter all three dated cash flows: −100,000, −20,000 and +130,000. The result reflects both the amounts and the time each amount was invested; it will not be the same as simply dividing the final value by the first contribution.
Important limitations
Use complete transaction records and a consistent valuation date. Taxes, fees, dividends or distributions should be included as cash flows if you want them reflected in the return. XIRR can have no solution or more than one mathematical solution for unusual cash-flow patterns, and this calculator may not identify every possible root. The estimate is educational and is not a recommendation or guarantee of future performance.
Frequently asked questions
XIRR Calculator FAQs
Common questions about cash-flow dates, signs and interpreting annualized returns.
What is XIRR?
XIRR estimates an annualized return when investments and receipts occur on different dates. It solves for the rate that makes the dated cash flows' net present value approximately zero.
Why might XIRR be unavailable?
XIRR needs at least one negative and one positive cash flow and a rate that solves the equation. Unusual cash-flow patterns can have no solution or more than one possible solution; this calculator reports a result only when its numerical method finds a solution.
How should I enter investments and withdrawals?
Enter money you invest as a negative amount and money you receive or withdraw as a positive amount. Use the actual transaction dates and include the current portfolio value as a positive cash flow on the valuation date if you are measuring an investment you still hold.
Is XIRR guaranteed or a prediction?
No. XIRR summarizes the dated cash flows you enter. It does not predict future returns and can be misleading if transactions or current valuation are missing.