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.$ Yan Yan Corp. has a $$2,000$ par value bond outstanding with a coupon rate of $4\mathrm{.}7$

percent paid semiannually and $13$ years to maturity. The yield to maturity of the

bond is $5\mathrm{.}05$ percent. What is the dollar price of the bond?

Input area:

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

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

Yan Yan Corp. has a $$2,000$ par value bond outstanding$$with a coupon rate of $4\mathrm{.}7$ percent paid semiannually and $13$ years to maturity. The$$yield to maturity of the bond is $5\mathrm{.}05$ percent. What is the dollar price of the bond?

Please use excel formulas to answer this question