Answer in excel spreadsheet showing formulas, Bond & Stock Valuation

1. JoJo Inc. issued 20-year bonds a year ago at a coupon rate of 3.9 percent. The bonds make semiannual payments and have a par value of $1,000. If the YTM on these bonds is 4.2 percent, what is the current bond price?
2. Sydney Co. has a $5,000 par value bond outstanding with a coupon rate of 6.2 percent paid semiannually and 10 years to maturity. The yield to maturity of the bond is 4.8 percent. What is the price of the bond?

3. Chapel Hill College has a bond outstanding with a coupon rate of 7.8 percent paid annually and 11 years to maturity. The yield to maturity on this bond is 4.4 percent, and the bond has a par value of $1,000. What is the price of the bond?