Manuals/calci/COUPNCD

COUPNCD(Settlement, Maturity, Frequency, Basis)

• Where $Settlement$ is the security's settlement date (a date when coupon or a bond is purchased),
• $Maturity$ is the security's maturity date (a date when coupon or a bond expires),
• $Frequency$ is the number of coupon payments per year, and
• $Basis$ is the type of day count basis to use.
  • COUPNCD(), returns the next coupon date after the settlement date.

Description

COUPNCD(Settlement, Maturity, Frequency, Basis)

• $Settlement$ and $Maturity$ dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
• If $Settlement$ date = $Maturity$ date, Calci displays #N/A error message.
• The values for $Frequency$ should be 1,2 or 4.

For Annual payment, frequency = 1,

For Semi-annual payment, frequency = 2,

For Quarterly payment, frequency = 4.

• 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} value is optional. If omitted, Calci assumes it to be 0.

Below table shows the use of 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} values:

Basis	Description
0	US (NASD) 30/360
1	Actual/actual
2	Actual/360
3	Actual/365
4	European 30/360

• If 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} value is other than 0 to 4, Calci displays #N/A error message.

Examples

Consider the following example that shows the use of COUPNCD function:

06/20/2010
12/20/2014
2
1

1. =COUPNCD(A1,A2,A3,A4) displays Mon Dec 20 2010 15:30:06 GMT+0530 (India Standard Time) as a result.

2. =COUPNCD(DATE(2012,1,31),DATE(2014,1,6),1,1) displays Sun Jan 06 2013 00:00:00 GMT+0530 (India Standard Time) as a result.

Related Videos

COUPNCD

See Also

• COUPNUM
• COUPDAYS
• COUPDAYBS
• COUPDAYSNC

References

• Coupon
• Day Count Basis

• List of Main Z Functions

• Z3 home