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

--
mana
-----------------------------------------------------------------------
manan's Profile: http://www.excelforum.com/member.php...fo&userid=3421
View this thread: http://www.excelforum.com/showthread.php?threadid=54154

Use the NPER() function

--
Kind regards,

Niek Otten

"manan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
|
| 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


--
manan
------------------------------------------------------------------------
manan's Profile: http://www.excelforum.com/member.php...o&userid=34216
View this thread: http://www.excelforum.com/showthread...hreadid=541540

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

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

Gives you 7.272541 years.

--
Kind regards,

Niek Otten

"manan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
|
| 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
|