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 ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.