期刊名称：Ovidius University Annals: Economic Sciences Series
电子版ISSN：2393-3127
出版年度：2018
卷号：18
期号：2
语种：English
出版社：Ovidius University Press
摘要：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.
