Need help with part c please

1. Analyzing and Reporting Financial Statement Effects of Premium Bond Transactions Assume that on January 1, Comcast issues $500,000 of 5-year, 10% coupon bonds payable, yielding an effective annual interest rate of 8%. Interest is payable semiannually on June 30 and December 31. A) Compute the issue price, bond premium, and the periodic coupon interest. Issue price: 540,554.48 Bond premium: $40,554 There are 10 semiannual payments of $25,000 B) Prepare an amortization table for the bonds for the five years. Amortization table for the premium bonds for the five years Interest Coupon Premium Expense Interest Amortization 0 1 2 3 4 5 6 7 8 9 10 Total LTD 21622.18 21487.07 21364.55 21200.41 21048.43 20890.36 20725.98 20555.02 20377.22 20192.31 209463.53 C) Using +/-, complete Comcast's financial statement effects template a. on bond issuance. Bonds payable, face Add bond premium Bonds payable, net b. on Jun. 30 of the 1st year. Interest expense in I/S Dr. Kiseok Nam 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 250000 Interest expense in I/S Bond Payable in B/S 3377.82 3512.93 3653.45 3799.59 3951.57 4109.64 4274.02 4444.98 4622.78 4807.69 40554.47 1 FIN360 Cash Premium Balance $40,554 37176.66 33663.72 30010.27 26210.68 22259.11 18149.48 14875.46 9430.47 4807.69 0 Retained earnings in B/S Cash Bond Payable in B/S Cash in B/S c. semiannual interest payment and premium amortization on Dec. 31 of the 1st year. Bond Payable, Net $540,554 537176.66 533663.72 530010.27 526210.68 522259.11 518149.48 514875.46 509430.47 504807.69 500000.00 Quinnipiac University Retained earnings in B/S Cash Cash in B/S