Excel Function : YIELD

Download now!

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: YIELD(, , , , , , []) Where: - The security's settlement date. - The security's maturity date. - The security's annual coupon rate. - The security's price per $100 face value. - The security's redemption value per $100 face value. - The number of coupon payments per year. - The type of day count basis to use.

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.