Microsoft KB Archive/102148

Works: Calculating the Future Value of a Single Cash Flow PSS ID Number: Q102148 Article last modified on 08-02-1993 PSS database name: M_WorKs

2.00 3.00

MACINTOSH

= SUMMARY =

The FV function in Microsoft Works 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)

Additional reference words: 2.00 3.00 mac mwksss m_eXcel

Copyright Microsoft Corporation 1993.