A $4$ year Tresasury Bond with a face value of $$1000$ with $4\%$ coupon rate has a YTM$,2\mathrm{.}35\%$

Fill out the highlighted cells $($type the work in the cell. E$.$g$.,$ type" $={1000}^{**}5\%{?}^{?}$ instead of $"50).$

Bond Price using a Timeline

Period Cash Flows

Present Value of Cash Flows

Bond Price $($using the EXCEL PV function$)$

Bond Price $($sum of the above present value of cash flows$)$