A company is considering issuing $10$ year bonds with a face value of $$1,000.$ The coupon rate is $5\%$ so the bonds will pay $5\%$ of the $$1,000$ face value in interest every year, or $$50.$ However, because interest is paid semiannually in two equal payments, there will be $20$ coupon payments of $$25$ each. The $$1,000$ will returned at maturity. Finally, the required rate of return$($discount rate$)$ is assumed to be $8\%.$ Prospective bond holders want to know the present value of the bonds.$$

$$Can you show formulas in excel to figure this out. I have the annual coupon rate at $5\%,$ the required return at $8\%,$ the years to maturity at $10,$ and the payment frequency at $2.$ I just need help with the PV function.