Manuals/calci/coupncd

COUPNCD(settle, M, F, basis)

• Settle - the security's settlement date.
• M - the security's maturity date.
• F - the number of coupon payments per year
• Basis - 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  Basis<0 or Basis>4,
• Settlement date greater than or equal to maturity date.

Examples

?UNIQ17b134979b170de4-nowiki-00000003-QINU?

where

B2=2/25/2007

B3=10/15/2008

B4=2

B5=1

COUPNCD returns (Sun APRIL 15, 2007).