Ef 350. Even though most corporate bonds in the United States make coupon paymentssemiannually, bonds issued elsewhere often have annual coupon payments.Suppose a German company issues a bond with a par value of €1,000, 27 yearsto maturity, and a coupon rate of 3.6 percent paid annuant. If the yield tomaturity is 3.2 percent, what is the current price of the bond in euros?B4 Input area:56 Settlement date7 Maturity date8Coupon rate9 Coupons per yearRedemption value (% of par)1011 Yield to maturity12 Par value13.1/1/20201/1/20473.60%17 Output area:1819 Price (% of par)20 Price2111003.20%€1,00014 (Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel function to answer this15 question. Leave the "Basis" input blank in the function. You may enter a constant as a hard coded value.)16-1036.00

Bond: It is financial security issued to raise debt capital by the issuer. The bondholder…

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, 27 years to maturity, and a coupon rate of 3.6 percent paid annuant. If the yield to maturity is 3.2 percent, what is the current price of the bond in euros? Input area: Settlement date Maturity date Coupon rate B 9 Coupons per year 10 Redemption value (% of par) 11 Yield to maturity 12 Par value 13 1/1/2020 1/1/2047 3.60% 17 Output area: 18 19 Price (% of par) 20 Price 1 100 3.20% €1,000 14 (Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel functions 15 question. Leave the "Basis" input blank in the function. You may enter a constant as a hard coded value.) 16 -1036.00