XIRR Calculator
Calculate the Extended Internal Rate of Return for investments with irregular cash flows and timing.
Initial Investment
Final Value
Ready to Calculate
Add your cash flows and click "Calculate XIRR" to see your investment returns.
Investments (Outflows)
- • Money you put into the investment
- • Purchase of stocks, mutual funds, etc.
- • Additional contributions or top-ups
Returns (Inflows)
- • Money you receive from the investment
- • Sale proceeds, dividends, redemptions
- • Maturity amounts
CSV Import Format
Import your cash flows from Excel or Google Sheets. Required columns: Date, Type, Amount
2024-01-01,investment,10000,Initial Investment
2024-12-31,return,12500,Final Value
Type must be "investment" or "return". Date format: YYYY-MM-DD
XIRR vs CAGR
XIRR is used for irregular cash flows with different timing, while CAGR is for regular investments. XIRR gives you the true annualized return considering the exact timing of each cash flow.
How to calculate XIRR online?
You can calculate XIRR online by entering your investment dates and amounts as outflows (investments), and your return dates and amounts as inflows (returns) into our XIRR calculator. It will instantly compute your annualized rate of return based on the exact timing of the cash flows.
What is the difference between XIRR and CAGR?
CAGR calculates the return between a single start and end point, assuming a steady growth rate. XIRR is used when there are multiple, irregular cash flows (investments and withdrawals) over different periods, giving a much more accurate true annualized return for scenarios like SIPs or periodic stock investments.