Excel Function : ACCRINT
Category
Financial
Description
Returns the accrued interest for a security that pays periodic interest
Microsoft Excel Reference Page
https://support.office.com/en-us/article/ACCRINT-function-fe45d089-6722-4fb3-9379-e1f911d8dc74
Syntax and Description of the ACCRINT Excel Function
The syntax of the ACCRINT function is as follows: ACCRINT(issue, first_interest, settlement, rate, par, frequency [, basis]) Where the function arguments are as follows: issue - The security's issue date. first_interest - The security's first interest date. settlement - The security's settlement date. rate - The security's annual coupon rate. par - The security's par value. frequency - The number of coupon payments per year. basis - [Optional] The type of day count basis to use. Basis The optional basis argument allows you to specify the type of day count
About ACCRINT Excel Function
The ACCRINT function returns the interest accrued on a security that pays periodic interest. ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [day_count_method]) issue - The security's issue date. first_interest - The security's first interest date. settlement - The security's settlement date. The settlement date is the date after the issue date when the security is traded to the buyer. rate - The security's annual coupon rate. par - The security's par value. frequency - The number of coupon payments per year. basis - The type of day count method used.
