Formulas > =YIELDDISC()
How to Use YIELDDISC() in Google Sheets
Description
How To Actually Use YIELDDISC() in Sheets
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
Try YIELDDISC yourself
In cells A1 to A5, enter the settlement date, maturity date, price, and redemption value for a discount security. Use the YIELDDISC formula in cell B1 to calculate the annual yield based on these inputs.
Hints (2)
-
Make sure to enter valid dates for settlement and maturity.
-
Price should be less than the redemption value.
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 YIELDDISC() formula:
Generate a YIELDDISC() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses YIELDDISC(). 2 free AI generations, no signup. Members get unlimited use.
Generate a YIELDDISC() formula