Spread Formula Reference
Formula Functions / Functions A to C / ACCRINT
In This Topic
    In This Topic

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




    This function has these arguments:

    Argument Description
    issue Date that the security is issued
    first First date for calculating the interest for the security
    settle Settlement date for the 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
    frequency Frequency of payment, number of payments per year
    basis [Optional] Integer representing the basis for day count (Refer to Day Count Basis.)


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

    Data Types

    Accepts numeric and DateTime object data. Returns numeric data.



    ACCRINT(DATE(2003,1,1),DATE(2003,1,7),DATE(2005,1,7),0.5,1000,2) gives the result 1008.33333

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ACCRINTM | INTRATE | Financial Functions