Spread.NET 14 Formula Reference
Formula Functions / Functions A to C / ACCRINTM
In This Topic
    ACCRINTM
    In This Topic

    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