# PRICEMAT

PRICEMAT(settlement, maturity, issue, rate, yield [,basis])

Returns the price of a security that pays interest at maturity.

 settlement The settlement date of the security. maturity The maturity date of the security. issue The issue date of the security. rate The interest rate of the security. yield The annual yield of the security. basis (Optional) The type of day counting to use:0 = 30/360 (default)1 = Actual/Actual2 = Actual/3603 = Actual/3654 = 30E/360

 REMARKS
 * If "settlement" is not an integer, it is truncated.* If "settlement" is not a valid date, then #NUM! is returned.* If "settlement" >= "maturity", then #NUM! is returned.* If "maturity" is not an integer, it is truncated.* If "maturity" is not a valid date, then #NUM! is returned.* If "issue" is not an integer, it is truncated.* If "issue" is not a valid date, then #NUM! is returned.* If "rate" < 0, then #NUM! is returned.* If "yield" < 0, then #NUM! is returned.* If "basis" is left blank, then 0 is used.* If "basis" is not an integer, it is truncated.* If "basis" < 0, then #NUM! is returned.* If "basis" > 4, then #NUM! is returned.* You can use the PRICE function to return the price of a security that pays interest at regular intervals.* You can use the PRICEDISC function to return the price of a discounted security (no interest payments).* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =PRICEMAT("2/15/1999", "4/13/1999", "11/11/1998", 0.061, 0.061, 0) = #VALUE!