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… Ross borrowed $20000 in a secured line of credit
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… 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 ________ I% _________ PV ________ PMT __________ FV ________ P / Y ________ C / Y _________ b. bi-weekly N ________ I% _________ PV ________ PMT __________ FV ________ P / Y ________ C / Y _________ c. weekly N ________ I% _________ PV ________ PMT __________ FV ________ P / Y ________ C / Y _________ d. Design a spreadsheet to calculate the interest he would have paid with each repayment option. Monthly repayments: _______________________ Bi-Weekly repayments: _______________________ Weekly repayments: _______________________