How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.

Effective use of the Yield function requires that you correctly format all the dates input. This formula contains a very specific syntax: "YIELD (settlement, maturity, rate, price, redemption ...