YIELDDISC

M

Mike R

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.
 
M

Myrna Larson

=REDEMPTION/PAR/T, where T = the fraction of a year from settlement date to
maturity, calculated according the date basis you choose.
 
M

Myrna Larson

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
PRICEDISC and YIELDDISC function 1
YIELDDISC 2
YIELDDISC vs. DISC 1
financial functions not in 2002 1
How to Create an S-Curve from Custom Field? 0
Need Help With YIELDMAT 6
Current Yield vs. Yield to Maturity at low prices 1

Top