| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FV with inconsistant cash flow
On Feb 14, 8:54 am, bpeltzer
wrote: =2252483*1.2^5 + 129937*1.2^4 - 407451*1.2^3 - 439447*1.2^2 - 376040*1.2^1 It's just the sum of each year's investment with a 20% annual return (adjust each year's figure to account for inflow/outflow and the number of years it has to run). " wrote: I need a formula to calculate the following; Year 0 invest -$ 2,252,483 Year 1 invest -$ 129,937 Year 2 return $407,451 Year 3 return $439,447 Year 4 return $376,040 My required return is 20%. What is my future value of my return needed if I sell this investment in year 5 wanting an IRR of 20%. I know the answer is $4,086,000, but I am looking for a formula that will give me this answer. jeff- Hide quoted text - - Show quoted text - Thank you it worked. jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cash Flow | Charts and Charting in Excel | |||
| Cash Flow | Excel Discussion (Misc queries) | |||
| Cash Flow by Week | Excel Worksheet Functions | |||
| Cash Flow Set-Up | Excel Worksheet Functions | |||
| Cash Flow Analysis | Excel Discussion (Misc queries) | |||
Threaded Mode
