Yield to Maturity (YTM) Calculator Excel using Annual/Semi-annual/Monthly Coupon Rates

I Instructions: Use this calculator to find the Yield to Maturity or YTM by entering values of coupon payment (PMT), present value (PV), and future value (FV) of a stock. Please input the desired values in the form below:

Define yield to maturity of a bond/security

Yield to Maturity or YTM is a key ratio of fixed-income bonds or security in terms of the rate of return earned over the total period. YTM also known as the interest rate to be received on a bond when a holder bought it and retained it till maturity.

Theoretical formula to calculate the YTM (Yield to Maturity)

YTM Formula

P = bond/security purchase price

C = Periodical payment of the coupon

F = face value of a bond  

N = Maturity or number of times to maturity