81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Calculates the annual yield of a discount (non-interest-bearing) security, based on price.

How To Use in Sheets

YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])

External Links

How to use YIELDDISC function in Excel

he YIELDDISC function in Microsoft® Excel is used to calculate the annual yield of a discounted security. Looking for methods to use the YIELDDISC function in Microsoft® Excel, just follow the easy steps shown in this video.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.