Please help me solve this question with Excel. Thank you!

For the Treasury curve with the data given below. Exercise Ta (F Tenor Price Coupon Cpn Freq You have a sv 1 100 0.21% 2 2 100 0.23% 2 Receive 3 100 0.28% 2 Fixed and 5 100 0.48% 2 7 6 10-year 100 0.71% 2 10 100 0.97% 2 Notione 20 100 1.36% 2 What is 30 100 1.45% 2 Wha a) Estimate the forward rates assuming they are piecewise constant. Who b) Estimate the forward rates assuming they are piecewise What linear. Ending forward rate for interval equals the starting forward rate for next interval. starting in Functional form of the forward rates are given below Years 0-1 1-2 2-3 3-5 5- 7 7-10 10-20 20-30 Constant Beg/End FWD1 FWD2 FWD3 FWD4 FWD5 FWD6 FWD7 FWD8 20-30 Years 0-1 1-2 2-3 3-5 5- 7 7-10 10-20 FWD6 FWD7 Linear Begin FWD1 FWD1 FWD2 FWD3 FWD4 FWD5 Linear End FWD1 FWD2 FWD3 FWD4 FWD5 FWD6 FWD7 FWD8 Can use excel with the solver function for this exercise