Please answer through using Excel and show the formulas used to answer. If possible include link to the spreadsheet, I will make sure to upvote for you!

2. A $750,000 loan is to be repaid over 8-years. The interest rate on the loan 1'\") = 6.5%. (a) (b) (C) Set up a repayment schedule assuming the loan is amortized with quarterly payments over the 8 years. (3 marks) Assume the loan is paid back using the sinking fund method and assume a sinking fund can earn 1'\") = 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 an_d the book value. (3 marks) Graph the outstanding balance of the amortized loan and the book value of the sinking fund loan on the same graph. (2 marks)