|
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft Excel > Functions > Financial > PRICEMAT |
PRICEMAT(settlement, maturity, issue, rate, yld [,basis]) |
| Returns the price per $100 face value 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. | |
| yld | The annual yield of the security. | |
| basis | The type of day counting to use: 0 = US 30/360 1 = Actual/Actual 2 = Actual/360 3 = Actual/365 4 = European 30/360 |
| REMARKS |
| This function is only available if you have the Analysis ToolPak add-in installed. | ||
| 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 "yld" < 0, then #NUM! is returned. | ||
| If "basis" is not an integer, it is truncated. | ||
| If "basis" < 0, then #NUM! is returned. | ||
| If "basis" > 4, then #NUM! is returned. | ||
| If "basis" is left blank, then 0 is used. |
| EXAMPLES |
|
| Functions - P | Index - P | Office Online |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | Top |