Try HELP for NPV. The formula is given.

If your 2nd suggestion, i.e. what do these numbers mean, you can probably find
help if you search Google.

On 17 Feb 2005 12:25:35 -0800, "
wrote:

is there anyone who could tell me the details on how these two formulas
work?

I get some results that do not seem to fit, I mean the percentage is
totally odd.

I'd like to know how Excel calculates these values.

Maybe it's not even about Excel but about understanding of calculating
"Net Present Value" and Internal Rate of Return" in general....