please answer in excel, with correct formula :)

thank you!

Sunrise, Inc, is trying to determine its cost of debt. The firm has a debt issue outstanding with 23 years to maturity that is quoted at 96 percent of face value. The issue makes semiannual payments and has an embedded cost of 5 percent annually. What is the company's pretax cost of debt? If the tax rate is 21 percent, what is the aftertax cost of debt? Input Area: 14 (Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel function to 15 answer this question. Leave the "Basis" input blank in the function.)