present value of a future amount

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I find out the current value of a future amount? Let's assume 10
years from now somebody hands me $10,000. Assuming 4% inflation, how do I
determine how much that $10k is worth today? When I look at PV and NPV they
seem to want periodic payments which this doesn't have.

thanks
 
Cool. The amount seems intuitively right. Why does it return a negative
number?

Thanks much!

Russ
 
It's the convention that most financial functions (including Excel) use. By
convention, a negative number is money out of your pocket, and a positive number
is money going back into your pocket. However, you can use them whichever way
you want as long as you remember they have opposite signs. If you have payments,
make sure the sign is correct.
 
Makes sense. Thanks!

Fred Smith said:
It's the convention that most financial functions (including Excel) use. By
convention, a negative number is money out of your pocket, and a positive number
is money going back into your pocket. However, you can use them whichever way
you want as long as you remember they have opposite signs. If you have payments,
make sure the sign is correct.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Present Value of equal payments of a future value 1
Financial Calc: present cash value of a future amount 2
Present value and future value 6
Annuity Payments From A Present Amount 2
calculating the present value of X 2
Future Value 2
Calculating Future Value 6
Present Value of a Continuously Compounded Annuity Payment 5

Back
Top