ACCRINTM
Returns the accrued interest for a security that pays interest at maturity.
FinancialFinance & Accounting
What it does
Calculates the accrued interest for a security that pays interest at maturity.
Syntax
ACCRINTM(issue, settlement, rate, par, [basis])
Arguments
issue(date) — The security's issue date.settlement(date) — The security's maturity date.rate(number) — The security's annual coupon rate.par(number) — The security's par value.
Examples
Interest at maturity
Calculate accrued interest for a security paying at maturity.
FORMULA
=ACCRINTM(A2, B2, 0.05, 1000)
RESULT
24.66
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Issue | Maturity |
| 2 | 2023-01-01 | 2023-07-01 |