IRR Calculator

IRR Calculator: Find the Internal Rate of Return of Any Investment

Calculate the internal rate of return of any investment with uneven cash flows using this IRR calculator. Just enter your initial investment, including as many yearly cash flows as you want and the IRR calculator calculates the exact discount rate at which your business breaks even. It also displays the NPV at that rate (which should come out at or near zero) and also a cash flow chart so you can see exactly how the figures operate, not just the final percentage.

[Calculator widget] Inputs: initial investment (negative cash flow), unlimited additional period cash flows (add/remove rows)  Outputs: IRR % NPV at calculated IRR Cash-flow chart Results to 2 decimal places

IRR Meaning: What Internal Rate of Return Actually Tells You

The internal rate of return (IRR) is the discount rate at which the net present value (NPV) of a project is zero. In other words, it is the annual return rate which will break even an investment, considering the time value of money.

That’s important for this reason. A dollar today is more valuable than a dollar tomorrow. You can invest it and accumulate interest on it in the meantime. NPV discounts future cash flows to present value at a selected rate. The IRR flips the question. Instead of selecting a rate and determining whether the project is profitable, it asks what rate would make the NPV of the project absolutely zero.

The higher the IRR the more attractive the investment is, by which the project may absorb more cost of capital and still break even. If your company’s cost of capital, sometimes termed the hurdle rate, is 10%, and a project has an IRR of 15%, that project clears the bar with some room to spare. If the IRR is 7%, then this project does not create sufficient return to justify the cost of the money financing the project.

The IRR Equation (And Why It Can’t Be Solved Directly)

The IRR equation looks like this:

0 = Σ [Cash Flow_t ÷ (1 + IRR)^t] − Initial Investment, for t = 0 to n

So all you do is take all the cash flows that the project throws out, discount each of those cash flows back to today’s dollars using the IRR as the discount rate, sum up all those discounted cash flows and remove the initial investment. The IRR calculator is the rate that makes that entire equation equal zero.

This is where a lot of people get hung up. Unlike a simple percentage calculation there is no algebra you can use to answer from an IRR calculator directly when a project has more than 2 cash flows. If you only had one cash flow you could rearrange the equation and solve for the rate in one step. When you put in a second, third or fourth year of cash flows, the IRR seems to be raised to multiple distinct powers at once (squared, cubed, etc.) and there is no neat method to isolate it algebraically.

And this is why all irr calculator spreadsheets and financial tools solve for IRR by trial and error (called iteration, not a plug-in formula). You take a rate, see how close the NPV goes to zero, and modify and repeat till the figures line up. It’s not that people are getting lax on the math. Real world cash flows are involved. It really cannot be solved any other way.

How to Calculate IRR Step by Step (Explained)

Here’s the iterative method in four steps that you can do with an IRR calculator, a spreadsheet or by hand:

Step 1: List all cash flows, including the negative initial investment. 

The first investment you make is always going to be a negative number, because it’s money that is going out of your pocket. Later all cash flows that the project makes are positive.

Step 2: Guess a discount rate and calculate NPV at that rate. 

Pick a starting rate, often somewhere in the range you’d expect the answer to fall, and calculate the NPV using that rate. 

Step 3: Check whether NPV is positive or negative, and adjust your guess. 

If NPV comes out positive, your guessed rate is too low, so try a higher rate next. If NPV comes out negative, your guessed rate is too high, so try a lower one. The IRR sits somewhere between a rate that gives a positive NPV and a rate that gives a negative NPV. 

Step 4: Use linear interpolation to estimate the IRR precisely. 

Once you have one rate with a positive NPV and one with a negative NPV, you can estimate the exact IRR between them using this formula: 

IRR ≈ Rate₁ + [NPV₁ ÷ (NPV₁ − NPV₂)] × (Rate₂ − Rate₁)

This gives you a close estimate in one step, rather than testing dozens of rates one by one. It won’t be perfectly exact, since the true relationship between rate and NPV curves slightly rather than moving in a straight line, but it usually lands within a fraction of a percentage point of the real answer. The worked example below shows exactly how close.

Full Worked Example: IRR Calculation Table

Let’s run through a whole example with real numbers. Say a project takes an initial expenditure of $50,000 and returns the following cash flows over the next four years: 

• Year 1: $15,000 
• Year 2: $18,000 
• Year 3: $20,000 
• Year 4: $22,000 

IRR Calculation Table (Testing 12% and 18%)

First, test a 12% discount rate:

Now test an 18% discount rate:

The NPV at 12% is positive. $5,959.77. That means the real IRR is more than 12%. We can guess that the real IRR is less than 18% since the NPV is -$840.84 at 18%. Now find the middle ground between the two:  

IRR = 12% + [5,959.77 / (5,959.77 – (-840.84))] × 18% – 12  IRR = 12% + (5959.77/6800.61) x 6% IRR = 12% + 0.8763 x 6% IRR = 12% + 5.26% = 17.26%

That is the estimated number that was interpolated. The real IRR, which would be found by an exact solution (like a calculator or Excel would do with many more iterations), is 17.19%. This means that the interpolation is within. 07 percentage points of the real answer, which is close enough for almost any choice. This is a real example that doesn’t come from anywhere else, so you can believe every number in this table.

IRR vs NPV vs ROI: What’s the Difference?

These three terms often get used interchangeably, but they answer different questions and can even point to different conclusions.

NPV tells you a number of dollars. This is the best way of comparing differently sized projects and finding out which project actually delivers the most value. The IRR calculator provides a rate that is straightforward to compare to a goal return or cost of capital. However, it can be misleading when comparing two very different sized projects. A small project with a 40% IRR could generate far less aggregate value than a large project with a 15% IRR since the large project produces far more money in absolute dollars. ROI is the simplest of the three, but it completely disregards the timing of cash flows. It is to say that a dollar gained next year is worth the same as a dollar obtained in ten years time. Usually this is not a reasonable comparison to make.

NPV and IRR are both good metrics to use, but if you’re trying to compare different projects, it’s best to use them together rather than separately.

Limitations of IRR You Should Know

IRR is a handy figure but it has a couple serious restrictions that don’t get much attention on most calculator pages.

The reinvestment rate assumption. 

The IRR assumption is all cash flows from the project are reinvested at the IRR rate. It assumes you can reinvest the money at 25% a year for a 25% IRR project which is hardly ever possible. This may lead IRR to overestimate the attractiveness of a project.

Multiple IRRs are possible. 

If a project has cash flows that go from positive to negative more than once (say a big cost in the middle of the project life) then the math can give more than one answer to satisfy the equation. In many circumstances IRR alone fails to provide a neat single solution, and reliance on it can be deceptive.

Modified IRR (MIRR) as a fix. 

MIRR addresses the reinvestment assumption by allowing you to assume a different and more realistic reinvestment rate, rather than assuming all cash flows are reinvested at the IRR itself. If the reinvestment assumption seems a reach for your particular project, it is worth calculating along with IRR.

Where IRR Is Used in Real Life

An IRR calculator shows up across a wide range of financial decisions, not just in textbooks.

Real estate. 

Investors use IRR to compare what they expect to earn on a property, including rental income and the price they want to get when they sell, to comparable opportunities or to what they need to earn.

Private equity and venture capital. 

IRR is a popular measure that funds reports for their investors. It measures the magnitude and timing of returns during the life of a fund.

Corporate capital budgeting. 

Companies use IRR to determine which projects to fund when they have more projects than they can afford. It is calculated by comparing each project’s IRR to the cost of capital for the company.

Business loans vs investment options. 

Say you are a small business owner trying to decide whether to take out a loan to expand your business or to invest that same capital elsewhere. IRR allows you to evaluate these two roads on equal footing.

Frequently Asked Questions

Q1. How do you calculate IRR without a financial calculator?

Try the trial and error method: Guess the discount rate, compute the NPV, and adjust the rate up or down depending on the sign of the NPV. Then linearly interpolate between two guesses to get a close estimate of the IRR.

Q2. What is a good IRR for an investment?

It depends upon the risk level of the project and your cost of capital. For a low-risk project (e.g., steady real estate), IRRs of 8% to 12% may be deemed good. For a high-risk project (e.g., an early-stage startup) it might target IRRs of 20% or higher. This is context, not investment advice, since every situation has its own risk profile.

Q3. What is the difference between IRR and NPV?

NPV tells you how much value a project adds now, in $s. The IRR is the percentage rate of return at which the project breaks even. Usually they are in agreement about the superior project but sometimes they can give opposing directions when evaluating projects of very different sizes.

Q4. Can a project have more than one IRR?

Yes. This occurs when the cash flows of a project change sign (positive to negative, or vice versa) more than once throughout the life of the project. When that happens the IRR equation can have more than one correct answer and no single IRR statistic can give the whole story by itself.

Q5. How does Excel calculate IRR?

Excel’s IRR() function is based on the same iterative method outlined here, trying rates and narrowing down the solution automatically. By default Excel will guess 10% until you tell it otherwise. It may give you an error if the cash flows don’t allow a solution to converge, eg if all the cash flows are positive or all negative.

Q6. What does a negative IRR mean?

A negative IRR suggests that the investment loses money even if you consider it with a 0% discount rate. That is, the total cash returning never pays back the initial investment at all, no matter what the time value of money.

Conclusion

When you understand the process to find the internal rate of return, there is no guesswork. This IRR calculator handles the iteration instantly, but knowing how the trial-and-error and interpolation process works underneath means you can sanity-check any number a calculator or spreadsheet gives you and spot the cases, like multiple IRRs or an unrealistic reinvestment assumption, where the number alone doesn’t tell the whole story. 

This is an educational tool and not investment advice. IRR is one useful input among a few (along with NPV, ROI and your personal judgment about risk) when considering any genuine investment choice.