YIELDDISC
 

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.

On Thu, 13 Jan 2005 10:19:04 -0800, Mike R
wrote:

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.

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.

On Thu, 13 Jan 2005 14:43:25 -0600, Myrna Larson
wrote:

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

On Thu, 13 Jan 2005 10:19:04 -0800, Mike R
wrote:

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.