FV with inconsistant cash flow

[kayvirgil]

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

 

[bpeltzer]

=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).

 

[kayvirgil]

=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).









- Show quoted text -

Thank you it worked. jeff