Implementation of Methods of Simulation Modeling of Investment Project Risks by Means of MS Excel
Journal Title: Бізнес Інформ - Year 2014, Vol 9, Issue 0
Abstract
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.
Authors and Affiliations
Yevhen Hlotov, Volodymyr Cherevatenko
Keywords
Related Articles
- EP ID EP158508
- DOI -
- Views 119
- Downloads 0
Economic Essence and Function of Financial Intermediaries in Ukraine
The article studies essence and purpose of activity of financial intermediaries in Ukraine. It analyses scientific works of foreign and Ukrainian scientists, on the basis of which it performs systematisation of views of...
The Improvement of Methodical Instruments for Alternative Mechanisms of Implementing Housing Programs: Theoretical and Practical Aspects of Public-private Partnership
The goal of this article is to study social and economic programs of construction (purchase) of affordable housing in Ukraine, creating offers on implementation of relevant housing projects and increasing its effectivene...
Prospects of Application of Project Investment for Innovative Agricultural Technologies
The article discusses the possibility of project investment for large-scale projects of innovative agricultural technologies. Agricultural technology implementation projects given the high cost of modern machines and equ...
Assessing the Level of Innovation Development of an Industrial Enterprise by Example of the Zavod Krasilovmash Limited Liability Company (LLC)
The goal of the article lies in approbation of the hierarchical model of assessment of the level of innovation development of an industrial enterprise on the basis of instruments of fuzzy logic on the basis of the engine...
Aspects of Stable Development on the Basis of Use of Innovation Energy-Saving
The article analyses the main strategic direction of reliability of energy supply of recreation systems with preservation of rates of economic growth under conditions of increase of efficiency of use of energy resources...