Gary E. answered 03/06/23
30+ year financial professional and college adjunct prof
Hi Marie,
Using a simple amortization table in Excel, it shows that the remaining balance at the end of five years will be $157,294.
Of course, all this assumes the $150,000 was borrowed at the beginning of the year and interest was accrued at the end of the year as well as the $20,000 annual payment.