Hi, there,

I am looking for a function to calculate the compound rate for a annual
payment which can give a total amount of $ in a given period.

P = Annual Payment
R = Interest rate
N = the total of year
$ = Total

so P + P*(1+R) + P*(1+R)^2 + P*(1+R)^3 + ...P*(1+R)^n = $

e.g. What is the growth rate required for an initial payment of $100
required to get total $610.51 payment in 5 years? the answer to this question
is 10% as

$100 +$100*(110%)^1+$100*(110%)^2+$100*(110%)^3+$100*(1 10%)^4 = $610.51

I search but I cannot find the function required. Please help.

Thank you.

BL