For the 1st problem, check out the NPV and XNPV functions, or the YIELD
function (in conjunction with Goal Seek)

For the 2nd problem, Excel has a payment (PMT) function.

On Tue, 4 Oct 2005 09:22:03 -0700, Swhouston055
wrote:

The help files don't have answers for the questions I have, such as how to
find the present value of a bond when given the par value, the years to
maturity, the coupon interest rate and the discount rate of return.

Also, how can I discover the payment required monthly for a $20,000 college
education 4 years from now at 6 %, with an initial payment of $9000.00.

These are the sort of questions I'd like to see if Excel can solve.

The dictionary you listed was too dated.

Thanks