How to calculate period

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.

Use the NPER() function

--
Kind regards,

Niek Otten

"manan" <manan.27p4rb_1147440004.7238@excelforum-nospam.com> wrote in message
news:manan.27p4rb_1147440004.7238@excelforum-nospam.com...
|
| 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...o&userid=34216
| View this thread: http://www.excelforum.com/showthread...hreadid=541540
|

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

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

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

Gives you 7.272541 years.

--
Kind regards,

Niek Otten

"manan" <manan.27p5wz_1147441504.1676@excelforum-nospam.com> wrote in message
news:manan.27p5wz_1147441504.1676@excelforum-nospam.com...
|
| 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...o&userid=34216
| View this thread: http://www.excelforum.com/showthread...hreadid=541540
|