The Mackenzie$$s also bought a business for $$90,000.$ They borrowed the money to buy the business at $6\mathrm{.}9\%$ compounded semi$-$annually and are to repay the debt by making 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 $6$thyear?

I. What is the total cost of financing the debt?

J$.$ 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?

L$.$ 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?

could you please answer these questions in the excel sheet? please answer all the parts.