I need the answers with the excel formulas.

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 annuaff. If the yield to maturity is 3.2 percent, what is the current price of the bond in euros? Input area: 14 (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.)