Skip to content

Stockertim Dictionary · Finance

Linear interpolation

Also called interpolation (IRR), interpolating the IRR

In short

A way of estimating a project's internal rate of return from two trial discount rates by assuming net present value changes in a straight line between them.

  • Intermediate
  • Process
  • Checked

In detail

The internal rate of return is the discount rate at which a project's net present value is exactly zero. There is usually no formula to solve for it directly, so without a spreadsheet it is found by trial. Linear interpolation shortens the search: calculate net present value at one rate that gives a positive answer and another that gives a negative answer, then estimate where the line joining the two crosses zero.

The estimate is the lower rate plus the gap between the rates multiplied by the share of that gap needed to bring the positive net present value down to zero. It is quick, transparent and good enough for most decisions, which is why it is still taught and examined.

Because the true relationship between net present value and the discount rate is a curve, not a line, the interpolated answer is approximate. It is most accurate when the two trial rates are close together and on either side of zero. Spreadsheets find the rate by repeated trial to many decimal places, but the logic is the same.

Formula

IRR ≈ L + (NL / (NL − NH)) × (H − L)

L
the lower trial rate
H
the higher trial rate
NL
net present value at the lower rate (positive)
NH
net present value at the higher rate (negative)

Worked example

A project has a net present value of 12,000 at 10% and of −8,000 at 15%.

  1. Share of the gap: 12,000 / (12,000 + 8,000) = 0.6
  2. Rate gap: 15% − 10% = 5%
  3. Estimated IRR: 10% + 0.6 × 5% = 13%

The internal rate of return is about 13%.

In practice

Analysts use interpolation for a quick check on a spreadsheet's internal rate of return, or in meetings and exams where only discount tables are to hand.

Watch out

  • Trial rates far apart give a rougher estimate.
  • Projects with cash flows that change sign more than once can have more than one internal rate of return.

Learn it properly

Official sources

Facts last checked on 3 November 2026.

Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.

English