XIRR Calculator
Calculate the Extended Internal Rate of Return for investments with irregular cash flows and timing.
Cash Flows (2)
investment
Initial Investment
return
Final Value
Results
Ready to Calculate
Add your cash flows and click "Calculate XIRR" to see your investment returns.
How it Works
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
Date,Type,Amount,Description
2024-01-01,investment,10000,Initial Investment
2024-12-31,return,12500,Final Value
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.