Financial calculation

[Guest]

If I get a 10% return and I recieve returns of $3,000, 4,000, & 5,000,
respectfully for the next 3 years on my investments, what is the present
value of my investment?

 

[Vasant Nanavati]

Something seems to be missing, but:

=NPV(10%,3000,4000,5000)

yields $9,790.
______________________________________________________________________

 

[Bernard Liengme]

Nothing seems wrong
year amt PV rate 10%
1 3000 $2,727.27
2 4000 $3,305.79
3 5000 $3,756.57
SUM $9,789.63




rate in E1, nper in column A, FV in Column B
=-PV($E$1,A2,0,B2)

 

[Guest]

Thank you Vasant & Bernard for the assistance. Much appreciated, gary