Find out the best practices for most financial modeling to price a bond, calculate coupon payments, and calculate a bond's yield to maturity in Microsoft Excel.

To calculate the current yield of a bond in Microsoft Excel, enter the bond value, the coupon rate, and the bond price into adjacent cells (e.g., A1 through A3).

Calculating yields “YTM is the true indicator of return on investment. ... (Microsoft Excel) to compute the yield on the bond. Key in the data as shown in the screenshot below.