This is the Internal Rate of Return (IRR in Excel)

There is no straight-forward calculation for this, you basically take a guess at the rate and then perform a Present Value calculation (the formula is in the Excel help file) to see how good your guess is.

Then you revise your guess and try again until you get the accuracy you need.