PLEASE USE EXCEL

You observe the following Treasury yields $($all yields are shown on a bond$-$equivalent basis$)$:

$\backslash$table$[[$Year$,$Yield to Maturity,Spot Rate$],[0\mathrm{.}5,10\%,10\mathrm{.}00\%$