UM MODELO DE PLANILHA INFORMATIZADA PARA AVALIAÇÃO ECONÔMICO-FINANCEIRA DE PROJETOS

Abstract

This article tries to contribute for modernizing the computerized worksheet models used for financial and economic evaluation of projects. Its strategy consists in taking computerization as operational under-assumption and enriching the traditional worksheet with extra doses of Economic Theory. Then, it becomes possible to draw a worksheet which is more effective as an evaluation tool. Section 2 depicts the qualities required by an ideal worksheet, in computerized environment: "comprehensiveness" (the worksheet must project "the firm" for two alternative situations: "with project" and "without project"); "descriptiveness" (all the assumptions of calculations must be disclosed); "economy" (only the portion of the firm directly affected by the project must be projected in detail); and "versatility" (the worksheet must serve several types of project). Section 3 outlines the format of the worksheet proposed (in Annex I) in accordance with the ideal pattern. Section 4 details the configuration of the final tables, such as they are presented in the Annex. Last, Section 5 shows how to isolate sub-projects by way of the "successive rounds" method of calculation (Annex II gives a numerical illustration of this method) and also the influence that the specific format of final projections undergoes from certain usually non-explicitly recognized hypotheses.