Manuals/calci/coupncd

COUPNCD(s,m,f,b)

• $s$ 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)
• $b$ 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 (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle basis\lt 0} or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle basis\gt 0} Basis>4,
• $Settlementdate$ must be greater than or equal to maturity date.
• $b$ 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

• COUPNCD returns errors when

Settlement$(s)$ or Maturity$(m)$ is not a valid date.
Frequency$(f)$ is any number other than 1, 2, or 4.
Basis$(b)$ < 0 or if Basis$(b)$ > 4.
Settlement$(s)$ ≥ Maturity$(m)$.

Examples

?UNIQ17b134979b170de4-nowiki-00000003-QINU?

where

B2=2/25/2007

B3=10/15/2008

B4=2

B5=1

COUPNCD returns (Sun APRIL 15, 2007).

• =COUPNCD("2007/02/21","2008/02/21",2,1)

Tue Aug 21 2007 00:00:00 GMT+0530 (India Standard Time)

• =COUPNCD("2005-07-13", "2009-01-18", 2, 3)

Mon Jul 18 2005 05:30:00 GMT+0530 (India Standard Time)

See Also

• COUPNCD
• CUMIPMT
• CUMPRINC

References

COUPNCD