topic badge

INVESTIGATION: Modelling a loan with a spreadsheet

Outcomes

4.3.1.5

use technology (spreadsheet) to calculate the future value of a compound interest loan or investment and the total interest paid or earned [complex]

4.3.1.7

use technology (spreadsheet) to compare, numerically and graphically, the growth of simple interest and compound interest loans and investments [complex]

4.3.1.9

use technology (spreadsheet) to investigate the effect of the interest rate and the number of compounding periods on the future value of a loan or investment [complex]

4.3.2.3

use technology (spreadsheet) to model a reducing balance loan [complex]

4.3.2.5

use technology (spreadsheet) to investigate the effect of the interest rate and repayment amount on the time taken to repay a loan [complex]

What is Mathspace

About Mathspace