Excel Function 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 = US 30/360 (default) 1 = Actual/Actual 2 = Actual/360 3 = Actual/365 4 = European 30/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.
* There is also a PRICE function for a security that pays interest at regular intervals.
* There is also a PRICEDISC function for a discounted security (no interest payments).
* For the Microsoft documentation refer to support.office.com

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