Formula please

Even though most corporate bonds in the United States make coupon payments

$2$

semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of $1,000,27$ years to maturity, and a coupon rate of $3\mathrm{.}6$ percent paid annually. If the yield to maturity is $3\mathrm{.}2$ percent, what is the current price of the bond in euros?

$3$

$4$

$5$

$6$

$7$

$8$

$9$

$10$

$11$

$12$

$13$

$14($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 $15$ question. Leave the "Basis" input blank in the function, You may enter a constant as a hard coded value.$)$

$\backslash$table$[[16,,],[17,$Output area:,$],[18,,],[,$Price $(\%$ of par$),],[20,$Price,$],[21,,],[22,,],[23,,],[24,,]]$

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

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