View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] kayvirgil@yahoo.com is offline
external usenet poster
 
Posts: 2
Default FV with inconsistant cash flow

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