D$17$

A

B

C

D

E

F

G

H

I

Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of $1,000,23$ years to maturity, and a coupon rate of $5\mathrm{.}8$ percent paid annually. If the yield to maturity is $4\mathrm{.}7$ percent, what is the current price of the bond in euros?

$4$

$5$

$6$

$7$

$8$

$9$

$10$

$11$

$12$

$13$

$14$

$15$

$16$

$17$

$18$

Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built$-$in Excel function to answer this question.

Price in eurosAnswear must ne entered as a formula