| View previous topic :: View next topic |
| Author |
Message |
km4hr
General User
Joined: 08 Oct 2005
Posts: 14
Location: USA
|
 Posted: Thu Jan 31, 2008 8:21 pm Post subject: How to calculate the current value of a future amount. |
 |
|
How would I calculate the present value of $100 ten years from now at 3% annual interest?
The PV function works fine for periodic amounts but how can I calculate the present value (PV) of a single future amount? |
|
| Back to top |
|
 |
km4hr
General User
Joined: 08 Oct 2005
Posts: 14
Location: USA
|
| Posted: Thu Jan 31, 2008 8:38 pm Post subject: |
|
|
Never mind. After reading the help for PV more carefully I got the answer I was looking for.
The fourth parameter is FV. It's used for this purpose.
Thanks anyway! |
|
| Back to top |
|
|
|
