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