YIELDMAT
Returns the annual yield of a security that pays interest at maturity
Syntax
YIELDMAT(settlement, maturity, issue, rate, pr, [basis])
Parameters
- settlement: Required. The security's settlement date
- maturity: Required. The security's maturity date
- issue: Required. The security's issue date
- rate: Required. The security's interest rate at date of issue
- pr: Required. The security's price per $100 face value
- basis: Optional. The type of day count basis
Example
=YIELDMAT("03/15/2024", "11/03/2024", "11/08/2023", 0.0625, 100.0123, 0)