Make an Excel spreadsheet for Example 5.8. Include 1. Repayment schedule using the sinking fund method; 2. Repayment schedules using amortization methods (a) prospective method (b) retrospective method Example 5.8: A loan of $1,000 at effective rate of interest of 6% per year is to be redeemed over 5 years by a sinking fund that credits interest at 5.5% with reinvestment rate of interest of 5%. Calculate the annual installments of the annuity-immediate required to redeem the loan. What is the equivalent rate of interest using the amortization method? Make an Excel spreadsheet for Example 5.8. Include 1. Repayment schedule using the sinking fund method; 2. Repayment schedules using amortization methods (a) prospective method (b) retrospective method Example 5.8: A loan of $1,000 at effective rate of interest of 6% per year is to be redeemed over 5 years by a sinking fund that credits interest at 5.5% with reinvestment rate of interest of 5%. Calculate the annual installments of the annuity-immediate required to redeem the loan. What is the equivalent rate of interest using the amortization method