OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to calculate the current value of a future amount.

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
km4hr
General User
General User


Joined: 08 Oct 2005
Posts: 14
Location: USA

PostPosted: Thu Jan 31, 2008 8:21 pm    Post subject: How to calculate the current value of a future amount. Reply with quote

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
View user's profile Send private message
km4hr
General User
General User


Joined: 08 Oct 2005
Posts: 14
Location: USA

PostPosted: Thu Jan 31, 2008 8:38 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group