Prev: If iserror help
Next: Need help with CountIF function
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" <KEDIAANIL(a)discussions.microsoft.com> 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 help
Next: Need help with CountIF function