Function Type: Financial
Returns the accrued interest for a security that pays periodic interest.
=ACCPRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
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|
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.
Buy any of these ebooks on Amazon.
If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.