1. Calculate the value of GEs bonds both before and after the change in bond ratings. Show the work with excel formulas thank you

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%