Please show in excel with formulas

4. An investor believes in the pure expectation hypothesis and observes the following yield curve: (6 points) Forward Rate 3.000% Maturity (years) 1 2 3 Zero Coupon Yield 3.00% 3.50% 4.75% a. Compute the forward rates for Year 2 & Year 3 b.According to this investor, how much should a 2-year 6% annual coupon bond be priced at a year from now? c. You find the following information about a futures contract on a 2-year bond deliverable one year from now. The underlying deliverable is assumed to have two years to maturity and a 6% annual coupon rate. [Note: quotes are based on a tick size of 1/32nds] Expiration One year from today Last Quote 100'14 Change -0'16 Based on this information, will the investor long or short the futures contract today? If she is correct in her assessment of the price of the bond one year from now, how much profit will she generate (I want to know how much $$ profit per bond) 4. An investor believes in the pure expectation hypothesis and observes the following yield curve: (6 points) Forward Rate 3.000% Maturity (years) 1 2 3 Zero Coupon Yield 3.00% 3.50% 4.75% a. Compute the forward rates for Year 2 & Year 3 b.According to this investor, how much should a 2-year 6% annual coupon bond be priced at a year from now? c. You find the following information about a futures contract on a 2-year bond deliverable one year from now. The underlying deliverable is assumed to have two years to maturity and a 6% annual coupon rate. [Note: quotes are based on a tick size of 1/32nds] Expiration One year from today Last Quote 100'14 Change -0'16 Based on this information, will the investor long or short the futures contract today? If she is correct in her assessment of the price of the bond one year from now, how much profit will she generate (I want to know how much $$ profit per bond)