,AccrintM( Issue, Settlement, Rate[, NominalCost[, Basis])
Issue. The security's issue date. Parameter value must be less than value of the Settlement parameter.
Settlement. The security's maturity date.
Rate. The annual interest rate for coupons on securities. Parameter value must be greater than zero.
NominalCost. The face value of securities. Parameter value must be greater than zero. Optional parameter. The default value is 1000.
Basis. The day calculation method used. It is set in the range from 0 to 4:
0. The day calculation method - American. 360 days (NSAD method). Default value.
1. Day calculation method - Actual/actual.
2. Day calculation method - Actual/360 days.
3. Day calculation method - Actual/365 days.
4. Day calculation method - European 30/360 days.
Optional parameter.
NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.
It returns the accrued interest for a security that pays interest at maturity.
The Issue parameter value must be less than the Settlement parameter value.
The function is calculated according to the following formula:
,
where:
A. The number of accumulated days according to the monthly basis. To calculate the yield for the settlement date, the number of days between the Issue issue date and the Settlement maturity date is used.
| Formula | Result | Description |
| =AccrintM("12.01.2008", "13.06.2008", 11, 100, 3) | 461,10 | Accumulated income derived from securities based on the following conditions:
|
| =AccrintM(A0, B0, 12.4, 100, 3) | 927,45 | Accumulated income derived from securities based on the following conditions:
|
See also:
Function Wizard │ Financial Functions