Mac Works: Computing Interest/Growth Rate on a Single Payment
  
PSS ID Number: Q102143
Article last modified on 10-22-1998
 
3.0
 
MACINTOSH
 

======================================================================
--------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, version 3.0 and 4.0
--------------------------------------------------------------------
 
SUMMARY
=======
 
In Microsoft Works, the RATE() function assumes a stream of payments.
If you would like to compute the interest rate for a single payment
(present value) over a given period, use this formula
 
   =((fv/pv)^(1/n))-1
 
where "pv" equals the value today (present value), "fv" equals the
value at the end of the time period (future value), and "n" equals the
total number of periods.
 
Keep in mind that the rate will be for one period, for example, for 10
years. In this case, use N=10 to get the annual rate or N=120 (10*12)
to get the monthly rate.
 
Example
-------
 
To find the annual rate of interest accrued by $1000 invested today
with an expected yield of $5000 in 10 years, use:
 
   =((5000/1000)^(1/10))-1
 
This means that it would require an interest rate of 17.46 percent
compounded annually to yield $5000 in 10 years from an initial
investment of $1000.
 
Additional query words: 3.00 mwksss m_eXcel
======================================================================
Version           : 3.0
Platform          : MACINTOSH
Issue type        : kbhowto
=============================================================================
Copyright Microsoft Corporation 1998.