UTILS.
100% in-browser
%∑

IRR / NPV / XIRR Calculator

Internal rate of return and net present value of any cash-flow series, with dated XIRR mode.

Periodic: one amount per line. Dated: YYYY-MM-DD amount

About this tool

IRR / NPV / XIRR Calculator is a free, in-browser tool that computes the internal rate of return and net present value of a cash-flow series you type in — one flow per line, negatives for money out and positives for money in. Switch to dated mode and each line takes a YYYY-MM-DD date so irregular timing is handled exactly like a spreadsheet XIRR.

The IRR is the rate r that makes Σ CF_k/(1+r)^(t_k) equal zero; the tool finds it by scanning for a sign change and then bisecting with a capped iteration count, so it never spins or returns infinity. In dated mode t_k is the actual day count from the first flow divided by 365, which makes the result an annualized rate. NPV is evaluated separately at whatever discount rate you enter.

It is the standard way to measure the true return of a mutual-fund SIP, a rental property, or any project with uneven deposits and withdrawals. Everything runs locally in your browser — your cash flows are never uploaded.

Frequently asked questions

What is the difference between IRR and XIRR?
Periodic IRR assumes flows are equally spaced and returns a per-period rate, while XIRR uses the actual dates you enter (day counts ÷ 365) and returns an annualized rate — use dated mode whenever timing is irregular.
Why does it say no IRR was found?
An IRR only exists when the series has at least one inflow and one outflow and the NPV curve crosses zero in the searched range (−99% to +1000%); an all-positive or all-negative series has no internal rate of return.
How is NPV calculated?
NPV discounts every flow at your entered rate — Σ CF_t/(1+rate)^t with the first flow at t = 0 — so a positive NPV means the series earns more than that discount rate.
Do my cash flows leave my device?
No. Parsing, root-finding and discounting all run locally in your browser on this static page; nothing is uploaded or stored.

More tools