prepare an amortization schedule using a spreadsheet. Include totals for the amount paid, interest paid, and principal repaid.

1. Hansco borrowed $9200.00 paying interest at 13% compounded annually. If the loan is repaid by payments of $2000.00 made at the end of each year, construct an amortization table