please show work on excel

(Bond valuation) Enterprise, Inc, bonds have an annual coupon rate of 12 percent. The interest is pad somiannualy and the bonds mature in 9 years. Their par value is $1,000. If the market's required yield to maturity on a comparable-isk bond is 15 percent, what is the value of the bond? What is its value if the unterest is paid annually? a. The value of the Enterprise bonds if the interest is paid semiarmually is $ (Round to the nearest cent.)