Thank JE,

Unfortunately, the RATE() Function requires the PV as input key, I am
looking the rate to discount the amount to PV. Any other suggestion? I am
building up a table and use the Goal Seek Function of Excel to help me find
the rate; however, the process is time-consuming.

BL

"JE McGimpsey" wrote:

Take a look at the RATE() function


In article ,
"BL" wrote:

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