Returns the number of coupons payable between the settlement date and maturity date.
구문
COUPNUM(settlement, maturity, frequency, [basis])인수
settlement필수
The security's settlement date.
maturity필수
The security's maturity date.
frequency필수
The number of coupon payments per year (1=annual, 2=semiannual, 4=quarterly).
basis선택
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.