Exercises: Loan amortisation

To celebrate the end of exams, a group of friends decides to finance the purchase of a sound system for their hangout, valued at $\$1500$. The bank offers them a loan at a nominal annual interest rate of $6 \%$, which they must repay in monthly installments over one year. The figure summarizes the situation. Identify the elements of the loan so you can apply the constant annuity formula:

• Initial capital ($C$)

• Number of payments per year ($k$)

• Total number of installments ($n$)

• Monthly interest rate ($i$) expressed as a decimal.

A Sixth Form student wants to buy an electric mountain bike costing $\$48\,000$. The shop offers financing at a nominal annual interest rate of $4.8 \%$ spread across monthly instalments. Calculate what monthly interest rate ($i$) will be applied to each instalment, expressing it both as a percentage and as a decimal.

Marta has taken out a loan of $\$3,000$ to pay for her university tuition fees and course materials. The bank applies the French amortisation system (equal instalments) with a monthly interest rate of $0.5 \%$. If the monthly instalment is $\$133.06$, calculate what amount of the first instalment corresponds exclusively to interest payment.

Lucas finances his new next-generation games console, costing $\$12\,000$, in 12 equal monthly instalments. At the end of the year, he realizes that he has paid a total of $\$12\,720$. Calculate:

1. a) The amount of the monthly instalment.
2. b) The total cost of the interest paid over the whole loan.

A language academy offers to finance the intensive summer course ($\$18\,000$) via an interest-free 4-month loan, but charges an arrangement fee of $\$500$ on the first payment.

1. a) What will be the amount of the instalments for the second, third and fourth months?
2. b) How much will the student pay in total in the first month?

Given the following incomplete amortization schedule for a loan for a graphics tablet, calculate the missing values marked with letters knowing that the monthly interest rate is $1 \%$:

To buy a moped costing $\$2,000$, Iratxe pays a deposit of $\$500$ and finances the remainder through equal monthly instalments over 2 years. If the nominal annual interest rate is $3 \%$, apply the amortisation annuity formula, clearly stating the principal $C$ that she is actually going to finance.

Draw a timeline that represents the amortization process of a loan of $\$1,200$ that is repaid in 4 quarterly installments.

Mark the instants 0, 1, 2, 3 and 4 (in quarters) on the line. At instant 0, indicate the loan payout with an upward arrow. At each time mark (quarter 1, 2, 3 and 4), draw a downward arrow and write the name given to the fixed amount of money that is paid to the bank.

You can do it on paper and send a photo with your answer.

To set up a small recording studio and start his YouTube channel, Marcos has taken out a loan of $4\,500$ pesos to be repaid over 2 years in equal monthly instalments. The bank charges a nominal annual interest rate of $6\%$. Calculate the amount of the monthly instalment that Marcos must pay.

A young entrepreneur applies for a loan of $12\,000$ pesos to buy a second-hand van for her delivery business. The loan will be amortised over 4 years with quarterly payments and an annual interest rate of $8\%$. Determine the portion of the first instalment corresponding to interest payment and how much is actually used to amortise the debt.

A group of friends decides to buy a professional mixing console that costs $1\,800$ pesos. They pay $300$ pesos in cash and finance the rest at an interest rate of $10\%$ per year (nominal, with monthly compounding period, that is, a monthly rate $i=\frac{0.10}{12}$) to pay it back over 6 months with constant monthly payments.

Remember that the constant payment $a$ that repays a principal $C$ in $n$ periods with rate $i$ per period is:

$a = C\times\dfrac{i}{1-(1+i)^{-n}}$

Create the first two rows of the amortization table, stating in each one: outstanding principal, interest for the period, principal repaid and monthly payment. Round to the nearest cent.

To finance an end-of-year trip, a student association takes out a loan of $3\,000$ pesos at an annual compound interest rate of $5\%$. The agreement is to repay it in a single lump sum payment after 18 months. What will the total interest amount to? If they had chosen to amortise it monthly over the same period, would they pay more or less interest in total? Reason your answer without needing to calculate the complete schedule.

Calculate the outstanding balance of a loan of $20\,000$ pesos taken out at $4\%$ per year after paying 12 monthly instalments. The loan was granted for a total of 5 years. (Hint: The outstanding balance is the present value of the remaining instalments to be paid).

A video rental store wants to renew its screens and applies for a loan of $120\,000$ pesos at $9\%$ per year to be repaid over 3 years in equal monthly installments. The contract includes an early redemption fee of $1\%$ of the outstanding balance. If at the end of the second year they decide to settle the remaining debt, what will be the total amount they must pay at that moment (outstanding balance plus fee)?

We compare two loans to buy a motorbike costing $3\,500$ pesos:

• Option A: Monthly amortisation over 2 years at $6\%$ nominal annual interest.

• Option B: Quarterly amortisation over 2 years at $6.2\%$ nominal annual interest.

Calculate the instalment for each option and determine in which of the two options more interest is ultimately paid at the end of the two years.

Given the following row from the amortization table of a loan at $12\,\%$ per year with monthly payments (the monthly interest is calculated by dividing the annual rate by $12$, that is, $1\,\%$ per month):

• Month: $10$

• Initial debt for the month: $14\,250,80$ pesos

• Monthly payment: $450$ pesos

Calculate:

1. a) The interest for month $10$ (round to the nearest cent).

1. b) The principal repaid in that month.

1. c) The outstanding debt at the start of month $11$.

A 24-year-old female entrepreneur decides to open a graphic design studio. To acquire the necessary equipment (high-end computers, software licenses and furniture), she applies for a loan from a financial institution to be repaid over 5 years in equal monthly installments of $\$8\,510$. The institution charges a nominal annual interest rate of $5.4 \%$.

Calculate the initial principal that the bank granted her to set up her business. Round the result to the nearest pesos cent.

A university student wants to buy a second-hand car costing $\$190\,000$. He has some savings, but needs to finance the remaining $\$140\,000$. The bank offers him a personal loan at an annual interest rate of $6.75 \%$. The student analyzes his budget and concludes that he can only allocate a maximum of $\$3\,600$ per month to the instalment payment.

Using logarithms, determine the minimum number of months it will take to repay the loan so that the monthly instalment does not exceed his limit of $\$3\,600$.

A family takes out a 20-year mortgage of $\$160,000$ at a fixed annual interest rate of $3.25 \%$ with monthly payments. After exactly 10 years of faithfully paying the monthly instalments, they receive an inheritance and consider paying off the outstanding debt.

Calculate the breakdown of the 121st instalment, specifying which part corresponds to interest payment and which part to capital amortisation.

A logistics technology company applies for a loan of $\$5\,000\,000$ to renew its fleet of electric vehicles. The loan is agreed at an annual interest rate of $4.5 \%$ with quarterly payments over 6 years. The financial institution grants them a full grace period of 6 months (during the first two quarters no payment is made, but interest accumulates on the initial principal).

Calculate the amount of the quarterly instalments that they will have to pay from the third quarter until the end of the loan.

We compare two loan options to finance a renovation of $\$600\,000$ to be repaid over 4 years with monthly payments:

• Option A: Nominal annual interest of $5 \%$ with no initial fees.

• Option B: Nominal annual interest of $4.2 \%$ but with an arrangement fee of $1.5 \%$ on the capital requested, paid in cash at signing.

Calculate the total cost of each option (sum of all instalments plus fees) and determine which is more advantageous for the client.

A mortgage loan of $\$200,000$ is taken out over a period of 25 years with monthly instalments. For the first two years, the interest rate is fixed at $2.5 \%$ per year. From the start of the third year, the interest rate becomes variable, changing to $4.75 \%$ per year.

Calculate by how much the family's monthly instalment will increase from the third year onwards due to this interest rate rise.

A self-employed worker applies for a microcredit of $\$240\,000$ at $8 \%$ per year to be repaid over 3 years in semi-annual instalments. After the first year (after paying the second instalment), he decides to make an early repayment of $\$60\,000$ to reduce the debt. The bank allows him to choose between reducing the loan duration or reducing the amount of the remaining instalments.

If he chooses to reduce the instalment amount while maintaining the original 3-year term, calculate what the new semi-annual instalment amount will be.

Consider a loan with principal $D$ to be repaid over $n$ periods with an interest rate per period of $i$. Prove step by step, using the geometric progression of outstanding balances, that if the interest rate were $0 \%$ ($i=0$), the formula for the equal instalment $a$ simplifies to the simple arithmetic division: $a = \frac{D}{n}$.

Note: For the proof, use the limit of the annuity formula as $i$ tends to zero or analyze the sum of the amortisation terms.