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

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

 
 Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole 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=COUPNUM("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