Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft 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 of the security.
 frequencyThe number of coupon payments in a year:
1 = annual
2 = semi annual
4 = quarterly
 basisThe type of day counting to use:
0 = US 30/360
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 date is the date a buyer purchases a coupon, such as a bond.
     
  		• The maturity date is the date when the security expires.
     
  		• If any of the arguments are not integers, they are truncated.
     
  		• 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 "frequency" is any number other than 1, 2 or 4, then #NUM! is returned.
     
  		• If "basis" < 0, then #NUM! is returned.
     
  		• If "basis" > 4, then #NUM! is returned.
     
  		• If "basis" is left blank, then 0 is used.
     
  		• What if the "maturity" date has passed ??

     EXAMPLES
     
     A
    1=COUPDAYSNC("1/25/1998","11/15/1999",2.3,1.5) = #VALUE!
    2=COUPDAYSNC("1/25/1998","11/15/1999",2,1.5) = #VALUE!
    3=COUPDAYSNC("1/25/1998","11/15/1999",2,1) = #VALUE!
    		 
     Functions - C | Index - C | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top