Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
PLS HELP ME TO FIND FV FOR A PERIODICAL UNEQUAL INVESTMENT WITH A CONSTANT
COMULATIVE INTREST RATE. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 ... PLS HELP ME TO FIND FV FOR A PERIODICAL UNEQUAL INVESTMENT WITH A CONSTANT COMULATIVE INTREST RATE. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
is there a formula for FV with UNEQUAL payments | Excel Worksheet Functions | |||
Unequal Product Sum | Excel Worksheet Functions | |||
Merging 2 unequal workbooks | Excel Discussion (Misc queries) | |||
unequal sign | Excel Discussion (Misc queries) | |||
Unequal Sign | Excel Discussion (Misc queries) |