XIRR Calculator for Dated Cash Flows
Account for deposits and withdrawals on actual dates.
Enter the opening value, closing value and elapsed years to calculate a compound annual growth rate. Use cash-flow return methods when money was added or withdrawn during the period.
CAGR turns a start-to-finish change into one constant annual compound rate. It is suitable for an investment with no intermediate external deposits or withdrawals, even when the actual yearly performance was uneven.
Divide closing value by opening value. This captures the cumulative change before spreading it over time.
Take the growth factor to the power of one divided by elapsed years. This finds the constant annual multiplier that recreates the closing value.
Subtract one and display the result as a percentage. The separate total-change figure remains cumulative and should not be confused with the annual result.
Sample inputs demonstrate the method. They are not a forecast or product offer.
The first example grows from 100 to 121 over two years. An annual factor of 1.10 produces 100 × 1.10 × 1.10 = 121, giving a 10% CAGR rather than half of the 21% total change.
Sample inputs demonstrate the method. They are not a forecast or product offer.
The same CAGR can describe very different return paths. It says nothing about the size of temporary losses, volatility or how steadily the investment grew.
When extra money was paid in, a larger closing balance may reflect contributions rather than performance. IRR or XIRR is needed to incorporate those external cash flows and their timing.
Annualise the change between a starting and ending value when there are no intermediate deposits or withdrawals.
A smooth annual equivalent does not describe the actual path or volatility.
Read our calculation and testing approach.