| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | The security settlement date is the date after the issue date when the security is traded to the buyer. Dates may be entered as text strings within quotation marks (for example, "1/30/1998" or "1998/01/30"), as serial numbers (for example, 35825, which represents January 30, 1998, if you're using the 1900 date system), or as results of other formulas or functions (for example, DATEVALUE("1/30/1998")). |
| | | The settlement date is the date a buyer purchases a coupon, such as a bond. The maturity date is the date when a coupon expires. For example, suppose a 30-year bond is issued on January 1, 1996, and is purchased by a buyer six months later. The issue date would be January 1, 1996, the settlement date would be July 1, 1996, and the maturity date would be January 1, 2026, which is 30 years after the January 1, 1996, issue date. |
| | | The maturity date is the date when the security expires. |
| | | If "settlement", "maturity", or "basis" are not integers, they are truncated. |
| | | If "settlement" = "maturity", then #NUM! is returned. |
| | | If "settlement" is not a valid date, then #NUM! is returned. |
| | | If "maturity" is not a valid date, then #NUM! is returned. |
| | | If "investment" = 0, then #NUM! is returned. |
| | | If "redemption" = 0, then #NUM! is returned. |
| | | If "basis" < 0, then #NUM! is returned. |
| | | If "basis" > 4, then #NUM! is returned. |
| | | If "basis" is left blank, then 0 is used. |
