IRR Calculator

Find the internal rate of return of a list of cash flows, with NPV at your discount rate, MIRR, and XIRR for flows on real dates. Warns when the flows can have more than one IRR.

Calculator Finance Updated Oct 4, 2026
Learn how this works
How to Use
  1. Choose Periodic for evenly spaced cash flows, or Dated (XIRR) for cash flows on real dates.
  2. Enter the cash flows one per line, starting with the money you put in as a negative number. In Dated mode write the date first: 2024-01-15, -10000.
  3. Enter your discount rate (the return you require). For MIRR, add a finance rate and a reinvestment rate, or leave them blank to use the discount rate.
  4. Read the IRR, the NPV at your rate and the MIRR. The chart shows NPV at every rate; the IRR is where the curve crosses zero.
  5. If the flows change sign more than once, the calculator lists every IRR it finds and warns you — use NPV or MIRR to decide then.
Input
$, first = t0
YYYY-MM-DD, $
% a year
%
%
Presets
NPV Profile
IRR (a year)
—
NPV at the discount rate
—
MIRR (a year)
—
Net cash flow
—

Worked Example

IRR. A machine costs $10,000 and saves $3,000, $3,500, $4,000 and $4,500 over the next four years. The IRR is the rate r that solves −10,000 + 3,000/(1+r) + 3,500/(1+r)2 + 4,000/(1+r)3 + 4,500/(1+r)4 = 0. There is no formula for r; trying rates narrows it to 17.0937%.

NPV. At a 10% cost of capital the same flows are worth −10,000 + 2,727.27 + 2,892.56 + 3,005.26 + 3,073.56 = $1,698.65. Positive NPV and an IRR above 10% say the same thing: the machine pays.

MIRR. Growing each saving to year 4 at 10% gives 3,993 + 4,235 + 4,400 + 4,500 = $17,128; the cost is $10,000 today. (17,128 ÷ 10,000)1/4 − 1 = 14.4002%.

The common mistake: using a spreadsheet’s NPV function on the whole column. =NPV(10%, −10,000, 3,000, …) treats the $10,000 as paid a year from now and returns $1,544.23. Add the year-0 flow outside the function to get the right $1,698.65.

Show Work

Enter values and calculate to see the step-by-step breakdown.

Formulas

NPV
NPV = Σ CFt / (1 + r)t
CF0 at t = 0 is not discounted
IRR
Σ CFt / (1 + IRR)t = 0
Solved numerically; one root per sign change at most
MIRR
MIRR = (FV+ / −PV−)1/n − 1
FV+ at the reinvestment rate, PV− at the finance rate
XIRR
Σ CFj / (1 + r)(dj − d0)/365 = 0
Time in days ÷ 365 from the first date
Annualising
ryear = (1 + rperiod)m − 1
m = 12 for monthly flows, 4 for quarterly

IRR, NPV and the Trouble with Two Answers

Irving Fisher set out the idea of comparing investments by a “rate of return over cost” in The Rate of Interest (1907) and The Theory of Interest (1930). Kenneth Boulding and John Maynard Keynes worked with similar rates in the 1930s, and Joel Dean’s Capital Budgeting (1951) made discounted-cash-flow IRR a standard tool in business.

James Lorie and Leonard Savage pointed out in 1955 that a project whose cash flows change sign more than once can have several IRRs, or none. Descartes’ rule of signs gives the limit: the number of positive roots of the NPV polynomial is at most the number of sign changes. The modified IRR, which fixes the reinvestment and finance rates, has one answer, and NPV at a chosen rate always has one.

About This Calculator

This calculator finds the IRR of evenly spaced cash flows by bracketed bisection, scans the rates from −99% to 1,000% for any further roots, and works out NPV and MIRR at the rates you give. Dated mode solves XIRR by Newton’s method with a bisection fallback, timing each flow in days ÷ 365 from the first date, the same convention as spreadsheet XIRR and XNPV. Every IRR is checked by putting it back into the NPV.

All calculations run in your browser; nothing you enter is sent to a server.

Estimates for planning and education — not financial, tax or legal advice.

Related calculators: NPV Calculator, Payback Period Calculator, and ROI Calculator.

Frequently Asked Questions

What is IRR in plain terms?

It is the yearly return the investment earns on the money tied up in it: the discount rate at which the NPV of all the cash flows is exactly zero. Putting in $10,000 and getting back $3,000, $3,500, $4,000 and $4,500 over four years is a 17.0937% IRR.

How do I use IRR to decide?

Compare it with your hurdle rate (the return you require). If the IRR is higher, the NPV at your rate is positive and the project adds value. The project above clears a 10% hurdle with an NPV of $1,698.65; at 20% its NPV is −$584.49.

Why can a project have two IRRs?

Each time the cash flows change sign, the NPV curve can cross zero again. A project costing $1,600, returning $10,000 a year later and then needing $10,000 of clean-up has an NPV of zero at both 25% and 400%. Neither is a meaningful return; look at the NPV at your own rate (−$773.55 at 10%) or the MIRR.

What is MIRR?

The modified IRR grows the positive flows to the end at a reinvestment rate, discounts the negative ones to the start at a finance rate, and finds the single rate linking the two. It has exactly one answer. For the four-year project at 10% for both rates it is 14.4002%, below the 17.0937% IRR, because the IRR assumes each inflow earns 17% again.

When should I use XIRR?

When cash flows do not arrive at even intervals. XIRR measures time in days ÷ 365 from the first date. Spreadsheet help uses −10,000 on 1 Jan 2008 followed by 2,750, 4,250, 3,250 and 2,750 on later dates; the XIRR is 37.3363%, and the XNPV at 9% is $2,086.65 — both match this calculator.

How do I use the IRR Calculator?

Just type your numbers. The answer shows up right away — there is no button to press. Change anything and it updates by itself.

Do I need to install or sign up for anything?

Not at all — it runs in the browser with nothing to install and no account. After it loads once, it even works without an internet connection.

Is my information private?

Yes. Everything happens in your browser. Nothing you type is sent to a server or saved anywhere.

Common Use Cases

Equipment purchase

A $10,000 machine saving $3,000 to $4,500 a year for four years returns 17.0937%, above a 10% cost of capital.

Buy-to-let with a sale

$100,000 in, $6,000 a year of rent for five years and a $120,000 sale returns 9.3206%; at 7% the NPV is $10,159.53.

Exit after four years

Investing $50,000 and selling for $75,000 four years later is a 10.6682% IRR, even though the total gain is 50%.

Monthly cash flows

$5,000 in and $450 back every month for a year is 1.2043% a month, an annualised 15.4489%.

Irregular investments

Use Dated mode for contributions and withdrawals on real dates, such as a brokerage account or a private-equity fund.

Last updated: