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%.

Construct repayment schedules using (A) prospective amortization method, and (B) retrospective amortization method. Excel solution preferred.