From: KEDIAANIL on 14 May 2010 10:41 PLS HELP ME TO FIND FV FOR A PERIODICAL UNEQUAL INVESTMENT WITH A CONSTANT COMULATIVE INTREST RATE. From: Brad on 14 May 2010 11:41 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. > From: Fred Smith on 14 May 2010 14:13 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 "KEDIAANIL" wrote in message news:16F6B94E-E40C-424D-B725-0099861488A2(a)microsoft.com...> PLS HELP ME TO FIND FV FOR A PERIODICAL UNEQUAL INVESTMENT WITH A CONSTANT > COMULATIVE INTREST RATE. >  |  Pages: 1 Prev: If iserror helpNext: Need help with CountIF function