Question: Could you please answer by Excel Bond J has a coupon rate of 4 percent and Bond K has a coupon rate of 10 percent.
Could you please answer by Excel

Bond J has a coupon rate of 4 percent and Bond K has a coupon rate of 10 percent. Both bonds have 13 years to maturity, make semiannual payments, and have a YTM of 7 percent. a. If interest rates suddenly rise by 2 percent, what is the percentage price change of these bonds? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. What if rates suddenly fall by 2 percent instead? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) a. Bond J % a. Bond K % b. Bond J % b. Bond K % Bond J has a coupon rate of 4 percent and Bond K has a coupon rate of 10 percent. Both bonds have 13 years to maturity, make semiannual payments, and have a YTM of 7 percent. a. If interest rates suddenly rise by 2 percent, what is the percentage price change of these bonds? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. What if rates suddenly fall by 2 percent instead? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) a. Bond J % a. Bond K % b. Bond J % b. Bond K %
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
