Finding outputs by changing 4 variable inputs

[trihiker]

Hi, I'm working on a 10 year financial forecasting model for an investment
fund. The end result is to calculate the IRR. There are 4 variable inputs I
would like to change, and observe how the IRR changes as those inputs change.
In other words, I would like to play with changing two different fees, the
fund size, and the expected return, and see how changing those impacts the
IRR.

Is there a way to do this on one sheet without manually changing all these
inputs? I think Scenario or Data Tables might do it, but I'm not sure.

Thank you.

[davegugg]

Not sure what you are asking, but there must be some sort of formula for IRR that includes your 4 values. To see how they changes look, set up 4 cells to hold the 4 values you want to change, then set up a seperate cell to = the formula that references those four cells. To see a graph of results, set up a data table with the different inputs and results.

As a side note, when you have a request such as yours above, try to post as much information as you can. Sample workbooks go a long way toward helping others to find solutions. Speaking for myself, I don't even know what IRR means, so it is hard to respond.