Excel ACCRINTM Function

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

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

issue	The date the security is issued.
maturity	The maturity date of the security.
rate	The 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

Remarks

* 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!

Expand ...

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.

Top