ACCRINT Function in Excel: Syntax, Examples and Free Practice
ACCRINT is an Excel Financial function. Returns accrued interest for a security paying periodic interest.
ACCRINT syntax
Arguments
issue: The security's issue datefirst_interest: The security's first interest datesettlement: The security's settlement (purchase) daterate: The interest rate per periodpar: The security's par (face) value
When to use ACCRINT
ACCRINT is used in loan, investment, or valuation models where precise financial math is required.
Practice ACCRINT online, free
Open the live Excel-style spreadsheet and try ACCRINT yourself. No Excel install or sign-up needed to start.
Practice ACCRINT now →More Financial functions
Frequently asked questions
What does the ACCRINT function do in Excel?
Returns accrued interest for a security paying periodic interest.
What is the syntax of ACCRINT in Excel?
The syntax is =ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis]). issue: The security's issue date; first_interest: The security's first interest date; settlement: The security's settlement (purchase) date; rate: The interest rate per period; par: The security's par (face) value.
Where can I practice ACCRINT online for free?
Open the free live spreadsheet on Cellgrids and try ACCRINT yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts