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