Excel Function : COUPNCD
Category
Financial
Description
Returns the next coupon date after the settlement date
Microsoft Excel Reference Page
https://support.office.com/en-us/article/COUPNCD-function-fd962fef-506b-4d9d-8590-16df5393691f
Syntax and Description of the COUPNCD Excel Function
I am trying to use the COUPNCD Excel function but cannot find a syntax for it.
I am trying to do a simple yield to maturity calculation for a bond, but the COUPNCD function doesn't seem to work.
Anyone have a syntax for it?
A:
It is a simple formula.
COUPNCD(settlement date,maturity date,frequency,basis)
Where
settlement date
is the date that you purchase the bond
maturity date
is the date that the bond matures
frequency
is how often
About COUPNCD Excel Function
COUPNCD(settlement, maturity, frequency, [basis], [calc_method]) The COUPNCD function syntax has the following arguments: Settlement Required. The security's settlement date. The settlement date must be entered as a date value. Maturity Required. The security's maturity date. The maturity date must be entered as a date value. Frequency Required. The number of coupon payments per year. Basis Optional. The type of day count basis to use. Calc_method Optional. A number that specifies the type of price to return. The COUPNCD function returns the next coupon payment date after the settlement date.