please solve it according to excel formulas

McGraw Hill Excel Question Home Insert Share Saved Formulas Search for tools, he File 9 Data Review View Help Draw a Celibri (Body) v 1 1 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 annually. If the yield to maturity is 3.2 percent, what is the current price of the bond in euros? 4 7 9 10 11 14 15 17 19 20 Input area: Settlement date Maturity date Coupon rate Coupons per year Redempton value (% of par) Yield to maturity Par value 1/1/2020 1/1/2047 3.60% 3.20% 1,000 (Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel function to answer this question. Leave the "Basis" input blank in the function. You may enter a constant as a hard coded value.) Output area: Price (0/6 of par) Price