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?

Something seems to be missing, but:

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

yields $9,790.
__________________________________________________ ____________________

"Gary" wrote in message
...
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?

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)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
Something seems to be missing, but:

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

yields $9,790.
__________________________________________________ ____________________

"Gary" wrote in message
...
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?

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

"Bernard Liengme" wrote:

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)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
Something seems to be missing, but:

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

yields $9,790.
__________________________________________________ ____________________

"Gary" wrote in message
...
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?