please solve with excel!

Based on the expectations above of the real rates and the inflation rates for each of the next $5$ years, you should be able to determine the corresponding nominal rates $($long rates$)$ and implied forward rates $(1-$year rates$)$ if the Pure Expectations Theory holds.

Assume that the Liquidity Preference theory of the term structure is correct and that the market requires an additional maturity risk premium equal to $(0\mathrm{.}1\%)($t$-1),$ where t is the number of years to maturity.$$ Determine how much you would pay today for a $5-$year, zero$-$coupon Treasury bond that will mature for $$10,000.$