ACCRINT Function in MS Excel What is the ACCRINT Function? The ACCRINT Function is an Excel Financial function . The function will calculate the accrued interest for a security that pays interest on a periodic basis. ACCRINT helps users calculate the accrued interest on a security, such as a bond, when that security is sold or is transferred to a new owner on a date other than the issue date or on a date that is an interest payment date. Syntax The syntax for the ACCRINT function in Microsoft Excel is: ACCRINT( issue_date, first_interest_date, settlement_date, rate, par, frequency, [basis], [calculation_method] ) Parameters or Arguments issue_date The date that the security was issued. first_interest_date The date that the first interest will be paid. settlement_date The settlement date of the security. rate The annual coupon rate for the security. par The par value of the security. If this parameter is omitted, the ACCRINT function will ...