Article updated on March 27, 2018

The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity.

Formula in cell C7:

=ACCRINTM(C2,C3,C4,C5,C6)

Excel Function Syntax

ACCRINTM(issue, settlement, rate, par, [basis])

Arguments

issue Required. The security's issue date.
settlement Required. The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
rate Required. The security's annual coupon rate.
par Required. The security's par value. Default value is $1,000.
[basis] Optional. The type of day count basis to use.
Basis Day count basis
0 (default value) US (NASD) 30/360
1 Actual/actual
2 Actual/360
3 Actual/365
4 European 30/360