Avaliação econômica de fluxo de caixa através de planilhas dinâmicas: estudo de casos

Abstract

This work focused to underst and how oil has been the strategically most important commodity in the world for many decades and, based on the concept of oil reserves, show the need to measure economic indices for future investment evaluation. With the aid of the computational platform, Excel 2010, a simulator was developed, which evaluated the data from websites, books, articles and works developed in the area. To verify the functionality and in order to analyze the simulator, two onshore (Solimões Basin) and offshore (Campos Basin) fields of study were selected, and the cash flow from an oil reserve was selected. Precepts for formulating the simulator, and thus calculating them. Therefore, at the end of the work it was possible to evaluate that the results obtained in the evaluation were satisfactory, and the necessity of this study stems from the decisive questions present in the oil and gas industry, in which problems in relation to losses and gains must be solved, to estimate the viability of projects for companies through economic analysis.