Manuals/calci/coupncd
Jump to navigation
Jump to search
COUPNCD(settle, M, F, basis)
where,
Settle - the security's settlement date.
M - the security's maturity date.
F - the number of coupon payments per year and Basis- Type of day count basis.
This function returns a date that represents next coupon date after the settlement date.
F must be 1,2or 4
COUPNCD shows there value when Basis<0 or Basis>4, and settlement date greaterthan or equal to maturity date.
COUPNCD
Lets see an example in (Column3,Row2)
=COUPNCD(B2,B3,B4,B5)
where
B2=2/25/2007
B3=10/15/2008
B4=2
B5=1
COUPNCD returns (Sun APRIL 15, 2007).
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2/25/2007 | Sun Apr 15 00:00:00 UTC+0530 2007 | ||
| Row2 | 10/15/2008 | |||
| Row3 | 2 | |||
| Row4 | 1 | |||
| Row5 | ||||
| Row6 |