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 (1000).
frequencyThe number of coupon payments per year:
1 = annual
2 = semi annual
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) A logical value indicating the start date for the accrued interest:
True = start accruing interest from the issue date (default)
False = start accruing interest from the last coupon payment date

Remarks

* 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. Example 18.
* 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 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.
* If "calc_method" is left blank, then True is used.
* You can use the ACCRINTM function to return the accrued interest for a security that pays interest at maturity.
* You can use the DATE function to enter your dates.
* In Excel 2007 the "calc_method" was added.
* In Excel 2003 "par" and "frequency" were displayed as optional but changed to required in 2007.
* For the Microsoft documentation refer to support.office.com

 AB
1=ACCRINT(B1,B5,B2,6%,1000,2,0) = 5.0001-Mar-2020
2=ACCRINT(B1,B5,B3,6%,1000,2,0) = 10.0001-Apr-2020
3=ACCRINT(B1,B5,B5,6%,1000,2,0) = 30.0001-May-2020
4=ACCRINT(B1,B5,B5,6%,1000,2,1) = 30.0001-Jun-2020
5=ACCRINT(B1,B4,B6,4%,2500,4,0) = 100.0001-Sep-2020
6=ACCRINT(B1,B4,B6,0.04,2500,4,0) = 100.0001-Mar-2021
7=ACCRINT(B1,B4,B6,4/100,2500,4,0) = 100.00 
8=ACCRINT(B1,B4,B6,0.04,2500,2,0) = 100.00 
9=ACCRINT(B1,B4,B6,5%,1000,2,0) = 50.00 
10=ACCRINT(B1,B4,B6,5%,,2,0) = 50.00 
11=ACCRINT(B1,B4,B6,5%,1000,2) = 50.00 
12=ACCRINT(B1,B4,B6,5%,-1000,2) = #NUM! 
13=ACCRINT(B1,B4,B6,5%,1000,2,-1) = #NUM! 
14=ACCRINT(B1,B4,B6,5%,1000,2,5) = #NUM! 
15=ACCRINT(B1,B4,"text",5%,1000,2,0) = #VALUE! 

1 - How much interest has accrued on a US treasury bond between 1 Mar 2020 and 1 Apr 2020. The bond has a par value of $1,000 issued on 1 Mar 2020 with a first interest paid date of 1 Sep 2020 and a settlement date of 1 Apr 2011 with a coupon of 6% paid semi-annually with a day count of US 30/360.
2 - The same as Example 1 except the settlement date is 1 Mar 2021.
3 - The same as Example 1 except the settlement date is 1 Sep 2021.
4 - The same as Example 3 except the basis is Actual/Actual instead of US 30/360.
5 - How much interest has accrued on a US treasury bond between 1 Mar 2020 and 1 Mar 2021. The bond has a par value of $2,500 issued on 1 Mar 2020 with a first interest paid date of 1 Jun 2020 and a settlement date of 1 Mar 2021 with a coupon of 4% paid quarterly with a day count of European 30/360.
6 - The same as Example 5 except the rate is 0.04, instead of 4%.
7 - The same as Example 5 except the rate is 4/100, instead of 4%.
8 - The same as Example 5 except the frequency is semi-annual.
9 - How much interest has accrued on a US treasury bond between 1 Mar 2020 and 1 Mar 2021. The bond has a par value of $1,000 issued on 1 Mar 2020 with a first interest paid date of 1 Jun 2020 and a settlement data of 1 Mar 2021 with a coupon of 5% paid semi-annually with a day count of US 30/360.
10 - The same as Example 9 except the par value has been left blank.
11 - The same as Example 9 except the basis has been left blank.
12 - The same as Example 9 except the par is negative.
13 - The same as Example 9 except the basis is -1 which is less than 1.
14 - The same as Example 9 except the basis is 5 which is greater than 4.
15 - The same as Example 9 except the settlement date is not numeric.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top