Assume that York Health Inc sold bonds that have a 7-yaer maturity, a 10% coupon rate with annual payments and a $1000 par value.

AWhat would be the bond's value? (Show ALL your work by typing in the calculations and demonstrating the final answer. For example, bond's value = ## + ## / ## OR by taking a snapshot of the excel formulas) (3 pts)

b.Question 3 (Continued): Suppose that two years after the bonds were issued, the required interest rate fell to 8%. What would be the bond's value? (Show ALL your work by typing in the calculations and demonstrating the final answer. For example, bond's value = ## + ## / ## OR by taking a snapshot of the excel formulas)(3 pts)

c.Question 3 (Continued): Assume that the 7-year maturity bond's current market price (NPV)is equal to $1200. The coupon rate is still 10% and the par value is $1000. What is the bond's yield to maturity? (Show ALL your work by typing in the calculations and demonstrating the final answer. For example, NPV = ## + ## / ## OR by taking a snapshot of the excel formulas)(4 pts)