What it means
Annuity tables exist because the underlying discounting formula is fiddly to compute by hand. The table does the awkward part once, so the user only has to find the right cell and perform a single multiplication.
There are two common versions. A present value annuity table gives factors for what future payments are worth now, while a future value annuity table gives factors for what a run of deposits will accumulate to by the end.
The factors themselves are intuitive once you see them. A present value factor of 6.21 simply means that a payment stream is worth 6.21 times one payment, which is less than the raw count of payments because money arriving later is worth less today.
In practice, annuity tables are now mostly a teaching and sense-checking tool rather than a calculating one, since spreadsheets compute the same factors instantly. They remain useful in exams, in loan documentation and as a quick way to spot when a spreadsheet answer looks wrong by an order of magnitude.
Reading across a row also teaches something useful about interest rates. As the rate rises the factor falls, so a long payment stream loses value quickly when rates move, which is the same effect that makes long-dated bonds and long leases so sensitive to rate changes.
The main trap is period matching. A table row labelled "8" means eight periods, not eight years, so if payments are quarterly you need 32 periods and a quarterly rate, not eight periods and an annual rate.
In practice
Real-world examples.
Example
A credit analyst valuing a customer's instalment plan of $12,000 a year for five years pulls the 9% factor of 3.8897 from an annuity table and arrives at a present value of $46,676.40. The number confirms the spreadsheet model built by the junior analyst.
Example
A charity trustee assessing a legacy that will pay $40,000 a year for 12 years uses a present value annuity table at 4% to explain to the board, without a spreadsheet, that the gift is worth roughly $375,000 in today's money.
Example
A training manager teaching lease accounting hands trainees a printed annuity table so they can see how the discount factor shrinks as the rate rises, which makes the sensitivity of lease liabilities to interest rates far easier to grasp.
Formula
Calculation
The present value annuity factor behind the table is:
Factor = [1 - (1 + r)^-n] / r
Value = Payment x Factor
Suppose you want to value eight annual payments of $25,000, discounted at 6%.
Step 1: find the cell where the 6% column meets the 8-period row. (1 + 0.06)^-8 = 0.627412, so 1 - 0.627412 = 0.372588, and 0.372588 / 0.06 = 6.209794. The table would show this as 6.2098.
Step 2: multiply. $25,000 x 6.2098 = $155,244.85.
The eight-year stream is worth $155,244.85 today. As a sense check, neighbouring cells in the same 6% column read 5.5824 for seven periods and 6.8017 for nine periods, so the factor rising steadily by a little less each time is exactly the pattern you should expect. Note also that the factor of 6.2098 is comfortably below the eight raw payments, which is the discounting doing its work.Case study
Seen in the real world.
Meridian Foods, an illustrative and entirely fictional food distributor, discovered a modelling error during an internal review. A spreadsheet valuing a 10-year supply contract had been built with an annual discount rate applied to monthly payments, inflating the present value by a wide margin.
The reviewer spotted it in under a minute using a printed annuity table. She reasoned that 120 monthly payments discounted at any sensible rate should produce a factor well below 120, whereas the model implied a factor far above what any cell in the table could support.
The fix was straightforward: convert the annual rate to a monthly rate and use 120 periods. The fictional company kept the annuity table pinned to the finance team's wall afterwards, purely as a reality check on spreadsheet output.
Watch out
Common mistakes.
- Mixing an annual rate with non-annual periods, which produces a factor that is wrong by a very large margin rather than a small one.
- Using a present value table when the question asks for future value, or the reverse. The two sets of factors are not interchangeable.
- Applying an ordinary annuity table to payments made at the start of each period, which understates the value by one period of interest and quietly biases every lease and loan valuation built on it.
Questions
People also ask.
Why is the factor always smaller than the number of payments in a present value table?
Because each future payment is discounted, so the sum of the discounted payments is less than the sum of the raw payments.
Do annuity tables still matter now that spreadsheets exist?
Mainly as a sense check and a teaching aid. They make the shape of discounting visible in a way a single cell formula does not.
How do I adapt an annuity table for payments at the start of each period?
Take the ordinary factor and multiply it by one plus the periodic rate, which converts it to an annuity due factor.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%