Actually, I believe JE is correct is suggesting the RATE function:

A1: RATE =RATE(A4,A3,A2,A5,A6)---Which calcs to 10%
A2: PV 0
A3: PMT -100
A4: TERM 5
A5: FV 610.51
A6: TYPE 0

--
Regards,
Ron