A 30-year bond with a settle date of 1 Jan 2021 and maturity date of 1 Jan 2051 has an 8% coupon paid annually and is callable 5 years from now at a call price of $1,100. The bond currently sells at a yield to maturity of 7%. (Please use excel to show all the calculations)

1. What is the current price of the bond if it were non-callable?

2. . What is the duration of the bond?

3. Assume the bond trades at par, what is its yield to call?

4. What is the yield to call if the call price is only $1,050?

5. What is the yield to call if the call price is $1,100, but the bond can be called in 2 years instead of 5 years?