Functions

COUPNCD

Next coupon date after settlement

Try it

When to use it

When should I use COUPNCD?

Use COUPNCD to find the exact date of the next coupon payment after the settlement date — helpful when scheduling cash-flow projections for bond portfolios.

Used in

finance

Syntax

COUPNCD(settlement, maturity, frequency, [basis])

Examples

=COUPNCD(DATE(2010,2,1),DATE(2019,12,31),4) // => 40268
=COUPNCD(DATE(2011,1,25),DATE(2011,11,15),2,1) // => 40678

COUPDAYSNC

Days from settlement to next coupon

COUPNUM

Number of coupons between settlement and maturity