15-year $500,000 bond is purchased. It is redeemable at 103.5, and it pays semi-annual coupons at i(2) = 6%. It is bought to yield i(2) = 5%. Set up a bond amortization/accumulation schedule and then graph the book value column (using a line graph). [[[[[Using Excel]]]]]

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