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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 <[email protected]>,
Dr. Sachin Wagh <[email protected]> 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 <[email protected]>,
> Dr. Sachin Wagh <[email protected]> wrote:
>
> > P=1000
> > N=5 (years)
> > P*(1+R)^N=1403
> > How do I get the value of R
> >
> > Thanx
>