A lot of money comes and goes not as one amount but as a series of equal payments: deposits into a savings account, loan payments, a pension, rent. You cannot simply add up such a series, because the payments arrive in different years. Moved to one day, though, equal payments form a series whose sum one formula gives.
For eight years in a row, 40 € go into an account at the end of each year. The bank pays 5% a year.
There are two questions:
How much is in the account right after the eighth deposit?
What is the whole series of deposits worth today?
The plain sum 8⋅40=320 € misses both answers: the first deposit sits in the bank for seven years and grows, the last does not grow at all. Each deposit has its own worth, depending on the day you look at it.
The answers: right after the eighth deposit the account holds 381.96 €, and today the whole series is worth 258.53 €. The first number is larger than 320 € because the early deposits have had time to earn interest. The second is smaller because each deposit is still to be waited for, and today it is worth less than its 40 €. To get both numbers without moving every deposit separately, the series is added up with one formula, the sum of a geometric sequence. The article starts with it. The annuity formulas follow from it in the next section.
Geometric sequences and their sum
We start with the first question, the balance after the eighth deposit. A payment is moved along the timeline with the factor q=1+r. Here r is the rate as a fraction: 5% is r=0.05 and q=1.05.
Let us move all eight deposits to the day of the last one. Each deposit grows for as many years as have passed since it was made:
Deposit at the end of year
Years to the 8th deposit
Worth on that day, €
8
0
40
7
1
40⋅1.05=42.00
6
2
40⋅1.052=44.10
…
…
…
1
7
40⋅1.057=56.28
The table runs from the last deposit to the first. That way the first term of the sum is the deposit itself, 40, and each next one is exactly 1.05 times the one before.
Such a row of numbers is called a geometric sequence (“geometrische Folge”): each term is the previous one multiplied by the same factor q. The formula sheet calls the first term x0 (the zero in the index only marks the starting term). The terms run x0,x0q,x0q2,… The second term has the power 1, the third 2. So the last of n terms has the power n−1: here 40⋅1.057, the eighth term with power 7.
After the eighth deposit the account holds the sum of all eight terms. Call it S:
S==40++40⋅⋅1.05++40⋅⋅1.052++…++40⋅⋅1.057
Adding eight powers takes a while. There is a trick that removes almost all the terms at once.
Multiply the whole sum by 1.05. Each term turns into the next one: 1.05S=40⋅1.05+40⋅1.052+…+40⋅1.057+40⋅1.058.
Subtract the original line from this one. The terms from 40⋅1.05 to 40⋅1.057 are in both lines and cancel.
What is left is the new last term and the old first one: 1.05S−S=40⋅1.058−40.
On the left 0.05S, on the right 40⋅(1.477455−1)=19.098218.
Divide by 0.05: S=381.96 €.
The same steps with letters: first term x0, factor q, n terms. Multiply by q, subtract, divide by q−1:
Sn=x0⋅q−1qn−1
The power in the sum is the number of termsn; the last term has a power one less, n−1. This is the main trap of the formula.
The same trick on another sequence: an app gets 32 new users in its first month, then each month one and a half times as many. Over 6 months that is 32, 48, 72, 108, 162, 243. In the figure below the lower row of bars is the sum S6. The upper row is the same bars multiplied by 1.5 and shifted one place to the right. The numbers from 48 to 243 stand above each other and cancel when you subtract. What is left is 364.5 on top and 32 at the bottom: 1.5S6−S6=364.5−32=332.5, so S6=332.5/0.5=665.
The annuity as a geometric sum
Our eight deposits of 40 € a year apart form an annuity. Loan payments, a pension and rent are built the same way. An annuity (German Rente) in financial mathematics is a series of equal payments at equal intervals. The formula sheet writes the payment of an annuity as a and the number of payments as t; here a=40 and t=8.
We have already worked out the sum of the deposits on the day of the last one, 381.96 €. Such a sum is called the future value of the annuity (German Endwert, E). The same series can also be moved to today, time 0; its sum today is called the present value (German Barwert, B). The steps below work out both.
first deposit: 56.28 €year-7 deposit: 42 €E = 381.96 €present value B = 258.53 €a year earlier: 271.45 €
value =381.96 €
Step 1 of 5The first deposit up to the day of the last
The deposit at the end of year 1 sits until the end of year 8 for 7 years: 40⋅1.057=56.28 €.
The deposit at the end of year 7 sits for 1 year: 40⋅1.05=42 €. The last deposit is made on the reference day and does not grow, 40 €.
This is the sum of the sequence with x0=a=40, q=1.05 and n=t=8 terms: E=40⋅0.051.058−1=381.96 €.
The sum 381.96 € refers to the end of year 8. To bring it to today, discount it over 8 years: B=381.96/1.058=381.96/1.477455=258.53 €.
Suppose the first deposit is made today and the last at the end of year 7. On any day, each deposit has been in the account a year longer and is worth 1.05 times as much. So is the whole sum. We multiply the unrounded B=258.5285: 258.5285⋅1.05=271.45 €.
Steps 3 and 4 in general form. The future value is the sum of the sequence with x0=a and n=t:
E==a⋅⋅q−1qt−1
The present value: E is divided by qt, as in step 4:
B==qtE==a⋅⋅(q−1)⋅qtqt−1
Split the fraction qtqt−1 term by term: qtqt−qt1=1−qt1.
The notation q−t means qt1 (rule a−t=1/at, where a here is any positive number, not the payment, see “Powers: four rules with numbers”). For example, 1.05−8=1.0581=0.676839. With this notation both formulas get shorter:
E=a⋅q−1qt−1,B=a⋅q−11−q−t,E==B⋅⋅qt
This is how you work out an annuity where each payment comes at the end of its period: it is called nachschüssig. If each payment comes at the start of the period, the annuity is vorschüssig. Step 5 of the example with the eight deposits of 40 € above showed that both of its values are q times as large.
The formula sheet writes the same formulas with d=q1, the discount factor: multiplying by dt is the same as dividing by qt, so dt=q−t. On the sheet:
present value nachschüssig: Bt=ad1−d1−dt;
present value vorschüssig: Bt=a1−d1−dt, without the factor d in front, so q times as large;
future value nachschüssig: Et=aq−1qt−1;
future value vorschüssig: Et=aqq−1qt−1.
Why Bt from the sheet matches our B: the factor in front is 1−dd=1−1/q1/q. Multiply the numerator and the denominator by q: (1−1/q)⋅q1/q⋅q=q−11.
The words of the task tell you when the first payment comes:
“am Jahresende” (at the end of the year), “erstmals in einem Jahr” (first in one year), “ein Jahr nach der Auszahlung” (a year after the loan is paid out): nachschüssig;
“zu Jahresbeginn” (at the start of the year), “ab heute” (from today), “sofort” (immediately), “bei Vertragsabschluss” (when the contract is signed): vorschüssig.
What a series of equal payments is worth today and at the end
The 40 € deposits were saved up in the account. With a loan the money flows the other way: the bank pays the amount out at once, the series of payments pays it back, and the present value is what you calculate:
Exam-style task
Ein Kredit wird durch 12 jährliche Raten von je 4000 GE getilgt; die erste Rate ist ein Jahr nach der Auszahlung fällig. Der Zinssatz beträgt 5% p. a. bei jährlicher Verzinsung.
Wie hoch ist der Kreditbetrag, also der Barwert der Raten (in GE)? Runden Sie auf zwei Nachkommastellen.
a)63668.51
b)35453.01
c)37225.66
d)33225.66
e)48000.00
The bank pays out a loan today, and the borrower repays it with twelve equal payments of 4000 GE, short for Geldeinheiten, money units.
Signal: equal payments (“instalments”) at equal intervals, and you are asked for their value today (“present value”), at the end of the term (“future value”), or for the payment itself.
Why does the loan amount equal the present value of the payments? Today the bank hands over the loan amount and in return gets a series of payments in the future. The deal is fair if both sides are worth the same on the same day. Today the loan is worth its amount, and the payments are worth their present value B. The later a payment, the less it is worth today. Take the eight deposits of 40 € from the start of the article:
the first is worth 40/1.05=38.10 € today;
the last 40/1.058=27.07 €;
all eight together 258.53 €.
In the task above there are 12 payments of 4000 GE each, the first a year after the loan is paid out: the annuity is nachschüssig.
without interest: 48000 GEB = 35453.01 GEfirst payment after a year: nachschüssig
loan amount =35453.01 GE
Step 1 of 4Write down the payments
From the task: payment a=4000, number of payments t=12, rate 5%, q=1.05. Without interest that is 12⋅4000=48000 GE, but today the payments are worth less.
The first payment comes after a year: 4000/1.05=3809.52 GE. The last after 12 years: 4000/1.0512=2227.35 GE. Adding all twelve one by one takes a while; the formula does it at once.
1.05−12=0.556837; 1−0.556837=0.443163; divide by q−1=0.05: 8.863252. Multiply by the payment: B=4000⋅8.863252=35453.01 GE.
“the first instalment is due one year after the loan is paid out”: the first payment comes after a year, the annuity is nachschüssig, no factor q. Answer: 35453.01 GE.
Ask yourself: why is the answer less than 48000 but more than 12⋅2227.35=26728.20?
It also goes the other way: the loan amount is given and the payment (“Rate”) is wanted. The loan still equals the present value of the payments, only now a is unknown. You solve the formula B=a⋅q−11−q−t for a in two steps:
multiply both sides by q−1: B⋅(q−1)=a⋅(1−q−t);
divide both sides by 1−q−t:
a=B⋅1−q−tq−1
A loan of 20000 € is repaid with 5 equal payments at the end of each year at 4%.
How large is the payment? And if the first payment is made immediately?
Dividing 20000 by 5 does not work: the payments fall in different years, and interest runs on the part not yet repaid.
5 payments a, loan 20000 € todaya = 4492.54 €check: B ≈ 20000 €first payment at once: a = 4319.75 €
loan 20000 € =19999.99 €
Step 1 of 4The loan equals the present value of the payments
B=20000, t=5, q=1.04; the payment a is unknown.
1.04−5=0.821927, that is 1/1.045.
1−0.821927=0.178073.
0.04/0.178073=0.224627: this is the factor 1−q−tq−1.
Payment a=20000⋅0.224627=4492.54 €.
Put the payment into the present value formula: 0.041−1.04−5=4.451822 with the full calculator value; 4492.54⋅4.451822=19999.99 €. That is the loan of 20000: the 0.01 € gap comes from rounding the payment.
If the first payment is made when the loan is paid out, the annuity is vorschüssig: its present value is q times as large, so for the same loan the payment is q times smaller: 4492.54/1.04=4319.75 €.
Ask yourself: why is 5⋅4492.54=22462.70 more than the loan of 20000?
A car costs 15000 €. The dealer sells it in instalments: 4 equal payments at the end of each year, the first a year after the purchase, at 7%.
How large is the payment?
Dividing 15000 by 4 does not work: the payments fall in different years, and interest runs on the part not yet repaid.
The price of the car equals the present value of the payments: B=15000, t=4, q=1.07, the annuity is nachschüssig.
1.07−4=0.762895; 1−0.762895=0.237105.
Factor 1−q−tq−1=0.07/0.237105=0.295228.
Payment a=15000⋅0.295228=4428.42 €. Together 4⋅4428.42=17713.68 €, 2713.68 € more than the price: that is the interest.
For five years, 1000 € is paid into an account at 4% at the end of each year.
How much is in the account right after the fifth deposit?
Adding 1000 five times does not work: the deposits stay for different lengths of time and grow differently.
Payment a=1000, number of payments t=5, q=1.04.
You are asked for the amount on the day of the last deposit: that is the future value. Deposits at the end of the year, the annuity is nachschüssig: E=a⋅q−1qt−1.
1.045=1.216653. What is E?
A loan of 15000 € is repaid with 8 equal payments, the first a year after the payout, rate 5%.
How large is the payment?
Dividing 15000 by 8 does not work: the payments fall in different years, and interest runs on the part not yet repaid.
The loan equals the present value of the payments: B=15000, t=8, q=1.05, the annuity is nachschüssig.
1.05−8=0.676839; 1−0.676839=0.323161.
Factor 1−q−tq−1=0.05/0.323161=0.154722. What is the payment a?
Your turn2 of 3
A buyer pays for a plot of land with 10 equal yearly payments of 6000 €, the first on the day of purchase. The rate is 4%. What are these payments worth today? Round to two decimal places.
Annuity traps
Mixing up nachschüssig and vorschüssig. You remember the formula in one form and apply it to every annuity. In the task above the vorschüssig answer is 35453.01⋅1.05=37225.66 GE. Check: find the words about the first payment in the task and decide whether it comes after a year or immediately.
Taking the future value instead of the present value. Both formulas sit side by side on the sheet and look alike. 4000⋅0.051.0512−1=63668.51 GE is more than the sum of all payments, 48000, while today the payments are worth less than that.
Counting the gaps instead of the payments. From the first payment to the last is 11 years, and the hand writes t=11: that gives 33225.66 GE. Check: t is the number of payments in the task, here 12.
Not discounting.12⋅4000=48000 GE adds payments from different years as they are.
On the sheet:Bt and Et for both annuities, with d=q1. Which annuity the task has, and whether it asks about today or the end, is your call.
What capital pays forever
The loan had twelve payments, and the series came to an end. If the payments never stop, there is nothing to put in for t, and the capital is found another way:
Exam-style task
Eine Stiftung soll einer Schule unbegrenzt lang jeweils am Jahresende 11800 GE auszahlen. Das Stiftungskapital wird mit 5.5% pro Jahr verzinst.
Wie hoch muss das Kapital heute sein? Runden Sie auf ganze GE.
a)214545
b)202102
c)220393
d)172065
e)226345
A fund has to pay 11800 GE at the end of every year, without end.
Signal: the payments go on without end (“for ever”, “indefinitely”, “with no time limit”), and you are asked for the capital today.
What capital can pay 11800 GE a year forever? One whose interest alone for a year equals the payment. Then the payment takes only the interest, and every year the account holds the same amount again. The interest on capital B for a year is B⋅r. The condition B⋅r=a gives:
B=ra
The annuity formula from the section on the value of a series of payments gives the same answer. The more payments t, the smaller q−t: at 1.055, already 1.055−100 is less than 0.005. For an endless annuity only 1 is left of the numerator 1−q−t, and B=q−1a=ra.
11800 GE every year, without endcapital today: B = 214545.45 GEfirst payment at year end: nachschüssig
capital today =214545.45 GE
Step 1 of 4Read the payments
Payment a=11800 GE at the end of each year, without end. Rate 5.5%, so r=0.055.
The first is worth 11800/1.055=11184.83 GE today, the second 11800/1.0552=10601.74 GE. Each next one is smaller, which is why the sum of the endless series is finite.
B=11800/0.055=214545.45, rounded 214545 GE. Check: 214545.45⋅0.055=11800, a year's interest equals the payment.
“at the end of every year”: the first payment comes after a year, the annuity is nachschüssig. Answer: 214545 GE.
If the first payment is today (vorschüssig):
it is paid out at once, on top of the capital ra that pays all the later payments;
so B=ra+a=ra⋅q;
on the sheet this is B=1−da, and for nachschüssig B=1−dad. That is our ra: the section “The annuity as a geometric sum” showed that 1−dd=q−11, and q−1=r.
A society will be paid 3000 € a year forever, but the first payment comes only in 3 years. The rate is 4%.
What is this worth today?
Putting 3000 into B=a/r and stopping does not work: the formula gives the value one year before the first payment, not today's.
a year before the first payment: time 2capital at time 2: 75000 €capital today: 69341.72 €
reference time =75000 €
Step 1 of 3Find the day where a / r works
The formula ra gave the capital a year before the first payment: in the task above, capital today, first payment after a year. Here the first payment is at time 3, so ra refers to time 2.
3000/0.04=75000 €.
From time 2 back to today is 2 years: 75000/1.042=75000/1.0816=69341.72 €.
If the first payment is in s years, discount over s−1 years: B=ra⋅ds−1.
A foundation is to pay a school 2000 € for books and 500 € for trips at the end of each year, forever. The rate is 5%.
How much does the foundation need today?
Taking only the 2000 € does not work: the capital would not cover the trips.
Both payments come on the same day, so they are added into one: a=2000+500=2500 €.
Payment at the end of the year: nachschüssig, B=ra, r=0.05. What is B?
Your turn3 of 3
A foundation must pay out 1200 € a year forever, the first payout immediately. How many € does it need today at 5%?
Perpetuity traps
Multiplying by q when the first payment comes after a year. After the vorschüssig formulas the hand wants to multiply. In the task above that gives 214545.45⋅1.055=226345 GE. Check: the words “at the end of every year” or “first after one year” mean ra with no factor.
Forgetting today's payment. If the task says “from today” or “the next of these payments is due today” and you work out ra, one payment is lost. Check: for vorschüssig the answer is larger than ra by exactly a.
Taking only part of the payment. When two payments go out each year (for example, for running costs and for repairs), add them before dividing by r.
Discounting a deferred perpetuity one year too many. With the first payment in 3 years it is tempting to divide by 1.043, which gives 66674.73 € instead of 69341.72. Check: ra already sits at the time a year before the first payment.
On the sheet:B=1−dad (nachschüssig) and B=1−da (vorschüssig). The shift for an annuity that starts later you keep in your head.
The rate c/12 for monthly payments and a perpetual payment a = B·r
In all the tasks above payments came once a year. Two common twists remain: monthly payments, and the perpetuity where the capital is given and the payment is unknown.
Monthly payments. If payments are monthly, the period of the annuity is a month. The rate per period: c/12, where c is the nominal annual rate (c on the sheet), and t is the number of months. The formulas stay the same. Example: a loan of 12000 € is repaid with 24 monthly payments at c=6%. The monthly rate is c/12=0.06/12=0.005, payment 12000⋅1−1.005−240.005=531.85 €. How the nominal and the effective rate are linked is covered in the article “How often interest is paid: why 9 % monthly beats 9.3 % once a year”.
The capital is known, the perpetual payment is wanted. From B=ra: a=B⋅r for nachschüssig. For vorschüssig the first payout leaves the capital at once: a=qB⋅r.
Formula sheet and what to memorise
The series of deposits, the loan and the perpetuity are all worked out with the annuity formulas from the sheet. The overview shows which one you need:
Equal payments a, t of them; you are asked for the value today, at the end of the term, or the loan payment. The loan equals the present value of the payments.
B==a⋅⋅q−11−q−t
Trap:mixing up nachschüssig and vorschüssig; the answer differs by the factor q.
Payments without end; the capital whose interest per period equals the payment.
B==ra
Trap:multiplying by q when the first payment comes after a year, or forgetting today's payment.
On the formula sheet the letters are the same as in the sections above: payment a, number of payments t, q=1+r and d=q1:
present value of an annuity: nachschüssig Bt=ad1−d1−dt, vorschüssig Bt=a1−d1−dt; this is our B from the section on the value of a series of payments, since 1−dd=q−11;
future value of an annuity: nachschüssig Et=aq−1qt−1, vorschüssig Et=aqq−1qt−1: value of a series of payments at the end of the term;
perpetuity: nachschüssig B=1−dad=ra, vorschüssig B=1−da: payments without end;
sum of a geometric sequence Sn=x0q−1qn−1: the derivation of all annuity formulas.
Memorise yourself:
“am Jahresende”, “erstmals in einem Jahr” mean nachschüssig; “zu Jahresbeginn”, “ab heute”, “sofort” mean vorschüssig, and the answer is q times as large;
loan payment a=B⋅1−q−tq−1;
perpetuity with the first payment in s years: ra⋅ds−1.
Existing capital is to fund equal payments forever, the first one at once; you need the payment.
Existing capital is to fund equal payments forever, the first one at once; you need the payment.
Solve the perpetuity for a: in arrears a=B⋅r, with the first payment at once a=B⋅r/q.
What it means
What does «vorschüssig» (in advance) mean?
What does «vorschüssig» (in advance) mean?
Each payment comes at the start of its period, so the first one comes at once.
What it means
What does «nachschüssig» (in arrears) mean?
What does «nachschüssig» (in arrears) mean?
Each payment comes at the end of its period, so the first one comes after one period.
What it means
What is the effective annual rate?
What is the effective annual rate?
The rate that, compounded once a year, gives the same as compounding several times a year. With several compoundings a year it is higher than the nominal rate.