By using Excel plz!!!!!!!!!!

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