Number of payments and remaining debt
A loan is repaid with payments ; you need the debt after payments or the number of payments .Trap: forgetting the interest on the debt, or rounding the number of payments down.
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:
Right after the third payment you want to pay off the rest in one go. How much is that?
Subtracting the three payments gives €, 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 €.
| Year | Debt before the payment, € | Debt after the payment, € |
|---|---|---|
| 1 | 15750.00 | 13750.00 |
| 2 | 14437.50 | 12437.50 |
| 3 | 13059.38 | 11059.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 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 is one payment, the number of payments, , where is the rate as a fraction:
The answer to the question from the start:
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:
Eine Druckerei kauft eine Maschine für GE auf Kredit. Der Betrag wird in gleichen Raten jeweils am Jahresende zurückgezahlt, die erste Rate nach einem Jahr. Verzinsung: pro Jahr.
Wie hoch ist der noch offene Betrag direkt nach der . Rate? Runden Sie auf ganze GE.
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.
Take a loan of 20000 € at : 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 payment | Calculation | Debt, € |
|---|---|---|
| 1 | 18300.00 | |
| 2 | 16532.00 | |
| 3 | 14693.28 | |
| 4 | 12781.01 |
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: . 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 is the future value of the two payments. After payments it is the same. The loan is compounded over years. Payment number is made at the end of year and would grow for years up to the day of the -th payment: the first for years, the last for 0. Together that is the future value of payments, and it is subtracted. Call the remaining debt after payments :
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
, , , first payment after a year. ; ; . Payment 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: GE, which rounds to the same 101397 GE.
The same loan: 20000 € at , 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.
A loan of 12000 € at 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.
Your turn2 of 2
A firm takes a loan of 50000 € at and pays 7000 € at the end of each year. What is the debt right after the 5th payment? Round to two decimal places.
Ein Betrieb nimmt ein Darlehen über GE auf. Es wird mit pro Jahr verzinst und durch gleich hohe Raten von GE getilgt, die jeweils am Jahresende fällig sind. Wie viele Raten sind nötig? Eine kleinere letzte Rate zählt mit.
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, , but sits in the power.
The logarithm gets the power out: in the logarithm of a power, the power comes out as a factor:
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.
The fraction is the share of the first year's interest in the payment:
In the last two cases is not above zero, there is no logarithm, and the loan is never repaid.
interest 6300 GE out of the 12900 GE payment
, , . The first year's interest is GE, its share of the payment .
An account holds 40000 € at . 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 is the same, , , .
A loan of 30000 € at 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.
On the sheet: of the annuity; the formulas for the remaining debt and the number of payments you derive from it yourself.
The exam task on the number of payments counted the smaller last payment too, so was rounded up. A task may count differently.
The number of full payments. If the task asks only for full payments, round down: in the example with the 20000 € loan that is 9, and the remaining 2009.25 € is cleared by a smaller 10th payment.
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:
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 , number of payments , , ):
Memorise yourself:
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
PractiseWas this article helpful?