This answer bust be done in excel only. Please do the work in the format provided in the picture. It must also include the formulas to complete the assignment. $.$ The Fairfold family decided to buy a super ski and water sports boat. They took out an $$80,000,5-$year, $6\%$ per year compounded semiannually loan with monthly payments from First Bank and Trust $($FB&T$).$ After making only two payments, a friend at another bank offered to make them a better deal: a $5-$year, $4\mathrm{.}2\%$ per year compounded semiannually loan with no transfer fee to his bank, and a no$-$fee repayment of the remaining principal to FB&T$.$ The principal on the new loan will be the remaining principal from the current loan. Answer the following questions for the Fairfolds as they deliberate this new offer.