View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brad Brad is offline
external usenet poster
 
Posts: 846
Default fv of a periodical unequal investment

Lots of assumptions being made here

=FV(0.04,(TODAY()-A2)/365,0,-B2)

..04 = assumed annual interest rate
Today() = is the "as of" date of the calculation - this probably needs to be
changes
a2 = date payment
b2 = the amount of payment

Then sum up all the individual accumulations. using sum(range) - example
=sum(c4:c300)

There are several different "calculation" methods that could be used - this
is a common one.

--
Wag more, bark less


"KEDIAANIL" wrote:

PLS HELP ME TO FIND FV FOR A PERIODICAL UNEQUAL INVESTMENT WITH A CONSTANT
COMULATIVE INTREST RATE.