It calculates the accrued interest for a security that pays periodic interest.<\/p>\n\n\n\n
The syntax of the function is the following: <\/p>\n\n\n\n
ACCRINT<\/strong>(issue<\/strong>, first_interest, settlement<\/strong>, rate, par, frequency, [basis], [calc_method]<\/b><\/span><\/em>) <\/p>issue<\/strong>: The issue date of the security.
first_interest<\/strong><\/b><\/span>: <\/strong>The 1st interest date of the security.
settlement<\/strong>: The settlement date of the security (It is the date when the security is traded to the buyer and it always comes after the issue date).
rate<\/strong>: The annual coupon rate of the security
par<\/strong>: The security’s par value.
frequency<\/strong>: The number of coupon payments per year (annual=1, semiannual=2, quarterly=4).
[basis]<\/strong>: Optional. The type of day count basis (default is 0).
[calc_method]<\/strong>: Optional. A logical value that specifies the way to calculate the total accrued interest when the date of settlement is later than the date of first_interest. A value of TRUE (1) returns the total accrued interest from issue to settlement. A value of FALSE (0) returns the accrued interest from first_interest to settlement. The default is TRUE . <\/cite><\/blockquote>\n\n\n\nIf the dates entered are not valid dates the function returns a #VALUE! error.<\/p>\n\n\n\n
If rate or par are less than or equal to zero the #NUM! error is returned.<\/p>\n\n\n\n
If basis is not inside the valid values (between 0 and 4) the #NUM! error is returned.<\/p>\n\n\n\n
If the settlement date is before the issue date the #NUM! error is returned<\/p>\n\n\n\n
<\/div>\n\n\n\n\n<\/div>\n\n\n\nClick on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n