Bond J has a coupon rate of 6 percent and Bond K has a coupon rate of 12 percent. Both bonds have 15 years to maturity, make semiannual payments, and have a YTM of 9 percent. If interest rates...

How can I calculate using excel? (see screenshot)

Extracted text: Bond J has a coupon rate of 6 percent and Bond K has a coupon rate of 12 percent. Both bonds have 15 years to maturity, make semiannual payments, and have a YTM of 9 percent. 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.) а. а. Bond J % Bond K % b. Bond J % Bond K %