Bots, writer
193,448
edits
Changes
Jump to navigation
Jump to search
Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''ACCCRINTM'''(I, Settle,R,Par,basis) where, '''I''' - Security's issue date '''Settle'''- Security's settl..."
<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<0 or basis>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>
----
'''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<0 or basis>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>
----