Find today's date US Treasury Yield Curve data provided in this Excel Workbook, and use it to work the problems below.

a$.$ Enter the most recent yield curve data from the provided worksheet into the corresponding yellow boxes. Use the

yield curve data as the spot rates for years $1$ through $10.$ Use interpolation to calculate the missing years.

Points $2$

Grade

b$.$ Determine the forward rates for the first $10$ years. Fill in the yellow fields in the table to the right.

Points $4$

Grade

c$.$ Determine the short rates for the first $10$ years. Fill in the yellow fields in the table to the right.

Points $3$

Grade

Short Rates

d$.$ Calculate the ten running PVs for the cash flow shown in the table to the right. Fill in the yellow fields in the table to the right.

Points $3$

Grade

Running PV