Please show all work.

CCSU Consulting LLC is asked to prepare various schedules on how interests are paid or accrual and how principal balances are changed for diffent debentures. Your Supervisor ask you to use effective interest rate method to prepare all the schedules by calendar year and accounting entries at issue and at the end of each calendar year for demonstration purpose A 7-year bond was issued by your client and purchased by an investor at July 1, 2019 with par value of $400,000, annual coupon rate at 2.7%, semi-annual interest paymentbat June 30 and December 31. The effective rate of the market is 3.0% (20 points); Present Value ofthe 5-year bond is Par Value ofthe 5-year bond is Premium (Discount) 400,000 Reduction of Cash Interest Payment (Premium) Premium 5-year Bond Balance Effective Interest or or Year 07/01/19 12/31/19 06/30/20 12/31/20 06/30/21 12/31/21 06/30/22 12/31/22 06/30/23 12/31/23 06/30/24 12/31/24 06/30/25 12/31/25 06/30/26 Discount (Discount) Accounting entries at the issue and at the end ofeach year are as follows