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

=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

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