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. Mr. and Mrs. Good purchased a ski chalet for $36,000.00. They paid $4000.00 down and agreed to make equal payments at the end of every three months for fifteen years. Interest is 8% compounded quarterly.