Difference between revisions of "Manuals/calci/accrintm"
(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...") |
|||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
'''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 | ||
'''Formula''':- | '''Formula''':- | ||
| Line 38: | Line 24: | ||
'''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 | ||
| Line 66: | Line 44: | ||
ACCRINTM returns 54.6667. | ACCRINTM returns 54.6667. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
Revision as of 03:07, 26 February 2014
ACCCRINTM(I, Settle,R,Par,basis)
- Security's issue date - Security's settlement date should be after issue date. - Security annual coupon rate. - Security par value and - Type of day count basis.
- Security's issue date
- Security's settlement date should be after issue date.
- Security annual coupon rate.
- Security par value and
- 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.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3/1/2008 | |||
| Row2 | 8/15/2008 | 54.666667 | ||
| Row3 | 12% | |||
| Row4 | 1000 | |||
| Row5 | 3 | |||
| Row6 |
'