Returns the number of coupons payable between the settlement date and maturity date.
Söz dizimi
COUPNUM(settlement, maturity, frequency, [basis])Bağımsız değişkenler
settlementzorunlu
The security's settlement date.
maturityzorunlu
The security's maturity date.
frequencyzorunlu
The number of coupon payments per year (1=annual, 2=semiannual, 4=quarterly).
basisisteğe bağlı
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.