How do you calculate yield to call in excell?

Answer 1

The formula to price a callable bond is:
http://classes.bus.oregonstate.edu/ba442/CJed3.Chapter10.ppt

In the formula, C is the annual coupon (in $), CP is the call price of the bond, T is the time (in years) to the earliest possible call date, and YTC is the yield to call, with semi-annual coupons.

As with straight bonds, we can solve for the YTC, if we know the price of a callable bond.