Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Financial > COUPDAYBS
 

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

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

 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=COUPDAYBS("25/1/2007","15/11/2008",2,1) = 71
    2=COUPDAYBS("1/25/2003","11/15/2004",2,1) = #VALUE!
    3=COUPDAYBS("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