For each of the following situations prepare an amortization schedule using a spreadsheet. Include totals for the amount paid, interest paid, and principal repaid.

1. Sams Auto Repairs Inc. borrowed $5500.00 to be repaid by monthly payments over four years. Interest on the loan is 9% compounded semi-annually.