"YIELD" function

[Ray Moore]

My old version of Excel (in Office 2000 Small Business)
had a function called "YIELD" which calculated the yield-
to-maturity for a bond, given the coupon rate, current
price, date of maturity, etc. I can't find this function
in my new version (Office xp Small Business. Is it there?
If not, how can I get it to be there? It would be very
disappointing to learn that a newer version wasn't as
powerful as an older one!

 

[J.E. McGimpsey]

in both versions, YIELD is part of the Analysis ToolPak Add-in
(Tools/Add-ins, check the appropriate box).

 

[Ray Moore]

-----Original Message-----
in both versions, YIELD is part of the Analysis ToolPak Add-in
(Tools/Add-ins, check the appropriate box).



.

Thank you J.E.McGimpsey for your very helpful
advice. Was able to locate and install the YIELD function
per your instructions. Now I am not sure about the input
for Coupon Rate and the resulting yield from the
function. Are they both expressed as percentages, as
the "Help" info seems to indicate? In the previous
version I used, the rate was expressed as a decimal for
both input and result.

 

[J.E. McGimpsey]

They're equivalent, you can enter either 7% or 0.07. XL will make
the conversion.