BUSINESS INFORM №9-2014

The title and content

ABSTRACTS AND INFORMATION ABOUT AUTHORS

20

Section: Economic and Mathematical Modeling
UDC 336.001.57.004
Hlotov Y. O., Cherevatenko V. A.
Implementation of Methods of Simulation Modeling of Investment Project Risks by Means of MS Excel (p. 119 - 124)
Investment project development regards an investment project as an object of a financial operation associated with time-phased financial receipts and spendings, that is cash flows, or as a system of organizational and legal as well as settlement and financial documents necessary for carrying out certain activities or those which describe such activities. This work considers a business problem which serves as the basis for development of a simulation procedure. Considering that the original variables included into the problem as well as the results are arbitrary, it is necessary to know the law of distribution of the variables (uniform or normal) before simulation modeling. If the law of distribution of random variables included into the problem is unknown, it is necessary to conduct computational experiments both for the uniform and the normal distribution and compare them afterwards. Based on the comparison, preference is given to the option which yields the largest money receipts with the minimal net present value of the investment project. In the view of the foregoing, the templates (“Simulation”, “Analysis Results”) designed for simulation modeling for the uniform and normal laws of distribution of the key variables of the problem as well as the results (NCF, NPV) were developed in the work. Numerical characteristics were obtained for the key variables and the results, and their probabilistic analysis was carried out. In addition, a graphical comparative analysis of NCF, NPV was conducted for different distributions. A conclusion was made on the basis of the comparative analysis that if a large number of experiments are held, the best option is to select the normal law of distribution of key variables and results.
Keywords: simulation modeling, uniform distribution, normal distribution, cash flow, net present value, key variables
Fig.: 6. Tabl.: 2. Formulae: 2. Bibl.: 15.

Hlotov Yevhen O. – Candidate of Sciences (Engineering), Associate Professor, Head of the Department, Department of Economic and Mathematical Methods and Information Technology, Kharkiv Institute of Finance of the Kyiv National University of Trade and Economics (5 Pletnovskyi Lane, Kharkіv, 61003, Ukraine)
Email: [email protected]
Cherevatenko Volodymyr A – Candidate of Sciences (Economics), Associate Professor, Deputy Director, Kharkiv Institute of Finance of the Kyiv National University of Trade and Economics (5 Pletnovskyi Lane, Kharkіv, 61003, Ukraine)
Email: [email protected]

Article is written in Ukrainian
Downloads/views: 175

Download article (pdf) -

Reference to this article:
Hlotov, Yevhen O., and Cherevatenko, Volodymyr A. (2014) “Implementation of Methods of Simulation Modeling of Investment Project Risks by Means of MS Excel.” Business Inform 9:119–124.

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 |

FOR AUTHORS

License Contract

Conditions of Publication

Article Requirements

Regulations on Peer-Reviewing

Publication Contract

Current Issue

Frequently asked questions

INFORMATION

The Plan of Scientific Conferences

OUR PARTNERS

Journal «The Problems of Economy»

The site and its metadata are licensed under CC BY-SA.

Write to webmaster