PRICEMAT

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

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

settlementThe settlement date of the security.
maturityThe maturity date of the security.
issueThe issue date of the security.
rateThe interest rate of the security.
yieldThe annual yield of the security.
basis(Optional) The type of day counting to use.
0 = 30/360 (default, US convention)
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = 30/360 (European convention)

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 ODDFPRICE function to return the price per $100 face value of a security with an odd first period.
* You can use the ODDLPRICE function to return the price per $100 face value of a security with an odd last period.
* 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).
* You can use the TBILLPRICE function to return the price per $100 face value for a treasury bill.
* 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!


© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top