Manuals/calci/ACCRINTM

ACCRINTM (Issue,Settlement,Rate,ParValue,Basis)

• $Issue$ Security's issue date.
• $Settlement$ Security's settlement date should  be after issue date.
• $Rate$ Security annual coupon rate.
• $ParValue$ Security par value.
• $Basis$ Type of day count basis.
  • ACCRINTM(),returns the accrued interest for a security that pays interest at maturity.

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)

1. N/A (BASIS < 0 or > 4)

Related Videos

ACCRINTM

See Also

• ACCRINT
• DATE

Refernces

• Accrued interest

• List of Main Z Functions

• Z3 home