Function Type: Financial
Description:
Returns the accrued interest for a security that pays periodic interest.
Function Structure:
=ACCPRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
Argument Breakdown:
issue – Issue date of the security.
first_interest – First interest date of the security.
settlement – Settlement date of the security.
rate – Interest rate of the security.
par – Par value of the security.
frequency – Coupon payments per year (annual = 1, semiannual = 2; quarterly = 4).
basis – The type of day count basis to use.
| Basis | Day count basis |
|---|---|
| 0 or omitted | US (NASD) 30/360 |
| 1 | Actual/actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |
calc_method – A logical value that specifies the way to calculate the total accrued interest when the date of settlement is later than the date of first_interest. A value of TRUE (1) returns the total accrued interest from issue to settlement. A value of FALSE (0) returns the accrued interest from first_interest to settlement. If you do not enter the argument, it defaults to TRUE.
Example:
Buy any of these ebooks on Amazon.
If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.
