function

V

Vishal Patel

Dear all,

Can some one tell me the function ;-

this is like if 60000 is left for 20 yrs at 30% compunding it will be
1cr

but how can i get the reverse of the same ie if i want 100000 after 20
yrs what should i invest today.
 
N

Niek Otten

Look in HELP for the PV() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Dear all,
|
| Can some one tell me the function ;-
|
| this is like if 60000 is left for 20 yrs at 30% compunding it will be
| 1cr
|
| but how can i get the reverse of the same ie if i want 100000 after 20
| yrs what should i invest today.
 
Top