Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default fv of a periodical unequal investment

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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 846
Default fv of a periodical unequal investment

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default fv of a periodical unequal investment

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
is there a formula for FV with UNEQUAL payments toma Excel Worksheet Functions 1 September 3rd 08 02:45 AM
Unequal Product Sum Aitchy Excel Worksheet Functions 3 April 6th 07 12:28 PM
Merging 2 unequal workbooks Chuck Excel Discussion (Misc queries) 1 July 6th 06 05:30 AM
unequal sign et Excel Discussion (Misc queries) 2 February 6th 05 11:17 PM
Unequal Sign et Excel Discussion (Misc queries) 1 February 5th 05 04:30 AM


All times are GMT +1. The time now is 09:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"