What-If Analysis Tools in Excel

Cosma Emil ()
Additional contact information
Cosma Emil: "Ovidius" University of Constanta

Ovidius University Annals, Economic Sciences Series, 2018, vol. XVIII, issue 2, 240-245

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

Keywords: analysis; table; pmt; ipmt (search for similar items in EconPapers)
JEL-codes: C3 (search for similar items in EconPapers)
Date: 2018
References: Add references at CitEc
Citations:

Downloads: (external link)
http://stec.univ-ovidius.ro/html/anale/RO/wp-content/uploads/2019/02/9-2.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ovi:oviste:v:xviii:y:2018:i:2:p:240-245

Access Statistics for this article

Ovidius University Annals, Economic Sciences Series is currently edited by Spatariu Cerasela

More articles in Ovidius University Annals, Economic Sciences Series from Ovidius University of Constantza, Faculty of Economic Sciences Contact information at EDIRC.
Bibliographic data for series maintained by Gheorghiu Gabriela ().