Hi, could you please provide an explanation of how to work out this problem in excel as well as the steps to calculate and record the journal entries?

For question4-7, please use excel to build an amortization schedule and calculate your answers. 4. Jessica Day Corp. issued callable bonds with a face value of $200,000 and a coupon rate of 6% The bond matures in 4 years and pays interest semi-annually. The market rate at time of issuance is 7%. Provide the journal entry to record the issuance of the bonds on January 1", 2020 S. Record the journal entry for the interest expense on 6/30/2021? 6. What is the net book value of the bonds payable at 12/31/2022? 7. Jessica Day Corp. decides to exercise the right to retire its bonds early on 12/31/2022. It calls its bond at a call premium of 3 percent over par. Record the retirement of the bonds