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.

Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome.

In cell B4, enter the formula "=-PMT (B2/1200,B3*12,B1)" to have Excel automatically calculate the monthly payment.For example, if you had a $25,000 loan at 6.5 percent annual interest for 10 ...