7-18 Yield To Maturity And Yield to call

Kaufman Enterprises has bonds outstanding with a $1000 face value and 10 years left until maturity. They have an 11% annual coupon payment, and their current price is $ 1175. the bonds may be called in 5 years at 109% of face value.

B) What is the yield to call if they are called in 5 years?

C) Which yield might investors expect to earn on these bonds? why?

D) The bonds indenture indicates that the call provision gives the firm the right to call the bonds at the end of each year beginning in year 5. In year 5, the bonds may be called at 109% of face value; but in each of the next 4 years, the call percentage will decline by 1%. thus, i year 6, they may be called at 108% of face value; in year 7, they may be called at 107% of face value, and so forth. If the yield curve is horizontal and interest rates remain at their current level, when is the latest that investors might expect the firm to call the bond?

Please answer in excel format