Functions
YIELDMAT
Annual yield at maturity
Try it
When to use it
When should I use YIELDMAT?
Use YIELDMAT to calculate the annual yield of a security that pays all interest at maturity rather than through periodic coupons — appropriate for instruments like certain bonds or notes that accumulate interest and pay it in a lump sum.
Used in
Syntax
YIELDMAT(settlement, maturity, issue, rate, pr, [basis])Examples
=YIELDMAT(DATE(2010,1,2),DATE(2010,12,31),DATE(2010,1,1),0.02,90,2) // => 0.13240688642319298
=YIELDMAT(DATE(2010,1,2),DATE(2039,12,31),DATE(2010,1,1),0.03,100.47) // => 0.02970124785690169