top of page
Search


MS Excel: YIELDDISC function for annual yield on discount securities
In fixed-income investing, some securities—like Treasury bills (T-bills) and commercial paper—are sold at a discount and do not pay periodic interest. Instead, investors earn the difference between the purchase price and the face value at maturity.
The YIELDDISC function in Excel calculates the annual yield on these discount (zero-coupon) securities, offering a straightforward way to evaluate their returns.

Fakhriddinbek
6 days ago2 min read
bottom of page