james vardaman Future Value of an Annuity – dummies


AccountingTools







AccountingTools

Accounting CPE Courses & Books

Articles

AccountingTools









Future value of an ordinary annuity table


/



Steven Bragg

An annuity is a series of payments that occur at the same intervals and in the same amounts. An example of an annuity is a series of payments from the buyer of an asset to the seller, where the buyer promises to make a series of regular payments. Thus, Harvest Designs buys a warehouse from Higgins Realty for $1,000,000, and promises to pay for the warehouse with five payments of $200,000, to be paid at intervals of one payment per year; this is an annuity. If the payments are due at the end of a period, the annuity is called an ordinary annuity . If the payments are due at the beginning of a period, the annuity is called an annuity due .

You might want to calculate the future value of an annuity, to see how much a series of investments will be worth as of a future date. You do this by using an interest rate to add interest income to the amount of the annuity. The interest rate can be based on the current amount you are obtaining through other investments, the corporate cost of capital , or some other measure.

An annuity table represents a method for determining the future value of an annuity. The annuity table contains a factor specific to the future value of a series of payments, when a certain interest earnings rate is assumed. When you multiply this factor by one of the payments, you arrive at the future value of the stream of payments. For example, if you expect to make 5 payments of $10,000 each into an investment fund and use an interest rate of 6%, then the factor would be 5.6371 (as noted in the table below at the intersection of the “6%” column and the “n” row of “5” periods. You would then multiply the 5.6371 factor by $10,000 to arrive at a future value of the annuity of $56,371.

Rate Table For the Future Value of an Ordinary Annuity of 1

n1%2%3%4%5%6%8%10%12%
11.00001.00001.00001.00001.00001.00001.00001.00001.0000
22.01002.02002.03002.04002.05002.06002.08002.10002.1200
33.03013.06043.09093.12163.15253.18363.24643.31003.3744
44.06044.12164.18364.24654.31014.37464.50614.64104.7793
55.10105.20405.30915.41635.52565.63715.86666.10516.3529
66.15206.30816.46846.63306.80196.97537.33597.71568.1152
77.21357.43437.66257.89838.14208.39388.92289.487210.0890
88.28578.58308.89239.21429.54919.897510.636611.435912.2997
99.36859.754610.159110.582811.026611.491312.487613.579514.7757
1010.462210.949711.463912.006112.577913.180814.486615.937417.5487
1111.566812.168712.807813.486414.206814.971616.645518.531220.6546
1212.682513.412114.192015.025815.917116.869918.977121.384324.1331
1313.809314.680315.617816.626817.713018.882121.495324.522728.0291
1414.947415.973917.086318.291919.598621.015124.214927.975032.3926
1516.096917.293418.598920.023621.578623.276027.152131.772537.2797
1617.257918.639320.156921.824523.657525.672530.324335.949742.7533
1718.430420.012121.761623.697525.840428.212933.750240.544748.8837
1819.614821.412323.414425.645428.132430.905737.450245.599255.7497
1920.810922.840625.116927.671230.539033.760041.446351.159163.4397
2022.019024.297426.870429.778133.066036.785645.762057.275072.0524
2123.239225.783328.676531.969235.719339.992750.422964.002581.6987
2224.471627.299030.536834.248038.505243.392355.456871.402892.5026
2325.716328.845032.452936.617941.430546.995860.893379.5430104.6029
2426.973530.421934.426539.082644.502050.815666.764888.4973118.1552
2528.243232.030336.459341.645947.727154.864573.105998.3471133.3339
2629.525633.670938.553044.311751.113559.156479.9544109.1818150.3339
2730.820935.344340.709647.084254.669163.705887.3508121.0999169.3740
2832.129137.051242.930949.967658.402668.528195.3388134.2099190.6989
2933.450438.792245.218952.966362.322773.6398103.9659148.6309214.5828
3034.784940.568147.575456.084966.438979.0582113.2832164.4940241.3327

The preceding annuity table is useful as a quick reference, but only provides values for discrete time periods and interest rates that may not exactly correspond to a real-world scenario. Accordingly, use the following annuity formula in an electronic spreadsheet to more precisely calculate the correct amount of the future value of an ordinary annuity:

P = PMT [((1 + r)– 1) / r]

Where:

P = The future value of the annuity stream to be paid in the future
PMT = The amount of each annuity payment
r = The interest rate
n = The number of periods over which payments are made