Skip to content

financial

Excel Function – ACCRINTM()

  • ilyar126 

Description To calculate the accrued interest for a stock/bond or other security that pays interest at maturity Syntax ACCRINTM(issue, settlement, rate, par, [basis]) Issue: when the security was issues. Date is in entered as DATE() function or a sequential serial number ex: 8/29/2001 is 44437 Settlement: maturity date rate: annual coupon rate par: par value of security; if blank then defaults at $1000 [basis]: 5 types of day counts; this… Read More »Excel Function – ACCRINTM()

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()