Please answer with an excel formula.

Paste Clipboard F D17 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 READY A Arial A A % Cell B IU A- Alignment Number Conditional Format as Formatting Table Styles Font Styles V I X fx B D E F G H I J 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.8 percent paid annually. If the yield to maturity is 4.7 percent, what is the current price of the bond in euros? Settlement date 1/1/2000 1/1/2023 Maturity date Coupon rate 5.80% Coupons per year 1 Redemption value (% of par) 100 Yield to maturity 4.70% Par value 1,000 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 euros Sheet1 100% 12 EEE Cells A Editing