A $25-$Year $$1,000$ Par Value Bond has an Annual Coupon Rate of $6\%.$ If The YTM for this bond Is $8\%,$ What is the price of this bond?

$\backslash$table$[[$Par Value,$1,000\mathrm{.}0$

$($Please solve these with excel formulas that i can fill into the yellow boxes. Thank you so much. Im not sure if #$1$ that I did is correct$)$