Hello,

I am trying to conduct a €œwhat-if€� analysis for a fairly simple financial
model. This model is basically one extensive income statement that contains
historical data as well as forward-looking statements. Historical data is
hard-coded while the forecast data is driven by revenue, expense, and other
miscellaneous assumptions. At any given point, I want to manipulate the
revenue assumption for the upcoming period to see what the effect would be,
not only on that period, but for all future periods.
Clearly, the easiest way to do this would be to punch in different
assumptions to see what the outcome would be. However, I want to develop
something that would outline multiple outcomes (for example, 10%, 30%, or 50%
growths) of these revenue adjustments all at the same time.
I tried using scenarios (under ToolsScenarios) and that works great except
that it cannot show multiple outcomes all on one page at the same time. I
messed around with €œSummary€� function under scenarios, but those outputs seem
gear towards one-time analysis rather than for something that would need to
be revisited each month. I was wondering if there is any other way to get the
Scenarios to €œpublish€� the effects of different inputs as a separate report
that has more functionality and transparency.
I also tried using data tables, which work fine if I just want to see
different outcomes for one period, but if I want to see how those one period
changes would affect other future periods, I would need to build additional
steps to implement it into my main model (toggle switches, etc.)

Any help/insight will be appreciated!