put answers in excel

formular

7 Calculating a bond price Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign in X - A 96 Alignment Number Conditional Format al Cell Formatting Table Styles Cells Editing powd Fom C3 Even though most corporate bonds in the United States make coupon payments G 1 c 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, 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 ouros? 5 Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par Yield to maturity Par value 1/1/2000 1/1/2023 5.80% 1 100 4.70% 1,000 13 1 Complete the following analysis. Do not hard code values in your calculations. Leave the "Basic" input blank in the function. You must use the built-in Excel function to answer this question Prev 1 of 8 8 Next >