XIRR / XNPV Calculator
Calculate present value and annualized IRR using actual dates and an actual/365 convention.
Results
Review or adjust your inputs, then calculate to see your results and interpretation.
Understand this calculation
XNPV measures value added at your hurdle rate. XIRR is a break-even discount rate, not a guaranteed reinvestment return.
See calculation method and assumptions
Formula
Dated present value (XNPV)
XIRR: numerical root condition
Dates cannot precede the first row. Uses UTC calendar days and a fixed 365 denominator, including leap years. Same-day flows net together. XIRR searches log(1+r)∈[−16,16], not all possible roots; multiple sign changes need care.
Variables, rates and periods
- CFᵢ / dᵢ
- Cash-flow amount and calendar date.
- d₀ / r
- First date / effective annual discount rate, decimal; day count divided by 365.
Scope and assumptions
- Dates cannot precede the first row.
- Uses UTC calendar days and a fixed 365 denominator, including leap years.
- Same-day flows net together.
- XIRR searches log(1+r)∈[−16,16], not all possible roots;
- multiple sign changes need care.
Calculate present value and annualized IRR using actual dates and an actual/365 convention.
Worked example
- Pay 1,000 on 2025-01-01 and receive 1,100 on 2026-01-01: XIRR 10%, XNPV zero at 10%.
- Change inputs and calculate again to compare assumptions.
Frequently asked questions
Is the result guaranteed?
Dates cannot precede the first row. Uses UTC calendar days and a fixed 365 denominator, including leap years. Same-day flows net together. XIRR searches log(1+r)∈[−16,16], not all possible roots; multiple sign changes need care.
Does the example represent actual markets?
No. All examples are hypothetical and contain no live market data.