5 Ross borrowed $20000 in a secured line of credit to finish his basement. The loan had an annual rate of 4.35% compounded semi-annually and he wanted to pay it off in four years. What would his payments be if he paid: (use your financial application and fill in the appropriate inputs) a. monthly N = 1% = PV C/Y=. FV= P/Y= b. bi-weekly N = PMT= 1% = PV= PMT= 1 mark FV = P/Y=. C/Y => b. 1 mark c. weekly 1% = PV = PMT= N = P/Y=. C/Y = FV => d. Design a spreadsheet to calculate the interest he would have paid with each repayment option. (1 mark each) Monthly repayments: Bi-Weekly repayments: Weekly repayments: e. What formula would you use in the spreadsheet to determine the interest paid per weekly payment