Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows $6$ through $12.$ The required answers are in rows $19$ through $20.$

Jiminy$$s Cricket Farm issued a $30-$year,$4\mathrm{.}5$ percent semiannual bond three years ago. The bond currently sells for $104$ percent$$of its face value. The company$$s tax rate is $22$ percent.

Input Area:

Settlement $1/1/2020$

Maturity $1/1/2047$

Coupon rate $4\mathrm{.}50\%$

Price $(\%$ of par$)104$

Redemption $(\%$ of par$)100$

Payments per year $2$

Tax rate $22\%$

$($Use cells A$6$ to B$12$ from the given information to complete this question. You must use the built$-$in Excel function to answer this question. Leave the $$Basis$$ input blank in the function.$)$

Output Area:

Pretax cost of debt $$

Aftertax cost of debt $$

Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work.

Nothing in this area will be graded, but it will be submitted with your assignment.