Calculate exactly what the Bond should go for in this market, and calculate the Premium or Discount at the time of sale.

Use the straight-line amortization method and spread the premium or discount over the life of the bond.

1- Plz make one Excel spreadsheet with the Bond of $120,000, 10 years, a coupon rate of 10%, and a market rate of 9%

Also make a journal entry for the sale of the bond, and 4 interest payments.

2- Another Excel sheet for a Bond of $120,000, 10 years, coupon rate of 10%, and a market rate of 11%.

Also make a journal entry for the sale of the bond, and 4 interest payments.