On Feb 22, 6:10 pm, "toyota58" wrote:
Another formula I want to make is
Example : Suppose I put $ 1,000 lump sum in a mutual fund at 10
percent interest per annum. How much is the accumulated wealth after 5
years.This is one lump sum payment only at the beginning of the
period. No additional monthly payments.

First, a correction to my previous response. If the mutual fund
returns 10% per year, its (compounded) monthly rate is
RATE(12,0,-1,1+10%), not 10%/12. So the previous formula should have
been:

=fv(rate(12,0,-1,1+10%), 5*12, -100, 0, 1)

For the latest example:

=fv(10%, 5, 0, -1000)

Please study Help - Excel Help for FV().