What-If Analysis Tools in Excel
What-If Analysis tools are available in Excel and they can be used for a variety of purposes. This paper is concerned with their description, as well as a few examples of their applications in financial models. For this reason, two types of data tables are taken into account: one-variable data table...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Ovidius University Press
2018-01-01
|
| Series: | Ovidius University Annals: Economic Sciences Series |
| Subjects: | |
| Online Access: | http://stec.univ-ovidius.ro/html/anale/RO/wp-content/uploads/2019/02/9-2.pdf |
| Summary: | What-If Analysis tools are available in Excel and they can be used for a variety of purposes.
This paper is concerned with their description, as well as a few examples of their applications in financial models. For this reason, two types of data tables are taken into account: one-variable data tables and two-variable data tables. We will look at how these can be structured in order to show us the effect that a loan could have on our yearly budget, by experimenting with different values for the interest rate and total number of payments. We will also employ the use of PMT and IPMT functions. |
|---|---|
| ISSN: | 2393-3127 2393-3127 |