Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |