Please answer in excel and show functions. I will upvote if answer is correct.

2. Analyzing and Reporting Financial Statement Effects of Discount Bond Transactions Assume that on January 1 , Xfinity issues $500,000 of 5-year, 8% coupon bonds payable, yielding an effective annual interest rate of 10%. Interest is payable semiannually on June 30 and December 31. A) Compute the issue price, bond discount, and the periodic coupon interest. B) Prepare an amortization table for the bonds for the five years. C) Using +/, complete Xfinity's financial statement effects template a. on bond issuance. LTD Cash b. on Jun. 30 of the 1st year. c. semiannual interest payment and premium amortization on Dec. 31 of the 1tt year