Would this not be far too much of work as I would have to repeat the whole
excercise again, it has about 15 inputs with about 30 outputs, I would like
to use the what if analysis in the data tab, click on the scenario manger,
tell it which cells I want to change and link that to a formulae and then
choose the result cells which would be the performance indicators. This
spread sheet is going to be used as a finacial analysis tool, so the users
will only need to enter their data in the data sheet and everything else will
be automated including the scenario analysis, is it possible to automate
scenario anlysis

"Monkey-See, Monkey-Do" wrote:

I'd recommend doing this as a table with the column headings as normal +10%
-10% or whatever else and then just duplicate the columns, alternatively you
could have each of the scenarios as a different tab at the bottom of the page
if you didn't want to see the whole table

"David" wrote:

I have the following Data Inputs

Capital Expenditure C1
Cost of Borrowing C2
Income C3
Expenses C4
Discount Rate C5

These inputs are used to generate a project discounted cash flow and a
amortization table

I then calculate perormance indicators such as
NPV
Profitability Index
Breakeven ratio

I the want to create three scenarios 1) Capital Expenditure increase by 10%
2) Income decrease by 10% and 3)cost of borrowing increase by 1% and would
like to see the effect it has on all the performance indicators.

Q1) When you click on the changing cells option in the what if analysis can
you use a formulae to say C2*-0.1
2) Is it possible for your scenario results to change automatically should
you change the data inputs