# What if Analysis - PowerPoint PPT Presentation

What if Analysis

1 / 6
What if Analysis

## What if Analysis

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
##### Presentation Transcript

1. What if Analysis

2. Goal Seek Command • Formulas- consider different options by changing values= what if analysis • Click on payment cell, go to Tools, Goal Seek, • set cell B5 • to value -250 (make negative because it’s a payment) • by changing cell \$B\$2 (just click on cell B2) • Excel tries options until it finds the right combination

3. Create What If Scenario • Can save changing values of a scenario • Select the values (only the items that get changed- principal, interest, and years), go to Tools, Scenarios, Add, name it

4. Compare Scenarios • Select and save different scenarios (ex: high, medium, and low payments) • Go to the Scenario Manager to Show each one • Or in Scenario Manager, go to Summary to see a report of all scenarios side-by-side (result cell should be B5, the payment)

5. Single Input Table • Click & Drag Loan Sheet while holding Ctrl and name it Single Input Table • Type 1% in cell D2, 2% in D3 and click an drag it down to increment by 1% (Get to 10%) • Click in cell E1 and type =B5 (payment cell) • Select table (list of values and resulting cells), go to Data, Table, • No Row Input, Column input- B3 (interest Cell) • Now you can see different values side-by-side • Use format painter tool to copy formatting from payment cell to table values

6. Two Input Table • Create new table sheet (Drag Single Input while holding Ctrl key) Name it Double Input Table • Drag cell E1 to D1 • In cell E1- J1- type 1, 2, 3, 4, 5, 6 (years) • Use Format Cells to change E1 to General • Select entire range of years & interest rates, go to Data, Table • Row Input- B4- years • Column input- B3- interest • Now you can see values for two sets of information