1. Identify the bonds that have the greatest change in value. Explain why those bonds had the greatest change in value. Please show the work through excel. Thank you very much

Standard & Poor's currently rates General Electric's (GE) debt as BBB GE's capital structure includes the following debt securities: Type Bonds and Notes Bonds and Notes Other Borrowings Principal Due (USD) 748.0 1,277.0 1,002.0 Coupon/Base Rate 4.250% 4.350% 5.030% Maturity 2040 2050 Sep-30-2022 Description 4.250% Notes Due 2040 4.350% Notes Due 2050 Current Portion of Long- Term Borrowings Senior Unsecured Debt - 3.450% Notes Due 2027 * Senior Unsecured Debt - 3.625% Notes Due 2030 * Bonds and Notes 1,000.0 3.450% 2027 Bonds and Notes 1,250.0 3.625% 2030 As provided above, GE's credit rating is currently BBB. Assume that GE's debt is downgraded one grade to BB. Current yields for both BBB and BB rated bonds are: # Term 1-year 5-year 6-year 7-year 8-year 9-year 10-year 19-year 29-year BBB 0.99% 2.30% 2.50% 2.68% 2.84% 2.98% 3.10% 3.75% 3.84% BB 2.05% 3.76% 4.05% 4.31% 4.54% 4.74% 4.93% 5.91% 6.08%