Microsoft KB Archive/103770

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

= 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.