Documentation/Calc Functions/ACCRINTM

Function name:
ACCRINTM

Category:
Financial Analysis

Summary:
Calculates the accrued interest for a security that pays interest on maturity.

Syntax:
ACCRINTM(Issue; Settlement; Rate[; Par[; Basis]])

Returns:
Returns a positive real number which is the accrued interest, expressed in the same currency units that were used for the security’s par value.

Arguments:
Issue is a date or a reference to a cell containing that date which is the issue date of the security.

Settlement is a date or a reference to a cell containing that date which is the date at which the interest accrued up until then is to be calculated.

Rate is a positive real number (expressed as a percentage or fraction) or a reference to a cell containing that number which is the annual nominal rate of interest (coupon rate).

Par is a positive real number or a reference to a cell containing that number which is the par value of the security. If Par is omitted, the function uses the value 1,000.


 * If either of Issue or Settlement are not valid dates then the function returns a value (#VALUE!) error.
 * If Basis is non-integer values, then the function uses its floor value, i.e. it is truncated to an integer value.

The function reports an invalid argument error (Err:502) if:
 * either Rate or Par is less than or equal to 0;
 * the Issue date is equal or after the Settlement date;
 * after truncation Basis is a number different 0,1,2,3,4.

Additional details:

 * The formula for ACCRINTM is:


 * This function doesn't strictly follow ODF section, since Par is an optional argument here.
 * For more detail on accrued interest, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/ACCRINT ACCRINT]

ODF standard:
Section 6.12.3, part 2

Equivalent Excel functions:
ACCRINTM