DO NOT USE EXCEL

Jacob takes a 20-year loan. He borrows 100,000 to be paid back with level monthly payments at the end of every quarter. The interest is charged on this loan at a nominal rate of interest of 10% convertible quarterly. The day after he makes his 60" payment, Jacob decides that when the next payment is due, he will just pay off the loan, in full, with a single payment. Find that huge payment he must make at that time after carefully considering exactly what is owed at that time