please explain this in excel with formulas given

4 and 5 both is a 1 whole problem

Bookt Formulas Data Review View @su. Home Insert Draw Page Layout Calibri (Body) 12 Copy BI U. 8 Format 137 x fx Analytic Solver Wrap Tort A-A- General Daste A Margo & Cantar - $. % > Condition Formattin E Treasury 100 3.00% 100 3.00% 4 5 > Use the following information. All bonds are issued by US Treasury and will pay coupons annually Bond B C D 5. Issue Treasury Treasury Treasury Treasury Face Value 100 100 100 Coupon Rate 3.0096 3.00% 3.00% Price 100 Maturity 1 2 3 10 The sequence of spot rates and forward rates are shown below 13 Time to Maturity Spot (OR) Forward in 1) 3.00% 3.00% 2 2,90% 2.80% 3 2.70% 16 4 2.60% 5 2.50% 10 20 224) The YTM of the Bond Dis doset to 23 24 Group of answer choo 2.78% 2.88% 2.98 3.08% 23 Jd 11 5) The YTM of the Bond Eis close to Group of answer choices 2.72% 2.73% 2.74% 2.75% 11 1 1 Bookt Formulas Data Review View @su. Home Insert Draw Page Layout Calibri (Body) 12 Copy BI U. 8 Format 137 x fx Analytic Solver Wrap Tort A-A- General Daste A Margo & Cantar - $. % > Condition Formattin E Treasury 100 3.00% 100 3.00% 4 5 > Use the following information. All bonds are issued by US Treasury and will pay coupons annually Bond B C D 5. Issue Treasury Treasury Treasury Treasury Face Value 100 100 100 Coupon Rate 3.0096 3.00% 3.00% Price 100 Maturity 1 2 3 10 The sequence of spot rates and forward rates are shown below 13 Time to Maturity Spot (OR) Forward in 1) 3.00% 3.00% 2 2,90% 2.80% 3 2.70% 16 4 2.60% 5 2.50% 10 20 224) The YTM of the Bond Dis doset to 23 24 Group of answer choo 2.78% 2.88% 2.98 3.08% 23 Jd 11 5) The YTM of the Bond Eis close to Group of answer choices 2.72% 2.73% 2.74% 2.75% 11 1 1