Function Type: Financial


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.

BasisDay count basis
0 or omittedUS (NASD) 30/360
4European 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.

Back to Learn Excel->

Published by Cash Heaven

Excel Expert and Financial Analyst Excel / Google Sheets / Financial Modelling, Valuation and Analysis Effective communicator / High quality / Affordable / Reliable / Quick Turnover I've successfully completed over 200 financial modelling, valuation and analysis projects with start-up stage and corporate companies over the past 4 years. I love to solve problems, have an eye for design, and have built business excel templates. I fix Excel formulas in 10 minutes.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: