Please complete in excel. I will like if answer was correct.

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. B) Prepare an amortization table for the bonds for the five years. C) Using +/-, complete Comcast's financial statement effects template i. on bond issuance. LTD Cash ii. on Jun. 30 of the 1st year. iii. semiannual interest payment and premium amortization on Dec. 31 of the 1st year