EXCEL FORMAT PLEASE.

Zorp Corporation also has some bonds for sale that your company is considering. These bonds have a $1,000 par value and will mature in 16 years. The coupon rate on the bonds is 5% paid annually, and they are currently selling for $987 each. The bonds are call protected for the next 4 years, and after this period, they are callable at 105. On the basis of this information, answer the following questions:

If the bonds are called immediately after the call protection period, what would be the yield to call (YTC)?

If the bonds paid interest semiannually instead of annually, would the YTC, the YTM, or both change? Explain your answers.