Skip to content

accrint

Excel Function – ACCRINT()

  • ilyar126 

Description To calculate the accrued interest for a stock/bond or other security with periodic interest Syntax ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) Issue: when the security was issues. Date is in entered as DATE() function or a sequential serial number ex: 8/29/2001 is 44437 First_interest: when first interest is due Settlement: when the stock was sold rate: annual coupon rate frequency: how often coupon pays per year [basis]:… Read More »Excel Function – ACCRINT()