Annuity Tables & Technology
Before smartphones, financial professionals carried pocket annuity tables to every meeting. These tables compressed hours of calculation into seconds of lookup. Today you'll master table-based calculations, learn interpolation for values between entries, and discover how technology has transformed computation without changing the underlying mathematics.
Practise this lesson
Three printable worksheets that build from foundations to mastery — or build your own from any module’s questions.
An annuity table shows that the PV factor for $r = 5\%$, $n = 10$ is $7.722$. Question 1: What does this factor mean in plain English? Question 2: If you need the factor for $r = 5.5\%$, $n = 10$, but the table only has 5% and 6%, how might you estimate it?
An annuity factor table pre-computes the formula $\dfrac{1-(1+r)^{-n}}{r}$ (PV) or $\dfrac{(1+r)^n-1}{r}$ (FV) for a grid of common $r$ and $n$ values. Instead of keying in the whole formula, you look up the factor and multiply by your payment $a$.
The factor is the PV (or FV) of $1 per period for $n$ periods at rate $r$. A factor of 7.722 means: if you receive $\$1$ at the end of each period for 10 periods at 5%, the present value is $\$7.722$. Scale up to any payment by multiplying.
Key facts
- How to read annuity factor tables
- The structure of PV and FV factor tables
- How to use linear interpolation
Concepts
- Why tables are pre-computed versions of the formula
- When interpolation is necessary and its limitations
- How technology replaces tables without changing the maths
Skills
- Look up factors and calculate PV/FV from tables
- Interpolate between table values
- Use financial calculator/TVM solver functions
- Write and interpret spreadsheet annuity formulas
Reading an annuity table is a four-step process:
- Locate the row for your number of periods $n$
- Locate the column for your interest rate $r$
- Read the factor at the intersection
- Multiply by your regular payment $a$
Example: PV factor for $r = 5\%$, $n = 10$ is $7.722$. For $a = \$300$: $PV = 300 \times 7.722 = \$2{,}316.60$.
PV factor = $\frac{1-(1+r)^{-n}}{r}$ — pre-computed for common $r$ and $n$; FV factor = $\frac{(1+r)^n-1}{r}$ — pre-computed for common $r$ and $n$
Pause — copy the PV factor $\dfrac{1-(1+r)^{-n}}{r}$ and FV factor $\dfrac{(1+r)^n-1}{r}$ — pre-computed for common $r$ and $n$; look up by finding the row ($n$) and column ($r$) intersection — into your book.
Quick check: A table shows the PV factor for $r = 6\%$, $n = 15$ is $9.712$. What is the PV of an annuity paying $\$1{,}500$ per period?
Linear interpolation · estimating between table values
We just saw that a factor table pre-computes $\dfrac{1-(1+r)^{-n}}{r}$ at tabulated rates and periods. That raises a question: what do you do when your required rate (say 5.5%) falls between two table columns (5% and 6%) — can you estimate without computing the full formula? This card answers it → linear interpolation: $y = y_1 + \dfrac{x-x_1}{x_2-x_1}(y_2-y_1)$ gives a close estimate, accurate to within $\sim 0.04\%$ for a 1% rate gap.
When your exact $r$ or $n$ is not in the table, linear interpolation gives a close estimate by assuming the factor changes at a constant rate between the two nearest table values.
Example: Estimate the PV factor for $r = 5.5\%$, $n = 10$.
From the table: at $r = 5\%$, factor $= 7.722$; at $r = 6\%$, factor $= 7.360$.
Exact formula value: $\frac{1-(1.055)^{-10}}{0.055} = 7.538$. Interpolation error: $0.003$ (only $0.04\%$).
Interpolation formula: $y = y_1 + \frac{x - x_1}{x_2 - x_1} \times (y_2 - y_1)$; Works because factor changes are approximately linear over small rate gaps (≤1%)
Pause — copy the interpolation formula $y = y_1 + \dfrac{x-x_1}{x_2-x_1}(y_2-y_1)$ — accurate for rate gaps $\leq 1\%$; error grows with larger gaps, so use the full formula when the gap exceeds 1–2% — into your book.
Try this now: Estimate the PV factor for $r = 4.5\%$, $n = 20$ using the table values: at 4%, factor $= 13.590$; at 5%, factor $= 12.462$. Show full working.
Show answer
$y = 13.590 + \frac{(4.5-4)}{(5-4)} \times (12.462 - 13.590) = 13.590 + 0.5 \times (-1.128) = 13.590 - 0.564 = \mathbf{13.026}$. Exact: $13.008$. Error: $0.14\%$.
Technology · calculators and spreadsheets
We just saw that linear interpolation estimates between table values, with accuracy limited by the assumption of linearity over the gap. That raises a question: modern calculators and spreadsheets can compute any annuity factor exactly in seconds — so what are the specific functions and when, in the HSC, is using technology acceptable versus requiring full algebraic working? This card answers it → Excel =PV(rate, nper, pmt) and =FV() give exact answers; TVM solvers on calculators do the same — but the HSC requires you to show the formula with substituted values.
Modern tools have replaced printed tables — but they use the same mathematics you've been learning:
In Excel, =PV(0.05, 10, -100) gives the PV of $100/period for 10 periods at 5%. The negative sign on pmt follows the cash-flow convention (money paid out).
Excel PV: =PV(rate, nper, pmt) — use negative pmt for payments you make; Excel FV: =FV(rate, nper, pmt) — same sign convention
Pause — copy the Excel functions: =PV(rate, nper, pmt) and =FV(rate, nper, pmt) — use negative pmt for outgoing payments — noting these are for checking only; the HSC requires full algebraic working — into your book.
Did you get this? True or false: writing =PV(0.06, 20, -500) in Excel and reporting the answer earns full marks in an HSC question.
Common errors · the 3 traps that cost marks
Fill in the blank: The FV factor for $r = 7.5\%$, $n = 10$ interpolated between 7% (factor $= 13.816$) and 8% (factor $= 14.487$) is (to 3 d.p.).
Quick-fire practice · 4 table problems
Using the table above, find the PV of $\$1{,}500$/period for 15 periods at 6% p.a.
Interpolate the PV factor for $r = 3.5\%$, $n = 20$ using: 3% → 14.877 and 4% → 13.590.
Write the Excel formula to find the FV of $\$500$/month for 24 months at 6% p.a. compounded monthly.
Explain in one sentence why the HSC requires formula working even though a TVM solver gives the same answer.
Odd one out: Three of these statements are correct. Which one is wrong?
Earlier: the factor $7.722$ means the present value of receiving $\$1$ per period for 10 periods at 5% is $\$7.722$. For $\$300$/period: $PV = 300 \times 7.722 = \$2{,}316.60$. For $r = 5.5\%$: interpolate between 5% ($7.722$) and 6% ($7.360$): $y = 7.722 + 0.5 \times (7.360 - 7.722) = 7.541$. Exact: $7.538$. Interpolation is remarkably accurate for small gaps.
Pick your answer, then rate your confidence — that tells the system what to drill next. Each retry pulls a fresh mix from the bank.
Q1. A table shows: PV factor at $r = 5\%$, $n = 8$ is $6.463$. (a) Find the PV of $\$600$/period for 8 periods at 5%. (b) Verify your answer using the formula $PV = a \times \frac{1-(1+r)^{-n}}{r}$. (c) In one sentence, explain why tables are useful even though formulas give the exact answer. (3 marks)
Q2. A table has PV factors: at $r = 5\%$, $n = 10$ → $7.722$; at $r = 6\%$, $n = 10$ → $7.360$. (a) Write down both known data points $(x_1, y_1)$ and $(x_2, y_2)$. (b) Use linear interpolation to estimate the factor for $r = 5.25\%$. (c) Find the PV of $\$400$/period for 10 periods at $r = 5.25\%$ using your interpolated factor. (3 marks)
Q3. A superannuation fund invests $\$500$/month for 20 years at 6% p.a. compounded monthly. (a) Write the Excel formula you would use to find the FV. (b) Calculate the FV using the annuity formula (show all working). (c) What does the negative sign in front of pmt in Excel's =FV function represent? (d) Explain why the HSC exam requires formula working even though technology can answer instantly. (4 marks)
📖 Comprehensive answers (click to reveal)
Drill 1: Factor $= 9.712$; $PV = 1{,}500 \times 9.712 = \$14{,}568$. 2: $y = 14.877 + 0.5 \times (13.590 - 14.877) = 14.877 - 0.644 = 14.234$. Exact: $(1-(1.035)^{-20})/0.035 = 14.212$. Error $\approx 0.15\%$. 3: =FV(0.005, 24, -500) (monthly rate $= 0.06/12 = 0.005$). 4: The HSC tests mathematical reasoning, not button operation — showing formula steps proves you understand why the answer is correct.
Q1 (3 marks): (a) $PV = 600 \times 6.463 = \$3{,}877.80$ [1]. (b) Formula: $600 \times [1-(1.05)^{-8}]/0.05 = 600 \times 6.4632 = \$3{,}877.92$ — matches to 2 d.p. [1]. (c) Tables compress hours of calculation into seconds and build intuition for how PV/FV change with $r$ and $n$ [1].
Q2 (3 marks): (a) $(x_1, y_1) = (5, 7.722)$; $(x_2, y_2) = (6, 7.360)$ [1]. (b) $y = 7.722 + \frac{5.25-5}{6-5} \times (7.360 - 7.722) = 7.722 + 0.25 \times (-0.362) = 7.722 - 0.091 = 7.631$ [1]. (c) $PV = 400 \times 7.631 = \$3{,}052.40$ [1].
Q3 (4 marks): (a) =FV(0.005, 240, -500) [1]. (b) $r = 0.005$, $n = 240$. $FV = 500 \times \frac{(1.005)^{240}-1}{0.005} = 500 \times 462.041 = \$231{,}020.30$ [1]. (c) Negative $pmt$ represents cash outflow — money leaving the investor's account each month [1]. (d) The HSC tests algebraic reasoning and mathematical understanding; showing $a$, $r$, $n$ substituted into the formula demonstrates comprehension, not just ability to operate software [1].
Five timed questions on table lookup, interpolation, and technology applications. Beat the boss to bank a tier — gold (90% + speed), silver (75%), or bronze (50%). Replays welcome.
⚔ Enter the arenaClimb platforms using annuity tables, interpolation, and technology comparisons. Pool: lessons 1–10.
Mark lesson as complete
Tick when you've finished the practice and review.