writer
5,435
edits
Changes
Manuals/calci/accrintm (view source)
Revision as of 09:07, 26 February 2014
, 09:07, 26 February 2014no edit summary
'''ACCCRINTM'''(I, Settle,R,Par,basis)
'''ACCCRINTM'''(I, Settle,R,Par,basis)
<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 and
<math>basis></math>- Type of day count basis.
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 or if Par less-than or equal to 0, basis<0 or basis>4 and I date greathearted or equal to settle date,
ACCRINTM shows the error value when R lessthan or equal to 0 or if Par lessthan or equal to 0, basis<0 or basis>4 and I date greaterthan or equal to settle date,
'''Formula''':-
'''Formula''':-
'''D''' - Annual Year Basis.
'''D''' - Annual Year Basis.
ACCRINTM
ACCRINTM
Lets see an example in (Column2,Row2)
Lets see an example in (Column2,Row2)
=ACCRINTM(B2,B3,B4,B5,B6)
where
where
ACCRINTM returns 54.6667.
ACCRINTM returns 54.6667.
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"