fv of a periodical unequal investment

  • Thread starter Thread starter KEDIAANIL
  • Start date Start date
K

KEDIAANIL

PLS HELP ME TO FIND FV FOR A PERIODICAL UNEQUAL INVESTMENT WITH A CONSTANT
COMULATIVE INTREST RATE.
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FV function 2
Possible problem with PMT and FV functions 2
Financial Functions, in particular, the INTRATE function 5
Future Value Function (FV) 2
Saving for College 1
Future Value calculation 15
Fv function in Excel 1
Finance functions discrepancy 4

Back
Top