Excel Function : YIELD

Download now!

Excel Function : YIELD

Category

Financial

Description

Returns the yield on a security that pays periodic interest

Microsoft Excel Reference Page

https://support.office.com/en-us/article/YIELD-function-f5f5ca43-c4bd-434f-8bd2-ed3c9727a4fe

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.