ACCRINT
Returns the accrued interest for a security that pays periodic interest.
FinancialFinance & Accounting
What it does
Calculates accrued interest for a security that pays periodic interest.
Syntax
ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
Arguments
issue(date) — The security's issue date.first_interest(date) — The security's first interest date.settlement(date) — The security's settlement date.rate(number) — The security's annual coupon rate.par(number) — The security's par value.frequency(number) — Number of coupon payments per year.
Examples
Calculate accrued interest
Calculate interest for a bond issued on Jan 1st.
FORMULA
=ACCRINT(A2, B2, C2, 0.05, 1000, 2)
RESULT
16.66
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Issue | First Interest | Settlement |
| 2 | 2023-01-01 | 2023-06-30 | 2023-05-01 |