0,0 9 10 11 SECTION I-BONDS (40 POINTS) Don't worry about decimals-all answer bones were fomated automatically - Highly recommended to use the excel formulas Question 3.0 points Calculate the invoice Price of the Elm Corp.'s Corporate Bond given the following Information FREE CALCULATION AREA Issuer: Elm Corporation 1.000 Trading Price 98.500 Trading Date Wednesday, January 16 Coupon Rate 8.002 Coupon Payment Days Mar 31. Sep 30 Face Value | 13 14 15 16 17 18 19 20 OUTPUT - ANSWERS Enter Answers Price 21 Involce Price 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Question 4.120 points ) Given the following data, using Excel formulas, calculate the YTM, all 4 years of YTC, YTW and Current Yield: : FREE CALCULATION AREA BOND CONTRACTUAL INFO: issuance Date 6/15/19 Face Value Per Bonde 1,000 Annual Coupon Payment $ $ 80.00 Term years from Issuance) 10 Redemption value at Maturity 100 Coupon Pets per years Z Call Price Provision L.E.ENTERM200 Enter Dates Year Call Price 36 37 104 103 38 39 Year 1 from Issuance Date Year 2 from Issuance Dates Year 3 from Issuance Dates Year 4 from Issuance Date 102 101 40 41 42 43 BOND TRADING INFORMATION: Trading Date Monday, November 23, 2020 44 45 Settlement Date lenter datele 9/12/2020- Current Market Price 96.00 Enter Answers Enter Answers YTM YTCI YTW YTO- 51 YTG- Current Yield YTC4- Questions 110 points Given the following data, calculate the price and Duration of the Band: 1,000 54 55 56 57 58 59 60 61 62 63 64 65 66 Face Value Coupon Rate Yield Remaining Years to Maturity Redemption Price Frequency 7.000% 9.000% 2 100 CALCULATIONS Time until Payments Payment PV of Pmt X Weight Duration (Years) ! 67 68 2 69 3 70 4 71 5 72 6 73 7 74 8 75 9 10 Enter Answer Enter Answer 78 Price Duration 0,0 9 10 11 SECTION I-BONDS (40 POINTS) Don't worry about decimals-all answer bones were fomated automatically - Highly recommended to use the excel formulas Question 3.0 points Calculate the invoice Price of the Elm Corp.'s Corporate Bond given the following Information FREE CALCULATION AREA Issuer: Elm Corporation 1.000 Trading Price 98.500 Trading Date Wednesday, January 16 Coupon Rate 8.002 Coupon Payment Days Mar 31. Sep 30 Face Value | 13 14 15 16 17 18 19 20 OUTPUT - ANSWERS Enter Answers Price 21 Involce Price 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Question 4.120 points ) Given the following data, using Excel formulas, calculate the YTM, all 4 years of YTC, YTW and Current Yield: : FREE CALCULATION AREA BOND CONTRACTUAL INFO: issuance Date 6/15/19 Face Value Per Bonde 1,000 Annual Coupon Payment $ $ 80.00 Term years from Issuance) 10 Redemption value at Maturity 100 Coupon Pets per years Z Call Price Provision L.E.ENTERM200 Enter Dates Year Call Price 36 37 104 103 38 39 Year 1 from Issuance Date Year 2 from Issuance Dates Year 3 from Issuance Dates Year 4 from Issuance Date 102 101 40 41 42 43 BOND TRADING INFORMATION: Trading Date Monday, November 23, 2020 44 45 Settlement Date lenter datele 9/12/2020- Current Market Price 96.00 Enter Answers Enter Answers YTM YTCI YTW YTO- 51 YTG- Current Yield YTC4- Questions 110 points Given the following data, calculate the price and Duration of the Band: 1,000 54 55 56 57 58 59 60 61 62 63 64 65 66 Face Value Coupon Rate Yield Remaining Years to Maturity Redemption Price Frequency 7.000% 9.000% 2 100 CALCULATIONS Time until Payments Payment PV of Pmt X Weight Duration (Years) ! 67 68 2 69 3 70 4 71 5 72 6 73 7 74 8 75 9 10 Enter Answer Enter Answer 78 Price Duration