topic badge

5.06 Investigating annuities using tables

Worksheet
Financial tables for loans and savings
1

The following financial table displays the annual repayments on a \$1000 loan:

\text{Annual interest rate}10 \\ \text{years}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}30 \\ \text{years}
5\%129.5096.3480.2470.9565.05
6\%135.87102.9687.1878.2372.65
7\%142.38109.7994.3985.8180.59
8\%149.03116.83101.8593.6888.83
9\%155.82124.06109.55101.8197.34
10\%162.75131.47117.46110.17106.08

Calculate the annual installments needed to pay off a \$110\,000 home loan at 7\% p.a. reducible interest if the installments are to be paid in equal amounts over 15 years.

2

The following financial table displays the monthly repayments on a \$1000 loan:

\text{Annual interest rate}10 \\ \text{years}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}30 \\ \text{years}
3\%9.666.915.554.744.22
4\%10.127.406.065.284.77
5\%10.617.916.605.855.37
6\%11.108.447.166.446.00
7\%11.618.997.757.076.65
8\%12.179.568.367.727.38

Calculate the monthly instalments required to pay off a 25-year loan of \$1000 at 4\% p.a. monthly reducible interest.

3

The following financial table displays the monthly instalments required to save \$1000:

\text{Annual interest rate}5 \\ \text{years}10 \\ \text{years}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}
1\%16.267.935.153.772.94
2\%15.867.534.773.392.57
3\%15.477.164.413.052.24
4\%15.086.794.062.731.95
5\%14.706.443.742.431.68
6\%14.336.103.442.161.44

Calculate the monthly instalments required to save \$50\,000 in 15 years if the savings account earns 3\% interest per annum, compounded monthly.

4

The following financial table displays the monthly repayments on a \$1000 loan:

\text{Annual interest rate}10 \\ \text{years}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}30 \\ \text{years}
5\%10.617.916.605.855.37
6\%11.108.447.166.446.00
7\%11.618.997.757.076.65
8\%12.139.568.367.727.34
9\%12.6710.149.008.398.05
10\%13.2210.759.659.098.78

Calculate the monthly instalments required to pay off a 15-year loan of \$200\,000 at 7\% p.a. monthly reducible interest.

5

The following financial table displays the monthly repayments on a \$1000 loan:

\text{Annual interest rate}5 \\ \text{years}10 \\ \text{years}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}
3\%17.979.666.915.554.74
4\%18.4210.127.406.065.28
5\%18.8710.617.916.605.85
6\%19.3311.108.447.166.44
7\%19.8011.618.997.757.07
8\%20.2812.139.568.367.72

Amelia received a 5-year \$120\,000 loan at 3\% p.a. monthly reducible interest. Find:

a

The amount of each monthly instalment.

b

The total repayments.

c

The interest on the loan.

d

The total interest as a percentage of the principal loan, correct to two decimal places.

6

The following financial table displays the monthly instalments required to save \$1000:

\text{Annual interest rate}10 \\ \text{years}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}30 \\ \text{years}
3\%7.164.413.052.241.72
4\%6.794.062.731.951.44
5\%6.443.742.431.681.20
6\%6.103.442.161.441.00
7\%5.783.151.921.230.82
8\%5.472.891.701.050.67

The interest rate on a savings account is 4\% per annum, compounded monthly. Vincent can afford to save \$300 per month. How long will it take him to save \$143\,000?

7

The following financial table displays the monthly repayments on a \$1000 loan:

\text{Annual interest rate}5 \\ \text{years}10 \\ \text{years}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}
4\%18.4210.127.406.065.28
5\%18.8710.617.916.605.85
6\%19.3311.108.447.166.44
7\%19.8011.618.997.757.07
8\%20.2812.139.568.367.72
9\%20.7612.6710.149.008.39

Luke received a 5-year loan at 4\% p.a. monthly reducible interest. His total repayments were \$221\,040.

a

Calculate the amount of each monthly instalment.

b

Find the amount of the loan.

8

The following financial table displays the monthly repayments on a \$1000 loan:

\text{Annual interest rate}20 \\ \text{years}25 \\ \text{years}30 \\ \text{years}35 \\ \text{years}40 \\ \text{years}
3\%5.554.744.223.853.58
4\%6.065.284.774.434.18
5\%6.605.855.375.054.82
6\%7.166.446.005.705.50
7\%7.757.076.656.396.21
8\%8.367.727.347.106.95

Han received a 25-year \$71\,000 loan at 5\% p.a. monthly reducible interest. If the term of the loan was reduced to 20 years, calculate:

a

The size of the monthly instalment when the term of the loan is 25 years.

b

The total amount repaid over 25 years.

c

The interest paid over 25 years.

d

The total amount repaid over a reduced term of 20 years.

e

The interest paid over the 20-year term.

f

The interest saved from a 5-year reduction in the term of the loan.

9

The following financial table displays the monthly instalments required to save \$1000:

\text{Annual interest rate}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}30 \\ \text{years}35 \\ \text{years}
1\%5.153.772.942.381.99
2\%4.773.392.572.031.65
3\%4.413.052.241.721.35
4\%4.062.731.951.441.09
5\%3.742.431.681.200.88
6\%3.442.161.441.000.70
a

Calculate the monthly instalments required to save \$110\,000 in 30 years if the savings account earns 5\% interest per annum, compounded monthly.

b

If instead of making consistent payments to an annuity, a single deposit was made into the same account at the start of the investment, how much must be invested in order to end up with \$110\,000 after 30 years?

10

The following financial table displays the monthly repayments on a \$1000 loan:

\text{Annual interest rate}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}30 \\ \text{years}35 \\ \text{years}
2\%6.445.064.243.703.31
3\%6.915.554.744.223.85
4\%7.406.065.284.774.43
5\%7.916.605.855.375.05
6\%8.447.166.446.005.70
7\%8.997.757.076.656.39

Mae received a 30-year \$89\,000 loan at 2\% p.a. monthly reducible interest. If the term of the loan was reduced to 25 years, calculate:

a

The amount of each monthly instalment over a 30-year term.

b

The monthly instalment needed for a 25-year term.

c

The amount saved, from this 5-year reduction in the term of the loan.

11

The following financial table displays the monthly repayments on a \$1000 loan:

\text{Annual interest rate}10 \\ \text{years}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}30 \\ \text{years}
4\%10.127.406.065.284.77
5\%10.617.916.605.855.37
6\%11.108.447.166.446.00
7\%11.618.997.757.076.65
8\%12.139.568.367.727.34
9\%12.6710.149.008.398.05

Neil received a 10-year \$130\,000 loan at 6\% p.a. monthly reducible interest. If the interest rate was increased to 7\% p.a., find the increase in the total repayments needed to clear the debt.

12

The following financial table displays the monthly repayments on a \$1000 loan:

\text{Annual interest rate}15 \\ \text{years}20 \\ \text{years}25 \\ \text{years}30 \\ \text{years}35 \\ \text{years}
3\%6.915.554.744.223.85
4\%7.406.065.284.774.43
5\%7.916.605.855.375.05
6\%8.447.166.446.005.70
7\%8.997.757.076.656.39
8\%9.568.367.727.347.10

Mae received a 15-year \$60\,000 loan at 6\% p.a. monthly reducible interest. If the interest rate fell to 5\% p.a., find the decrease in the total repayments needed to clear the debt.

Future value interest factor tables
13

Use the table to find the future value of an annuity in which \$6000 is invested every year for 4 years at 15\% p.a. with interest compounded annually.

\text{Period}11\% \\ \text{per year}12\% \\ \text{per year}13\% \\ \text{per year}14\% \\ \text{per year}15\% \\ \text{per year}
00.00000.00000.00000.00000.0000
11.00001.00001.00001.00001.0000
22.11002.12002.13002.14002.1500
33.34213.37443.40693.43963.4725
44.70974.77934.84984.92114.9934
56.22786.35286.48036.61016.7424
14

Use the table to find the interest generated on an annuity in which \$3100 is invested every year for 7 years at 15\% p.a. with interest compounded annually.

\text{Period}14.5\% \\ \text{per year}15\% \\ \text{per year}15.5\% \\ \text{per year}16\% \\ \text{per year}16.5\% \\ \text{per year}
33.45603.47253.48903.50563.5222
44.95714.99345.02985.06655.1034
56.67596.74246.80946.87716.9455
68.64398.75378.86498.97759.0915
710.897311.066811.239011.413911.5915
813.477413.726813.981014.240114.5041
15

Use the table to find the future value of an annuity in which \$2500 is invested every 3 months for 5 years at 15\% p.a. with interest compounded quarterly.

\text{Period}2.75\% \\ \text{per quarter}3.25\% \\ \text{per quarter}3.75\% \\ \text{per quarter}4.25\% \\ \text{per quarter}4.75\% \\ \text{per quarter}
2026.197427.564229.017430.562532.2056
2127.917829.460131.105532.861434.7354
2229.685631.417533.272035.258037.3853
2331.501933.438635.519737.756540.1611
2433.368235.525437.851740.361143.0688
2535.285837.679940.271143.076546.1146
16

Use the table to find the interest generated on an annuity in which \$2700 is invested every 3 months for 2 years at 9\% p.a. with interest compounded quarterly.

\text{Period}2.25\% \\ \text{per quarter}2.75\% \\ \text{per quarter}3.25\% \\ \text{per quarter}3.75\% \\ \text{per quarter}4.25\% \\ \text{per quarter}
88.65928.81388.97169.13269.2967
99.854010.056210.263210.475010.6918
1011.075711.332811.596711.867812.1462
1112.324912.644412.973613.312913.6624
1213.602213.992114.395314.812115.2431
1314.908315.376915.863116.367616.8909
17

Han is hoping to save up \$18\,347 for when he retires in 12 years. In order to achieve this goal, he deposits \$10 into his superannuation fund every week. The fund generates an average return of 15.6\% p.a., compounded weekly.

\text{Period}0.2\% \\ \text{per week}0.3\% \\ \text{per week}0.4\% \\ \text{per week}0.5\% \\ \text{per week}0.6\% \\ \text{per week}
6201225.66841801.95842720.58484205.42986634.7095
6211229.11981808.36432732.46714227.45696675.5178
6221232.57801814.78942744.39704249.59426716.5709
6231236.04321821.23372756.37464271.84226757.8703
6241239.51521827.69742768.40014294.20146799.4175
6251242.99431834.18052780.47374316.67246841.2140
a

Using the table of future value interest factors, how much will Han have saved up by the time he retires?

b

Will he reach his savings goal?

18

Use the table to find the contribution Mae needs to deposit into her savings account every 3 months, which pays 12\% p.a. with interest compounded quarterly, in order to reach her savings goal of \$42576 in 3 years. Round your answer to the nearest dollar.

\text{Period}2\% \\ \text{per quarter}2.5\% \\ \text{per quarter}3\% \\ \text{per quarter}3.5\% \\ \text{per quarter}4\% \\ \text{per quarter}
1010.949711.203411.463911.731412.0061
1112.168712.483512.807813.142013.4864
1213.412113.795614.192014.602015.0258
1314.680315.140415.617816.113016.6268
1415.973916.519017.086317.677018.2919
1517.293417.931918.598919.295720.0236
Present value interest factor tables
19

Use the table to find the present value of an annuity in which \$7000 is invested every year for 9 years at 3\% p.a. with interest compounded annually.

\text{Period}1\% \\ \text{per year}1.5\% \\ \text{per year}2\% \\ \text{per year}2.5\% \\ \text{per year}3\% \\ \text{per year}
87.65177.48597.32557.17017.0197
98.56608.36058.16227.97097.7861
109.47139.22228.98268.75218.5302
1110.367610.07119.78689.51429.2526
1211.255110.907510.575310.25789.9540
1312.133711.731511.348410.983210.6350
20

Use the table to find the present value of an annuity in which \$2800 is invested every 6 months for 7 years at 12\% p.a. with interest compounded semi-annually.

\text{Period}5.5\% \\ \text{per 6 months}6\% \\ \text{per 6 months}6.5\% \\ \text{per 6 months}7\% \\ \text{per 6 months}7.5\% \\ \text{per 6 months}
118.09257.88697.68907.49877.3154
128.61858.38388.15877.94277.7353
139.11718.85278.59978.35778.1258
149.58969.29509.01388.74558.4892
1510.03769.71229.40279.10798.8271
1610.462210.10599.76789.44669.1415
21

Use the table to find the contribution Beth needs to deposit into her savings account every 3 months, which pays 9\% p.a. with interest compounded quarterly, in order to obtain an amount in 6 years with a present value of \$5516.71.

\text{Period}0.25\% \\ \text{per quarter}0.75\% \\ \text{per quarter}1.25\% \\ \text{per quarter}1.75\% \\ \text{per quarter}2.25\% \\ \text{per quarter}
2019.484518.508017.599316.752915.9637
2120.433419.362818.369717.447516.5904
2221.380020.211219.130618.130317.2034
2322.324121.053319.882018.801217.8028
2423.266021.889120.624219.460718.3890
2524.205522.718821.357320.108818.9624
22

Rosey buys a car for \$21\,000 and repays it over 4 years through equal monthly instalments. She pays a 10 \% deposit and interest is charged at 9 \% p.a. on the reducing balance loan.

N0.6 \% \\ \text{per month}0.65 \% \\ \text{per month}0.70 \% \\ \text{per month}0.75 \% \\ \text{per month}0.80 \% \\ \text{per month}0.85 \% \\ \text{per month}
4539.3340638.9073838.4871238.0731837.6654537.26383
4640.0935039.6496539.2126338.7823138.3585937.94133
4740.8484140.3871439.9331039.4861739.0462238.61311
4841.5988241.1198640.6485640.1847839.7283939.27924
4942.3447541.8478541.3590540.8782040.4051539.93975
5043.0862342.5711342.0645941.5664541.0765340.59470
a

Find the monthly repayment P that Rosey must pay to to complete the loan after 4 years.

b

Calculate the total interest paid over the life of the loan.

23

The table gives the present value interest factors for annuity of \$1 per period, for various interest rates r and numbers of periods N:

N0.75 \% \\ \text{per month}0.80 \% \\ \text{per month}0.85 \% \\ \text{per month}0.90 \% \\ \text{per month}0.95 \% \\ \text{per month}
r0.00750.00800.00850.00900.0095
7054.3046253.4396052.5939751.7672450.95891
7154.8929354.0075453.1422652.2965751.46995
7255.4768554.5709753.6859352.8211852.47764
7356.0564355.1299354.2250253.3411152.47764
7456.6316955.6844654.7595753.8564152.97438
a

Tom plans to invest \$200 per month for 74 months. His investment will earn interest at a rate of 0.0080 (as a decimal) per month. Calculate the present value of the annuity.

b

Hannah has a loan of \$21\,500 and will be repaid in equal monthly repayments over 6 years. The interest rate on her loan is 10.8 \% per annum. Find the monthly repayment P.

24

The table gives the present value interest factors for annuity of \$1 per period:

\text{Period}1 \% \text{ p.a.}2 \% \text{ p.a.}4 \% \text{ p.a.}6 \% \text{ p.a.}
10.99010.98040.96150.9434
21.97041.94161.88611.8334
32.94102.88392.77512.6730
43.90203.80773.62993.4651
a

Tina pays \$3000 into an annuity at the end of each year for 4 years at 2 \% p.a. compounded annually. Find the present value of her annuity.

b

If Jack pays \$6000 into an annuity at the end of each year for 2 years at 4 \% p.a. compounded annually. Is he better off than Tina?

Effective interest rates
25

AMS Bank of offers two investment opportunities to investors:

  • Option 1: 6.86\% p.a. simple interest for 10 years.

  • Option 2: 6.76\% p.a. compound interest for 6 years, compounding semiannually.

a

On an investment of \$1000, find the interest earned for Option 1.

b

On an investment of \$1000, find the interest earned for Option 2.

c

Find the effective annual interest rate for Option 2, to two decimal places.

d

Which of the two investment opportunities has the larger effective annual interest rate?

26

Complete the following sentences relating to annuities:

a

Contributions are made:

A

At regular time intervals.

B

Whenever you feel like it.

b

The interest is paid at:

A

The end of each time period.

B

The beginning of each time period.

c

The future value of an annuity is:

A

Equal to the sum of the individual contributions.

B

Greater than the sum of the individual contributions.

27

You need to take out a loan and you have the following interest rate options:

  • Option 1: 1.9\% p.a. compounding semi-annually

  • Option 2: 1.5\% p.a. compounding quarterly

Which option would you choose? Use calculations and reasoning to explain your answer.

28

Two different lending institutions are offering different rates on their loans:

  • Betta Bank is offering 4.4\% p.a. compounding monthly.

  • Lucky Lending is offering 4.2\% p.a. compounding quarterly.

a

What is the effective rate of Betta Bank correct to two decimal places?

b

What is the effective rate of Lucky Lending correct to two decimal places?

c

Which institution has the better offer? Explain your answer.

29

Dave's investment of \$17\,380 earned 6.2\% p.a. simple interest for the first 5 years and 0.29\% p.a. compound interest for the next 8 years, compounded daily.

a

Calculate the value of the investment after 5 years.

b

Calculate the final value of the investment.

c

Calculate the total amount of interest earned.

d

Calculate the average amount of interest earned per year.

e

Express the average interest per year as a percentage of the original investment. Round your answer to two decimal places.

30

Maria has \$7000 to invest for 4 years and would like to know which investment plan to enter into out of the following three:

  • Plan 1: Invest at 4.98\% p.a. interest, compounded monthly.

  • Plan 2: Invest at 6.63\% p.a. interest, compounded quarterly.

  • Plan 3: Invest at 5.90\% p.a. interest, compounded annually.

Determine which investment plan yields the highest return, showing calculations to support your answer.

Sign up to access Worksheet
Get full access to our content with a Mathspace account

Outcomes

MA12-2

models and solves problems and makes informed decisions about financial situations using mathematical reasoning and techniques

What is Mathspace

About Mathspace