COUPNCD Function Explained
The COUPNCD function in Microsoft Excel is used to calculate the next coupon date after the settlement date. It takes three arguments: the settlement date, the maturity date, and the frequency of the coupon payments. The settlement date is the date on which the security is traded, and the maturity date is the date on which the security will expire. The frequency of the coupon payments is the number of coupon payments per year.
The function returns the next coupon date after the settlement date. This is the date on which the bondholder will receive the next coupon payment. The COUPNCD function assumes that the first coupon payment is made on the maturity date, and that subsequent coupon payments are made on the same day of each month or quarter, depending on the frequency specified.
COUPNCD Function Syntax
The syntax for the COUPNCD function in Microsoft Excel is:
COUPNCD(settlement,maturity,frequency)
The function takes three arguments:
settlement: This is the settlement date of the security, which is the date on which the security is traded and the buyer takes ownership. This argument must be a valid Excel date serial number or a valid date enclosed in quotation marks. If the date is earlier than the security’s issue date, the function returns the #NUM! error value.maturity: This is the maturity date of the security, which is the date on which the security will expire. This argument must be a valid Excel date serial number or a valid date enclosed in quotation marks. If the maturity date is before the settlement date, the function returns the #NUM! error value.frequency: This is the number of coupon payments per year. This argument must be either 1, 2, or 4, corresponding to annual, semiannual, or quarterly payments, respectively. If the value is not one of these three options, the function returns the #NUM! error value.