ReferenceFunctionsFinancial Functions
ACCRINTM
ACCRINTM: Returns accrued interest for a security that pays interest at maturity.
Summary
ACCRINTM accrues from issue to settlement with no periodic coupon schedule.
Remarks
- Date inputs are spreadsheet serial dates and must satisfy
settlement > issue. rateis an annual decimal rate (for example,0.05for 5%), andparmust be positive.basiscodes:0=US(NASD)30/360,1=Actual/Actual,2=Actual/360,3=Actual/365,4=European30/360.- Return value is accrued interest amount in the same currency units as
par. - With positive
rateandpar, the result is positive.
Examples
One full 30/360 year
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
50
European 30/360 half-year accrual
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
20
Related functions
FAQ
Does ACCRINTM use coupon frequency?
No. It accrues directly from issue to settlement with no periodic coupon schedule.
What causes #NUM!?
Invalid basis, non-positive rate/par, or settlement <= issue.
Runtime metadata
Category
Financial
Signature
ACCRINTM(arg1: Number, arg2: Number, arg3: Number, arg4: Number, arg5…: Number)Arity
min 4, max variadic
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
arg3Number · Scalar · coercion NumberLenientText
arg4Number · Scalar · coercion NumberLenientText
arg5Number · Scalar · coercion NumberLenientText
Caps
PURE
Source