ACCRINTM DAX Function (Financial)

Syntax  |  Return values  |  Remarks  |  Examples  

Returns the accrued interest for a security that pays interest at maturity.

Syntax

ACCRINTM ( <Issue>, <Maturity>, <Rate>, <Par> [, <Basis>] )

Parameter	Attributes	Description
Issue		The security’s issue date.
Maturity		The security’s maturity date.
Rate		The security’s annual coupon rate.
Par		The security’s par value.
Basis	Optional	The type of day count basis to use.

Return values

Scalar A single decimal value.

Remarks

Basis sets the day-count method. Use 0 or omit the value for US (NASD) 30/360. Use 1 for actual/actual. Use 2 for actual/360. Use 3 for actual/365. Use 4 for European 30/360.

Rate and Par must be greater than 0. Issue must be earlier than Maturity.

Examples

-- ACCRINTM returns accrued interest for a security that pays interest at maturity
-- Example terms:
--   Issue 1-Apr-2008, Maturity 15-Jun-2008
--   Rate 10%, Par 1000, Basis 3 (Actual/365)
EVALUATE
{
    ACCRINTM ( DATE ( 2008, 4, 1 ), DATE ( 2008, 6, 15 ), 0.1, 1000, 3 )
}

Value
20.5479452054795

Last update: Oct 14, 2026   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/accrintm-function-dax