Calculation: Each part of the project requires calculations and answering questions based on the calculations. All calculations and answers must be done on the spreadsheet. Only data given or calculated in the spreadsheet will be accepted. All arguments in a calculation must be done using reference cells.

Formatting: Each part of the project requires the creation of charts, tables, and text answers. Cells should be formatted so that the data provided, calculations, charts, tables, and text answers are arranged in an organized matter.

Part $2)$ Given are the Yield to Maturity $($YTM$)$ for bonds with terms of $1$ to $10$ years $($see Columns H to Column Q$)$ and the liquidity premiums for $1$ to $10$ years $($see Column R to Column AA$).$

Calculate: The $10$ expected one$-$year interest rates under the expectations theory.

Calculate: The $10$ expected one$-$year interest rates under the liquidity premium theory.

Calculate: Explain the differences in interest rates between the two theories.

Formatting: Create a line chart of interest rates under the two theories.

Formatting: Format cells to display data and answers. StudentID House Price Rate a Years b Rate b Years c Rate c YTM $1$ year YTM $2$ year YTM $3$ year YTM $4$ year YTM $5$ year YTM $6$ year YTM $7$ year YTM $8$ year YTM $9$ year YTM $10$ year LP $1$ year LP $2$ ear LP $3$ year LP $4$ year LP $5$ year LP $6$ year LP $7$ year LP $8$ y ear LP $9$ year LP $10$ year Start Date End Date