Calculating Equal Monthly Repayments on a Loan
Loans are usually arranged to be repaid at a constant fixed monthly rate. This means that to start with a large fraction of the repayment made each month is used to pay interest. As time progresses the amount used to pay interest decreases and with the last payment the loan is paid off completely.
It is quite tricky to calculate the month repayment. The method is illustrated in this example.
A loan of £500 is taken out at 11% annual interest to be repaid at a fixed monthly rate. Interest is to be charged from the date of the loan and the first repayment is to be made a month after the loan is taken out. Find the monthly repayment.
Call the monthly repayment x. Since the annual rate of interest is 11%, the monthly rate of interest is the solution to
After a month the amount owing in £ isand after the first monthly payment the amount owing is
After two months the amount owing in £ isand after the second monthly payment the amount owing is
After three months the amount owing in £ isand after the second monthly payment the amount owing is
We will carry on in the same way, until after two years, twenty four monthly repayments, the whole loan is paid off. After the last monthly payment there is no money left owing so
The expression on the right is a geometric series with first termand common ratioso the right hand side equalsand
Substituting the value ofinto this expression gives a monthly repayment of £23.18 to the nearest penny. The total amount repaid is £556.41 to the nearest penny.