Create a bond amortization table, which automatically adjusts to the value of input variables. The headings of the table should have (1) year, (2) interest payment, (3) interest expense, (4) amortization of (premium)/discount, and (5) ending balance columns. Pay attention to discount or premium of bonds. You must construct the worksheet with the appropriate numeric format and professional layout. Round number values to the nearest whole dollar. The fixed variables for the assignment are as follows: Term of bonds = 10 years Interest Payments = semi-annual Amortization of Premium or Discount = effective interest method Bond issued = July 1, 2018 First interest payment due = December 31, 2018.

Looking for a blank template please and thank you!