COUPNUM
Returns the number of coupons payable between the settlement date and maturity date.
FinancialFinance & Accounting
What it does
Counts how many coupons remain to be paid.
Syntax
COUPNUM(settlement, maturity, frequency, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.frequency(number) — Coupons per year.
Examples
Remaining Coupons
Count payments left.
FORMULA
=COUPNUM(DATE(2023,1,25), DATE(2024,11,15), 2, 1)
RESULT
4
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Settlement | Maturity |
| 2 | 2023-01-25 | 2024-11-15 |