'Graded W$...$

A

B

C

D

E

F

G

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?

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

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