Internal Rate of Return Calculator: The One Rate That Sums Up a Whole Investment
An internal rate of return calculator answers a question every investor eventually asks: if I put money in now and get money back over several years, what yearly rate of return am I really earning? It takes the whole messy story, the upfront cost, the uneven yearly payoffs, the wait between them, and boils it down to a single percentage you can compare against anything else, from a savings account to a rival project.
What IRR really means, in plain English
Imagine you lend a friend $10,000 and they pay you back in three uneven chunks over three years. You made money, since you got $12,000 back. But was it a good deal? That depends on how long your money was tied up, and what else you could have done with it. A 20% profit over one year is a great return; over ten years it is barely worth the wait.
IRR is the yearly rate that makes the whole deal balance out: the discount rate at which the present value of everything coming in exactly equals the money going out, so net present value (NPV) is zero. Think of it as the interest rate your investment is secretly paying you. If that rate beats what you could earn elsewhere, the project earns its keep. And never judge an investment by total profit alone, since profit ignores timing: money back next year beats the same money back in five years.
Every input, explained
Initial investment (Year 0). The money you put in at the start. Enter it as a positive amount and the calculator treats it as an outflow from your pocket.
Yearly cash-flow rows. What comes back (or goes out) in each later year. Positive means money in your pocket that year; negative means an extra cost, like a repair bill. Add as many years as the project runs, and leave a row blank if a year has no flow.
Hurdle rate for the NPV verdict (%/yr). Your personal bar: your cost of borrowing, the return of a safe alternative, or the minimum return your business demands. IRR above the hurdle means the project clears your bar, and below it means it doesn't.
What you get back. The IRR itself, the NPV at your hurdle rate in dollars, a plain verdict, and a warning if the cash flows produce more than one possible IRR (covered below).
A worked example: $10,000 in, $3,000, $4,000, $5,000 out
Say you invest $10,000 today and receive $3,000 after one year, $4,000 after two years, and $5,000 after three years. You get $12,000 back, so the undiscounted profit is $2,000. But over three years, is that good? Let's find the rate that makes it all balance.
- Write down the flows. Year 0: -$10,000. Year 1: $3,000. Year 2: $4,000. Year 3: $5,000. Money out is negative, money in is positive.
- Try a rate and discount everything back. At 10%, the inflows are worth $2,727.27, $3,305.79, and $3,756.57 today, totalling $9,789.63. That's $210.37 short of your $10,000, so NPV at 10% is -$210.37: 10% is too high for this deal.
- Try a lower rate. At 8%, the inflows are worth $2,777.78, $3,429.36, and $3,969.16, totalling $10,176.29. Now NPV is +$176.29, so 8% is slightly too low. The true rate sits between 8% and 10%.
- Narrow it down. At 9%, NPV is -$20.07, just barely negative. The rate that lands exactly on zero is 8.90%: the IRR. Check it: at 8.90%, the inflows are worth $2,754.82, $3,372.91, and $3,871.56, summing to $9,999.29, essentially your $10,000.
So this investment earns about 8.90% a year. Against a 10% hurdle it fails, since NPV at 10% is -$210.37. Against an 8% hurdle it passes. Same project, two verdicts, and only the bar changed. That's why the hurdle rate deserves real thought instead of a guess.
The round-trip check: discount every inflow at the IRR and the total should match the investment: $2,754.82 + $3,372.91 + $3,871.56 = $9,999.29.
Watch NPV cross zero as the rate rises
The table below shows NPV for the same flows at several discount rates. As the rate climbs, future dollars get discounted harder, so NPV slides down from +$2,000 at 0%, crossing zero right at the IRR of 8.90%.
| Discount rate | NPV | What it means |
|---|---|---|
| 0% | $2,000.00 | Undiscounted profit |
| 5% | $804.45 | Comfortably positive |
| 8% | $176.29 | Near the break-even rate |
| 8.90% | $0.00 | The IRR: NPV crosses zero |
| 10% | -$210.37 | Fails the hurdle |
| 15% | -$1,079.15 | Past the break-even rate |
| 20% | -$1,828.70 | Future money heavily discounted |
This crossing is the whole idea in one picture. Below 8.90%, NPV is positive and the project clears the bar; above it, NPV turns negative. An IRR is simply the exact rate where the deal stops making sense.
The multiple-IRR trap
IRR has one famous weakness, and it bites whenever cash flows change sign more than once. Our example changes sign once: money out, then money in. But suppose a project needs a big cleanup cost at the end, so the flows go out, in, then out again. With two sign changes, the math can produce two different rates that both make NPV zero.
Take a small case: put in $100, receive $230 after a year, then pay $132 in year two. Both 10% and 20% make NPV exactly zero, so which one is the return? Neither answer is wrong on its own, and that's the problem: no single rate exists to compare against your hurdle. When this calculator spots that pattern it warns you, and the right move is to judge the project by its NPV at your hurdle rate instead. NPV never has this ambiguity: one rate in, one dollar figure out. There's also a quieter weakness: IRR acts as if every dollar received gets reinvested at the IRR itself, which flatters high IRRs.
Common mistakes
- Comparing IRRs across projects of different sizes. A 30% IRR on a $1,000 project makes $300. A 12% IRR on a $1,000,000 project makes far more money. IRR is a rate, not a pile of cash, so check NPV too before picking a winner.
- Using a hurdle rate you haven't thought about. A hurdle pulled from thin air makes the verdict meaningless. Tie it to something real: your borrowing cost, the return of your next best option, or your company's required return.
- Trusting IRR when cash flows flip sign twice. If money goes out, comes in, and goes out again, multiple IRRs may exist. Don't pick the flattering one. Use NPV at your hurdle rate and let that decide.
Practical tips
Run the numbers at a few hurdle rates, not just one: a project that only passes at 6% is shakier than one that still passes at 12%. If you're choosing between projects, rank them by NPV at your hurdle first and use IRR as a second opinion. And always sanity check the inputs: a cash flow in the wrong year can swing the IRR by points.
Frequently asked questions
What is a good IRR for a small investment project?
It depends on your hurdle rate, not on any universal number. A project earning 9% looks fine if your alternative pays 5%, and poor if it pays 12%. Check NPV in dollars before deciding.
Why is my IRR negative, and what does that mean?
A negative IRR means the inflows never repay the investment, even before discounting. In plain terms the project loses money.
Can an investment have more than one IRR?
Yes, when cash flows change sign more than once, for example money out, then in, then out again for a cleanup cost. Our $100, $230, then $132 example has two IRRs, 10% and 20%, both making NPV zero. Judge such a project by NPV at your hurdle rate instead.
How is IRR different from ROI?
ROI divides total profit by total cost and ignores when the money arrives. IRR accounts for timing, so a profit paid back next year scores far better than the same profit in ten years.
Should I use IRR or NPV to pick between two projects?
Use NPV at your hurdle rate for the final call, since it measures dollars gained, and use IRR as supporting evidence. IRR can mislead when projects differ in size or timing.
Related calculators: NPV Calculator, ROI Calculator, and Finance Calculator.
Want more plain-English guides like this one? Browse the full set on the CalcMega Blog, where each calculator gets its own worked example.
The real lesson of IRR is humbler than the formula looks: one percentage can hide the size of the bet, the years your money is locked away, and whether the cash flows flip sign halfway through. Run the rate, read the NPV beside it, and ask what your money could have done instead.
Treat this as an explanation of the arithmetic, not as advice about where to put your money. Returns depend on cash flows arriving as projected, so check your own numbers carefully before committing money to any project.
Further reading: the US Securities and Exchange Commission's investor education pages explain return, risk, and how to check an investment pitch before you trust it, at investor.gov.