Hello, can I get a step by step solution using excel. Thank you

One Step, Inc., is trying to determine its cost of debt. The firm has a debt issue outstanding with 12 years to maturity that is quoted at 111 percent of face value. The issue makes semiannual payments and has a coupon rate of 8 percent. What is the company's pretax cost of debt? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) If the tax rate is 24 percent, what is the aftertax cost of debt? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Pretax cost of debt Aftertax cost of debt