Returns the number of coupons payable between the settlement date and maturity date.
Sintaxis
COUPNUM(settlement, maturity, frequency, [basis])Argumentos
settlementobligatorio
The security's settlement date.
maturityobligatorio
The security's maturity date.
frequencyobligatorio
The number of coupon payments per year (1=annual, 2=semiannual, 4=quarterly).
basisopcional
The type of day count basis to use.
The COUPNUM function calculates the total number of coupon payments that occur from the settlement date to the maturity date of a security. It is essential for financial analysts determining the remaining payment schedule for bonds or fixed-income instruments.
=COUPNUM("2023-01-01", "2025-01-01", 2)→4Calculates the number of semiannual payments over a two-year period.
Enter the dates
Ensure your settlement and maturity dates are in a format Excel recognizes, such as DATE(year, month, day).
Specify frequency
Input the integer representing how often the coupon is paid per year.
Calculate
Press Enter to see the total number of remaining coupon payments.
The function will return a #NUM! error.