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

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

Syntax

ACCRINT(issue,first,settle,rate,par,frequency,basis)

Arguments

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.)

Remarks

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.

Examples

ACCRINT(A1,A2,A3,B4,D9,E9,0)

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