Please complete in excel

P14-31A Analyzing, journalizing, and reporting bond transactions Billy's Hamburgers issued 5%, 10-year bonds payable at 90 on December 31, 2012. At December 31, 2014, Billy reported the bonds payable as follows: Long-term Liabilities Bonds Payable $400,000 Less: Discount on Bonds Payable 32,000 $ 368,000 Billy pays semiannual interest each June 30 and December 31 Requirements 1. Answer the following questions about Billy's bonds payable: What is the maturity value of the bonds? b. What is the carrying amount of the bonds at December 31, 2014? What is the semiannual cash interest payment on the bonds? d. How much interest expense should the company record each year? a. C. 2. Record the June 30, 2014, semiannual interest payment and amortization of discount