When the factor you need falls between two columns of a present value (PV) or annuity table, you can estimate the interest rate with linear interpolation:
r = r₁ + (F₁ − F) / (F₁ − F₂) × (r₂ − r₁)
Here F is the factor you calculated from the problem, and F₁ and F₂ are the table factors at the rates r₁ and r₂ either side of it. With a 1 percentage point gap between columns, the answer is usually within a few hundredths of a percent of the exact rate.
You can check every example on this page with our linear interpolation calculator.
Why the rate sits between two columns
PV and annuity tables list discount factors for whole-number rates (1%, 2%, 3% and so on) and whole-number periods. Real problems rarely land on a whole rate. A lender offers you $4,000 today against five yearly payments of $1,000, and you want to know the interest rate built into that deal. The answer is somewhere between two columns, and interpolation gives you a fast, close estimate without trial and error on a financial calculator.
Two factors come up most often:
- PV factor (single sum): 1 / (1 + r)ⁿ, the value today of 1 received after n periods.
- PV of an ordinary annuity factor (often written PVIFA): (1 − (1 + r)⁻ⁿ) / r, the value today of 1 received at the end of each of n periods.
Both factors fall as the rate rises. That is why the formula above uses F₁ − F on top: the bigger rate has the smaller factor.
Step-by-step method
- Work out the factor the problem implies. For an annuity, divide the present value by the payment. For a single sum, divide the present value by the future value.
- Find the row for the number of periods in the table and look along it for the two factors either side of yours.
- Note the two rates and two factors. The rate with the larger factor is r₁.
- Apply the formula. The fraction (F₁ − F) / (F₁ − F₂) tells you how far between the columns you are, from 0 to 1.
- Sense-check the answer. It must sit between r₁ and r₂, and closer to the column whose factor is closer to yours.
Worked example 1: the interest rate on a loan (annuity table)
A lender gives you $4,000 today. You repay $1,000 at the end of each year for 5 years. What annual rate are you paying?
Step 1: the factor. PV / payment = 4,000 / 1,000 = 4.000. You need the rate at which the 5-year annuity factor equals 4.000.
Step 2: the table row. Here is the 5-period row of a standard annuity table, rounded to 3 decimals as exam tables are:
| Rate | 6% | 7% | 8% | 9% |
|---|---|---|---|---|
| PV of annuity factor, n = 5 | 4.212 | 4.100 | 3.993 | 3.890 |
4.000 sits between 4.100 (7%) and 3.993 (8%).
Step 3: plug in.
- r₁ = 7%, F₁ = 4.100
- r₂ = 8%, F₂ = 3.993
- F = 4.000
Step 4: the formula.
- F₁ − F = 4.100 − 4.000 = 0.100
- F₁ − F₂ = 4.100 − 3.993 = 0.107
- Fraction = 0.100 / 0.107 = 0.9346
- r = 7% + 0.9346 × 1% = 7.93%
Step 5: sense-check. 4.000 is much closer to 3.993 than to 4.100, so the rate should be close to 8%. It is.
How accurate is it? Solving (1 − (1 + r)⁻⁵) / r = 4 exactly gives 7.9308%. The interpolated 7.9346% is off by less than half a basis point (0.004 percentage points). For exam and planning work that is as good as exact.
What happens with a wider gap
Suppose your table only had 6% and 9% columns. Using F₁ = 4.212 and F₂ = 3.890:
- Fraction = (4.212 − 4.000) / (4.212 − 3.890) = 0.212 / 0.322
- r = 6% + 0.212 / 0.322 × 3% = 7.98%
That is about 0.04 points too high. The annuity factor curves as the rate changes (it is convex), so a straight line between distant columns overshoots. Always use the two columns closest to your factor.
Worked example 2: the growth rate of an investment (PV table)
You invest $6,500 today and receive $10,000 in 6 years. What annual return does that represent?
Step 1: the factor. PV / FV = 6,500 / 10,000 = 0.650.
Step 2: the table row. The 6-period row of a PV table:
| Rate | 6% | 7% | 8% | 9% |
|---|---|---|---|---|
| PV factor, n = 6 | 0.705 | 0.666 | 0.630 | 0.596 |
0.650 sits between 0.666 (7%) and 0.630 (8%).
Step 3 and 4: the formula.
- F₁ − F = 0.666 − 0.650 = 0.016
- F₁ − F₂ = 0.666 − 0.630 = 0.036
- r = 7% + (0.016 / 0.036) × 1% = 7% + 0.4444% = 7.44%
Check: for a single sum you can solve exactly with r = (FV / PV)^(1/n) − 1 = (10,000 / 6,500)^(1/6) − 1 = 7.4437%. The interpolated answer, 7.4444%, matches to three decimals.
In practice, for a single sum you can just use that exact formula. Interpolation earns its keep with annuities, where there is no closed-form solution for the rate.
Check it with the calculator
Our interpolation calculator finds a missing value on a straight line through two points. To reproduce example 1, treat the factor as x and the rate as y:
| Field | Value |
|---|---|
| X1 | 4.100 |
| Y1 | 7 |
| X2 | 3.993 |
| Y2 | 8 |
| X3 | 4.000 |
| Y3 | leave empty |
Press Calculate and Y3 shows 7.93, the rate in percent. The calculator rounds to 2 decimals, which is the precision you normally quote a rate to anyway.
Common mistakes
- Putting the larger rate first by habit. It still works if you are consistent, but mixing an r₁ from one column with an F₁ from the other gives a rate outside the two columns. The sense-check in step 5 catches this.
- Using the wrong table. Level payments over several periods need the annuity table. One payment at the end needs the PV table. An annuity factor of 4.000 in a PV table makes no sense, since PV factors are always below 1 for positive rates.
- Annuity due vs ordinary annuity. Standard tables assume payments at the end of each period. If payments are at the start, the factor is the ordinary factor × (1 + r), so the table look-up changes. For payments at the start you can use the (n − 1) row plus 1.
- Interpolating across a wide gap. As example 1 showed, a 3-point gap adds error. Use adjacent columns.
- Mixing period and annual rates. With monthly payments, the table rate is a monthly rate. Multiply by 12 for the nominal annual rate, or compound it for the effective rate.
When to skip the table
Interpolation from tables is the expected method in many accounting and finance exams, and it is a good mental check. Outside an exam, the RATE function in Excel or Google Sheets, or a financial calculator, solves the equation directly. For example 1, =RATE(5,-1000,4000) returns 7.93%. For more ways to interpolate in a spreadsheet, see linear interpolation in Excel.
The same idea finds the internal rate of return of a project from two NPVs. That is covered step by step in IRR by interpolation. For rates between bond maturities, see yield curve interpolation.
FAQ
Can I interpolate a PV factor instead of a rate? Yes. If you know the rate (say 7.5%) and need the factor, interpolate between the 7% and 8% factors in the same way. The error is small for a 1-point gap, but computing 1 / (1.075)ⁿ directly is exact and just as quick on a calculator.
Why is the interpolated rate slightly too high? The factor curve bends (it is convex in the rate), so the straight line between two table points lies above the curve. The rate where the line hits your factor is therefore a little higher than the true rate. With adjacent columns the overshoot is usually under 0.01 percentage points.
Does this work for future value tables? Yes. The FV factor rises with the rate, so the larger factor goes with the larger rate. The fraction becomes (F − F₁) / (F₂ − F₁). The calculator handles either direction, because it only needs the two points.
How many decimals should I keep? Keep the table factors as printed (usually 3 decimals) and give the final rate to 2 decimals. More digits suggest a precision the table does not have.