You plan to purchase a $200,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.50 percentage. You will make a down payment of 20 percent of the purchase price.

a. Calculate your monthly payments on this mortgage.

b. Construct the amortization schedule for the first six and last six payments.

Please show excel funtions