Formulas > =YIELD()
How to Use YIELD() in Google Sheets
Description
How To Actually Use YIELD() in Sheets
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
Try YIELD yourself
Use the YIELD() formula to calculate the annual yield of a bond based on the data in cells A1 to F1. The settlement date is in A1, maturity date in B1, annual interest rate in C1, price in D1, redemption value in E1, and frequency in F1.
Hints (2)
-
Make sure to include all required arguments in the YIELD function.
-
Check the order of the arguments in the formula.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the YIELD() formula:
Generate a YIELD() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses YIELD(). 2 free AI generations, no signup. Members get unlimited use.
Generate a YIELD() formula