Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Financial > COUPDAYSNC
 

COUPDAYSNC(settlement, maturity, frequency [,basis])

 
 Returns the number of days from the settlement date to the next coupon.

 settlementThe settlement date of the security.
 maturityThe maturity date of the security.
 frequencyThe number of coupon payments in a year:
1 = annual
2 = semi annual
4 = quarterly
 basis(Optional) The type of day counting to use:
0 = US 30/360 (default)
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = European 30/360

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• The "settlement" is the date a buyer purchases a coupon, such as a bond.
     
  		• The" maturity" is the date when the security expires.
     
  		• If "settlement" >= "maturity", then #NUM! is returned.
     
  		• If "settlement" is not a valid date, then #NUM! is returned.
     
  		• If "maturity" is not a valid date, then #NUM! is returned.
     
  		• If "maturity" has passed, then #VALUE! is returned.
     
  		• If "frequency" is not an integer, then it is truncated.
     
  		• If "frequency" is any number other than 1, 2 or 4, then #NUM! is returned.
     
  		• If "basis" is left blank, then 0 is used.
     
  		• If "basis" is not an integer, then it is truncated.
     
  		• If "basis" < 0, then #NUM! is returned.
     
  		• If "basis" > 4, then #NUM! is returned.
     
  		• Example 1 -
     
  		• Example 2 -
     
  		• Example 3 -
     
  		• Example 4 -
     
  		• Example 5 -

     EXAMPLES
     
     A
    1=COUPDAYSNC("1/25/2004","11/15/2010",2.3,1.5) = #VALUE!
    2=COUPDAYSNC("1/25/2009","11/15/2010",2,1.5) = #VALUE!
    3=COUPDAYSNC("1/25/2009","11/15/2010",2,1) = #VALUE!
    		 
     Functions - C | Index - C | Office Online 2003 | Office Online 2007 

     Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top