XIRR calculator
Calculate the exact annualized internal rate of return (XIRR) for investment portfolios, private equity, angel checks, real estate capital calls, or dividend streams with irregular calendar dates. Pure client-side Newton-Raphson solver with automatic bisection fallback.
Runs locally · No data uploaded · Newton-Raphson solver
Dated Cash Flows
Negative (−) for investments or contributions; positive (+) for returns, dividends, or current valuation.
| # | Date (YYYY-MM-DD) | Amount ($) | Type | Action |
|---|---|---|---|---|
| 1 | Outflow (Investment) | |||
| 2 | Outflow (Investment) | |||
| 3 | Inflow (Return) | |||
| 4 | Inflow (Return) |
- Total invested (outflows)
- $12,500.00
- Total returned (inflows)
- $16,500.00
- Net profit / gain
- $4,000.00
- Timeline
- 2022-01-15 → 2024-01-15
| # | Date | Amount | Day offset | Year fraction |
|---|---|---|---|---|
| 1 | 2022-01-15 | -$10,000.00 | +0 days | 0.000 yrs |
| 2 | 2022-07-01 | -$2,500.00 | +167 days | 0.458 yrs |
| 3 | 2023-03-15 | $1,000.00 | +424 days | 1.162 yrs |
| 4 | 2024-01-15 | $15,500.00 | +730 days | 2.000 yrs |
Disclaimer: Not financial advice. Extended Internal Rate of Return (XIRR) calculations assume all returns are reinvested at the calculated rate and does not account for taxes, inflation, or transaction commissions.
Looking for loan amortization and payment notes? Use the Seller financing calculator, Owner financing calculator, or Pool financing calculator.
Example
4-stage investment with $10,000 initial and $16,500 total exit
2022-01-15: -$10,000; 2022-07-01: -$2,500; 2023-03-15: +$1,000 dividend; 2024-01-15: +$15,500 exit. Yields an annualized XIRR of 16.13% over 2.0 years.
Related: Seller financing calculator, Owner financing calculator, Pool financing calculator, Break-even calculator, Retirement corpus calculator, GST calculator
FAQ
- What is XIRR and how does it differ from regular IRR?
- Standard IRR assumes cash flows occur at equal, periodic intervals (such as every month or every year). XIRR (Extended Internal Rate of Return) accounts for exact calendar dates and calculates the true annualized rate of return across irregular investment contributions, capital calls, dividends, and distributions.
- Why do some cash flows need to be negative and others positive?
- Cash flows represent money entering or leaving your pocket. Negative numbers represent cash outflows (money you invested, purchase price, or capital additions). Positive numbers represent cash inflows (dividends received, cash distributions, or current portfolio valuation at exit).
- How does this calculator solve for XIRR in the browser?
- The calculator calculates the discount rate r where Net Present Value (NPV) equals zero. It uses the Newton-Raphson iterative algorithm. If the derivative vanishes or oscillations occur, it automatically falls back to a bracketed bisection search.
- What causes an XIRR calculation to show an error?
- XIRR requires at least two cash flows spanning at least two different calendar days. There must be at least one negative amount (investment) and at least one positive amount (return/valuation). If all numbers share the same sign, NPV can never cross zero and no rate of return exists.
- Can I use this for SIPs, mutual funds, and stock portfolios?
- Yes. Enter each purchase date with a negative amount and your current portfolio value as of today's date as a positive amount. The resulting percentage is your annualized return (CAGR adjusted for cash flow timing).
- How is XIRR calculated without this page?
- Given cash flows (d_i, C_i) for i = 0..n-1, let t_i = (d_i − d_0) / 365. Find rate r > −1 such that NPV(r) = sum(C_i / (1 + r)^t_i) = 0. Compute derivative dNPV(r) = sum(−t_i × C_i / (1 + r)^(t_i + 1)). Start with initial guess r_0 = 0.10. Iterate r_{k+1} = r_k − NPV(r_k) / dNPV(r_k) until |NPV(r)| < 1e-7. If Newton diverges, find bracket [a, b] where NPV(a) × NPV(b) ≤ 0 and bisect.