writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left"> − − where,+ − + − '''I''' - Security's issue date+ − + − '''Settle'''- Security's settlement date should be after issue date.+ − − '''R'''- Security annual coupon rate. − − '''Par'''- Security par value and − '''basis'''- Type of day count basis. − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − This function returns the accumulated interest for a security that pays interset at maturity. − </div>+ − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − Issue, Basis, Settlement be intergers.+ − − Line 38:
Line 24: − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − <nowiki>=ACCRINTM(B2,B3,B4,B5,B6)</nowiki>+ Line 66:
Line 44: − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left">
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"