Functions
ACCRINTM
Accrued interest at maturity
Try it
When to use it
When do I use ACCRINTM instead of ACCRINT?
Use ACCRINTM for discount instruments or bonds that pay all interest at maturity (no interim coupon payments); use ACCRINT when the bond pays periodic coupons.
Used in
Syntax
ACCRINTM(issue, settlement, rate, par, [basis])Examples
=ACCRINTM(DATE(1969,12,31),DATE(1999,12,31),0.05,100,0) // => 150
=ACCRINTM(DATE(1969,12,31),DATE(1999,12,31),0.05,100,1) // => 150
=ACCRINTM(DATE(2008,4,1),DATE(2008,6,15),0.1,1000,3) // => 20.54794520547945