Yield to Maturity function

[Al Eaton]

I am trying to correctly calculate a Yield to Maturity for a muni bond using
Excel's YTM function.

S/D 8/15/03
M/D 9/1/2011
DTD 1/1/92
CPN 6.125%
PX 116.170
BASIS 0

The correct answer is 3.775%. Excel gives 2.196%. What is going on here?

 

[Harlan Grove]

I am trying to correctly calculate a Yield to Maturity for a muni bond using
Excel's YTM function.

...

Excel doesn't have a 'YTM' function. Looks like you're using an HP calculator's
YTM function. Anyway, Excel's TIELDMAT function is *NOT* what you want to use.
You want to use Excel's YIELD function.

 

[Paul Corrado]

Al,

While the name of XL's YieldMaturity function sounds like it should
calculate the YTM of a financial instrument, it appears that is not the
case. YIELDMATURITY seems to calculate the Yield on a bond that pays
interest at maturity.

They YIELD function does however return the answer you are looking for.

PC