Reducing Balance Loan in Numbers? Important!

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%."

MacRumors attracts a broad audience
of both consumers and professionals interested in
the latest technologies and products. We also boast an active community focused on
purchasing decisions and technical aspects of the iPhone, iPod, iPad, and Mac platforms.