Difference between revisions of "Manuals/calci/accrintm"

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''ACCCRINTM(I, Settle,R,Par,basis)'''</div><br/>
-*<math>I</math> Security's issue date.
-*<math>Settle</math> Security's settlement date should  be after issue date.
-*<math>R</math> Security annual coupon rate.
-*<math>Par</math> Security par value.
-*<math>basis></math> 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:
-.R less-than or equal to 0
-.Par less-than or equal to 0
-.basis < 0 or basis > 4
-.I date greater-than or equal to settle date.
-:<math>ACCRINTM = Par * Rate *\frac{M}{D}</math>
-*<math>M</math> number of days counted from issue date to maturity date.
-*<math>D</math> Annual Year Basis.
-==Example==
-{| class="wikitable"
-|+Spreadsheet
-|-
-! !! A !! B
-|-
-! 1
-| 3/1/2008
-|
-|-
-! 2
-| 8/15/2008
-|
-|-
-! 3
-| 12
-|
-|-
-! 4
-| 1000
-|
-|-
-! 5
-| 3
-|
-|}
-*=ACCRINTM(A1,A2,A3,A4,A5)
-.41095890411
-*=ACCRINTM("3/7/2012","7/13/2013",10,10000,4)
-*=ACCRINTM("3/7/2012","7/13/2013",10,10000,5)
-NAN
-==Related Videos==
-{{#ev:youtube|wkvOBTuJEuw|280|center|ACCRINTM}}
-==See Also==
-*[[Manuals/calci/ACCRINT| ACCRINT]]
-*[[Manuals/calci/DATE| DATE]]
-==Refernces==
-*[http://www.excelfunctions.net/Excel-Accrintm-Function.html  Accrued interest]

Latest revision as of 15:16, 19 August 2016