Prepare a spreadsheet to show a repayment schedule for a loan of $100,000, [6 marks] repayable quarterly over 10 years calculated at an effective interest rate of 9.68%
(a) Calculate the amount of the quarterly repayment.
(b) Calculate the loan outstanding right after the 10th payment.
(c) Calculate the interest component of the 11th payment.
(d ) Calculate the principal(capital) repaid in the 11th payment.
interest rate 20.00% per annum, effective