It is difficult to calculate these values manually and while calculators make it easier, Excel is the preferred tool for finding these values over a range of cells.

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.

I hope the previous post of this series (Part 1, Part 2, Part 3) have served you well. My goal was never to create an Excel manual for everyone, but ...