finding the results of changing 4 variables

I

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.
 
M

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top