Changes

2,685 bytes added , 02:29, 25 October 2013

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>
----

MassBot1

Bots, writer

193,448

edits

Changes

Manuals/calci/accrintm (view source)

Revision as of 02:29, 25 October 2013