Calculating annuities and monthly payments
Paying off a car loan in monthly repayments and saving up for a trip to the Cliffs of Moher with fixed monthly deposits in a credit union are, mathematically, the same idea: a series of equal payments at regular intervals. This is called an annuity, even if the payments are monthly, quarterly or yearly. By the end of the page you will be able to say how much a Leaving Cert student saving for a car needs to put aside each month.
The constant annuity: two sides of the same formula
To save up for his driving licence, Cian decides to deposit €60 per month into a bank account at the end of each period. The bank offers him $2.4 \%$ annual compound…
To save up for his driving licence, Cian decides to deposit €60 per month into a bank account at the end of each period. The bank offers him $2.4 \%$ annual compound interest with monthly compounding. Calculate how much money he will have accumulated after 2 years (24 months) of making these deposits.
Note: Remember to convert the annual interest rate into a monthly interest rate by dividing by 12.
Aoife bought an electric scooter by financing the €450 it costs with a loan. The bank charges her fixed monthly instalments of €40 at the end of each month for one year.…
Aoife bought an electric scooter by financing the €450 it costs with a loan. The bank charges her fixed monthly instalments of €40 at the end of each month for one year. If the total interest paid is the difference between the sum of all instalments and the cash price, how much money has Aoife paid solely in interest by the end of the year?
Aoife is 18 years old and plans to save to pay for the deposit and move-in expenses of a shared flat when she finishes her Post-Leaving Certificate (PLC) course in $3$…
Aoife is 18 years old and plans to save to pay for the deposit and move-in expenses of a shared flat when she finishes her Post-Leaving Certificate (PLC) course in $3$ years ($36$ months). She is going to deposit $150$ € at the end of each month into an interest-bearing youth account with a nominal interest rate of $3\%$ per year ($i = \frac{0.03}{12} = 0.0025$ monthly).
- a) Make a reasoned prior estimate before applying complex formulas: calculate how much she would accumulate if the interest rate were $0\%$, and justify whether, after adding the $3\%$ per year, the final accumulated capital will manage to exceed the $6,000$ € threshold or not.
- b) Apply the future value formula for an ordinary constant savings annuity to calculate the exact amount she will have accumulated after the $36$ months have elapsed.
- c) Check the exact result against your prior estimate and calculate what percentage of the final accumulated capital comes from the interest paid by the bank.
Rearranging for the instalment or the deposit
A family applies for a loan of $\text{€}\ 5,000$ to buy a second-hand motorbike. The bank grants them the loan at an annual interest rate of $5 \%$, which they must…
A family applies for a loan of $\text{€}\ 5,000$ to buy a second-hand motorbike. The bank grants them the loan at an annual interest rate of $5 \%$, which they must repay in 4 equal annual instalments payable at the end of each year. Determine the amount of this annual loan repayment.
A 1st Baccalaureate student wants to buy a gaming computer costing $\text{€}\ 1,200$. A computer shop allows him to pay for it in 12 equal monthly instalments at a…
A 1st Baccalaureate student wants to buy a gaming computer costing $\text{€}\ 1,200$. A computer shop allows him to pay for it in 12 equal monthly instalments at a nominal annual interest rate of $6 \%$. Knowing that the monthly interest rate is calculated as $i = \frac{0.06}{12}$, use the loan repayment formula to calculate the monthly instalment he must pay at the end of each month.
A family applies for a loan of $15,000$ € to renovate their kitchen and bathroom. The bank grants them the loan at an annual interest rate of $5\%$ to be repaid over $4$…
A family applies for a loan of $15,000$ € to renovate their kitchen and bathroom. The bank grants them the loan at an annual interest rate of $5\%$ to be repaid over $4$ years in fixed monthly instalments due at the end of each month.
- a) Determine the monthly instalment amount they will have to pay.
- b) Calculate the total amount they will end up paying back to the bank after $4$ years.
- c) What percentage of the total amount paid corresponds to interest?
A small business buys a delivery van valued at $22,000$ €. They make a deposit of $4,000$ € and finance the rest at a nominal annual interest rate of $4.8\%$. The…
A small business buys a delivery van valued at $22,000$ €. They make a deposit of $4,000$ € and finance the rest at a nominal annual interest rate of $4.8\%$. The contract stipulates payment by equal annual instalments over $5$ years.
- a) Calculate the amount of the annual loan instalment.
- b) Prepare the first two rows of the amortisation schedule (indicating for each year: outstanding balance, interest, principal repaid, and instalment).
Calculate the Annual Percentage Rate (APR) of a bank loan advertised at $6 \%$ nominal annual interest with monthly compounding, given that the bank also charges an…
Calculate the Annual Percentage Rate (APR) of a bank loan advertised at $6 \%$ nominal annual interest with monthly compounding, given that the bank also charges an arrangement fee of $1.5 \%$ of the loan amount and a compulsory life insurance policy of $250$ € paid upfront. Assume the loan amount is $20,000$ € to be repaid in a single payment after one year.
How would this APR change if the loan amount were $50,000$ € under the same conditions? Explain why the APR depends on the requested amount in this case.
Finding the number of payments: logarithms
If you know the instalment and the capital but not the term, rearrange for $n$ by taking logarithms.
Lucas wants to buy an electric motorbike that costs $4,200$ €. In order not to deplete his savings, he decides to finance it at a nominal annual interest rate of $6\%$,…
Lucas wants to buy an electric motorbike that costs $4,200$ €. In order not to deplete his savings, he decides to finance it at a nominal annual interest rate of $6\%$, committing to pay monthly instalments of $120$ €.
- a) Use the loan repayment formula to calculate how many months it will take him to pay off the motorbike (you will need to use logarithms).
- b) If he decides to pay off the motorbike in exactly $3$ years, what should the fixed monthly instalment be?
A user finances an extraordinary purchase of $C_0 = 2,500$ € using a credit card in revolving mode with a nominal interest rate of $19.2\%$ per year (…
A user finances an extraordinary purchase of $C_0 = 2,500$ € using a credit card in revolving mode with a nominal interest rate of $19.2\%$ per year ($i = \frac{0.192}{12} = 0.016$ monthly). The card's advertisement claims: "Pay comfortably from just $35$ € a month".
- a) Try to formally determine the number of months $n$ required to pay off the debt with a monthly payment of $a = 35$ € by applying the formula $n = \frac{-\ln(1 - \frac{C_0 \times i}{a})}{\ln(1+i)}$. Explain the mathematical impossibility that arises when evaluating the argument of the logarithm and reason financially why, by comparing the payment with the interest accrued in one month ($C_0 \times i$), the debt would grow indefinitely instead of decreasing.
- b) Deduce what the theoretical minimum monthly payment is that would avoid generating additional debt, and calculate the fixed monthly payment that should be set to clear the loan within a reasonable term of $3$ years ($36$ months).
- c) If the cardholder chooses a fixed monthly payment of $60$ €, calculate the number of months $n$ it will take to pay off the debt (rounding up) and the total amount paid. Using these calculations, demonstrate why instalments set very close to the threshold $C_0 \times i$ lead to the financial phenomenon known as 'captive debt'.
Finding the initial capital or the final capital
Sometimes you know the instalment, the interest and the term, and what is missing is the capital (borrowed or saved).
Aoife is planning to attend a music festival when she finishes the Leaving Certificate in 3 years' time. To cover the expenses, she decides to open a youth savings…
Aoife is planning to attend a music festival when she finishes the Leaving Certificate in 3 years' time. To cover the expenses, she decides to open a youth savings account offering $3 \%$ annual compound interest. If she deposits $€250$ at the beginning of each year, what total capital will she have accumulated for her trip at the end of the three years?
A school e-sports club decides to save up to replace their chairs. They deposit $\text{€}\ 100$ at the beginning of each quarter into an account yielding $4 \%$ annual…
A school e-sports club decides to save up to replace their chairs. They deposit $\text{€}\ 100$ at the beginning of each quarter into an account yielding $4 \%$ annual compound interest. If compounding is quarterly ($n=4$ periods per year), calculate the capital they will have saved after one full year (4 deposits).
A family wishes to build up a savings fund for their child's university education. They plan to deposit $1,500$ € at the start of each year for the next $10$ years. The…
A family wishes to build up a savings fund for their child's university education. They plan to deposit $1,500$ € at the start of each year for the next $10$ years. The financial institution guarantees them a compound interest rate of $4.25\%$ per annum.
- a) What capital will they have accumulated right after making the tenth deposit?
- b) What capital will they have one year after the last deposit (at the end of the tenth year)?
Note: Take into account whether the annuity is due (in advance) or ordinary (in arrears).
A 22-year-old entrepreneur decides to plan her financial independence. Her goal is to have saved $100,000$ € by the time she turns 35. To do this, she sets up the…
A 22-year-old entrepreneur decides to plan her financial independence. Her goal is to have saved $100,000$ € by the time she turns 35. To do this, she sets up the following savings plan in an account with annual compound interest of $4.5 \%$:
-
During the first 5 years, she will make monthly contributions of $a$ euros at the beginning of each month.
-
During the next 8 years, she will increase her savings capacity and contribute $2a$ euros at the beginning of each month.
Calculate the value of the initial monthly payment $a$ needed to achieve her goal.
When the interest rate changes during the plan
If the rate changes part-way through a plan, split the plan into stages. Work out the value at the date of the change, then use that value as the starting capital for the next stage with the new rate.
A private investor wants to save $50,000$ € over a period of $8$ years. To do so, they will make quarterly deposits into a fund offering a nominal annual interest rate…
A private investor wants to save $50,000$ € over a period of $8$ years. To do so, they will make quarterly deposits into a fund offering a nominal annual interest rate of $3\%$.
- a) What is the applied quarterly interest rate?
- b) How much money must they deposit each quarter to achieve their goal?
- c) If after $4$ years the market interest rate rises to a nominal $4\%$ per annum, how will the quarterly deposit change for the remaining $4$ years to maintain the same final target?
Inflation and purchasing power
Prices usually rise over time, so €1 in the future buys less than €1 today. The CPI (Consumer Price Index) measures this, and the CSO publishes it. If prices rise by $f$ per year, the real value of an amount $M$ after $t$ years is $\dfrac{M}{(1+f)^t}$.
Topic challenge. Your emancipation plan: loan and inflation. Imagine that you start working and need to finance a second-hand vehicle for $6000$ €, analysing the real…
Topic challenge. Your emancipation plan: loan and inflation.
Imagine that you start working and need to finance a second-hand vehicle for $6000$ €, analysing the real impact of the cost of living. Prepare your financial proposal in a spreadsheet following these stages:
-
CPI and purchasing power: Check the annual CPI rate for the last $3$ years on the CSO website and construct its index numbers. If you start from a salary of $1300$ € that grows by $2.5$ % annually (geometric progression), deflate said salary to analyse whether you gain or lose real purchasing power.
-
Loan simulation: Search for the conditions of a consumer credit on the Central Bank of Ireland's consumer information portal (record the nominal interest rate and the APR). Design the $3$-year amortisation schedule using the French method with monthly payments, distinguishing between the principal and interest portions of each monthly instalment.
-
Final report: Write a reasoned proposal (1 page) evaluating the total financial cost against expected inflation, deciding whether the operation is viable.
Assessment criteria:
-
Rigorous collection of data from the CSO and correct calculation of rates, indices, and deflated real salary.
-
Mathematical accuracy in the spreadsheet when modelling the monthly instalment, APR, and amortisation schedule.
-
Clarity and critical judgment in the final report when justifying economic viability.