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.
par(Optional) The par value of the security (1000).
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

* 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 left blank, then 0 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.
* You can use the DATE function to enter your dates.
* For the Microsoft documentation refer to support.office.com.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.

 A
1=ACCRINTM("1/1/2011","1/12/2011",0.06,1000,0) = 55
2=ACCRINTM("1/1/2003","1/7/2005",0.04,1000,0) = 100
3=ACCRINTM("1/1/2003","1/7/2003",0.04,1000,0) = 20
4=ACCRINTM("1/1/2003","1/7/2003",0.04,,0) = 20
5=#N/A = #N/A
6=ACCRINTM("1/1/2003","1/7/2003",0.04,,2) = 20.1
7=ACCRINTM(DATE(2003,1,1),"1/7/2003",0.04,,2) = 20.1
8=#N/A = #N/A
9=ACCRINTM("1/1/2003","1/7/2003",0.04,-100,0) = #NUM!
10=ACCRINTM("1/1/2003","1/7/2003",0.04,,-1) = #NUM!
11=ACCRINTM("1/1/2003","1/7/2003",0.04,,5) = #NUM!
12=ACCRINTM(DATE(2003,1,1),"1/17/2003",0.04,,2) = #VALUE!

1 - How much interest has accrued at maturity on a US treasury bond with a par value of $1,000 issued on 1 Jan 2011 with a maturity date of 1 Dec 2011 with a coupon of 6% paid semi-annually with a day count of 30/360.


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top