Please assist with this question. Work out in detail in Excel. Show all work.

#9 On June 30, 2018, Keyser Soze Corporation sold $3,000,000 (face value) of bonds. The bonds are dated June 30, 2018, pay interest semiannually on December 31 and June 30, and will mature on June 30, 2021. The following schedule was prepared by the accountant for 2018. Semi-Annual Interest to Interest Bond Interest Period Unamortized be Paid Expense Amortization Amount Carrying Value $75,000 $2,925,000 $120,000 $131,625 $11,625 63,375 1,936,625 nstructions On the basis of the above information, answer the following questions. (Round your answer to the nearest dollar or percent.) What is the stated interest rate for this bond issue? What is the market interest rate for this bond issue? What was the selling price of the bonds as a percentage of the face value? Prepare the journal entry to record the sale of the bond issue on June 30, 2018. Prepare the journal entry to record the payment of interest and amortization on December 31, 2018