ACCRINTM function in Excel

Use

ACCRINTM function returns the accrued interest of a security (usually a bond) that pays interest at maturity.

Syntax

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

issue – The issue date of the security.

settlement – The maturity date of the security.

rate – The rate of return of the security.

par – The par value of the security.

[basis] – The optional argument that specifies type of days count.

Basis Day count basis
0 or omitted US (NASD) 30/360
1 Actual/actual
2 Actual/360
3 Actual/365
4 European 30/360

Example

Formula:

Result:

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved