Annuity Table

August 24, 2024 Personal Finance

An annuity table lists present- or future-value factors by periodic rate and payment count for equal recurring cash flows.

On this page

An annuity table is a grid of precomputed factors used to find the present value or future value of equal payments made at regular intervals. The table’s rows usually show the number of periods, its columns show periodic rates, and each cell contains a factor to multiply by the payment amount.

An annuity table is a calculation aid, not an account statement, return forecast, or schedule of actual payments.

Key Takeaways

Identify the table type before looking up a factor.
Use the periodic rate, not an unmatched annual quote.
The row should represent the number of payments or periods required by that table’s convention.
Beginning-of-period payments require an annuity-due factor or a separate timing adjustment.
Table rounding can create small differences from calculators and spreadsheets.

The Four Common Annuity Tables

Table	What it answers	Standard payment timing
Present value of an ordinary annuity	What are future level payments worth today?	End of period
Future value of an ordinary annuity	What will repeated deposits accumulate to?	End of period
Present value of an annuity due	What are advance level payments worth today?	Beginning of period
Future value of an annuity due	What will advance deposits accumulate to?	Beginning of period

Do not confuse these with present- or future-value-of-$1 tables, which value a single lump sum rather than a series of payments.

How an Annuity Table Is Organized

A simplified ordinary-annuity table at a 5% periodic rate looks like this:

Number of periods	Present value factor	Future value factor
1	0.952381	1.000000
3	2.723248	3.152500
5	4.329477	5.525631
10	7.721735	12.577893

For five end-of-period payments, move across row 5 to the 5% column in the required table. The present-value factor is 4.329477; the future-value factor is 5.525631.

Each factor is derived from a formula:

PVIFA(r,n) = \frac{1-(1+r)^{-n}}{r}

FVIFA(r,n) = \frac{(1+r)^n-1}{r}

Where (r) is the periodic rate and (n) is the number of payments.

Worked Example: Reading the Table

Assume five payments of $2,500 occur at the end of five consecutive years and the annual discount rate is 5%.

Present value

Use the present value of an ordinary annuity table:

PV = \$2{,}500 \times 4.329477 \approx \$10{,}823.69

Future value

Use the future value of an ordinary annuity table:

FV = \$2{,}500 \times 5.525631 \approx \$13{,}814.08

The two answers differ because they are measured on different dates. Present value is measured one period before the first payment; future value is measured immediately after the fifth payment.

If the payments occur at the beginning of each year, multiply each ordinary factor by 1.05 or use a dedicated annuity-due table:

Value	Ordinary-annuity result	Annuity-due result
Present value	`$10,823.69`	`$11,364.88`
Future value	`$13,814.08`	`$14,504.78`

The example assumes a constant rate and equal payments. It excludes fees, taxes, inflation, and other cash flows.

Step-by-Step Table Workflow

Define the value date. Decide whether the answer belongs today or at a future date.
Classify payment timing. Determine whether payments occur at the beginning or end of each period.
Confirm equal payments. A basic annuity table does not directly handle changing payments.
Convert the rate. Match the interest-rate period to the payment interval.
Count payments. Use the actual schedule rather than assuming the number from a calendar label.
Select the cell. Find the intersection of the period row and rate column.
Multiply by payment. Retain the table’s precision until the final result.
Check independently. Recalculate with the formula or a cash-flow schedule.

Table vs. Calculator vs. Spreadsheet

Method	Strength	Limitation
Printed table	Fast lookup and easy conceptual check	Limited rates, periods, and decimal precision
Financial calculator	Handles non-tabulated inputs quickly	Mode and sign settings can hide timing errors
Spreadsheet	Flexible and reproducible	Function arguments and rate conversions still require judgment
Cash-flow schedule	Makes each payment date visible	More time-consuming for long streams

OpenStax’s Time Value of Money appendix provides separate tables for lump sums and ordinary annuities. Its annuity lesson also shows how formula and period-by-period calculations reconcile.

Rounding and Interpolation

Printed tables often show four to six decimal places. Multiplying a rounded factor by a large payment can create a visible difference from software that retains more precision.

If the required rate is not listed, interpolation between columns gives only an approximation because annuity factors do not change linearly with the rate. A formula or spreadsheet is generally preferable when exact inputs are available. Always document the rate and rounding method when the result supports a financial decision.

Common Mistakes

Choosing the wrong table

A future-value factor cannot answer a present-value question. Likewise, a single-sum table does not value recurring payments.

Treating 5% annual as 5% monthly

The table heading refers to the rate per table period. Monthly payments require an appropriately converted monthly rate and a monthly payment count.

Ignoring beginning-of-period timing

An annuity due factor differs from the ordinary factor because every payment occurs one period earlier.

Rounding too early

Use the full available factor through the calculation and round the final currency amount. Premature rounding is more consequential with large payments or many periods.

Applying a level factor to irregular cash flows

Changing deposits, balloon payments, residual values, skipped periods, or contingent payments should be modeled separately rather than forced into one annuity factor.

FAQs

Are annuity tables still useful when software is available?

Yes. They provide a quick reasonableness check and make the rate-and-period relationship visible. Software is more flexible, but it can still produce a wrong answer when its timing mode or inputs are wrong.

Can an annuity table handle variable interest rates?

Not directly. A standard table assumes one periodic rate. When rates vary, discount or compound each cash flow using the applicable rates or use a model designed for a changing term structure.

Why does my spreadsheet differ from the table?

Check factor precision, payment timing, rate conversion, payment count, value date, and spreadsheet sign conventions. Small differences often come from rounding; large differences usually indicate mismatched assumptions.

Present Value of an Annuity: The discounted value of equal recurring payments.
Future Value of an Annuity: The accumulated value of equal recurring payments.
Ordinary Annuity: A level stream paid at each period end.
Discount Rate: The rate used to translate future cash flows into present value.

This article is educational and does not provide personalized investment, tax, lending, insurance, or retirement advice.

Annuity Due Factor

Future Value of Annuity