Menu
EXCEL COUPNUM FUNCTION
Excel COUPNUM Function Introduction
The Excel Coupnum technique calculates the amount of discounts payable between such a security’s closing date and maturity period, collected to the closest whole cent.
Description of Excel COUPNUM Function
Syntax:
=COUPNUM( settlement, maturity, frequency, [basis] )
Parameter:
- The arguments are as follows:
settlement:
- The settling date of the security.
maturity:
- The maturity date of the security.
frequency:
- An integer reflecting 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 that defines the day count basis to be utilised.
This must be one of the following values:
| 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 COUPNUM Function
Example :
The Excel Coupnum function is shown in Cell A3 of the spreadsheet below to determine the number of coupon payments for a security that employs the US (NASD) 30/360 day count basis, has a settlement date of 01-Jan-2011, a maturity date of 25-Oct-2012, and 4 coupon payments each year.
Key Points
- #NUM! – Occurs if any of the following conditions are met: the supplied settlement date is mature date; the given frequency arguments is an integer which is not equal to 1, 2, or 4; and the supplied [basis] justification is a number that is not equal to 0, 1, 2, 3, or 4.
- #VALUE! – Occurs when either the specified settlement or maturity dates are not valid Excel dates; Any of the given arguments is not a number.
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
