compound rate
 

P=1000
N=5 (years)
P*(1+R)^N=1403
How do I get the value of R

Thanx
--
Dr. Sachin Wagh
MBBS, DHA, DPH

"Dr. Sachin Wagh" wrote in message
...
P=1000
N=5 (years)
P*(1+R)^N=1403
How do I get the value of R

The easy way is Tools Goal Seek

Another way is that R= ((1403/P)^(1/N))-1
--
David Biddulph

R= ((1403/P)^(1/N))-1
solved the problem

thanx a ton David!

"David Biddulph" wrote:

"Dr. Sachin Wagh" wrote in message
...
P=1000
N=5 (years)
P*(1+R)^N=1403
How do I get the value of R

The easy way is Tools Goal Seek

Another way is that R= ((1403/P)^(1/N))-1
--
David Biddulph

One way:

=RATE(N,0,-P,1403)

In article ,
Dr. Sachin Wagh wrote:

P=1000
N=5 (years)
P*(1+R)^N=1403
How do I get the value of R

Thanx

another way!
Thanx


"JE McGimpsey" wrote:

One way:

=RATE(N,0,-P,1403)

In article ,
Dr. Sachin Wagh wrote:

P=1000
N=5 (years)
P*(1+R)^N=1403
How do I get the value of R

Thanx