Manuals/calci/accrintm

ACCCRINTM(I, Settle,R,Par,basis)

• $I$ Security's issue date.
• $Settle$ Security's settlement date should  be after issue date.
• $R$ Security annual coupon rate.
• $Par$ Security par value.
• $basis>$ Type of day count basis.

Description

• 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:

1.R less-than or equal to 0
2.Par less-than or equal to 0
3.basis < 0 or basis > 4
4.I date greater-than or equal to settle date.

$ACCRINTM=Par*Rate*{\frac {M}{D}}$

• $M$ number of days counted from issue date to maturity date.
• $D$ Annual Year Basis.

Example

Spreadsheet

	A	B
1	3/1/2008
2	8/15/2008
3	12
4	1000
5	3

• =ACCRINTM(A1,A2,A3,A4,A5)

5490.41095890411

• =ACCRINTM("3/7/2012","7/13/2013",10,10000,4)

135000

• =ACCRINTM("3/7/2012","7/13/2013",10,10000,5)

NAN