Steps in Excel Please

Current cost of a bond: You are analysing the cost of debt for a company. You know that the company's 14-year maturity, 10.55 per cent coupon bonds are selling at a price of $1050.24. The bonds pay interest semiannually and have a face value of $1000. If these bonds are the only debt outstanding for the company, what is the after-tax cost of debt for this company if the corporate tax is 30 per cent