Repaying a loan in payments: how much debt is left and how many payments are needed

22 min · 2 drills

In the textbook: Ch. 2.3 Geometrische Folgen2.4 Finanzmathematische Renten

Why is more than half of a loan usually still owed after half of the payments? And how many payments does it take to clear it?

Almost every loan is repaid with equal payments: for a car, a flat, a degree. Part of each payment goes to the interest, the rest reduces the debt. That is why after half of the payments usually more than half of the debt is still left.

Say you take out a car loan:

  • 15000 € at 5 % a year;
  • at the end of each year you pay back 2000 €.

Right after the third payment you want to pay off the rest in one go. How much is that?

Subtracting the three payments gives 15000−3⋅2000=9000 €, and that is too low: every year interest builds up on the debt, and part of each payment goes to it.

Let us follow the debt year by year: in a year it grows 1.05 times, then the payment lowers it by 2000 €.

YearDebt before the payment, €Debt after the payment, €
115750.0013750.00
214437.5012437.50
313059.3811059.38

Right after the third payment you need 11059.38 € to clear the loan, 2059.38 € more than the subtraction gave. The amount still owed to the bank at such a moment is called the remaining debt (German Restschuld).

The basics

The car-loan table in the introduction followed the debt year by year. For three years it stays short. For the debt after the tenth payment, or for the number of payments, you need formulas. A loan is worked with two formulas from the article “Save first, then pay out: two annuities in a row”. In them a is one payment, t the number of payments, q=1+r, where r is the rate as a fraction:

  • future value E=a⋅qt−1q−1: the value of all payments on the day of the last one, if each comes at the end of a year. For example, three payments of 1000 € at 4 % are worth 1000⋅1.043−10.04=3121.60 € on the day of the third (section on deposits earning interest);
  • payment a=B⋅q−11−q−t: the payment that repays a loan B in t payments, the first a year after the loan is paid out. For example, 10000 € at 4 % in 6 payments need a=10000⋅0.041−1.04−6=1907.62 € a year (section on the value of a series of payments).

The answer to the question from the start:

  1. Over 3 years interest builds up on the whole loan: 15000⋅1.053=17364.38 €.
  2. Each payment reduced the debt on its day, and from that day on no more interest built up on that part. So the three payments are moved to the same day too, as a future value: 2000⋅1.053−10.05=2000⋅3.1525=6305.00 €.
  3. Debt right after the third payment: 17364.38−6305.00=11059.38 €, over 2000 € more than the 9000 € without interest.
  4. The same calculation at the halfway point: after 5 of almost 10 payments the debt is 15000⋅1.055−2000⋅1.055−10.05=19144.22−11051.26=8092.96 €, more than half of the loan, 7500 €.

How much debt is left and how many payments are needed

For the car loan the debt was followed in a table over three years. For ten years such a table would be too long. The exam task asks exactly for the debt after the tenth payment:

Exam-style task

Eine Druckerei kauft eine Maschine für 140000 GE auf Kredit. Der Betrag wird in 25 gleichen Raten jeweils am Jahresende zurückgezahlt, die erste Rate nach einem Jahr. Verzinsung: 4.5% pro Jahr.

Wie hoch ist der noch offene Betrag direkt nach der 10. Rate? Runden Sie auf ganze GE.

  1. a)104642
  2. b)106066
  3. c)84000
  4. d)101397
  5. e)92575

A loan of 140000 GE (the task counts in GE, money units) is repaid with equal payments at the end of each year, and after the tenth payment the borrower wants to know the debt.

Signal: a loan is repaid in payments, and you are asked how much debt is left after some payments (“remaining debt”, “the amount still outstanding”) or how many payments will be needed.

Remaining debt

Take a loan of 20000 € at 4 %: it is repaid with payments of 2500 € at the end of each year.

What happens to the debt year by year? Over the year interest builds up on the debt, then the payment reduces it:

After paymentCalculationDebt, €
120000⋅1.04−250018300.00
218300⋅1.04−250016532.00
316532⋅1.04−250014693.28
414693.28⋅1.04−250012781.01
Debt on the loan of 20000 € right after each payment0246805000100001500020000payments madedebt, €

The debt drops faster and faster: each year there is less interest, so the same payment clears more debt.

Write out the second year without putting in 18300: (20000⋅1.04−2500)⋅1.04−2500=20000⋅1.042−2500⋅1.04−2500. The loan grew for two years. The first payment, had it sat in an account, would have grown for one year, the second for none. The subtracted part 2500⋅1.04+2500 is the future value of the two payments. After m payments it is the same. The loan is compounded over m years. Payment number j is made at the end of year j and would grow for m−j years up to the day of the m-th payment: the first for m−1 years, the last for 0. Together that is the future value of m payments, and it is subtracted. Call the remaining debt after m payments Rm:

Rm=B⋅qm−a⋅qm−1q−1

In the exam task the payment is not given. First you find it from the loan amount, as in the example “the loan payment” of the section on the value of a series of payments, and then you work out the remaining debt.

a = 9441.46 GE from 25 payments

A loan of 140000 GE at time 0 and the first ten equal payments; loan and payments compounded to the day of the 10th payment at 4.5 percent012345678910140000 GEloan−9441.46 GE−9441.46 GE−9441.46 GE−9441.46 GE−9441.46 GEafter the 10th paymentyearsrate = 4.5 %
Step 1 of 4Find the payment from the loan amount

B=140000, t=25, q=1.045, first payment after a year. 1.045−25=0.332731; 1−0.332731=0.667269; 0.045/0.667269=0.067439. Payment a=140000⋅0.067439=9441.46 GE (from here on we use the unrounded value).

A check by another route. After the 10th payment, 15 payments are left, and the debt equals their present value on that day: 9441.46⋅1−1.045−150.045=101396.99 GE, which rounds to the same 101397 GE.

The same loan: 20000 € at 4 %, payments of 2500 € at the end of the year.

What is the debt after the 4th payment and after the 9th? What is the last, 10th payment?

Subtracting 2500 four times from 20000 does not work: interest builds up on the debt every year.

  1. m=4: loan compounded 20000⋅1.044=23397.17 €; payments compounded 2500⋅1.044−10.04=10616.16 €. R4=23397.17−10616.16=12781.01 €, as in the table.
  2. m=9: loan 20000⋅1.049=28466.24 €; payments 2500⋅1.049−10.04=26456.99 €. R9=28466.24−26456.99=2009.25 €.
  3. The remaining 2009.25 € is less than the payment of 2500 €, so the 10th payment is the last. During year 10 interest builds up on what is left, and the last payment clears it completely: 2009.25⋅1.04=2089.62 €.

A loan of 12000 € at 3 % is repaid with payments of 2000 € at the end of each year.

What is the debt right after the 3rd payment?

Subtracting 2000 three times from 12000 does not work: interest builds up on the debt every year.

  1. m=3, q=1.03. Loan compounded over 3 years: 1.033=1.092727; 12000⋅1.092727=13112.72 €.
  2. Three payments compounded to the day of the 3rd: 1.033−10.03=3.090900; 2000⋅3.090900=6181.80 €.
  3. What is R3?

Your turn2 of 2

A firm takes a loan of 50000 € at 6 % and pays 7000 € at the end of each year. What is the debt right after the 5th payment? Round to two decimal places.

Number of payments

Exam-style task

Ein Betrieb nimmt ein Darlehen über 105000 GE auf. Es wird mit 6 % pro Jahr verzinst und durch gleich hohe Raten von 12900 GE getilgt, die jeweils am Jahresende fällig sind. Wie viele Raten sind nötig? Eine kleinere letzte Rate zählt mit.

  1. a)3
  2. b)12
  3. c)9
  4. d)6
  5. e)4

A loan of 105000 GE is repaid with payments of 12900 GE at the end of each year, and the borrower wants to know how many years to pay.

How to recognise it: the loan, the rate and the payment are given, and the question is how many payments are needed (“How many instalments are needed?”).

Now the payment is known, and what is unknown is how many will be needed. The loan still equals the present value of the payments, B=a⋅1−q−tq−1, but t sits in the power.

The logarithm gets the power out: in the logarithm of a power, the power comes out as a factor:

ln⁡(qt)=t⋅ln⁡q

On the calculator this is the ln key, the natural logarithm. Where this rule comes from and how it finds the term is covered in the article “Term and interest rate: when the unknown is in the exponent”.

The four steps below derive the term in general. The example right after them goes through the same steps with the 105000 GE loan from the exam task above.

  1. Multiply the formula by q−1=r and divide by a: B⋅ra=1−q−t.
  2. Isolate the power: q−t=1−B⋅ra.
  3. Take ln, the power comes to the front: −t⋅ln⁡q=ln⁡(1−B⋅ra).
  4. Divide by −ln⁡q:
t=−ln⁡(1−B⋅ra)ln⁡q

The fraction B⋅ra is the share of the first year's interest in the payment:

  • less than 1: the payment covers the interest and also repays part of the debt;
  • equal to 1: the payment goes only to interest, and the debt does not shrink;
  • more than 1: the debt grows.

In the last two cases 1−B⋅ra is not above zero, there is no logarithm, and the loan is never repaid.

interest 6300 GE out of the 12900 GE payment

A loan of 105000 GE at 6 percent repaid with payments of 12900 GE, number of payments unknown012345678910111212900 GE12900 GE12900 GE12900 GE12900 GE12900 GElastloan 105000 GEyearsrate = 6 %
Step 1 of 4Interest share of the payment

B=105000, r=0.06, a=12900. The first year's interest is 105000⋅0.06=6300 GE, its share of the payment 6300/12900=0.4884.

An account holds 40000 € at 3 %. At the end of each year the owner withdraws 5000 € until the account is empty.

How many times does she withdraw money, if the smaller last withdrawal counts too?

Dividing 40000 by 5000 does not work: while the money stays, it earns interest, and more withdrawals are needed.

The account works like a loan in reverse: the capital of 40000 € equals the present value of the withdrawals. The formula for t is the same, B=40000, a=5000, r=0.03.

  1. Interest share in the first year: 40000⋅0.03/5000=1200/5000=0.24.
  2. 1.03−t=1−0.24=0.76.
  3. ln⁡0.76=−0.274437, ln⁡1.03=0.029559, t=0.274437/0.029559=9.28.
  4. Round up: 10 withdrawals. After the 9th the account still holds 40000⋅1.039−5000⋅1.039−10.03=52190.93−50795.53=1395.40 €. A year later with interest that is 1395.40⋅1.03=1437.26 €, the tenth, smaller withdrawal.

A loan of 30000 € at 5 % is repaid with payments of 4000 € at the end of each year. The smaller last payment counts too.

How many payments are needed?

Dividing 30000 by 4000 does not work: interest builds up on the remaining debt every year, and more payments are needed.

  1. Interest share: 30000⋅0.05/4000=0.375.
  2. 1.05−t=1−0.375=0.625.
  3. ln⁡0.625=−0.470004, ln⁡1.05=0.048790, t=0.470004/0.048790=9.63. How many payments?

Remaining debt and number of payments traps

  • Remaining debt one payment short. It is easy to take m one too small, for example to compound the payments over 9 years instead of 10. In the task on the 140000 GE loan that gives 106065.55 GE, the debt after the 9th payment. Check: “right after instalment number 10” means m=10 in both terms.
  • Repaying without interest. It seems each payment repays 140000/25=5600 GE, leaving 140000−10⋅5600=84000 GE. But in the first years most of the payment goes to interest, so the debt falls more slowly. Check: the remaining debt must be larger than this “linear” amount.
  • Subtracting the payments from the loan as they are. 20000−4⋅2500=10000 € instead of 12781.01: the loan and the payments have to be compounded to the same day.
  • Compounding only the loan. 20000⋅1.044−4⋅2500=23397.17−10000=13397.17 €. The loan is compounded, the payments are not. But each payment reduced the debt earlier, and no more interest built up on that part, so the payment is compounded just like the loan. Check: in Rm both terms are compounded to the same day.
  • Rounding the number of payments down. From t=11.50 it is tempting to take 11: there are eleven full payments, after all. But after 11 payments 6187.16 GE of debt is left, and the 12th payment clears it. Check: if the smaller last payment counts, round t up.
  • Dividing the loan by the payment. 105000/12900=8.14, so 9 payments seem enough (option c). But interest builds up on the debt every year: in the first year 6300 of the 12900 GE go to it. Check: without interest the term is always shorter than with it.

On the sheet: Bt of the annuity; the formulas for the remaining debt and the number of payments you derive from it yourself.

Only full payments: round t down

The exam task on the number of payments counted the smaller last payment too, so t was rounded up. A task may count differently.

The number of full payments. If the task asks only for full payments, round t down: in the example with the 20000 € loan that is 9, and the remaining 2009.25 € is cleared by a smaller 10th payment.

Formula sheet and what to memorise

The two tasks in this article differ in what is unknown: the debt after some of the payments, or the number of payments. The overview shows where each one starts:

  • Number of payments and remaining debt

    A loan B is repaid with payments a; you need the debt after m payments or the number of payments t.
    Rm=B⋅qm−a⋅qm−1q−1

    Trap: forgetting the interest on the debt, or rounding the number of payments down.

On the formula sheet there are two annuities, and you derive the remaining debt and the number of payments yourself (payment a, number of payments t, q=1+r, d=1q):

  • future value of an annuity: nachschüssig Et=a qt−1q−1: the payments made so far, compounded to the day of the last of them;
  • present value of an annuity: nachschüssig Bt=a d 1−dt1−d: the loan and its payment, the number of payments.

Memorise yourself:

  • remaining debt Rm=B⋅qm−a⋅qm−1q−1; number of payments t=−ln⁡(1−B⋅ra)/ln⁡q, round up.

Remaining debt and the number of payments are drilled in the “Annuities, intra-year and continuous compounding” trainer. The chapter ends with choosing the method: “Which method? Financial mathematics” has only task statements, and nothing to calculate.

Now practise it

Repaying a loan in payments: how much debt is left and how many payments are needed

Trainer · Elementary financial mathematics

Practise
Next: Which method? Financial mathematics
0/2

Was this article helpful?