writer
6,694
edits
Changes
Jump to navigation
Jump to search
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: − 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. − − :<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) − 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== − − {{#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]
Blanked the page