yield to call

[Guest]

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?

 

[Myrna Larson]

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