Huh? You give the PV in your problem statement!

Your example shows an initial payment (PV) of $100, compounded for 4
years, with subsequent annual $100 payments at the end of each period,
compounding annually.

You can either model that as

=RATE(4,100,100,-610.51,0) === 10%

or, use a PV of 0 and stretch the period to 5 years:

=RATE(5,100,0,-610.51,0) === 10%

In neither case is the PV unknown.

In article ,
"BL" wrote:

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.