Spread Formula Reference
ACCRINTM
Formula Functions > Functions A to C > ACCRINTM

This function calculates the accrued interest at maturity for a security that pays periodic interest.

Syntax

ACCRINTM(issue,maturity,rate,par,basis)

Arguments

This function has these arguments:

Argument Description
issue Date that the security is issued
maturity Maturity date for security
rate Annual interest rate for the security
par [Optional] Par value for the security; if omitted, the calculation uses a value of $1,000
basis [Optional] Integer representing the basis for day count (Refer to Day Count Basis.)

Remarks

This function requires that issue is a valid date (otherwise a #Value! error is returned). If the rate or par is less than or equal to 0, then a #NUM! error is returned. If the basis is less than 0 or greater than 4, a #NUM! error is returned. If the issue is less than the settlement, then a #NUM! error is returned.

Data Types

Accepts numeric and DateTime object data. Returns numeric data.

Examples

ACCRINTM(A2,A3,B4,D9,3)

ACCRINTM(R1C1,R2C3,R4C2,R9C4,3)

Version Available

This function is available in product version 1.0 or later.

See Also

ACCRINT | INTRATE | Financial Functions