XIRR / IRR Calculator
Approximate IRR for irregular dates and amounts using Newton–Raphson on XNPV — paste rows or enter manually; educational.
Sponsored
Cash flows
Irregular dates → annualized IRR
Amounts follow spreadsheet sign convention: outflows negative, inflows positive. Uses actual/365 year fractions from the first cash-flow date.
Advanced mode
Notes for CSV import (phase-2 style workflows).
Results
XIRR (annualized)
Rate
3.31%
Newton–Raphson on NPV; verify material cases in a spreadsheet
Advertisement
Perspective
IRR can have multiple or no solutions
Non-conventional cash flows can produce multiple IRRs; XIRR depends on date spacing.
Use alongside simpler metrics when diagnosing portfolios.
FAQ
Common questions
Is this Excel-identical?
It aims for similar methodology but may differ slightly from Excel XIRR in edge cases.
Minimum flows?
You need at least one negative and one positive cash flow for a meaningful IRR.
Sponsored
Explore next