ACCRINTM
Returns the accrued interest for a security that pays interest at maturity
Syntax
ACCRINTM(issue, settlement, rate, par, [basis])
Parameters
- issue: Required. The security's issue date
- settlement: Required. The security's maturity date
- rate: Required. The security's annual coupon rate
- par: Required. The security's par value
- basis: Optional. The type of day count basis to use (0=US 30/360, 1=Actual/actual, 2=Actual/360, 3=Actual/365, 4=European 30/360)
Example
=ACCRINTM("01/04/2024", "06/01/2024", 0.10, 1000, 3)