To work with the tool in Foresight Analytics Platform 10, use the new interface.
The function wizard for the Accrint function looks as follows:
Accrint(Issue, FirstInterest, Settlement, Rate[, NominalCost[, Frequency[, Basis])
Issue. The security's issue date.
FirstInterest. The first payment date on securities.
Settlement. The security's maturity date.
Rate. Annual interest rate for coupons on securities. Parameter value must be greater than zero.
NominalCost. Face value of securities. Parameter value must be greater than zero.
Frequency. The number of coupon payments per year. The parameter may take the following values:
1. Annual payments.
2. Semi-annual payments.
4. Quarterly payments.
Basis. The day calculation method used. Select a value 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, it is available to specify either the parameter value or the cell address where it is located.
It returns an accrued interest for securities with periodic interest payments.
The Issue parameter value must be less than the Settlement parameter value.
Formula | Result | Description |
=Accrint("11.01.2008", "11.02.2008", "11.03.2008", 0.1, 1000, 2, 0) | 16,6667 | Accumulated percentage derived from securities based on the following terms:
|
=Accrint(A1, A2, A3, 0,124, 100, 4, 3) | 9,2656 | Accumulated percentage derived from securities based on the following terms:
|
See also: