How to Calculate Yield to Maturity in Excel
Yield to maturity (YTM) is the total return expected from a bond if the investor holds it until maturity, taking into account the current market price, coupon payments, and the face value of the bond.
YTM is academically defined as market interest rate, but means Yield to Maturity. It actually takes purchase price, the value of redemption, time between payment of interest, and the yield of coupon.