Carla borrowed $1200 from the Royal Bank at 8.5% per annum calculated on the monthly unpaid balance. She agreed to repay the loan in blended payments of $180 per month.
Use the design shown in Figure to construct a complete repayment schedule including the totaling of the Amount Paid, Interest Paid, and Principal Repaid columns for each of the following loans.
Basic Design of a loan repayment schedule

Transcribed Image Text:

Payment Number Balance Before Payment AmountPaid Paid Interest PrincipalBalance After Repaid