ПРОГНОЗУВАННЯ ПРИБУТКУ ПІДПРИЄМСТВА З ВИКОРИСТАННЯМ MS EXCEL

Abstract

The article is devoted to the question of forecasting the success and profitability of enterprises. The autonomy carried out an analysis of the results of the enterprises. We believe that we have a forecast for net arrangements, but they have identified realworld enterprises, weighted operating results, net results of other manufacturing enterprises, and the profitability of enterprises for unchanged functions that exist, and may believe that to consider it a profitable industry, and from different management companies do not require any changes. The article forecasts the profit and profitability of the company. The author draws conclusions from the results of the analysis of the financial results of the enterprise activity and the results of forecasting the profit and profitability of the enterprise. The results of forecasting net income from sales of products and cost of sales show a tendency to increase these indicators. The results of forecasting gross profit and net financial result of the enterprise activity also showed an upward trend. However, the company's net profit will grow at a modest pace. In the unchanged conditions of functioning of the enterprise, if on the one hand there are no changes in external circumstances that may affect the profitability of the enterprise, and on the other hand, the management of the enterprise will not introduce any changes, then during the period only the indicators of return on equity (due to the lack of company equity) and all other profitability indicators will be positive. On the whole, over the forecast, the trend of growth of the enterprise will remain in the dynamics of the profitability indicators of the enterprise under constant conditions of functioning of the enterprise. However, given the volatile development of the Ukrainian economy, the constant changes in legislation, etc., it is not necessary to use such a straight-line method in the long run. On the whole, over the forecast, the trend of growth will remain in the dynamics of the enterprise's indicators in the unchanged conditions of the enterprise's functioning. However, given the volatile development of the Ukrainian economy, the constant changes in legislation, etc., it is not necessary to use such a straight-line method in the long run.