The AnalyticPro Spreadsheet (provisional name) is a powerful financial tool in Microsoft Excel for project and enterprise cash flow projections developed at GPFA by Prof. Dr. Daniel Christian Henrique. After a few years of construction, the spreadsheet could now be validated in projections of real and simulated projects arising from monograph research.
One of the biggest advantages of this spreadsheet in relation to the software found on the market is its total integration with financial theories, with integrated and pre-designed tabs to meet the different phases of a direct cash flow. Notably, it has already entered as one of the best spreadsheets for financial projection in the national academic environment.
The spreadsheet supports the inclusion of up to 35 products or services, with the possibility of splitting the revenues and costs; SAC or PRICE financing; separation between direct, indirect costs and expenses; projection for a predictable period of up to 30 years plus another 30 years of unpredictable period - totaling 60 years of cash flow. Offers the option of taxation by real or simple national profit.
The projections of changes in future cash flows can be differentiated for each product, type of tax, revenue, costs or expenses, facilitating the generation of optimistic, probable or pessimistic estimates as the fluctuations in the main variables of the project are simulated.
The spreadsheet already supports performing scenario analyzes, sensitivity analyzes and Monte Carlo simulations. However, the possibility of greater automation in the inputs of the variation data and generation of the resulting cash flows is in progress.
The AnalyticPro Spreadsheet is exclusive for use in research, not for sale. In the future, at the end of its development, we intend to adapt it to HTML or in executable to facilitate the use in GPFA research and guidelines in other universities.