Find the cost of debt using the yield to maturity of bond

Callable bonds with a coupon interest rate of 5% at a par value of 1,000 per bond and a term of 30 years. The 250,000 issue bonds would pay interest semi-annually, tax rate at 34%, the after-tax interest rate on the issue would be 3.3%. The would have a market price of 103 as a percentage of par.

I use RATE function to find yield to maturity without using after-tax interest on issue. I think it's wrong. Please help me, it will be good if you capture excel showing calculation.