From the below information, find the following forward rates and develop two yield curves (yield curves one year from now and two years from now) from your answers. Do the work in Excel using cell references. Please make the yield curve in Excel, use an XY scatter graph with time on the horizontal axis and rate on the vertical axis.

1 year forward rate one year from now.

2 year forward rate one year from now.

3 year forward rate one year from now.

4 year forward rate one year from now.

5 year forward rate one year from now.

1 year forward rate two years from now.

2 year forward rate two years from now.

3 year forward rate two years from now

4 year forward rate two years from now

Maturity Yield

1 1.90%

2 2.20%

3 2.35%

4 2.70%

5 3.00%

6 3.25%

7 3.50%