Please show your work using EXCEL and layout formula for inputing calculation into a HP 10B2 Financial Calculator.

8. What is the annual coupon rate of a 10-year bond outstanding that has 6% annual required rate and $1147.20 in present value (future value=$1000.00)? a. 2% b.4% c. 8% d. 10% e. None of the above 9- What is the annual required rate of a 10-year bond outstanding that has 4% coupon rate and $922.78 in present value (future value=$1000.00)? a. 4% b. 5% c. 6% d. 7% e. None of the above 10- How many years left in a 10-year bond outstanding with 10% annual coupon rate, 12% annual required rate, and $908.73 in its fair value (future value-$1000.00)? a. 3 years b. 5 years c. 7 years d. 9 years e. None of the above