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 |
|
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top