Difference between revisions of "Manuals/calci/accrintm"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
==Description== | ==Description== | ||
| − | This function returns the accumulated interest for a security that pays interest at maturity. | + | *This function returns the accumulated interest for a security that pays interest at maturity. |
| − | Issue, Basis, Settlement be integers. | + | *Issue, Basis, Settlement be integers. |
| − | ACCRINTM shows the error value when | + | *ACCRINTM shows the error value when: |
| + | R less-than or equal to 0 | ||
| + | if Par less-than or equal to 0 | ||
| + | basis<0 or basis>4 | ||
| + | I date greathearted or equal to settle date, | ||
| − | + | <math>ACCRINTM = Par * Rate * (M /D)</math> | |
| − | + | <math>M</math> number of days counted from issue date to maturity date. | |
| − | ACCRINTM=Par | + | <math>D</math> Annual Year Basis. |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | ==Example== | ||
Lets see an example in (Column2,Row2) | Lets see an example in (Column2,Row2) | ||
Revision as of 06: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.
- 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.
Type of day count basis.Description
- 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 if Par less-than or equal to 0 basis<0 or basis>4 I date greathearted or equal to settle date,
number of days counted from issue date to maturity date. Annual Year Basis.
number of days counted from issue date to maturity date.
Annual Year Basis.
Example
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 |