Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to find returns for lump sum & yearly investments
To all you kind n intelligent souls out there, I need help to solve the following: A lump sum of $10,000 is invested in a fund for 20 years. Thereafter, an additional yearly investment of $1200 is made every anniversary till the end of the 20 year period. (i.e. a lump sum of 10,000 + 20 yearly payments of $1200). If the compounded interest is 5% for the first ten years and 7% for the remaining ten years, what is the future value that I can expect at the end of the 20 year period? What Excel functions can I use? Thanks for your help! Jack -- jackoat ------------------------------------------------------------------------ jackoat's Profile: http://www.excelforum.com/member.php...o&userid=25800 View this thread: http://www.excelforum.com/showthread...hreadid=399548 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find last occurance of text in range | Excel Worksheet Functions | |||
Find within Workbook. | Excel Discussion (Misc queries) | |||
How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
How to find returns in cells | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |