Manuals/calci/ACCRINTM

From ZCubes Wiki
Revision as of 14:52, 16 November 2018 by Devika (talk | contribs) (→‎Related Videos)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
ACCRINTM (Issue,Settlement,Rate,ParValue,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.
    • 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.
  • number of days counted from issue date to maturity date.
  • 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

Related Videos

ACCRINTM

See Also

Refernces