Please Show how you do it in Excel, thank you!

To calculate the market rate of interest that you will use in this problem, use the following formula, where Rm is the market rate of interest to use below and Ln is the last number of your student ID: Rm = 10% + 2 * Ln% For example, if the last digit of my student ID is 4, my market rate of interest is Rm = 10% +.2 * 4% = 10.8%. Everyone's market rate will be between 10.0% and 11.8%. Given Data: On August 1, 2022, Strouse Products issued 8.5% bonds, dated August 1, with a face amount of $240 million. The bonds mature on July 31, 2027 (5 years). The market yield for bonds of similar risk and maturity was the rate calculated above. Required: 1. Determine the price of the bonds issued on August 1, 2022 using Excel. Remember that the bonds pay semiannual interest. Please label this calculation in your spreadsheet. 2. Prepare an amortization schedule that calculates Strouse's interest expense using the effective interest method. Your amortization table should look something like this: Strouse Products Amortization Schedule Cash Payment Effective Interest Increase in Balance Outstanding Balance 1-Aug-22 31-Jan-23 31-Jul-23 31-Jan-24 31-Jul-24 31-Jan-25 31-Jul-25 31-Jan-26 31-Jul-26 31-Jan-27 31-Jul-27 There should be totals in the last row for Cash Payments, Effective Interest, and Increase in Balance. In addition, the cells in the table should contain formulas (do not type in numbers let Excel do the calculations). 3. Prepare the journal entries to record the issuance of the bonds by Strouse on August 1, 2022. 4. Prepare journal entries to show the accrual of interest at year end, the payment of semi-annual interest, and the retirement of the bonds. You will have two journal entries in 2022 (one for the issuance and one for accrual of interest), three journal entries in years 2023-2026 (two for the semi-annual payments of interest and one for accrual of interest), and three in 2017 (two for the semi-annual payments of interest and one for the retirement of the bonds). LN=6 rm= 11.2%