COUPNCD
Returns the next coupon date after the settlement date.
FinancialFinance & Accounting
What it does
Calculates the next coupon date after settlement.
Syntax
COUPNCD(settlement, maturity, frequency, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.frequency(number) — Coupons per year.
Examples
Next Coupon Date
Find next payment date.
FORMULA
=COUPNCD(DATE(2023,1,25), DATE(2023,11,15), 2, 1)
RESULT
2023-05-15
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Settlement | Maturity |
| 2 | 2023-01-25 | 2023-11-15 |