ACCRINT(issue, first_interest, settlement, rate, par ,frequency [,basis] [,calc_method])

Returns the accrued interest for a security that pays interest periodically.

issueThe date the security is issued.
first_interestThe date when the initial interest is paid.
settlementThe settlement date of the security.
rateThe annual interest rate or coupon when the security was issued.
parThe par value of the security.
frequencyThe number of coupon payments per year:
1 = annual
2 = semi annual (default)
4 = quarterly
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
calc_method(Optional) The start date for the accrued interest:
True = start accruing interest from the issue date.
False = start accruing interest from the last coupon payment date.

* Dates must be entered as text strings within quotation marks or as serial numbers.
* The "issue" date and the "first_interest" date are needed to calculate the amount accrued each day.
* If "issue" is not an integer, it is truncated.
* If "issue" is not a valid date, then #VALUE! is returned.
* If "issue" >= "settlement", then #NUM! is returned.
* If "first_interest" is not an integer, it is truncated.
* If "first_interest" is not a valid date, then #VALUE! is returned.
* The "settlement" date when the security is traded to the buyer.
* If "settlement" < "issue", then
* If "settlement" is not an integer, it is truncated.
* If "settlement" is not a valid date, then #VALUE! is returned.
* If "rate" <= 0, then #NUM! is returned.
* If "par" is left blank, then 1000 is used.
* If "par" <= 0, then #NUM! is returned.
* If "frequency" is left blank, then 2 is used.
* If "frequency" is not an integer, it is truncated.
* If "frequency" is any number other than 1, 2 or 4, then #NUM! is returned.
* 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.
* In Excel 2007 the "calc_method" was added.
* The "par" argument was optional in Excel 2003 but required in 2007.
* The "frequency" was optional in Excel 2003 but required in 2007.
* 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.

 AB
1=ACCRINT("1/3/2011","1/9/2011","1/4/2011",0.06,1000,2,0) = 5.0001/03/2016 March
2=ACCRINT("1/3/2011","1/9/2011","1/5/2011",0.06,1000,2,0) = 10.0001/04/2016 April
3=ACCRINT("1/3/2011","1/9/2011","1/9/2011",0.06,1000,2,0) = 30.0001/05/2016 May
4=ACCRINT("1/3/2011","1/9/2011","1/9/2011",0.06,1000,2,1) = 30.0001/09/2016 September
5=ACCRINT("1/1/2003","1/7/2003","1/7/2005",0.04,2500,4,0) = 250.0001/01/2016 January
6=ACCRINT("1/1/2003","1/7/2003","1/7/2005",4%,2500,4,0) = 250.0001/07/2016 July
7=ACCRINT("1/1/2003","1/7/2003","1/7/2005",4/100,2500,4,0) = 250.00 
8=ACCRINT("1/1/2003","1/7/2003","1/7/2005",0.04,1000,2) = 100.00 
9=ACCRINT("1/1/2003","1/7/2003","1/7/2005",0.04,,2) = 100.00 
10=ACCRINT("1/1/2005","1/7/2003","1/7/2005",0.04,2500,4,0) = 50.00 
11=ACCRINT(DATE(2005,1,1),"1/7/2003","1/7/2005",0.04,2500,4,0) = 50.00 
12=ACCRINT(40117,"8/4/2009",40138,0.05,5000000,4,2) = 14583.33 
13=ACCRINT(DATE(2005,1,1),"1/7/2003","1/7/2005",0.04,2500,4,2000) = #NUM! 
14=ACCRINT("1/1/2005","1/7/2003","1/7/2003",0.04,2500,4,0) = #NUM! 
15=ACCRINT("1/1/2003","1/7/2003","1/7/2005",0.04,-100,4,-1) = #NUM! 
16=ACCRINT("1/1/2003","1/7/2003","1/7/2005",0.04,2500,4,-1) = #NUM! 
17=ACCRINT("1/1/2003","1/7/2003","1/7/2005",0.04,2500,4,5) = #NUM! 
18=ACCRINT(DATE(2005,1,1),"1/17/2003","1/7/2005",0.04,2500,4,0) = #VALUE! 

1 - How much interest has accrued on a US treasury bond between 1 Mar 2011 and 1 Apr 2011. The bond has a par value of $1,000 issued on 1 Mar 2011 with a first interest paid date of 1 Sep 2011 and a settlement date of 1 Apr 2011 with a coupon of 6% paid semi-annually with a day count of 30/360.
2 - How much interest has accrued on a US treasury bond between 1 Mar 2011 and 1 May 2011. The bond has a par value of $1,000 issued on 1 Mar 2011 with a first interest paid date of 1 Sep 2011 and a settlement date of 1 May 2011 with a coupon of 6% paid semi-annually with a day count of 30/360.
3 - How much interest has accrued on a US treasury bond between 1 Mar 2011 and 1 Sep 2011. The bond has a par value of $1,000 issued on 1 Mar 2011 with a first interest paid date of 1 Sep 2011 and a settlement date of 1 Sep 2011 with a coupon of 6% paid semi-annually with a day count of 30/360.
4 - The same as Example but with a day count of Actual/Actual.
13 - If "basis" is very large thern #NUM is returned.


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