I'm having difficulty entering the correct formulas and solutions into EXCEL.

5) The following table contains data to calculate forward rates using pure expectations theory. a) Find the yield on a 8 year bond, 2 years forward (2/8). b) Find the yield on a 6 year bond, 3 years forward (36). Maturity 1 year 2 years 3 years 4 years 5 years 6 7 years 8 years 9 years 10 years Yield 2.00% 2.20% 3.40% 4.50% 5.00% 5.00% 5.20% 5.40% 5.50% 5.50% year