Chapter 12. USING DATA ANALYSIS TOOLS AND TECHNIQUES

Perform What-If Analysis

By using the Internal Rate of Return (IRR) function, you can find out how a change in the amount loaned, payment amount, or payment date — or some combination of these factors — affects the interest received. You can type in different amounts at different payment dates to see how different scenarios affect the interest rate.

What-if analysis is a systematic way of finding out how a change in one or more scenarios affects the result. The Scenario Manager lets you vary one or more inputs into any formula or function to see how the result changes.

There are two ways to use the scenario manager. You can click a scenario in the Scenario Manager dialog box and then click Show. ...

Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.