I need to work out how long it will take to pay off a loan. $945 is paid off each month, plus interest of 6.95% of how much there is left to pay off in that month. How would I do this in Numbers? Thanks. (question is below). "A reducing balance bank housing loan has an outstanding balance of $123 685.45 at the beginning of the year. Instalments of $945 are paid each month and the monthly interest is calculated after each instalment, the current yearly rate being 6.95%."