YIELDDISC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know what formula YIELDDISC is using to calculate the yield for a
discounted security? The formulas for most of the related functions are
documented.

Thanks.
 
=REDEMPTION/PAR/T, where T = the fraction of a year from settlement date to
maturity, calculated according the date basis you choose.
 
I note for a security with less than 1 year to maturity, YIELDDISC gives the
same result as YIELD with settings of 0 for the rate and 1 for the frequency.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What are the formulas behind the YIELDDISC function? 2
YIELDDISC 2
PRICEDISC and YIELDDISC function 1
YIELDDISC vs. DISC 1
financial functions not in 2002 1
Yield function in VBA 8
Current Yield vs. Yield to Maturity at low prices 1
Conditional format; if statement 3

Back
Top