Menu
EXCEL COUPDAYSNC FUNCTION
Excel COUPDAYSNC function Function Introduction
The Excel Coupdaysnc function estimates the number of days from the settlement date to the next coupon date for a securities under specified criteria.
Description of Excel COUPDAYSNC function Function
Syntax:
=COUPDAYSNC( settlement, maturity, frequency, [basis] )
Parameter:
- The following are the arguments:
settlement:
- The security’s settlement date.
maturity:
- The security’s maturity date.
frequency:
- An integer indicating the number of coupon payments made every year. This must have a value of 1, 2, or 4, implying:
| 1 | – | Annually |
| 2 | – | Semi-Annually |
| 4 | – | Quarterly |
[basis]:
- An optional integer input indicating the day count basis to be utilised.
This must be one of the values listed below:
| Basis | Day Count Basis |
|---|---|
| 0 (or omitted) | US (NASD) 30/360 |
| 1 | actual/actual |
| 2 | actual/360 |
| 3 | actual/365 |
| 4 | European 30/360 |
Step By Step Guide of COUPDAYSNC function Function
Example :
Cell A3 of the spreadsheet below provides an example of the Excel Coupdaysnc function, which is used to calculate the number of days between the settlement date of a securities and the next coupon date. The security has a settlement date of January 1, 2011, a maturity date of October 25, 2012, and four payments per year. The 30/360 day count system is used in the United States (NASD).
Key Points
- #NUM! -Happens if either:
The given settlement date is maturity date; the supplied frequency argument is a number that is not one of one, two, or four; and the supplied [base] argument is a number that is not one of zero, one, two, three, or four. - #VALUE!-Occurs if either the specified settlement or maturity dates are not valid Excel dates; or if any of the supplied arguments is non-numeric. .
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
