accrint (Financial library)



This is the description of the function accrint

FUNCTION=ACCRINT
SYNTAX=ACCRINT(issue,first_interest,settlement,rate,par,frequency,basis)
DESCRIPTION
   ACCRINT calculates the accrued interest for a security that pays periodic interest.  The  rate is the annual rate of the security and par is the principle[?] value of the security. basis is the type of day counting system you want to use:
 
           0  US 30/360
           1  actual days/actual days
           2  actual days/360
           3  actual days/365
           4  European 30/360
 
If basis is omitted, US 30/360 is applied.
If issue date or settlement date is not valid, ACCRINT returns  #NUM! error.
If rate or par are zero or negative, ACCRINT returns #NUM! error.
If basis < 0 or basis > 4, ACCRINT returns #NUM! error.
If issue date is after settlement date or they are the same, ACCRINT returns #NUM! error.

QUESTION: What is the first_interest meant to do? Is it a date?
QUESTION: How is frequency meant to be used.  My assumption is that the frequency is  how often the interest is added to the principle.  And will be one or more times per year.  Is there any case where you might have interest added less then once a year?

gnumeric, from looking at the code for this functions I feel that it is wrong but until I know what it is meant to do I can not help with the patch to fix it.

Phill



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]