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

ACCRINTM(issue, maturity, rate [,par] [,basis])

 
 Returns the accrued interest for a security that pays interest at maturity.

 issueThe date the security is issued.
 maturityThe maturity date of the security.
 rateThe annual coupon rate of the security.
 parThe par value of the security.
 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.
     
  		• Dates must be entered as text strings within quotation marks or as serial numbers.
     
  		• The maturity date is the date that the security expires.
     
  		• If "issue" is not an integer, it is truncated.
     
  		• If "issue" is not a valid date, then #VALUE! is returned.
     
  		• If "issue" >= "maturity", then #NUM! is returned.
     
  		• If "maturity" is not an integer, it is truncated.
     
  		• If "maturity" is not a valid date, then #VALUE! is returned.
     
  		• If "rate" <= 0, then #NUM! is returned.
     
  		• If "par" <= 0, then #NUM! is returned.
     
  		• If "par" is left blank, then 1000 is used.
     
  		• If "basis" is not an integer, it is truncated.
     
  		• If "basis" < 0, then #NUM! is returned.
     
  		• If "basis" > 4, then #NUM! is returned.
     
  		• If "basis" is left blank, then 0 is used.
     
  		• You can use the DATE() function to enter your dates.

     EXAMPLES
     
     A
    1=ACCRINTM("1/1/2003","1/7/2005",0.04,1000,0) = 100
    2=ACCRINTM("1/1/2003","1/7/2003",0.04,1000,0) = 20
    3=ACCRINTM("1/1/2003","1/7/2003",0.04,,0) = 20
    4=#N/A = #N/A
    5=ACCRINTM("1/1/2003","1/7/2003",0.04,,2) = 20.1
    6=ACCRINTM(DATE(2003,1,1),"1/7/2003",0.04,,2) = 20.1
    7=#N/A = #N/A
    8=ACCRINTM("1/1/2003","1/7/2003",0.04,-100,0) = #NUM!
    9=ACCRINTM("1/1/2003","1/7/2003",0.04,,-1) = #NUM!
    10=ACCRINTM("1/1/2003","1/7/2003",0.04,,5) = #NUM!
    11=ACCRINTM(DATE(2003,1,1),"1/17/2003",0.04,,2) = #VALUE!
    		 
     Functions - A | Index - A | Office Online 

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