Excel Function : YIELD
Returns the yield on a security that pays periodic interest
Microsoft Excel Reference Page
Syntax and Description of the YIELD Excel Function
The YIELD function syntax is as follows:
About YIELD Excel Function
The YIELD function returns the yield to maturity of a security with periodic interest payments. The yield is the annual interest rate that the security pays, expressed as a percentage of the security's price.