Trek, Inc., has two bonds outstanding in the market. Both Bond X and Bond Y have 6 percent coupons, make semiannual payments, and are priced at par value. Bond X has 20 years to maturity, whereas Bond Y has 10 years to maturity.

If interest rates suddenly rise by 1 percent (percentage points), what is the percentage change in the price of the two bonds?

Solve for the missing information. Please show formulas. I will upvote :)

A B C 6.0% 1,000 21 201 1/1/20001 1/1/20201 1,0001 6.0% 1,000 2 1 Input 2 Bond X: 3 Coupon rate 4 Face value 5 Coupons per year 6 Years to maturity 7 Settlement date 8 Maturity date 9 Current price 10 11 Bond Y: 12 Coupon rate 13 Face value 14 Coupons per year 15 Years to maturity 16 Settlement date 17 Maturity date 18 Current price 19 20 Calculation & Output 21 A. 22 Increase in interest rate 23 New YTM 24 New Price of Bond X 25 New Price of Bond Y 26 % change in Bond X 27 % change in Bond Y 28 101 1/1/20001 1/1/2010 1,000 1.0%