PRICEMAT
Returns the price per $100 face value of a security that pays interest at maturity
Syntax
PRICEMAT(settlement, maturity, issue, rate, yld, [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
- yld: Required. The security's annual yield
- basis: Optional. The type of day count basis
Example
=PRICEMAT("02/15/2024", "04/13/2024", "11/11/2023", 0.0610, 0.0609, 0)