You’ve taken a 30-year, $60,000 mortgage to finance the purchase of your new house. The mortgage has an interest rate of 10% annually and requires monthly flat payments of interest and principal (by “flat” we mean that all the payments are equal).

a. Use PMT to compute the monthly payment.

b. Design a loan table showing that the payment you computed in the first part of this problem indeed pays off the mortgage.