this is an amortization excel project. so must be done in excel. also please show exactly you you did each question on excel including the formulas used. also please label each answer. and of course please check if all the answers are correct.

thanks

Questions: 1. Alma and Bob bought a property valued at $86,000 for $15,000 down with the balance amortized over 20 years. The terms of the mortgage require equal payments at the end of each month. Interest on the mortgage is 3.4% compounded semi-annually and the mortgage is renewable after five years. a. What is the size of each monthly payment? b. Prepare an amortization schedule for the first five year term. Make sure your values are rounded (not just cut off) to the nearest cent. Express totals at the bottom of each column as currency. c. What is the cost of the mortgage (total interest expense) for the first five year term? d. If the mortgage is renewed for a further five years at 4.2% compounded semi-annually, what will be the size of each monthly payment