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