Please solve in excel with formulas, thank you! Ying Import has several bond issues outstanding, each making semiannual interest

payments. The bonds are listed in the following table. If the corporate tax rate is $32$

percent, what is the aftertax cost of Ying's debt?

Multiple Choice

$1\mathrm{.}66\%$

$1\mathrm{.}81\%$

$2\mathrm{.}54\%$

$1\mathrm{.}64\%$

$1\mathrm{.}72\%$