Yield to Maturity function

  • Thread starter Thread starter Al Eaton
  • Start date Start date
A

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?
 
I am trying to correctly calculate a Yield to Maturity for a muni bond using
Excel's YTM function.
Click to expand...
...

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.
 
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
 
Back
Top