Waller, Inc., is trying to determine its cost of debt. The firm has a debt issue outstanding with 13 years to maturity that is quoted at 98 percent of face value. The issue makes semiannual payments and has an embedded cost of 10 percent annually.

Required:

(a)	What is the company's pretax cost of debt? (Do not round your intermediate calculations.)
	(Click to select)10.20%10.28%10.69%10.80%9.77%

(b)	If the tax rate is 36 percent, what is the aftertax cost of debt? (Do not round your intermediate calculations.)
	(Click to select)6.58%5.15%6.25%6.84%6.91%

*If possible could you solve in excel, and show the formulas? Thank you!