ACCCRINTM(I, Settle,R,Par,basis)
Security's issue date. Security's settlement date should be after issue date. Security annual coupon rate. Security par value Type of day count basis.
Security's issue date.
Security's settlement date should be after issue date.
Security annual coupon rate.
Security par value
Type of day count basis.
This function returns the accumulated interest for a security that pays interest at maturity.
Issue, Basis, Settlement be integers.
ACCRINTM shows the error value when R less-than or equal to 0 or if Par less-than or equal to 0, basis<0 or basis>4 and I date greathearted 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 |