Difference between revisions of "Manuals/calci/accrintm"

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
-'''ACCCRINTM'''(I, Settle,R,Par,basis)
-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.
-ACCRINTM shows the error value when  R lessthan or equal to 0 or if Par lessthan or equal to 0, basis&lt;0 or basis&gt;4 and I date greaterthan or equal to settle date,
-'''Formula''':-
-ACCRINTM=Par χ Rate χ(M /D)
-where,
-'''M''' - number of days counted from issue date to matuarity date.
-'''D''' - Annual Year Basis.
-</div>
-----
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
-ACCRINTM
-</div></div>
-----
-<div id="8SpaceContent" class="zcontent" align="left">
-Lets see an example in (Column2,Row2)
-<nowiki>=ACCRINTM(B2,B3,B4,B5,B6)</nowiki>
-where
-B2=3/1/2008
-B3=8/15/2008
-B4=12%
-B5=1000
-B6=3
-ACCRINTM returns 54.6667.
-</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">
-{| id="TABLE3" class="SpreadSheet blue"
-|- class="even"
-| class=" " |
-| Column1
-| class="   " | Column2
-| Column3
-| Column4
-|- class="odd"
-| class=" " | Row1
-| class="sshl_f" | 3/1/2008
-| class="sshl_f" |
-| class="                                                             " |
-|
-|- class="even"
-| class="  " | Row2
-| class="sshl_f" | 8/15/2008
-| class="sshl_f" | 54.666667
-|
-|
-|- class="odd"
-| Row3
-| class="sshl_f " | 12%
-| class="                                                                               sshl_f sshl_t ChangeBGColor" |
-|
-|
-|- class="even"
-| Row4
-| class="  " | 1000
-| class="sshl_t" |
-|
-|
-|- class="odd"
-| class=" " | Row5
-| class=" " | 3
-| class="sshl_t" |
-|
-|
-|- class="even"
-| Row6
-| class="sshl_f" |
-| class="sshl_t" |
-|
-| class="sshl_f " |
-|}
-<div align="left"></div>''''''</div>
-----

Difference between revisions of "Manuals/calci/accrintm"

Latest revision as of 14:16, 19 August 2016

Navigation menu

Search