Functions
YIELD
Yield on a coupon bond
Try it
When to use it
When should I use YIELD?
Use YIELD to find the annual yield of a coupon-paying bond given its price — the inverse of PRICE, useful for determining whether a bond trading at a discount or premium meets a target return.
Used in
Syntax
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])Examples
=YIELD(DATE(2010,1,2),DATE(2039,12,31),3,93.45,100,2) // => 3.1876008031666876
=YIELD(DATE(2010,1,2),DATE(2039,12,31),3,93.45,100,1,1) // => 3.1795991124043925