Please use spreadsheet to solve it, thanks. I will give a good rate.

3. A 15-year $500,000 bond is purchased. It is redeemable at 103, and it pays semi-annual coupons at i(2) = 5%. It is bought to yield i(2) = 6%. Set up a bond amortization/accumulation schedule. Graph the book value column. (3 + 2 = 5 marks) = = =