How to calculate period

[manan]

Hi

I know the principle , compound interest rate and the future vale.
need to calculate the time required to raech the future value. wha
should be the formula to arrive at the result

 

[Niek Otten]

Use the NPER() function

--
Kind regards,

Niek Otten

|
| Hi
|
| I know the principle , compound interest rate and the future vale. I
| need to calculate the time required to raech the future value. what
| should be the formula to arrive at the result.
|
|
| --
| manan
| ------------------------------------------------------------------------
| manan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34216
| View this thread: http://www.excelforum.com/showthread.php?threadid=541540
|

 

[manan]

Its a simple compound interest problem.
e.g
i need to find in how many years will a a sum double at 10% p.a
compound interest

 

[Niek Otten]

Yes, that's exactly what NPER() does.

=NPER(10%,0,-100000,200000)

Gives you 7.272541 years.

--
Kind regards,

Niek Otten

|
| Its a simple compound interest problem.
| e.g
| i need to find in how many years will a a sum double at 10% p.a
| compound interest
|
|
| --
| manan
| ------------------------------------------------------------------------
| manan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34216
| View this thread: http://www.excelforum.com/showthread.php?threadid=541540
|