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. ...