Please use spreadsheet to solve it, thanks. I will give a good rate.

For question 2(b), I added that I want you to include a column for the quarterly expense and for the book value of the loan (you will need the book value in order to do part (c)).

2. A $750,000 loan is to be repaid over 8-years. The interest rate on the loan i(4) = 6.5%. (a) Set up a repayment schedule assuming the loan is amortized with quarterly payments over the 8 years. (3 marks) (b) Assume the loan is paid back using the sinking fund method and assume a sinking fund can earn i(4) = 4.2%. Set up a sinking fund schedule similar to the one shown on page 186 of the textbook but you also need to include a column for the quarterly expense and the book value. (3 marks) (c) Graph the outstanding balance of the amortized loan and the book value of the sinking fund loan on the same graph. (2 marks) =