IRR Calculator: Internal Rate of Return Calculator

Internal Rate of Return Calculator: What the Result Tells You

The internal rate of return, usually shortened to IRR, is the annual rate of growth an investment is expected to generate across its whole life. Technically, it is the discount rate at which the net present value of every cash inflow and outflow adds up to exactly zero. Think of it as the break-even rate of return: earn more than the IRR somewhere else and the project loses out, earn less and the project wins. Pair this with the compounding and your return calculator for a fuller picture before you make a decision.

Because IRR reflects both the size and the timing of each payment, it behaves like an annualized return that is tailored to an uneven stream of money. A deal that pays back early scores a higher figure than one that pays the same total later, which is why investors lean on IRR to compare opportunities that look similar on a spreadsheet but differ in when the money actually arrives. Many people describe it as the effective annual return of the deal, a handy way to compare it with a savings account or a bond.

How the Discount Rate Connects to IRR

This rate converts future dollars into today's dollars, which is the time value of money in action. Pick a high rate and distant payments shrink sharply; pick a low one and they barely change. IRR is simply the one rate that makes the present value of your inflows equal to your initial investment. Any rate below it leaves a positive value, and any rate above it pushes the result negative, which is exactly the crossing point you will see in the chart further down this page.

IRR Formula and How to Calculate IRR Step by Step

The IRR formula is the net present value equation with the answer fixed at zero. You solve for the rate, r, instead of for the dollar value: Try the free annual rate of return calculator to run your own numbers — everything is calculated in your browser and nothing you enter is stored or sent anywhere.

$$0 = \sum_{t=0}^{n} \frac{CF_t}{(1 + IRR)^{t}}$$

To calculate IRR by hand you work through four inputs and one search:

• CF₀ is the initial cost, entered as a negative number because the cash leaves your pocket.
• CF_t is the net cash flow in each later time period, positive for money received and negative for extra spending.
• t is the period number, counting from 0 for today.
• IRR is the unknown rate that the search below finds.

This approach is a form of discounted cash flow method, and it works best when you list annual cash flows for each year of the project's life. The more carefully you forecast each investment return, the more meaningful the final percentage becomes, so spend your effort on the inputs rather than the arithmetic.

Every row you add to the calculator becomes another term in the sum. Rows with zero cash flow still count, because an empty year still pushes later payments further away and lowers the result.

Why IRR Calculation Needs Iteration

Once a project runs past two periods, the equation becomes a polynomial that has no tidy algebraic answer. That is why every IRR calculation relies on an iterative process: guess a rate, test the result, adjust, and repeat until it rounds to zero. Numerical methods such as Newton-Raphson and bisection do this in a blink, and the same logic sits behind the IRR function in any spreadsheet and in most financial calculators. Doing it manually is possible but tedious, so let the tool handle the guessing and keep your attention on the inputs.

Worked Example: $62,500 Packaging Machine in the IRR Calculator

A small food producer is weighing the purchase of a packaging machine. The equipment costs $62,500 today and is expected to lift profit by the following net cash inflows over a five-year holding period, including a final-year payment that counts the machine's resale value.

Enter -$62,500 as the initial investment, add the five yearly amounts, and the result is an IRR of 15.43%. The last column proves it: discount each payment at 15.43% and the five inflows add up to the $62,500 you paid, so the total is zero. The same inputs return an NPV of $5,885.52 at 12% and -$3,901.63 at 18%, which brackets the IRR neatly.

Notice how the shape of the cash flows matters. Year 3 contributes the largest single payment, but because it arrives later, each dollar is discounted more heavily than a dollar from year 1. If the same $97,400 of total inflows had instead arrived entirely in year 5, the IRR would fall to about 9.3%, even though the total gain stays the same. That timing sensitivity is why a business should read IRR alongside the total dollars an investment returns, and why two projects with equal gains can rank very differently.

If the producer's required rate of return is 12%, the machine clears the bar by about 3.4 percentage points. If financing pushes that requirement to 18%, the same machine fails it.

How to Read a Good IRR

There is no universal good IRR. The figure only has meaning next to something else: your cost of capital, the opportunity cost of the money, or the IRR of a competing deal. Higher is better when risk and effort are equal, yet investors regularly pass on a slightly higher IRR if it comes with more risk or more work than a calmer alternative.

Your risk tolerance matters here too. A cautious investor may want a wide cushion between the IRR and the hurdle, while one comfortable with uncertainty may accept a thinner margin on a promising investment. Anyone choosing between two projects can apply the same logic: the one with the larger gap above the hurdle, adjusted for how reliable its forecast is, usually deserves the first dollar of funding.

Decision Rule: Compare IRR With Your Hurdle Rate

The simplest decision rule is to set a hurdle rate, the lowest return you will accept, and ask whether the IRR beats it. Many companies use their required rate of return for this, which blends borrowing cost and the return shareholders expect. In the packaging example, 15.43% against a 12% hurdle means accept; against 18% it means reject.

Limitations of IRR You Should Know

IRR is a ratio, so it ignores scale: a 40% return on a tiny project can add less money than a 15% return on a large one, and NPV shows that difference in dollars. It also assumes each payment is reinvested at the IRR itself, which is often optimistic. And when cash flows change sign more than once, such as an expansion that needs fresh spending midway, the equation can produce multiple IRRs, none of them trustworthy. In those cases, lean on NPV or on the modified version below.

IRR vs MIRR and Other Return Measures

Two companion measures fix the weak spots above, and a good internal rate of return calculator should let you compare all three side by side.

Modified Internal Rate of Return (MIRR)

The modified internal rate of return, or MIRR, replaces the unrealistic reinvestment assumption with two rates you choose. The reinvestment rate is what your positive cash flows can realistically earn, and the finance rate is what negative cash flows cost you to borrow. With a 10% reinvestment rate and a 6% finance rate, the packaging machine's MIRR is 13.23%, a more cautious reading than the 15.43% IRR. MIRR always yields a single answer, which makes it the safer pick for irregular patterns.

Return on Investment (ROI) Compared With IRR

Return on investment divides total profit by the amount invested. Here the machine yields $97,400 of gain on $62,500, an ROI of 55.84%. That sounds large, but ROI says nothing about how long it took, while IRR spreads the gain over time. A similar yardstick, the compound annual growth rate (CAGR), also ignores the middle of the journey because it only looks at start and end values; IRR is the one that respects every payment in between.

Reading the IRR of a Rental Duplex Purchase

Marisol Okafor has an offer to review on a duplex listed at $181,900. With closing costs and a few repairs, she expects to put in $187,650. She will fund it with a home equity line at 8.25%, so that figure is the number her result has to beat.

Her rent roll, after taxes, insurance and upkeep, works out to net cash flows of $11,380, $12,140, $12,910 and $13,720 for years 1 through 4. In year 5 she plans to sell, so she keys in $13,950 of rent plus $196,400 of net sale proceeds, a single entry of $210,350. She enters -$187,650 as the initial investment, fills in the five rows and clicks Calculate.

The internal rate of return comes back at 7.58%. Total inflows of $260,500 look healthy next to the $187,650 she pays, but spread over five years they earn less than her 8.25% borrowing rate. Measured against 10%, a rough long-run nominal gain for U.S. large-cap stocks, the duplex is $17,590.27 short in today's dollars, so it trails what she could earn without a single tenant call.

So she changes one input instead of walking away. Lowering the purchase to $173,650 by asking for $14,000 off the list price, and leaving every payment alone, lifts the IRR to 9.48%, comfortably above the 8.25% line. Her counteroffer goes out at $173,650, and the walkthrough shows exactly why that number, and not the asking price, is her ceiling.

IRR for Real Estate, Private Equity and Capital Budgeting

Few metrics travel as widely. In capital budgeting, finance teams rank competing projects by IRR before approving funds, and manufacturing firms use it for equipment like the machine above. In real estate, investors fold in rental income, the sale price and the holding period. Lenders and brokers, including those behind any CRE IRR calculator, rely on it to size commercial real estate deals. Typical uses include:

1. Investment decision screening, where IRR must beat the cost of capital before a project moves forward.
2. Project evaluation across several projects competing for the same budget.
3. Lease analysis and loan analysis, which reveal the true cost of financing.
4. Private equity and venture capital reporting, where funds are judged by the IRR on their holdings.
5. Ranking investment opportunities for real estate investors weighing a property purchase.

When you model a property, remember that closing costs and other acquisition costs belong in the initial outlay, while selling costs come out of the final cash inflow. Leaving them out inflates the profitability you see.

Tips for Getting Accurate IRR Results

• Use consistent spacing. If your time period is a year, every row must be a year, and a quarter-by-quarter stream needs a different setup.
• Keep signs honest: cash outflows are negative, cash inflows positive.
• Compare the result with an NPV profile, which plots NPV against many discount rates; the point where the curve crosses zero is the IRR.
• Stress-test your forecast. Lower the final-year payment and rerun it to see how fast the IRR falls.
• Remember that a high IRR built on optimistic projections only overstates profitability.

Whether you are an investor reviewing a new investment or an owner planning a purchase, and whether your fixed cash flow repeats each year or your irregular cash flow bounces around, these habits keep the output honest and every investment comparison fair.