Manuals/calci/ACCRINT
ACCRINT(I, FI, settle, R, par, F, basis)
Where 'I' is the security's issue date, 'FI' is the first interest date, 'settle' is the security's settlement date, 'R' is the security's annual coupon rate, 'par' is the security's par value, 'F' is the number of coupon payments per year and 'basis' is the type of day count basis to use.
- I, FI, Settle should be valid in this function and 'F' should be 1, 2, or 4.
- Whenever rate ≤ 0 or if par ≤ 0, ACCRINT shows NAN(error) value.
- Basis must be between 0 and 4
- ACCRINT is calculated as follows:
where:
Ai = number of accrued days for the ith quasi-coupon period within odd period.
NC = number of quasi-coupon periods that fit in odd period. If this number contains a fraction, raise it to the next whole number.
NLi = normal length in days of the ith quasi-coupon period within odd period.
ACCRINT
Lets see an example,
ACCRINT(I, FI, settle, R, par, F, basis)
B
April 1, 2010
August 31, 2010
June 1, 2010
20%
500
3
0
=ACCRINT(B2,B3,B4,B5,B6,B7,B8) is 16.667
=ACCRINT(DATE(2010,3,5),B3,B4,B5,B6,B7,B8) is 23.889
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | April 1, 2010 | |||
| Row2 | August 31, 2010 | 16.666667 | ||
| Row3 | June 1, 2010 | 23.888889 | ||
| Row4 | 20% | |||
| Row5 | 500 | |||
| Row6 | 3 | |||
| Row7 | 0 |
