function

  • Thread starter Thread starter Vishal Patel
  • Start date Start date
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.
 
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.
 
Back
Top