I am working on financial model. I am having problem with the IRR function. i would like to enter the IRR value and resulted in the capex value.
Example:
year 0 1 2 3 4 5
cash -25 5 5 6 7 8
with discounted rate (or guess) is 0.08
The IRR is 7%
Now my question is
year 0 1 2 3 4 5
cash X 5 5 6 7 8
with discounted rate (or guess) is 0.08
The IRR is 10%
What function or formula i can use to solve X
Any help and input is greatly appreciated. Thank you in advance.
Bookmarks