This post will guide you how to use Excel ACCRINTM function with syntax and examples in Microsoft excel.
The Excel ACCRINTM function returns the accrued interest for a security that pays interest at maturity.
The ACCRINTM function is a build-in function in Microsoft Excel and it is categorized as a Financial Function.
The ACCRINTM function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2011 for Mac.
The syntax of the ACCRINTM function is as below:
= ACCRINTM(issue, settlement, rate, par, [basis])
Where the ACCRINTM function arguments are:
Issue -This is a required argument. The security’s issue date.
Sattlement – This is a required argument. The security’s settlement date.
Rate – This is a required argument. The security’s annual coupon rate.
Par – This is a required argument. The par value of the security. Note: If Par is omitted, the default Par value will be set to $1000.
Basis – This is an optional argument. The type of day count basis to use. it can be set as the following values:
|Basis||Day count basis|
|0 or omitted||US (NASD) 30/360|
The below examples will show you how to use Excel ACCRINTM Function to return the accrued interest for a security that pays interest at maturity.