Question: The group project can be done in either Python or Excel. The report and Excel file/Python code must be uploaded to the Assignments section on

The group project can be done in either Python or Excel. The report and Excel file/Python code must be uploaded to the Assignments section on Canvas. There should be only one copy of the assignment submitted per group (maximum of four students). On the cover page, include the names of every member of the group. The deadline is Monday October 16, 11:59 pm EDT. A corporate bond has an anual-pay coupon of 6.0% plus a face value of $1,000 at maturity. This bond has a remaining maturity of 30 years. The required rate of return on securities of similarrisk grade is 7.0%. 1. What is the value of this corporate bond today? 2. If the coupon interest payment is compounded on a semi-annual basis, what would be the value of this security today? 3. How would the price of the bond react to changing market interest rates? To find out, determine how the bond price reacts to changes in the bond's yield to maturity. Find the value of the bond using (1) the present value equation and (2) the modified duration when the YTM is (1) 6.0%, (2) 8.0%, and (3) 4.0%. Label your findings as being a premium, par, or discount bond. The group project can be done in either Python or Excel. The report and Excel file/Python code must be uploaded to the Assignments section on Canvas. There should be only one copy of the assignment submitted per group (maximum of four students). On the cover page, include the names of every member of the group. The deadline is Monday October 16, 11:59 pm EDT. A corporate bond has an anual-pay coupon of 6.0% plus a face value of $1,000 at maturity. This bond has a remaining maturity of 30 years. The required rate of return on securities of similarrisk grade is 7.0%. 1. What is the value of this corporate bond today? 2. If the coupon interest payment is compounded on a semi-annual basis, what would be the value of this security today? 3. How would the price of the bond react to changing market interest rates? To find out, determine how the bond price reacts to changes in the bond's yield to maturity. Find the value of the bond using (1) the present value equation and (2) the modified duration when the YTM is (1) 6.0%, (2) 8.0%, and (3) 4.0%. Label your findings as being a premium, par, or discount bond
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
