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