Manuals/calci/couppcd

COUPNCD(settle, M, F, basis)

• $Settle$ is the security's settlement date.
• $M$ is the security's maturity date(Expire date).
• $F$ is the number of coupon(interest) payments per year(1,2 or 4)
• $basis$ is the Type of day count basis.

Description

• This function returns a date that represents next coupon date after the settlement date.
• $F$ must be 1,2 or 4
• COUPNCD shows there value  when  Failed to parse (unknown function "\lt"): {\displaystyle basis\lt 0} or Failed to parse (unknown function "\gt"): {\displaystyle basis\gt 0} Basis>4,
• $Settlementdate$ must be greater than or equal to maturity date.
• $basis$ is the calender system to use.

0 - US method (NASD), 12 months of 30 days each
1 - Actual number of days in months, actual number of days in year
2 - Actual number of days in month, year has 360 days
3 - Actual number of days in month, year has 365 days
4 - European method, 12 months of 30 days each

Examples

=COUPPCD(B2,B3,B4,B5)

Where

B2=2/25/2007

B3=10/15/2008

B4=2

B5=1

COUPPCD returns (Sun Oct 15, 2006).