Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What If Analysis in Excel 2007
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I do sensitivity analysis in excel 2007? | Excel Worksheet Functions | |||
Data Analysis with Excel 2007 | New Users to Excel | |||
regression analysis in excel 2007? | Excel Discussion (Misc queries) | |||
data analysis addin in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 Analysis Toolpak | Excel Discussion (Misc queries) |