ACCRINT

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.

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven 😉

---

Back to Learn Excel->