Te - A 3 Merge & Center Font Alignment Number Clipboard 126 7.0% 100 2 20 100 A 1 Input 2 Bond X: 3 Coupon rate 4 Face value 5 Coupons per year 6 Years to maturity 7 Current price 8 9 Bond Y: 10 Coupon rate 11 Face value 12 Coupons per year 13 Years to maturity 14 Current price 15 16 17 Calculation & Output 18 Question 11 19 Increase in interest rate 20 New YTM Bond X 21 New Price of Bond X 5.5% 100 100 3.0% Task 2 - Time Value of Money Task 3 - DCF Task 4 - Loan Amortization Task 5 - Bond + Type here to search O File Expl E 112 - A Times New Roman as Wrap Text General SEE E Merge & Center Merge & Center $ % aste BI UB F Number Clipboard Font Alignment 26 fi H D AA B Current price 100 4 15 16 17 18 19 Calculation & Output Question 11 Increase in interest rate New YTM Bond X New Price of Bond X 3.0% 20 21 22 23 Net YTM Bond Y P- 24 25 26 27 % change in Bond X % change in Bond Y 28 29 30 31 Question 12 One of the GoodConstruction's Rivals, Deere & Company, has an outstanding bond with 20 years to maturity, offering a yield higher than the YTM provided by GoodConstruction's bond with a similar maturity. In your opinion, which should be the expla YTM offered by the two bonds? 32 33 34 Task 2 - Time Value of MoneyTask 3 - DCF Task 4 - Loan Amortization Task 5 Bond + Type here to search O a File Explo $