Calculating an Annuity
Before we use the annuity formula, let’s solve a short 3 year example the “long way”.
First we need the compound interest formula which is:
Total = Principal × ( 1 + Rate )years
Now let’s say the amount that we invest annually is $2,000 per year and the interest rate is 8%
The $2,000 invested 3 years ago has become
$2,000 * (1.08)3 = $2,000 * 1.259712 = $2,519.424
The $2,000 invested 2 years ago has become
$2,000 * (1.08)2 = $2,000 * 1.1664 = $2,332.80
The $2,000 invested 1 year ago becomes
$2,000 * (1.08)1 = $2,000 * 1.08 = $2,160.00
Adding up all 3 yearly amounts, we obtain $7,012.22
As you can see, the mathematics of this can be a little cumbersome especially when the time involved gets larger.
1) Solving the Total Amount
To make these calculations a little easier, there is a formula:
where the AMOUNT is the annual amount invested each year,
‘n’ is the number of years and
‘r’ is the annual rate of the investment.
So, we have:
$2,000 * { [(1 + .08)(3 + 1) -1] ÷ .08 } — $2,000.00
$2,000 * { [1.36048896 -1] ÷ .08 } — $2,000.00
$2,000 * { .36048896 ÷ .08 } — $2,000.00
$2,000 * { 4.506112 } — $2,000.00
$9,012.224 — $2,000.00
$7,012.22
Which is the answer we obtained using the “long” method at the top of this page.
2) Solving the Annual Amount
You have an 8% annual interest annuity which yields $100,000, after 25 years.
How much has to be invested each year?
We input the amounts into the numerator:
([(1.08)(25 + 1)-1] ÷ .08) -1
which equals 78.954415149
Dividing 100,000 by the numerator
100,000 ÷ 78.954415149 =
1266.553615923 which rounds to
$1,266.55 per year.
3) Solving for Years
You plan for your retirement by setting up an 8.5% annuity with an annual investment of $2,500 and you would like this to yield $500,000 when you retire.
How many years will this take?
Inputting these numbers into the numerator of the formula:
Log(.085 * (500,000 / 2500) + 1.085)
= Log(17.085)
= 1.2326149831
The log of the denominator 1.085 = 0.035429738185
The number of years = 1.2326149831 ÷ 0.035429738185
= 34.4877 years