fv of a periodical unequal investment

[KEDIAANIL]

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

 

[Brad]

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.

 

[Fred Smith]

People have to make too many assumptions to provide any help. You should
clarify what you are looking for. An example would be good.

And stop SHOUTING.

Regards,
Fred