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.$

You find a zero coupon bond with a par value of$$$$10,000$ and $24$ years to maturity. 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.

Input area:

Settlement date $1/1/2020$

Maturity date $1/1/2044$

Coupon rate $0\mathrm{.}00\%$

Coupons per year $2$

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

Yield to maturity $4\mathrm{.}20\%$

Par value $$10,000$

$($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. You may enter a constant as a hard coded value.$)$

Output area:

Price $(\%$ of par$)$

Price $=$