Difference between revisions of "Manuals/calci/accrintm"
Jump to navigation
Jump to search
| Line 27: | Line 27: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | |||
| Column1 | | Column1 | ||
| − | + | | Column2 | |
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | Row1 | |
| − | + | | 3/1/2008 | |
| − | |||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | Row2 | |
| − | + | | 8/15/2008 | |
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| Row3 | | Row3 | ||
| − | + | | 12% | |
| − | |||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| Row4 | | Row4 | ||
| − | + | | 1000 | |
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | Row5 | |
| − | + | | 3 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| + | |||
| + | =ACCRINTM("3/1/2008","8/15/2008",12,1000,3) | ||
| + | 5490.41095890411 | ||
| + | = | ||
Revision as of 23:45, 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:
1.R less-than or equal to 0 2.Par less-than or equal to 0 3.basis < 0 or basis > 4 4.I date greater-than 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
=ACCRINTM("3/1/2008","8/15/2008",12,1000,3) 5490.41095890411 =
| Column1 | Column2 |
| Row1 | 3/1/2008 |
| Row2 | 8/15/2008 |
| Row3 | 12% |
| Row4 | 1000 |
| Row5 | 3 |
=ACCRINTM("3/1/2008","8/15/2008",12,1000,3) 5490.41095890411 =