WorksheetFunction.AccrInt Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Returns the accrued interest for a security that pays periodic interest.
public double AccrInt (object Arg1, object Arg2, object Arg3, object Arg4, object Arg5, object Arg6, object Arg7);Public Function AccrInt (Arg1 As Object, Arg2 As Object, Arg3 As Object, Arg4 As Object, Arg5 As Object, Arg6 As Object, Optional Arg7 As Object) As DoubleParameters
- Arg1
- Object
Issue date - Security's issue date.
- Arg2
- Object
First interest - Security's first interest date.
- Arg3
- Object
Settlement - Security's settlement date
- Arg4
- Object
Rate - Security's annual coupon rate.
- Arg5
- Object
Par - Security's par value.
- Arg6
- Object
Frequency - Number of coupon payments per year.
- Arg7
- Object
Basis - The type of day count basis to use.
Returns
Remarks
Important: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
The following table describes the values that can be used for Arg5.
| 0 or omitted | US (NASD) 30/360 |
| 1 | Actual/actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |