please show within excel with great detail please

9. A bond you are evaluating has a 10 percent coupon rate (compounded semiannually), a $1.000 face value, and is a. If the required rate of return on the bond is 6 percent, b. If the required rate of return on the bond is 8 percent. c. What do your answers to parts (a) and (b) say about the 10 years from maturity. (LG 3-4) what is its fair present value? what is its fair present value relation between required rates of return and fair values of bonds