Please show work in excel.

2 Please use the following information for the questions that follow, as appropriate. 3 You are considering a bond with a Face Value of $1,000.00 and a Coupon Rate of 11.0%. The bond has 18 years until maturity, and coupon payments are paid Semiannually. 4 The yield to maturity on similar securities in the market is 8.4%. 5 6 Given the information provided, what is the per period coupon payment for this bond? 7 8 Answer = 9 0 1 Given the information provided, what is the appropriate per period discount rate used to price this bond? 2 3 Answer = 4 5 6 Given the information provided, how many periods remain until the bond reaches maturity? 7 8 Answers 9 0 1 What is the current price of this bond? 2 3 Answer = 4 5 6 If the YTM in the market shifts to 7.7%, what will be the new price of the bond? 7 8 Answers 9 0 1 Consider the bond price from the previous part. What is the correct bond terminology to describe this price in relation to the bond's face value? Please describe in one word. 2 Answers 3 4 -0 1 Consider the bond price from the previous part. What is the correct bond terminology to describe this price in relation to the bond's face value? Please describe in one word. 2 3 Answer = -4 5 6 If the bond price subsequently shifts to $1,114.40, what must be the new YTM in the market? You may round to the nearest tenth of a percent. 7 8 Answer 9 1 Consider the YTM calculated in the previous part. What is the appropriate per period discount rate for this bond? Answer = 3 54 au WN