| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | The settlement date is the date a buyer purchases a coupon, such as a bond. . 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 a coupon expires. |
| | | If "settlement" is not an integer, it is truncated. |
| | | If "settlement" = "maturity", then #NUM! is returned. |
| | | If "maturity" is not an integer, it is truncated. |
| | | If "rate" < 0, then #NUM! is returned. |
| | | If "yld" < 0, then #NUM! is returned. |
| | | If "redemption" = 0, then #NUM! is returned. |
| | | If "frequency" is any number other than 1, 2 or 4, then #NUM! is returned. |
| | | If "frequency" is not an integer, it is truncated. |
| | | If "basis" < 0, then #NUM! is returned. |
| | | If "basis" > 4, then #NUM! is returned. |
| | | If "basis" is not an integer, it is truncated. |
| | | If "basis" is left blank, then 0 is used. |
