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 = 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).
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* 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!


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