Computer question

Use a spreadsheet language (such as Excel) to answer the following questions.Print out your results/take a screen shot/take a photo and hand them in/scan them with the rest of your assignment.

Best practices: try to fit your answers to question on ONE page if you can

1.A loan of $100,000 is to be paid back over 4-years with monthly payments at j₁₂ = 9%.Set up a repayment schedule for the entire 4-year period using the

(a)amortization method

(b)sum of digits method

To emphasize the "penalty" of paying off your loan early under the sum of digits method, graph the

difference between the outstanding balance columns of the sum of digits method and the amortization

method (do not graph the outstanding balances, just the difference - use either a line or column graph).

(3+3+2 = 8 marks)