Mac Works 3.0: Calculating Future Value of a Single Cash Flow
  
PSS ID Number: Q103770
Article last modified on 10-22-1998
 
3.0
 
MACINTOSH
 

======================================================================
3.00
MACINTOSH 103770
kbother
 
-------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, version 3.0
-------------------------------------------------------------------
 
SUMMARY
=======
 
The FV function in a Microsoft Works spreadsheet returns the future
value of an investment based on periodic, constant payments and a
constant interest rate.
 
The FV function can also be used to calculate the future value of a
single lump sum payment. To do this, enter the lump sum payment amount
as the present value (PV) and enter the payment amount as zero.
Entering a zero as the payment amount tells Works there is no constant
stream of payments.
 
For example, suppose that you will invest $1,000 today at an interest
rate of 12 percent, and you would like to know what the investment
will be worth at the end of five years.
 
The FV formula is entered as follows:
 
   =FV(12%,5,0,-1000,0)
 
KBCategory: kbother
KBSubcategory: macworkskb
 
Additional reference words: 3.00 mwksss m_eXcel
======================================================================
Version           : 3.0
Platform          : MACINTOSH
Issue type        : kbhowto
=============================================================================
Copyright Microsoft Corporation 1998.