Don't really understand what it really means. What formula do I have to use? I tried on my own already but don't if i did it right. I need explanation for A,B,C please thank you!

Task I: Customer Care Debate Tou are a branch manager of Bank A and your debate partner is a branch manager of bank B. A potential customer Mr. Smith would like to make a mortgage of $450,000 to buy a new condo in downtown, Toronto. He agrees to repay the loan by making equal monthly payments of $1700 to $2000 for at most 30 years. The two banks offer different mortgage plans for the customer. laillim il ! WILT Bank A: A monthly loan repay of $2000 of the first 24 months and a nthly repay of $1800 of the rest months. The annuity of the mortgage is 3%/a. Bank A also offer their customers a bonus invest plan of $20000 with an annuity of 5%/a. Bank B: A monthly repay of at least $1700. Customers can choose to pay more mortgages at the end of each month. The annuity of bank B is. increase over time with an annual increase rate of 1%. The initial annuity is 2%. Bank B offer a bonus invest plan: invest of $1200 at the end of each 6-month period in an annuity he earns 4%/a compounded semi-annually for the next 20 years. In this task, you and your group partner will debate with each other to defense the advantage of the mortgage plan of your bank. In the debate you should use information below to let your audience believe your plan is better: a) How long will it take Mr. Smithto pay off the loan for each plan? Use spreadsheet to show to him. Offer the detailed formula on your debate report. (C3.7)(10p) b) If a customer choose to repay $1700 monthly for the first three years, and repay $2000 monthly after three years. How does your mortgage plan match the customer's repay plan? If the customer inquiries about plan change, (change from plan A to plan B after 3 years or change from plan B to plan A after 3 years), How would this affect his payment rate and annuity? Use TVM solver on graphing calculator or online tools to solve these problem. (C 3.6)(8p) c) Compare the bonus invest plan offered by each bank. Determine the future value of each plan. Use spreadsheet to solve this problem. Show the detailed formula. (C3.5)(7p)