finding the results of changing 4 variables

[irrhelp]

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.

 

[JLatham]

You might try this template, available free from the Microsoft Excel
Templates area:
http://office.microsoft.com/en-us/templates/TC012342021033.aspx?CategoryID=CT101444811033

 

[Mike Middleton]

irrhelp -

For single-factor sensitivity analysis, where usually you keep three inputs
at base case and vary the fourth, you could use a one-way data table.

For two-factor sensitivity analysis, where usually you keep two inputs at
base case and vary the other two, you could use a two-way data table.

The data table approach is described in my free chapter, Sensitivity
Analysis Using Excel, available from the Chapters page at www.treeplan.com.

An alternative is to use an add-in to automate similar analyses. My SensIt
add-in may be useful. Another add-in is Palisade's TopRank.

- Mike
http://www.MikeMiddleton.com

 

[J D]

Did you ever find the answer to this? I am trying it today and there doesn't seem to be an easy way to do it in excel! Chug and plug...