The COUPNCD function returns a number that represents the next coupon date after the settlement date.
|settlement||The security’s settlement date – the date after the issue date when the security is traded to the buyer|
|maturity||The security’s maturity date – the date when the security expires|
|frequency||The number of coupon payments per year. Must be one of the following:
|[basis]||Optional. Defines the day count basis to be used in the calculation
The financial day count basis rules are explained in detail on the Wikipedia Day Count Convention page
Note: The settlement and maturity dates should be input as either:
- References to cells containing dates, or
- Dates returned from formulas
If you attempt to input these date arguments as text, Excel may misinterpret them, due to different date systems, or date interpretation settings.
Warning: Although you can input the date arguments as date serial numbers, this is not recommended as date serial numbering does vary across different computer systems.
|8||=COUPNCD(A2,A3,A4,A5)||15-May-2014||The next coupon date after the settlement date, for a bond with the above terms|
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any of the arguments are non-numeric|
|#NUM!||Occurs if either:
|#NAME?||Occurs when Analysis ToolPak add-in is not enabled|