|
|
(26 intermediate revisions by 3 users not shown) |
Line 1: |
Line 1: |
− | '''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,
| |
− |
| |
− | '''Formula''':-
| |
− |
| |
− | ACCRINTM=Par χ Rate χ(M /D)
| |
− |
| |
− | where,
| |
− |
| |
− | '''M''' - number of days counted from issue date to matuarity date.
| |
− |
| |
− | '''D''' - Annual Year Basis.
| |
− |
| |
− | ACCRINTM
| |
− |
| |
− | Lets see an example in (Column2,Row2)
| |
− |
| |
− | =ACCRINTM(B2,B3,B4,B5,B6)
| |
− |
| |
− | where
| |
− |
| |
− | B2=3/1/2008
| |
− |
| |
− | B3=8/15/2008
| |
− |
| |
− | B4=12%
| |
− |
| |
− | B5=1000
| |
− |
| |
− | B6=3
| |
− |
| |
− | ACCRINTM returns 54.6667.
| |
− |
| |
− | {| 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 " |
| |
− | |}
| |