topic badge

Investigation: Modelling a loan with spreadsheets

Outcomes

4.3.4

use technology to calculate the future value of a compound interest loan or investment and the total interest paid or earned

4.3.5

use technology to compare, numerically and graphically, the growth of simple interest and compound interest loans and investments

4.3.6

use technology to investigate the effect of changing the interest rate and the number of compounding periods on the future value of a loan or investment

4.3.7

use technology and a recurrence relation to model a reducing balance loan

4.3.8

investigate the effect of the interest rate and repayment amount on the time taken to repay a loan

What is Mathspace

About Mathspace