Use excel

Hanley Corporation issued $520,000 of 5%, 12-year bonds payable on March 31, 2016. The market interest rate at the date of issuance was 8%, and the Hartley Corporation bonds pay interest semiannually. Hartley Corporation's year-end is March 31. Using the PV function in Excel, calculate the issue price of the bonds. Prepare an effective-interest amortization table for the bonds through the first three interest payments. Round amounts to the nearest dollar. Record Hartley Corporation's issuance of the bonds on March 31. 2016, and payment of the first semiannual interest amount and amortization of the bond discount on September 30. 2016. Explanations are not required. (Learning Objective 3: Account for bonds payable issued at a discount using effective-interest method) Use the amortization table that you prepared for Hartley Corporation's bonds in S9-II to answer the following questions: How much cash did Hartley Corporation borrow on March 31, 2016? How much cash w ill Hartley Corporation pay back at maturity on March 31. 2028 ? How much cash interest will Hartley Corporation pay each six months? How much interest expense w ill Hartley Corporation report on September 30, 2016, and on March 31, 2017? Why does the amount of interest expense increase each period