how do you solve these using execl? especially how do you find the payment?

Calculating Cost of Debt 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 Calculating Cost of Debt Jiminy's Cricket Farm issued a 30-year, 4.5 percent semiannual bond three years ago. The bond currently sells for 104 percent of its face value. The company's tax rate is 22 percent. a. What is the pretax cost of debt? b. What is the aftertax cost of debt? c. Which is more relevant, the pretax or the aftertax cost of debt? Why