Often an investor will make a regular payment to contribute to the growth of the investment. Tables and recursive rules are useful for more complex finance problems, such as a compound interest investment with regular deposits, or a reducing balance loan with regular payments. Investments involving compound interest are often displayed in a table of values so that the growth in the value of the investment can be clearly seen.
For a principal investment/loan, $P$P, at the compound interest rate of $r$r per period and payment $d$d per period, the sequence of the value of the investment over time forms a first order linear recurrence.
The sequence which generates the value, $V_n$Vn, of the investment/loan at the end of each instalment period is:
$V_n=V_{n-1}\times(1+r)+d$Vn=Vn−1×(1+r)+d, where $V_0=P$V0=P
$V_n=V_{n-1}\times(1+r)+d$Vn=Vn−1×(1+r)+d, where $V_1=P$V1=P
Fiona invests $\$14000$$14000 in an investment account that compounds annually. To further grow the investment she also makes a regular contribution of $\$2000$$2000 per year. The progression of the investment is shown in the table below.
Year | Account balance at start of year ($) |
Interest ($) | Payment ($) | Account balance at end of year ($) |
---|---|---|---|---|
1 | $14000$14000 | $350$350 | $2000$2000 | $16350$16350 |
2 | $16350$16350 | $408.75$408.75 | $2000$2000 | $18758.75$18758.75 |
3 | $18758.75$18758.75 | $468.97$468.97 | $2000$2000 | $21227.72$21227.72 |
(a) Determine the interest rate for the investment.
Think: We can use any of the table rows to do this. Use the formula
$\text{interest rate }=\frac{\text{amount of interest in year n}}{\text{account balance start of year n }}\times100$interest rate =amount of interest in year naccount balance start of year n ×100%
Do: Using the figures from Year 1 we find:
Rate | $=$= | $\frac{350}{14000}$35014000 |
$=$= | $0.025$0.025 | |
$=$= | $2.5%$2.5% |
Reflect: We can check we obtain the same result using the values from Year 2 or Year 3.
(b) Write a recursive rule for $V_n$Vn in terms of $V_{n−1}$Vn−1 that gives the value of the account after $n$n years and an initial condition $V_0$V0.
Think: Using the sequence which generates the value, $V_n$Vn, of the investment at the end of each instalment, $V_n=V_{n-1}\times(1+r)+d$Vn=Vn−1×(1+r)+d, where $V_0=P$V0=P. We have an initial investment of $V_0=14000$V0=14000, a regular deposit of $d=2000$d=2000 and the rate we found in part (a) to be $r=2.5%$r=2.5%.
Do:
$V_n=V_{n-1}\times(1+0.025)+2000$Vn=Vn−1×(1+0.025)+2000, where $V_0=14000$V0=14000.
Select the brand of calculator you use below to work through an example involving compound interest investments with regular payments using sequences.
Casio Classpad
How to use the CASIO Classpad to complete the following tasks involving sequences in a compound investment context with a regular payment.
Nadia opens an account to help her save for a motorcycle. She opens the account with an initial deposit of $\$4000$$4000 that is compounded monthly at a rate of $3.5%$3.5% per annum. She makes further deposits of $\$250$$250 at the end of each month.
Using a recursive relationship, generate the value of the investment at the end of each month for the first $6$6 months.
Find the balance in the account at the end of $1$1 year.
If the motorcycle costs $\$11500$$11500, at the end of which month will Nadia have enough saved to buy it?
TI Nspire
How to use the TI Nspire to complete the following tasks involving sequences in a compound investment context with a regular payment.
Nadia opens an account to help her save for a motorcycle. She opens the account with an initial deposit of $\$4000$$4000 that is compounded monthly at a rate of $3.5%$3.5% per annum. She makes further deposits of $\$250$$250 at the end of each month.
Using a recursive relationship, generate the value of the investment at the end of each month for the first $6$6 months.
Find the balance in the account at the end of $1$1 year.
If the motorcycle costs $\$11500$$11500, at the end of which month will Nadia have enough saved to buy it?
Jenny is saving for a European holiday which will cost $\$15000$$15000. She puts the $\$5000$$5000 she has already saved in a savings account which offers interest compounded quarterly. She also makes a quarterly contribution of $\$350$$350, at the end of each quarter.
The progression of the investment is shown in the table below.
Quarter | Account balance at start of quarter ($\$\quad$$ ) | Interest ($\$\quad$$ ) | Payment ($\$\quad$$ ) | Account balance at end of quarter ($\$\quad$$ ) |
---|---|---|---|---|
$1$1 | $5000$5000 | $46.88$46.88 | $350$350 | $5396.88$5396.88 |
$2$2 | $5396.88$5396.88 | $50.60$50.60 | $350$350 | $5797.48$5797.48 |
$3$3 | $5797.48$5797.48 | $A$A | $350$350 | $B$B |
Find the interest rate per quarter for this account, as a percentage to four decimal places.
Calculate the value of $A$A in dollars.
Round your answer to the nearest cent.
Calculate the value of $B$B in dollars.
Round your answer to the nearest cent.
Write a recursive rule, $T_{n+1}$Tn+1, in terms of $T_n$Tn that gives the balance in the account at the beginning of the $\left(n+1\right)$(n+1)th quarter.
$T_{n+1}=$Tn+1=$\editable{}$$\times T_n+$×Tn+$\editable{}$
$T_1=$T1=$\editable{}$
Using your calculator, how many whole quarters will it take to until she has enough money to go on the holiday?
If she changes the payment to $\$400$$400 per quarter, how much sooner, in whole quarters, will she be able to go on holidays?
A graphics or CAS calculator is a powerful tool for financial problems when used correctly. The examples above can also be answered using the financial application.
Select the brand of calculator you use below to work through an example involving compound interest investments with regular payments using the financial application.
Casio Classpad
How to use the CASIO Classpad to complete the following tasks using the inbuilt financial solver.
Consider an investment of $\$1500$$1500 at $4.5%$4.5% p.a. compounded monthly. With additional regular payments of $\$40$$40 per month.
Find the value of the investment after $3$3 years.
Find the interest earned by the investment in the first $2$2 years.
Calculate the number of whole months it will take until the investment doubles.
What payment would be required for the investment to double at the end of $2$2 years?
TI Nspire
How to use the TI Nspire to complete the following tasks using the inbuilt financial solver.
Consider an investment of $\$1500$$1500 at $4.5%$4.5% p.a. compounded monthly. With additional regular payments of $\$40$$40 per month.
Find the value of the investment after $3$3 years.
Find the interest earned by the investment in the first $2$2 years.
Calculate the number of whole months it will take until the investment doubles.
What payment would be required for the investment to double at the end of $2$2 years?
Valerie is saving for a European holiday which will cost $\$20000$$20000. She puts the $\$8000$$8000 she has already saved in a savings account which offers $3.75%$3.75% p.a compounded quarterly. She also makes a quarterly contribution of $\$400$$400. Valerie is interested in finding how long it will take her to save up for her holiday.
If $N$N is the number of payments, complete the table of values showing the variables required to use a financial solver to solve this problem.
Variable | Value |
---|---|
$N$N | - |
$I\left(%\right)$I(%) | $\editable{}$$%$% |
$PV$PV | $\editable{}$ |
$Pmt$Pmt | $\editable{}$ |
$FV$FV | $\editable{}$ |
$P/Y$P/Y | $\editable{}$ |
$C/Y$C/Y | $\editable{}$ |
Determine the number of whole quarters it will take for Valerie to save the $\$20000$$20000 required for the holiday.
An investor deposits $\$20000$$20000 into a high earning account with interest of $4.5%$4.5% p.a. compounded weekly and makes $\$150$$150 weekly deposits into the account.
If $N$N is the number of payments, complete the table of values showing the variables required to use a financial solver to determine how long it takes for the original investment to double in value.
Assume there are $52$52 weeks in a year.
Variable | Value |
---|---|
$N$N | - |
$I\left(%\right)$I(%) | $\editable{}$$%$% |
$PV$PV | $\editable{}$ |
$Pmt$Pmt | $\editable{}$ |
$FV$FV | $\editable{}$ |
$P/Y$P/Y | $\editable{}$ |
$C/Y$C/Y | $\editable{}$ |
Calculate the number of whole weeks it will take for the investment to double.
How much should the investor deposit each week in dollars if they want the original investment to double at the end of three years?
Again, assume there are $52$52 weeks in a year.
Round your answer to the nearest cent.
Let's explore this interactive compound interest spreadsheet. When we explore different options with a financial problem we call it "what if analysis".
You can change the amount invested (the blue cell) to any value you'd like to invest.
You can change the annual interest rate (the green cell) to any value.
You can change the number of compounding periods (the pink cell) to quarterly ($4$4), monthly ($12$12), weekly ($52$52) or perhaps daily ($365$365).
Spreadsheets can also include payment details and are a useful tool for solving financial problems as the progression of the investment can be clearly seen as well as the effect of changing interest rates and payments.
Thomas needs $\$17000$$17000 for a house deposit. He invests $\$10000$$10000 in the bank with an interest rate of $8%$8% p.a. compounded monthly and also makes a payment of $\$150$$150 per month. He creates the following spreadsheet to help him do "what if analysis" to examine the problem.
Some of the formulae Thomas used to create this spreadsheet are shown in the table below.
A | B | C | D | E | |
---|---|---|---|---|---|
5 | Month | Balance start | Interest | Payment | Balance end |
6 | 1 | =B1 | =$B$2/12*B6 | =$B$3 | =B6+C6+D6 |
7 | =A6+1 | =E6 | |||
8 |
Note:
(a) What is the purpose of the formula in cell C6?
Think: Ignore the $ signs. The formula is =B2/12 * B6
Do: Write that it calculates the amount of monthly interest by taking the yearly interest rate (cell B2) and dividing by $12$12 then multiplying by the amount at the start of the month (cell B6).
(b) What would the formula in cell C6 be if the interest was to be compounded quarterly instead of monthly?
Think: We would divide the yearly rate by four instead of dividing by twelve.
Do: Write the formula would be =$B$2/4*B6 or =B2/4*B6 (without an absolute reference).
(c) What is the purpose of the formula in cell E6?
Think: The formula is =B6+C6+D6 so it is added three values together.
Do: Write that it calculates the balance at the end of the month by calculating start balance + interest + payment
(d) Write the formula that will be in cell E7.
Think: This will be the start amount + interest + payment for row 7
Do: Write the formula is =B7+C7+D7
(e) What is the purpose of the formula in cell B7?
Think: The formula is =E6 and E6 contains the amount at the end of month 1.
Do: Write that it copies the balance at the end of month 1, to the start of month 2.
(f) Use Microsoft Excel, Google Sheets or your CAS calculator to create this spreadsheet. How long does it take Thomas to save the $\$17000$$17000?
Reflect: The spreadsheet should show that it takes him $30$30 months to save the money.
The spreadsheet below shows the first year of an investment with regular deposits.
$A$A | $B$B | $C$C | $D$D | $E$E | |
$1$1 | Year | Beginning Balance | Interest | Deposit | End Balance |
$2$2 | $1$1 | $6000$6000 | $660$660 | $500$500 | $7160$7160 |
$3$3 | |||||
$4$4 | |||||
$5$5 |
Calculate the annual interest rate for this investment.
Write a formula for cell $B$B$3$3.
Enter only one letter or number per box.
$B$B$3$3 $=$= $\editable{}$$\editable{}$
Write a formula for cell $C$C$6$6 in terms of $B$B$6$6.
Enter one letter or a number per box.
$C$C$6$6 $=$= $\editable{}$$\ast$∗$\editable{}$$\editable{}$
Which of the following is the correct formula for cell $E$E$5$5?
$B$B $5$5 $\ast$∗ $C$C $5$5 $+$+ $D$D $5$5
$B$B $5$5 $+$+ $C$C $5$5 $-$− $D$D $5$5
$B$B $5$5 $+$+ $C$C $5$5 $+$+ $D$D $5$5
$B$B $5$5 $+$+ $C$C $5$5 $\ast$∗ $D$D $5$5
$B$B $5$5 $\ast$∗ $C$C $5$5 $\ast$∗ $D$D $5$5
$B$B $5$5 $-$− $C$C $5$5 $-$− $D$D $5$5
Use technology to reproduce this spreadsheet and determine the end balance for the $4$4th year.
Calculate the total interest earned over these $4$4 years.
use a recurrence relation to model an annuity, and investigate (numerically or graphically) the effect of the amount invested, the interest rate, and the payment amount on the duration of the annuity
with the aid of a financial calculator or computer-based financial software, solve problems involving annuities (including perpetuities as a special case); for example, determining the amount to be invested in an annuity to provide a regular monthly income of a certain amount