A 15-year $500,000 bond is purchased. It is redeemable at 102.5, 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

Note: Do the first couple years and I will do the rest using excel if they follow the same formulas.