YIELD
Returns the yield on a security that pays periodic interest
Syntax
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
Parameters
- settlement: Required. The security's settlement date
- maturity: Required. The security's maturity date
- rate: Required. The security's annual coupon rate
- pr: Required. The security's price per $100 face value
- redemption: Required. The security's redemption value per $100 face value
- frequency: Required. The number of coupon payments per year
- basis: Optional. The type of day count basis
Example
=YIELD("02/15/2024", "11/15/2027", 0.0575, 95.04287, 100, 2, 0)