Returns the accrued interest for a security that pays periodic interest.
الصيغة
ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis])المعاملات
issueمطلوب
The security's issue date.
first_interestمطلوب
The security's first interest date.
settlementمطلوب
The security's settlement date.
rateمطلوب
The security's annual coupon rate.
parمطلوب
The security's par value; if omitted, it defaults to $1,000.
frequencyمطلوب
The number of coupon payments per year (1, 2, or 4).
basisاختياري
The type of day count basis to use.
The ACCRINT function calculates the interest that has accumulated on a bond or security between its issue date and the settlement date. It is commonly used for financial modeling to determine the value of a security when it is traded between interest payment dates.
=ACCRINT("2023-01-01", "2023-07-01", "2023-04-01", 0.1, 1000, 2)→25Calculates the accrued interest for a $1,000 bond with a 10% coupon rate, paid semi-annually, from Jan 1 to April 1.
Prepare date inputs
Ensure your issue, first interest, and settlement dates are in a format Excel recognizes.
Enter the function
Input the ACCRINT function with the required financial parameters to calculate the interest.
The ACCRINT function will return a #NUM! error.
No, ACCRINT is designed for securities that pay periodic interest.