Apple iWork Numbers Function Reference
ACCRINT
Description:
The ACCRINT function calculates the total accrued interest for a security that pays
periodic interest.
Syntax:
ACCRINT(issue, first, settle, rate, par, frequency, [day-count])
- issue: The date when the security was issued.
- first: The date of the first interest payment.
- settle: The settlement date, usually the date when the security was purchased.
- rate: The coupon rate of the security, expressed as a percentage from 0 to 1.
- par: The face value of the security.
- frequency: The number of coupon payments each year.
- day-count: Optional; specifies the number of days per month and days per year used
in the calculations (sometimes called the day count basis).
1 means annual payments.
2 means semiannual payments (twice per year).
3 uses actual/365 (calendar days for each month but 365 days per year).
4 means quarterly payments (four times per year).
0 or omitted uses 30/360 (30 days for each month, 360 days in a year).
1 uses actual/actual (the number of days shown on a calendar).
2 uses actual/360 (calendar days for each month but 360 days per year).
3 uses actual/365 (calendar days for each month but 365 days per year).
4 uses 30E/360 (European 30/360).
Examples:
