show the info within excel very detailed not just the function please that does not help if you can attach excel spread sheet

1. A bond you are evaluating has a 10 percent coupon rate (compounded semiannually), a $1,000 face value, and is 10 years from maturity. a. If the required rate of return on the bond is 6 percent, what is its fair present value? b. If the required rate of return on the bond is 8 percent, what is its fair present value?