Manuals/calci/accrintm
ACCCRINTM(I, Settle,R,Par,basis)
where,
I - Security's issue date
Settle- Security's settlement date should be after issue date.
R- Security annual coupon rate.
Par- Security par value and
basis- Type of day count basis.
This function returns the accumulated interest for a security that pays interset at maturity.
Issue, Basis, Settlement be intergers.
ACCRINTM shows the error value when R lessthan or equal to 0 or if Par lessthan or equal to 0, basis<0 or basis>4 and I date greaterthan or equal to settle date,
Formula:-
ACCRINTM=Par χ Rate χ(M /D)
where,
M - number of days counted from issue date to matuarity date.
D - Annual Year Basis.
ACCRINTM
Lets see an example in (Column2,Row2)
=ACCRINTM(B2,B3,B4,B5,B6)
where
B2=3/1/2008
B3=8/15/2008
B4=12%
B5=1000
B6=3
ACCRINTM returns 54.6667.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3/1/2008 | |||
| Row2 | 8/15/2008 | 54.666667 | ||
| Row3 | 12% | |||
| Row4 | 1000 | |||
| Row5 | 3 | |||
| Row6 |