topic badge

Investigation: Modelling a loan with a spreadsheet

Interactive practice questions

There are no interactive problems for this subtopic

Outcomes

ACMEM171

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

ACMEM172

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

ACMEM173

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

ACMEM174

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

ACMEM175

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

What is Mathspace

About Mathspace