Hi,

I am looking for a way to calculate bond yields also. I used the yield and
yieldmat functions which work fine, except that some of our bonds have coupon
rate steps before maturity. Any ideas?

Thanks,
analyst

"engineer" wrote:

Hi Fred:

Yes, I've installed the "pak". Thanks for the tip on the yield function.
Watch for Bonds to fall in price in 2005 and rise in yield. By when they fall
below 100!

Engineer

"Fred Smith" wrote:

As far as I know, all versions of Excel, especially 2003, come with the
Analysis ToolPak. You just have to install it. Did you try ToolsAddins?

For bonds which pay regular interest, use the YIELD function, rather than
YIELDMAT. With YIELD, you can specify the payment frequency (eg, 2 times per
year).

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"engineer" wrote in message
...
Thanks Fred:

I'm a little better off except my excel 2003 doesn't have all these addin
functions. As well the bonds I have pay interest semi-annually not just at
maturity as per yieldmat

Regards





"Fred Smith" wrote:

The YIELDMAT function should do what you want.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"engineer" wrote in message
...
I need to calculate bond yields to different dates such a maturity,
retraction dates etc.

I work in excel 2003