"YIELD" function

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!

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


In article ,
"Ray Moore" wrote:

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!

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


In article ,
"Ray Moore" wrote:

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



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.

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

In article ,
"Ray Moore" wrote:

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.

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

In article ,
"Ray Moore" wrote:

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

I find that entering the coupon rate as a decimal or
as a percentage with the sign (%) produces the result as
a decimal. The result is consistent with my previous
calcs. and with an approximate method that I have, so I
think I'm all set. Thank you again for your help.