You find a zero coupon bond with a par value of $$10,000$ and $24$ years to maturity.

$2$ If the yield to maturity on this bond is $4\mathrm{.}2$ percent, what is the dollar price of the bond? Assume semiannual compounding periods.

$($Use cells A$6$ to B$12$ from the given information to complete this question. You must use the built$-$in Excel function to a question. Leave the "Basis" input blank in the function. You may enter a constant as a hard coded value.$)$

Output area:

Price $(\%$ of par$)$

Price