Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
finding the results of changing 4 variables
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the biggest number out of 8 variables | Excel Discussion (Misc queries) | |||
Copying functions without changing most variables in it | Excel Discussion (Misc queries) | |||
using VLookup with two variables to get results | Excel Discussion (Misc queries) | |||
Finding Top Two Survey Results | Excel Worksheet Functions | |||
Changing the cell color due to results. | Excel Discussion (Misc queries) |