please show answer using excel

Spot Interest Rates The price of a one-year strip is 97.56%, the price of a four-year strip is 87.48%. Given the following treasury bonds below, calculate the spot and forward interest rates. Put your final answers in the highlighted areas. Show your work in the current worksheet. Assume that bonds pay annual coupons, for simplicity. Tip: Use Bond A and B to replicate the cashflows of a five-year strip. Bond A Maturity (years) Coupon 5 2 5 3 3 5 Price (%) 92.89 97.43 105.42 B Price Year 1 2 3 Bond A Bond B Bond C Year 5 102 Year 2 2 3 5 Year 3 2 3 105 Year 4 2 3 103 5 1 10.1 2 3 12.- 4 5 Spot Interest Rates The price of a one-year strip is 97.56%, the price of a four-year strip is 87.48%. Given the following treasury bonds below, calculate the spot and forward interest rates. Put your final answers in the highlighted areas. Show your work in the current worksheet. Assume that bonds pay annual coupons, for simplicity. Tip: Use Bond A and B to replicate the cashflows of a five-year strip. Bond A Maturity (years) Coupon 5 2 5 3 3 5 Price (%) 92.89 97.43 105.42 B Price Year 1 2 3 Bond A Bond B Bond C Year 5 102 Year 2 2 3 5 Year 3 2 3 105 Year 4 2 3 103 5 1 10.1 2 3 12.- 4 5