Consider a $1 million, 5% p.a., 10-year mortgage with monthly payments. Using a spreadsheet, compute the monthly principal, interest, and total payment and the loan balance for each month during the entire loan term. For each amount, round down to the nearest cent (rounddown(amount, 2)). Make sure that the loan balance after 10 years becomes zero by paying down the entire balance during the final month.

1. Interest-only mortgage
2. Constant amortization mortgage (CAM)
3. Fully-amortizing constant payment mortgage (CPM)
4. 10-year CPM with a 30-year amortization schedule