International Baccalaureate · DP 1: Applications and Interpretation HL
Loans and Annuities
I
Loans
A loan of \(\dollar 10\,000\) is taken out at an annual interest rate of \(5\pourcent\). The borrower agrees to make a regular repayment of \(\dollar 1\,000\) at the end of each year. How many repayments are needed to clear the loan?
Interest is calculated on the amount still owed (the balance) before the repayment reduces it.
The balance of the loan, year by year:
The interest amount decreases each year because the balance is getting smaller: more of each \(\dollar 1\,000\) repayment goes towards paying off the principal in the second year than in the first.
Continuing the table year by year, about \(\dollar 200.68\) is still owed after \(14\) repayments. With one more year of interest, a \(15\)th repayment of only about \(\dollar 210.72\) clears the loan: \(15\) repayments are needed, the last one smaller than the others.
Interest is calculated on the amount still owed (the balance) before the repayment reduces it.
The balance of the loan, year by year:
- After One Year:
- Interest charged: \(5\pourcent \text{ of } 10\,000 = 0.05 \times 10\,000 = \dollar 500\).
- Balance before payment: \(10\,000 + 500 = \dollar 10\,500\).
- Balance after payment: \(10\,500 - 1\,000 = \dollar 9\,500\).
- After Two Years:
- Interest charged (on the new balance): \(5\pourcent \text{ of } 9\,500 = 0.05 \times 9\,500 = \dollar 475\).
- Balance before payment: \(9\,500 + 475 = \dollar 9\,975\).
- Balance after payment: \(9\,975 - 1\,000 = \dollar 8\,975\).
| Year | Start Balance | Interest (\(5\pourcent\)) | Repayment | End Balance |
| 1 | \(\dollar 10\,000\) | \(\dollar 500\) | \(\dollar 1\,000\) | \(\dollar 9\,500\) |
| 2 | \(\dollar 9\,500\) | \(\dollar 475\) | \(\dollar 1\,000\) | \(\dollar 8\,975\) |
Continuing the table year by year, about \(\dollar 200.68\) is still owed after \(14\) repayments. With one more year of interest, a \(15\)th repayment of only about \(\dollar 210.72\) clears the loan: \(15\) repayments are needed, the last one smaller than the others.
Definition — Loan
A common way to finance large purchases like houses or cars is through a loan. The financial institution lends money to the borrower, who repays the amount plus interest through regular payments over a set period. This process is called amortisation.Interest is calculated on the reducing balance of the loan: interest is paid only on the amount still owed. Once the loan is repaid,$$\text{Interest paid} = \text{Total repayments} - \text{Principal}.$$ Before the end of the loan, the interest already paid is found from the outstanding balance.
Method — Calculating Loan Repayments with a TVM Solver
The solver signs each amount by the direction of the money, seen by the borrower: an amount is positive when the money comes to the borrower, and negative when it leaves the borrower.We can use the TVM Solver to calculate the regular payment amount (\(PMT\)) required to pay off a loan.
- \(N\): Total number of payments (\(N = \text{number of years} \times \text{payments per year}\)).
- \(I\pourcent\): Annual interest rate as a percentage.
- \(PV\): Present Value. This is the loan amount. The borrower receives this money, so it is positive.
- \(PMT\): Payment amount. The borrower pays it to the bank, so it is negative.
- \(FV\): Future Value. To pay off the loan completely, this should be \(\mathbf{0}\).
- \(P/Y\): Payments per Year (e.g., 12 for monthly).
- \(C/Y\): Compounding Periods per Year (usually the same as \(P/Y\)).
Example
Erica takes a personal loan of \(\dollar 16\,500\) to buy a car. The loan is for 4 years at \(5.5\pourcent\) p.a. compounded monthly. - Calculate her monthly repayment.
- Calculate the total amount she repays over the 4 years.
- Calculate the total interest she pays.
- Using the TVM Solver:
- \(N = 4 \times 12 = 48\)
- \(I\pourcent = 5.5\)
- \(PV = 16500\) (positive, money received)
- \(FV = 0\) (loan paid off)
- \(P/Y = 12\), \(C/Y = 12\)
- Total Repayment = Monthly Payment \(\times\) Total Months $$ 383.7318\ldots \times 48 \approx \dollar 18\,419.13 $$ (the unrounded payment is kept and the result rounded once, at the end; paying the rounded \(\dollar 383.73\) each month gives \(383.73 \times 48 = \dollar 18\,419.04\), the last payment then being about 10 cents larger to clear the loan).
- Total Interest = Total Repayment - Principal $$ 18\,419.128\ldots - 16\,500 \approx \dollar 1\,919.13 $$
Method — Finding the Outstanding Balance with a TVM Solver
The outstanding balance of a loan after \(k\) repayments is the amount still owed once the \(k\)-th repayment has been made. In examinations, as for most loans, repayments are made at the end of each period (the END setting of a calculator's solver). To find the balance with the TVM solver: - Find the repayment \(PMT\) of the whole loan, and keep it unrounded in the calculator's memory.
- Change \(N\) only: \(N = k\), the number of repayments already made, fewer than the total number of repayments. Keep \(I\pourcent\), \(PV\) (positive: money received), \(PMT\) (negative: money paid), \(P/Y\) and \(C/Y\).
- Solve for \(FV\). The solver returns a negative value, money the borrower still has to pay: the outstanding balance is \(|FV|\).
Example
Tomás borrows \(\dollar 24\,000\) to renovate his kitchen. The loan is repaid monthly over 5 years at \(6.6\pourcent\) p.a. compounded monthly. - Calculate the monthly repayment.
- Find the outstanding balance after 2 years.
- Calculate the interest Tomás has paid during these 2 years.
- After \(40\pourcent\) of the term, which percentage of the loan does Tomás still owe? Explain why it is more than \(60\pourcent\).
- TVM solver with \(N = 5 \times 12 = 60\), \(I\pourcent = 6.6\), \(PV = 24\,000\) (money received), \(FV = 0\) (loan repaid), \(P/Y = C/Y = 12\). Solving for \(PMT\): $$PMT = -470.7125\ldots$$ The monthly repayment is \(\dollar 470.71\).
- Same entries, \(PMT = -470.7125\ldots\) kept in memory, and \(N = 2 \times 12 = 24\). Solving for \(FV\): $$FV = -15\,335.383\ldots$$ The outstanding balance after 2 years is \(\dollar 15\,335.38\).
- Over the first \(k = 24\) repayments: $$\begin{aligned}[t] \text{Interest paid} &= k \times |PMT| - \left(PV - |FV|\right) && \text{(interest paid over the first \(k\) repayments)}\\ &= 24 \times 470.7125\ldots - (24\,000 - 15\,335.383\ldots)\\ &= 11\,297.100\ldots - 8\,664.616\ldots\\ &\approx \dollar 2\,632.48. \end{aligned}$$
- \(\dfrac{15\,335.38}{24\,000} \approx 0.639\): after \(40\pourcent\) of the term, Tomás still owes about \(63.9\pourcent\) of the loan. Each repayment first pays the interest of the month, computed on the balance, and only the rest reduces the debt. In the first month the interest is \(24\,000 \times \frac{0.066}{12} = \dollar 132\), so only \(470.71 - 132 = \dollar 338.71\) of the repayment reduces the debt. While the balance is large the interest part is large: the debt falls slowly at first, then faster.
Proposition — Balance of a Loan after k Repayments
A loan of amount \(P\) is charged interest at the rate \(i > 0\) per period and repaid by equal repayments \(R\), each made at the end of a period. The outstanding balance after \(k\) repayments, for \(k\) from \(0\) up to the last repayment, is $$B_k = P(1+i)^k - R \times \frac{(1+i)^k - 1}{i}.$$ The loan is repaid by \(n\) repayments exactly when \(B_n = 0\), that is when $$R = \frac{P \times i \times (1+i)^n}{(1+i)^n - 1}.$$ A TVM solver computes its values from this same relation, with \(P = PV\), \(R = |PMT|\), \(n = N\) and \(i = \dfrac{I\pourcent}{100 \times C/Y}\).
During each period the balance grows by its interest, then the repayment is subtracted: \(B_0 = P\) and \(B_{j+1} = B_j(1+i) - R\) for every whole number \(j \geq 0\). The first balances are $$\begin{aligned}[t] B_1 &= P(1+i) - R\\
B_2 &= B_1(1+i) - R = P(1+i)^2 - R(1+i) - R\\
B_3 &= B_2(1+i) - R = P(1+i)^3 - R(1+i)^2 - R(1+i) - R, \end{aligned}$$ which suggests, after \(k\) periods, a bracket that is the sum of the first \(k\) terms of the geometric sequence with first term \(1\) and ratio \(1+i \neq 1\): $$\begin{aligned}[t] B_k &= P(1+i)^k - R\left[1 + (1+i) + \cdots + (1+i)^{k-1}\right]\\
&= P(1+i)^k - R \times \frac{1 - (1+i)^k}{1 - (1+i)} && \text{(sum of a geometric sequence)}\\
&= P(1+i)^k - R \times \frac{(1+i)^k - 1}{i}. \end{aligned}$$ This formula holds for every whole number \(k\), by induction. For \(k = 0\) it gives \(B_0 = P - R \times 0 = P\). If it holds for \(B_j\), then $$\begin{aligned}[t] B_{j+1} &= B_j(1+i) - R\\
&= P(1+i)^{j+1} - R \times \frac{(1+i)^{j+1} - (1+i)}{i} - R\\
&= P(1+i)^{j+1} - R \times \frac{(1+i)^{j+1} - (1+i) + i}{i}\\
&= P(1+i)^{j+1} - R \times \frac{(1+i)^{j+1} - 1}{i}, \end{aligned}$$ which is the formula for \(B_{j+1}\). The loan is repaid after \(n\) repayments when \(B_n = 0\): $$\begin{aligned}[t] P(1+i)^n &= R \times \frac{(1+i)^n - 1}{i}\\
R &= \frac{P \times i \times (1+i)^n}{(1+i)^n - 1} && \text{(multiplying both sides by \(\tfrac{i}{(1+i)^n - 1} > 0\), since \(i > 0\))}. \end{aligned}$$
Skills to practice
- Reading a Loan in the Solver
- Calculating Repayments and Interest
- Finding an Outstanding Balance
- Investigating Loan Repayments
II
Annuities
A retired person has saved \(\dollar 300\,000\) and puts this money into an account that earns \(5\pourcent\) interest compounded annually. The plan is to withdraw \(\dollar 25\,000\) at the end of each year to live on. How long will the money last?
The savings, year by year:
Because more is withdrawn each year (\(\dollar 25\,000\)) than the interest earned (\(\dollar 15\,000\) in the first year), the balance decreases, and the interest with it.
Continuing the table year by year, about \(\dollar 18\,676.15\) is left after \(18\) withdrawals. With one more year of interest, a \(19\)th withdrawal of only about \(\dollar 19\,609.96\) empties the account: the money lasts \(19\) years, the last withdrawal smaller than the others. This is how an annuity works.
The savings, year by year:
- After One Year:
- Interest earned: \(5\pourcent \text{ of } 300\,000 = 0.05 \times 300\,000 = \dollar 15\,000\).
- Balance before withdrawal: \(300\,000 + 15\,000 = \dollar 315\,000\).
- Balance after withdrawal: \(315\,000 - 25\,000 = \dollar 290\,000\).
- After Two Years:
- Interest earned (on the new balance): \(5\pourcent \text{ of } 290\,000 = 0.05 \times 290\,000 = \dollar 14\,500\).
- Balance before withdrawal: \(290\,000 + 14\,500 = \dollar 304\,500\).
- Balance after withdrawal: \(304\,500 - 25\,000 = \dollar 279\,500\).
| Year | Start Balance | Interest (\(5\pourcent\)) | Withdrawal | End Balance |
| 1 | \(\dollar 300\,000\) | \(\dollar 15\,000\) | \(\dollar 25\,000\) | \(\dollar 290\,000\) |
| 2 | \(\dollar 290\,000\) | \(\dollar 14\,500\) | \(\dollar 25\,000\) | \(\dollar 279\,500\) |
Continuing the table year by year, about \(\dollar 18\,676.15\) is left after \(18\) withdrawals. With one more year of interest, a \(19\)th withdrawal of only about \(\dollar 19\,609.96\) empties the account: the money lasts \(19\) years, the last withdrawal smaller than the others. This is how an annuity works.
Definition — Annuity
An annuity is essentially the reverse of a loan. Instead of borrowing a lump sum and paying it back, an individual deposits a lump sum into an account and then makes regular withdrawals over a fixed period. The remaining balance in the account continues to earn interest.This is commonly used for retirement: a person saves during their working life, then transfers that lump sum into an annuity to provide a regular income.
Method — Calculating Annuities with a TVM Solver
When performing annuity calculations, the amounts are signed by the direction of the money, seen by the investor: - \(PV\): The lump sum initially deposited. The investor puts this money into the account, so it leaves the investor: it is entered as negative.
- \(PMT\): The regular withdrawal amount. The investor receives this money, so it is positive.
- \(FV\): The amount remaining in the account at the end. Usually, we calculate how long the money lasts until it runs out, so \(FV = 0\).
Example
Heather retires at age 65 with \(\dollar 900\,000\) in her savings fund. She transfers this money into an annuity fund earning \(4\pourcent\) p.a. compounded monthly. She wants to withdraw \(\dollar 5\,400\) per month to live on.How long will her money last? Give your answer in years and months.
Using the TVM Solver:
- \(I\pourcent = 4\)
- \(PV = -900000\) (money invested)
- \(PMT = 5400\) (monthly income)
- \(FV = 0\) (money runs out)
- \(P/Y = 12\), \(C/Y = 12\)
Method — Finding the Capital Needed and the Duration of an Annuity
The entries are those of annuity calculations: the deposit is \(PV\) (negative), each withdrawal is \(PMT\) (positive), made at the end of each period. - Capital needed: to withdraw a given \(PMT\) during \(N\) periods until the fund is empty (\(FV = 0\)), solve for \(PV\). The capital to deposit is \(|PV|\).
- Duration: for a given deposit and a given withdrawal, with \(FV = 0\), solve for \(N\). The fund runs out only if the withdrawal is larger than the interest of the first period; otherwise the balance never decreases and \(N\) does not exist. When \(N\) is not a whole number, the last withdrawal is smaller than the others: the money runs out at withdrawal number \(N\) rounded up. Convert this number of periods into years and months. With a solver that does not solve for \(N\), compute \(FV\) for whole values of \(N\): the money runs out at the first \(N\) for which \(FV\) is negative or zero.
- Balance: after \(k\) withdrawals, set \(N = k\) and solve for \(FV\) (as for the outstanding balance of a loan): \(FV\) is the money still in the fund.
Example
Aiko plans to retire at 62. She wants an annuity that pays her \(\dollar 3\,800\) at the end of every month for 25 years, from a fund earning \(4.2\pourcent\) p.a. compounded monthly. - Calculate the capital Aiko must deposit in the fund when she retires.
- Find the amount left in the fund after 10 years of withdrawals.
- Compare the total amount withdrawn with the capital deposited, and interpret the difference.
- If Aiko can deposit only \(\dollar 600\,000\), how long will withdrawals of \(\dollar 3\,800\) per month last? Give the answer in years and months.
- TVM solver with \(N = 25 \times 12 = 300\), \(I\pourcent = 4.2\), \(PMT = 3\,800\) (money received), \(FV = 0\) (fund empty at the end), \(P/Y = C/Y = 12\). Solving for \(PV\): $$PV = -705\,084.732\ldots$$ Aiko must deposit \(\dollar 705\,084.73\).
- Same entries, \(PV = -705\,084.732\ldots\) kept in memory, and \(N = 10 \times 12 = 120\). Solving for \(FV\): $$FV = 506\,835.380\ldots$$ About \(\dollar 506\,835.38\) is left in the fund after 10 years.
- Aiko withdraws $$\begin{aligned}[t] \text{Total withdrawn} &= N \times PMT\\ &= 300 \times 3\,800\\ &= \dollar 1\,140\,000, \end{aligned}$$ so the withdrawals exceed the deposit by $$\begin{aligned}[t] \text{Total withdrawn} - |PV| &= 1\,140\,000 - 705\,084.732\ldots\\ &\approx \dollar 434\,915.27. \end{aligned}$$ This difference is the interest earned by the money while it waits in the fund: the fund pays out far more than it received, because the balance keeps earning interest until the last withdrawal.
- The first month's interest is \(600\,000 \times \frac{0.042}{12} = \dollar 2\,100 < \dollar 3\,800\), so the fund does run out. TVM solver with \(I\pourcent = 4.2\), \(PV = -600\,000\), \(PMT = 3\,800\), \(FV = 0\), \(P/Y = C/Y = 12\), solving for \(N\): $$N = 230.222\ldots$$ (Without an \(N\) solve: \(FV \approx 844.67 > 0\) for \(N = 230\) and \(FV \approx -2\,952.37 < 0\) for \(N = 231\).) \(N\) is not a whole number: after \(230\) withdrawals about \(\dollar 845\) is left; with one more month of interest it is paid out as a smaller \(231\)st withdrawal, of about \(\dollar 848\). The money lasts \(231\) months, that is \(19\) years and \(3\) months (\(231 = 19 \times 12 + 3\)).
Skills to practice
- Reading an Annuity in the Solver
- Calculating with Annuities
- Investigating Annuities
III
Going further
Skills to practice
- Solving Problems on Loans and Annuities
- Quiz
Jump to section