D
Dr. Sachin Wagh
P=1000
N=5 (years)
P*(1+R)^N=1403
How do I get the value of R
Thanx
N=5 (years)
P*(1+R)^N=1403
How do I get the value of R
Thanx
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
Dr. Sachin Wagh said: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
D
Dr. Sachin Wagh
R= ((1403/P)^(1/N))-1
solved the problem
thanx a ton David!
solved the problem
thanx a ton David!
J
JE McGimpsey
One way:
=RATE(N,0,-P,1403)
=RATE(N,0,-P,1403)
D