Please use Excel to compute. Thanks

The spreadsheet calculatfons should be set up in a systematfo manner. Your set-up should contaln a list of the given values, and as many calculated values as posslble. Make your spreadsheet as 'active' as possible by using cell references (so that if one value Is changed, subsequent calculations will automatically update). Use absolute cell references in spectal sltuations. Bob and Angelique Mackenzle bought a property valued at $84,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 the monthly payment? b. Prepare an amortization schedule for the first five-year term. Make sure your payments are rounded to the nearest cent. c. What is the cost of financing the debt during 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 stze of each monthly payment? The Mackenzle's also bought a business for $90,000. They borrowed the money to buy the business at 6.9% compounded seml-annually and are to repay the debt by makng quarterly payments of $3645. e. How many payments are required to repay the loan? f. What is the term of the loan in years and months? g. Prepare a complete amortization schedule for the loan. Express totals at the bottom as currency. h. What is the principal reduction in the 6th year? 1. What is the total cost of financing the debt? 1. If Bob and Angelique make a lump sum payment of $10,000 at the end of the fourth year, by how much is the amortization period shortened? k. How much interest do they save by making the lump sum payment? 1. If Bob and Angelique had made the lump sum payment at the end of the second year instead of the end of the fourth year, how much more money could they save? The spreadsheet calculatfons should be set up in a systematfo manner. Your set-up should contaln a list of the given values, and as many calculated values as posslble. Make your spreadsheet as 'active' as possible by using cell references (so that if one value Is changed, subsequent calculations will automatically update). Use absolute cell references in spectal sltuations. Bob and Angelique Mackenzle bought a property valued at $84,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 the monthly payment? b. Prepare an amortization schedule for the first five-year term. Make sure your payments are rounded to the nearest cent. c. What is the cost of financing the debt during 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 stze of each monthly payment? The Mackenzle's also bought a business for $90,000. They borrowed the money to buy the business at 6.9% compounded seml-annually and are to repay the debt by makng quarterly payments of $3645. e. How many payments are required to repay the loan? f. What is the term of the loan in years and months? g. Prepare a complete amortization schedule for the loan. Express totals at the bottom as currency. h. What is the principal reduction in the 6th year? 1. What is the total cost of financing the debt? 1. If Bob and Angelique make a lump sum payment of $10,000 at the end of the fourth year, by how much is the amortization period shortened? k. How much interest do they save by making the lump sum payment? 1. If Bob and Angelique had made the lump sum payment at the end of the second year instead of the end of the fourth year, how much more money could they save