yield to call
 

I am trying to do some bond analysis on a spreadsheet. There are functions
for Yield & Yield to Maturity but none for Yield to Call. Does anyone know
how to accomplish thi in Excel?

AFAIK YIELD is calculated to the date you specify as the maturity date,
whether that's actually what it is or not.

To get yield-to-call, you use the YIELD formula with the call date instead of
the maturity date and the call price instead of the value at maturity. (The
latter is probably par, the call price may be above par.)

On Wed, 5 Jan 2005 12:31:11 -0800, Dins95
wrote:

I am trying to do some bond analysis on a spreadsheet. There are functions
for Yield & Yield to Maturity but none for Yield to Call. Does anyone know
how to accomplish thi in Excel?