IRR by Interpolation: Formula and Worked Example

The internal rate of return (IRR) is the discount rate at which a project’s net present value (NPV) is zero. To estimate it by hand, work out the NPV at two discount rates, one giving a positive NPV and one giving a negative NPV, then interpolate between them:

IRR ≈ a + NPVₐ / (NPVₐ − NPV_b) × (b − a)

where a is the lower rate with a positive NPV (NPVₐ) and b is the higher rate with a negative NPV (NPV_b). This is the formula used in ACCA, CIMA and most corporate finance courses. You can check the final step with our linear interpolation calculator.

Why interpolation works for IRR

As the discount rate rises, NPV falls. Plot NPV against the rate and you get a downward curve that crosses zero at the IRR. If you know two points on that curve, one above zero and one below, a straight line between them crosses zero close to where the curve does. The formula above is just that straight line solved for NPV = 0.

Note the minus sign in the denominator. NPV_b is negative, so NPVₐ − NPV_b is really NPVₐ plus the size of NPV_b. Many students write NPVₐ + NPV_b by mistake and get a rate outside the two they used.

Worked example: a four-year project

A company is considering a machine that costs $50,000 today and is expected to bring in these cash flows:

Year 0 1 2 3 4
Cash flow ($) −50,000 15,000 18,000 20,000 12,000

Step 1: NPV at a first rate (10%)

Using 3-decimal discount factors from a PV table:

Year Cash flow Factor at 10% Present value
0 −50,000 1.000 −50,000
1 15,000 0.909 13,635
2 18,000 0.826 14,868
3 20,000 0.751 15,020
4 12,000 0.683 8,196
NPV 1,719

NPV is positive, so the IRR is above 10%.

Step 2: NPV at a second, higher rate (15%)

Year Cash flow Factor at 15% Present value
0 −50,000 1.000 −50,000
1 15,000 0.870 13,050
2 18,000 0.756 13,608
3 20,000 0.658 13,160
4 12,000 0.572 6,864
NPV −3,318

NPV is negative, so the IRR is between 10% and 15%.

Step 3: interpolate

  • a = 10%, NPVₐ = 1,719
  • b = 15%, NPV_b = −3,318
  • NPVₐ − NPV_b = 1,719 − (−3,318) = 5,037
  • IRR ≈ 10% + (1,719 / 5,037) × 5% = 10% + 1.706% = 11.71%

Step 4: interpret

If the company’s cost of capital is below 11.7%, the project earns more than it costs to fund and is acceptable on an IRR basis. If the cost of capital is above it, the project should be rejected.

How accurate is the estimate?

Solving for the exact rate where NPV = 0 (with a numerical solver) gives an IRR of 11.618%. Our estimate of 11.71% is about 0.09 percentage points too high.

The choice of the two rates matters. Here is the same project interpolated with different pairs, using exact (unrounded) discount factors:

Rates used NPV at lower rate NPV at higher rate Estimated IRR Error vs exact
10% and 12% 1,735 −396 11.628% +0.010 points
10% and 15% 1,735 −3,335 11.711% +0.093 points
5% and 20% 7,761 −7,639 12.560% +0.942 points

Two patterns stand out:

  1. The closer the two rates, the better the estimate. A 2-point gap is almost exact. A 15-point gap is nearly a full percentage point out.
  2. The estimate is too high, not too low. The NPV curve bends upward (it is convex), so the straight line between two points lies above the curve and reaches zero later. For a normal project, with one outflow followed by inflows, linear interpolation overstates the IRR. The wider the gap, the bigger the overstatement.

So if a first pair of rates gives an estimate, you can tighten it by recomputing NPV at rates either side of that estimate. Two rounds are usually enough to get within a few hundredths of a percent.

How to choose the two rates

  • Start with the cost of capital. You usually have to compute NPV at that rate anyway. If NPV is positive, try a higher rate for the second one. If it is negative, try a lower one.
  • Aim for NPVs of opposite sign. If both are positive or both negative, you are extrapolating, not interpolating. The formula still gives a number, but it is less reliable. See linear extrapolation for why.
  • Keep the gap modest. In exams, a 5-point gap is normal and accepted. Outside exams, narrow it.

Check it with the calculator

You can reproduce step 3 on our interpolation calculator by treating NPV as x and the rate as y, then asking for the rate where NPV is zero:

Field Value
X1 1719
Y1 10
X2 -3318
Y2 15
X3 0
Y3 leave empty

Y3 shows 11.71, the estimated IRR in percent.

Common mistakes

  • Adding the NPVs in the denominator. Write NPVₐ − NPV_b and let the negative sign do the work. The denominator is the total drop in NPV between the two rates.
  • Mixing up which NPV goes on top. The numerator is the NPV at the lower rate a, the one you add the fraction to.
  • Forgetting year 0. The initial outlay is not discounted (factor 1.000), but it must be in the NPV.
  • Rounding too early. Keep present values to the nearest unit and the IRR to 1 or 2 decimals.
  • Trusting IRR alone. Projects with cash flows that change sign more than once can have more than one IRR, and IRR can rank mutually exclusive projects differently from NPV. When the two disagree, NPV is the better guide to value.

When to use software

In Excel or Google Sheets, put the cash flows in a row and use =IRR(range). For this project it returns 11.62%. Use interpolation when the exam requires it, when you need a quick estimate from figures you already have, or to sanity-check a spreadsheet result.

For the same technique applied to a single loan or annuity, see finding an interest rate from PV and annuity tables. For the general method behind it, see linear interpolation and inverse interpolation, which is exactly what IRR estimation is: finding x when you know y.

FAQ

What is the IRR interpolation formula? IRR ≈ a + NPVₐ / (NPVₐ − NPV_b) × (b − a), where a and b are two discount rates and NPVₐ and NPV_b the NPVs at those rates, one positive and one negative.

Do the two NPVs have to be one positive and one negative? For interpolation, yes. With both on the same side of zero the formula extrapolates, which is less accurate and can mislead if the NPV curve bends a lot.

Why does my answer differ from Excel’s IRR? Excel solves for the exact rate. Interpolation draws a straight line between two points on a curve, so it is slightly high for normal projects. Rounded table factors add a little more difference.

What gap between rates should I use? In exams, the rates given or a 5-point gap. For a closer estimate, use rates 1 or 2 points apart around your first answer.

Soren Vance
Soren Vance

Soren Vance is the Director of Quantitative Analysis & Algorithms at Interpolation Calculator, where he leads the design and optimization of the company’s core interpolation engines and data processing frameworks.

With a master’s in Computational Mathematics and over 8 years of experience in analytical modeling and numerical computing, Soren oversees the development of high‑performance methods — from spline interpolation and polynomial regressions to multidimensional estimators for real‑world datasets.

Known for his clarity of thought, Soren builds systems that balance mathematical rigor with computational efficiency. He collaborates closely with product, engineering, and UX teams to ensure users get reliable, transparent, and fast results. Outside of work, he contributes to open‑source math libraries and teaches data science workshops at local universities.

Articles: 21

Interpolation Calculator is a mathematical method used to estimate an unknown value between known data points.

Privacy

Disclaimer

Terms

GDPR

Affiliate

Refund

Company

About Us

Contact Us