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 |
| id |
doaj-a0ef85d1e52046478f1075af327f8c7e |
|---|---|
| record_format |
Article |
| spelling |
doaj-a0ef85d1e52046478f1075af327f8c7e2020-11-24T21:12:41ZengOvidius University PressOvidius University Annals: Economic Sciences Series2393-31272393-31272018-01-01XVIII2240245What-If Analysis Tools in ExcelCosma Emil0"Ovidius" University of ConstantaWhat-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.http://stec.univ-ovidius.ro/html/anale/RO/wp-content/uploads/2019/02/9-2.pdfanalysistablepmtipmt |
| collection |
DOAJ |
| language |
English |
| format |
Article |
| sources |
DOAJ |
| author |
Cosma Emil |
| spellingShingle |
Cosma Emil What-If Analysis Tools in Excel Ovidius University Annals: Economic Sciences Series analysis table pmt ipmt |
| author_facet |
Cosma Emil |
| author_sort |
Cosma Emil |
| title |
What-If Analysis Tools in Excel |
| title_short |
What-If Analysis Tools in Excel |
| title_full |
What-If Analysis Tools in Excel |
| title_fullStr |
What-If Analysis Tools in Excel |
| title_full_unstemmed |
What-If Analysis Tools in Excel |
| title_sort |
what-if analysis tools in excel |
| publisher |
Ovidius University Press |
| series |
Ovidius University Annals: Economic Sciences Series |
| issn |
2393-3127 2393-3127 |
| publishDate |
2018-01-01 |
| description |
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. |
| topic |
analysis table pmt ipmt |
| url |
http://stec.univ-ovidius.ro/html/anale/RO/wp-content/uploads/2019/02/9-2.pdf |
| work_keys_str_mv |
AT cosmaemil whatifanalysistoolsinexcel |
| _version_ |
1716750104258412544 |