please do in excel

Your company plans to issue debt with an annual coupon rate of $6\mathrm{.}5\%($interest paid semi$-$

annually$)$ and which will mature in $10$ years at a par value of $$1,000.$ Your firm's investment

bankers have stated that the bonds can be sold publicly to investors at a price of $$995$ per

bond, but that the firm will be required to pay a flotation expense to the investment bankers

equal to $2\%$ of this price. If the firm has a marginal corporate tax rate of $40\%,$ then what will

be the firm's after$-$tax cost on this new debt to be issued?

$4\mathrm{.}17\%$

$4\mathrm{.}04\%$

$4\mathrm{.}11\%$

$4\mathrm{.}72\%$

$4\mathrm{.}26\%$