Functions
ACCRINT
Accrued interest for periodic coupon
Try it
When to use it
When do I use ACCRINT instead of ACCRINTM?
Use ACCRINT for bonds that pay periodic coupons (interest before maturity); use ACCRINTM for instruments that pay all interest at maturity such as T-bills or zero-coupon notes.
Used in
Syntax
ACCRINT(issue, first_coupon, settlement, rate, par, frequency, [basis])Examples
=ACCRINT(DATE(2010,1,1),DATE(2010,2,1),DATE(2012,12,31),0.05,100,4) // => 14.98611111111111
=ACCRINT(DATE(2010,1,1),DATE(2010,7,1),DATE(2015,6,30),0.06,1000,2) // => 329.8333333333333
=ACCRINT(DATE(2010,1,1),DATE(2011,1,1),DATE(2020,12,31),0.04,500,1,1) // => 219.94520547945206