Content
3. Organization computer processing economic information 3
15. Analysis of capital allocation and assessment of the property status of the enterprise 7
Problem 1 15
Problem 2 18
Problem 3 19
References 21
3. Organization of computer processing of economic information
Economic information reflects the facts of production and economic activity using a system of natural and cost indicators. Economic information, as a rule, is transmitted and processed in the form of signs recorded on various substances and media. A set of signs used for the exchange of economic information in a certain economic system, forms the language of economic information.
Analytical processing of economic information is very labor-intensive, so the efficiency and effectiveness of economic analysis increases significantly when using modern technologies information processing. The computing tools available to enterprises and organizations make it possible to fully automate the processing of economic information, including the analysis of enterprise activities. The need to automate economic analysis is due to the increasing importance economic methods enterprise management: the need to develop and justify long-term business plans, comprehensive assessment of the effectiveness of short-term and long-term management decisions.
In this regard, the organization of computer processing of economic information becomes objective necessity. This trend is due to the growing importance of high-quality information services for the business management process, the rapid development of the technical capabilities of modern computers, and the peculiarities of the current period of economic development.
The most effective organizational form of using PCs is the creation on their basis of automated workstations (AWS) for accountants, economists, planners, etc. An automated analyst workstation is understood as a professionally oriented small computing system designed to automate work on analyzing business activities. The technical base of the analyst's workstation consists of personal computers of domestic and foreign production.
Most effective form The functioning of the automated workplace is to connect them into a single computer network for analytical support of the economic activities of the enterprise.
Experience in designing analyst's workstations and other systems allows us to generalize the requirements for their functioning: timely satisfaction of the computational and information needs of the economist when analyzing economic activities; minimal response time to analytical requests; the ability to present output information in tabular and graphical form; the ability to make adjustments to the calculation methodology and to the forms for displaying the final result; repeating the process of solving a problem from any arbitrarily specified point (stage) of calculation; ability to work as part of a computer network; ease of mastering the techniques of working on an automated workstation and the interaction of the man-machine system.
Within the framework of the analyst's workstation, the entire information fund of the enterprise functions in the form of a database, knowledge base and software. Databases provide factual data about business activities. The intellectual shell of their useful reading is knowledge bases - methods and techniques of analysis. Software tools form a tool for the automated execution of analytical tasks for information support of economic activities.
At the same time, the organization of computer processing of economic information is characterized by a number of features:
Firstly, maintaining the integrity of the analysis, subject to decentralized information processing. In the theory of business activity analysis, much has already been done to achieve consistency, functional, technical, methodological and information compatibility of the components of the analysis into a single whole. Thanks to this, the objectivity of the analysis and its reliability are achieved. In conditions of decentralized information processing, the integrity of the analysis is not destroyed, the unity of goals and analysis tasks from the point of view of its systemic properties. Therefore, we can say that a developed network of distributed databases corresponds to a system of distributed tasks of economic activity, individual tasks of AHD, intermediate results, etc.; no matter how important they are, they must pass through the prism of hearts common system comprehensive analysis, which implements all particular tasks.
Secondly, connecting the information processing process with the decision-making process. Centralization of information processing in powerful computer centers, characteristic of older generation automated control systems......
References
1. Abryutina M.S., Grachev A.V. Analysis of financial and economic activity of an enterprise: educational and practical work. allowance / M.S. Abryutina, A.V. Grachev. – M.: Business and Service, 2007. – 257 p.
2. Bakanov M.I., Sheremet A.D. Theory of economic analysis: textbook. allowance / M.I. Bakanov, A.D Sheremet. – M.: Finance and Statistics, 2009. – 218 p.
3. Berdnikova T.B. Analysis and diagnostics of financial and economic activities of an enterprise: textbook. allowance / T.B. Berdnikova. – M.: Infra-M, 2009. – 215 p.
4. Kodrakov N.P. Basics financial analysis: textbook / N.P. Kondrakov. – M.: Glavbukh, 2007. – 114 p.
5. Lyubushin N.P. Complex economic analysis of economic activity: textbook / N.P. Lyubushin. - M.: UNITY, 2008. - 445 p.
6. Nikolskaya E.V., Lozinskaya V.B. Financial analysis: textbook. allowance / E.V. Nikolskaya, V.B. Lozinskaya. – M.: MGAP World of Books, 2007.–316 p.
7. Pyastolov S.M. Analysis of the financial and economic activities of an enterprise: textbook. manual for universities / S.M. Postoyalov. – M.: Masterstvo, 2008.-336 p.
8. Savitskaya G.V. Analysis of the economic activity of an enterprise: textbook / G.V. Savitskaya. – M.: INFRA-M, 2007.–336 p.
9. Enterprise management and analysis of its activities: textbook / S.Yu. Naumov – Saratov: Saratov University Publishing House, 2008. – 318 p.
10. Chechevitsyna L.N. Economics of the company: textbook / L.N. Chechevitsyna. - Rostov n/d: Phoenix, 2008. - 389 p.
In a decision-making system, data obtained through analysis financial condition organizations represent one of the most essential elements. Almost all users of accounting data and financial reports use financial analysis methods to make decisions to one degree or another.
Taking risky decisions in production, a manager can lead the organization to bankruptcy or to the fact that the enterprise will have large financial problems. Therefore, recently a large number of software products, capable of analyzing accounting and financial reporting data and providing fairly accurate data on the state of affairs in the organization. The cost of such computer programs, as a rule, ranges from 0 to 1000 dollars per program, and the price does not always correspond to the quality - even free programs can give good results.
In this course work I reviewed the most well-known domestic programs in our country for diagnosing financial condition in order to compare them according to various parameters: starting from the cost of a specific program, the ability to export data for analysis from other programs (most often “1C: Enterprise” from 1C), and ending with the ability to present data in English.
This work consists of two parts: the first part describes a theoretical approach to financial diagnostics of organizations, and the second part describes specific programs for conducting financial analysis, gives their main characteristics and draws a conclusion about for which enterprises this program fits best.
1. General scheme of financial diagnostics
1. 1. Essence, goals and types of financial condition assessment
Currently, the financial condition of organizations is interpreted from different perspectives, while there is no unified methodological approach to its determination, which makes it difficult to construct universal practical analysis methods.
In general, the financial condition of an enterprise can be defined as complex economic category, which characterizes, as of a certain date, the presence of various assets in an enterprise, the size of liabilities, the ability of a business entity to function and develop in a changing external environment, the current and future ability to satisfy the demands of creditors, as well as its investment attractiveness.
Different interpretations of the concept of financial condition lead to different purposes for its assessment. From the point of view of business diagnostics, the result of the analysis of the financial condition is to determine the optimal amount of the enterprise's reserves, which should be sufficient to ensure the normal solvency of the enterprise and minimize costs financial risk, and, at the same time, not to divert excess working resources from current economic activities.
There is also an orientation of the analysis towards finding and eliminating intra-company problems:
The main purpose of financial analysis is to assess and identify internal problems companies for preparing, justifying and making various management decisions, including in the field of development, overcoming the crisis, transition to bankruptcy procedures, buying and selling a business or a block of shares, attracting investments.
The set goals determined the need to solve a number of analytical problems. In the domestic literature, the following main groups of tasks of internal analysis of the financial condition of an enterprise are distinguished:
1. Identification financial situation.
2. Identification of changes in financial condition in space and time.
3. Identification of the main factors that caused changes in financial condition.
4. Timely identification and elimination of deficiencies in financial activities, and search for reserves for improving the financial condition of the enterprise and its solvency.
5. Forecasting possible financial results, economic profitability based on the actual conditions of economic activity and the availability of own and borrowed resources, developing models of financial condition for various options for using resources.
6. Development of specific activities aimed at more efficient use financial resources and strengthening the financial condition of the enterprise.
The assessment of financial condition can be carried out using various types of models that allow structuring and identifying the relationships between the main indicators. There are three main types of models: descriptive, predicative and normative.
Descriptive models, known as descriptive models, are fundamental for assessing the financial condition of an enterprise. These include: building a system of reporting balance sheets, presenting financial statements in various analytical sections, vertical and horizontal analysis of reporting, a system of analytical coefficients, analytical notes for reporting. All of these models are based on the use of accounting information.
Predictive models are models of a predictive, predictive nature. They are used to forecast a company's income and its future financial condition. The most common of them are: calculating the point of critical sales volume, building predictive financial reports, dynamic analysis models (strictly determined factor models and regression models), situation analysis models.
Regulatory models allow you to compare the actual results of enterprises with the expected results calculated according to the budget. These models are used primarily in internal financial analysis. Their essence comes down to the establishment of standards for each cost item for technological processes, types of products, responsibility centers and to the analysis of deviations of actual data from these standards. The analysis is largely based on the use of strictly deterministic factor models.
Depending on the specified areas, financial condition analysis can be carried out in the following forms:
1. Retrospective analysis (intended to analyze current trends and problems in the financial condition of the company, while it is believed that quarterly reporting for the last reporting year is sufficient and reporting period current year).
2. Prospective analysis (necessary for examination financial plans, their validity and reliability from the standpoint of the current state and existing potential).
3. Plan-fact analysis (required to assess and identify the reasons for deviations of reporting indicators from planned ones).
1. 2. Procedure for assessing financial condition
As a rule, the main information base for financial analysis there are forms of annual and quarterly financial statements, analytical reports, data obtained by independent expertise.
General qualitative analysis is one of the initial stages of assessing the financial condition of an organization. At this stage, the reliability of the reporting provided, the quality of accounting organized at the enterprise is assessed, the degree of compliance of the monetary valuation of assets and liabilities with their real market values is studied, the intangible sphere of the enterprise is assessed from a qualitative point of view: business reputation, established economic relations, the level of training and organization of management, turnover and professionalism of personnel, prospects for the development of the industry and target markets of the enterprise, stages life cycle basic goods of the enterprise, etc. Similar procedures can be carried out using SWOT analysis methods, constructing matrices of comparative competitive advantages of an enterprise and local problem areas, bottlenecks. Vertical and horizontal financial analysis can also be performed at this stage.
Ratio analysis is the calculation of coefficients in various areas (Appendix 2):
Indicators for assessing property status.
Indicators for assessing liquidity and creditworthiness.
Evaluation indicators financial stability.
Business activity indicators.
Indicators for assessing profitability.
This area traditionally plays a major role in analytical procedures when assessing the financial condition of an enterprise. Transition from absolute indicators relative is due to the following factors:
The influence of the size of the company on the final indicators is eliminated, it becomes possible to evaluate not only the size, but also the efficiency of the enterprise;
Since the numerator and denominator are expressed in the same units, the influence of inflationary processes and exchange rates is leveled out, it becomes possible to compare enterprises from different countries;
The basis of comparison for assessing a particular financial indicator can be:
1. Corridors of standard values regulated by documents and legislative acts.
2. Scientifically based optimal values of indicators.
3. Industry average values of indicators.
4. Characteristics of analogous enterprises.
5. Dynamics of own indicators for previous periods.
The influence of problematic situations arising during interpretation financial ratios, to a certain extent make it possible to level out integrated models for assessing financial condition based on the calculation of a small number financial indicators summarized in a comprehensive assessment. Moreover, these models make it possible to classify an enterprise into one group or another, with the corresponding set of characteristics. Based on such an analysis, it becomes possible to make an absolute assessment of the financial position of an enterprise as of a certain date, and not just study its changes and comparative analysis. Also, integral methods are convenient for express analysis of financial condition, since they do not require significant investments of time and resources.
In the general block of integral methods, the following conceptual directions can be distinguished:
1. Statistically based models for predicting possible bankruptcy. The Altman indicators (also known as Z score, Z indicator or creditworthiness index), the Fox Model, the Taffler Model, the IGEA Model, the Fulmer Model, the Springate Model and others are used here (Appendix 3).
2. Methods for determining the rating of an organization for lending purposes. Methods developed by various commercial banks are used here. Examples include models developed by Sberbank of the Russian Federation, Moscow Industrial Bank, as well as other financial institutions (Appendix 4).
3. Methods for ranking organizations. The method of sum of places, the method of geometric mean, the method of significance coefficients and the method of distances are used here (Appendix 5).
Based on the data obtained during the assessment of the financial condition of the enterprise, the expert group makes a conclusion about the financial condition of the organization.
Users |
Scope of economic interests in assessment |
|||||||||||||||||||||||||||||||
Owners |
Assessment of the feasibility of costs incurred and achieved financial results financial stability and competitiveness, opportunities and prospects for further development, efficiency of use borrowed funds, identifying damages, unproductive expenses and losses, making reasonable forecasts about the financial viability of the enterprise. |
|||||||||||||||||||||||||||||||
Shareholders |
Composition analysis management expenses and assessment of their feasibility, analysis of profit generation, analysis of losses, unproductive expenses and losses, structural analysis spending profits on accumulation and consumption, assessing the effectiveness and ongoing dividend policy. |
|||||||||||||||||||||||||||||||
Banks and lenders |
Assessment of composition and structure enterprise property, analysis and assessment of the solvency and financial stability of the enterprise, assessment of the efficiency of using equity and borrowed capital, analysis of the composition, structure and ratio of receivables and payables, assessment of settlements for previously received short-term and long-term loans and borrowings. |
|||||||||||||||||||||||||||||||
Suppliers and buyers |
Assessing the liquidity of current liabilities, the presence of overdue receivables and accounts payable, analysis and assessment of the structure of current assets, assessment of solvency and financial stability. |
|||||||||||||||||||||||||||||||
Assessing the reliability of data on the tax base for the calculation of federal and local taxes and their transfer to the budget |
||||||||||||||||||||||||||||||||
Off-budget funds |
Assessing the reliability of information on the average number of employees of an enterprise and the accrued wage fund, assessing the timeliness of settlements with extra-budgetary funds. |
|||||||||||||||||||||||||||||||
Investors |
Assessing the efficiency of using equity and borrowed capital, accounts receivable and payable, enterprise property, assets, analyzing the degree of liquidity for repaying short-term and long-term obligations, financial stability. analysis and evaluation of the effectiveness of long-term and short-term financial investments due to own funds enterprises. |
|||||||||||||||||||||||||||||||
Hired labor |
Assessment of the dynamics of sales volume, production costs, implementation production tasks and compliance with labor legislation on remuneration, provision of labor and social benefits at the expense of the net profit of the enterprise. 2. Share of fixed assets in assets = 120/300 3. Magnitude of own working capital = 290 – 230 – 690 4. Maneuverability of own working capital = 260/(290-230-690) 5. Current ratio = (290-230)/690 6. Quick ratio = (290-210-220 -230)/690 7. Coefficient absolute liquidity = 260/690 8. Share of working capital in assets = (290-230)/300 9. The share of own working capital in their total amount = (290-230 -690)/(290-230), or (490+590-190)/290-230 10. Share of inventories in current assets = (210+220)/290 11. Share of own working capital = (290-230-690)/(210+220) 12. Concentration factor equity =490/300 13. Financial dependency ratio = 300/490 14. Equity capital flexibility ratio = (290-230-690)/490 15. Concentration factor borrowed capital = (590 + 690)/300 16. Long-term investment structure coefficient = 590/(190 +230) 17. Debt to equity ratio = (590 +690)/490 18. Capital productivity = f.2 10/120 19. Equity turnover f.2 10/490 20. Total capital turnover f.2 10/300 21. Net profit = f.2 10 22. Product profitability = f.2 50/ f. 2 10 23. Return on total capital = f.2 190/300 24. Return on equity = f. 2 190 /490 25. Payback period of equity capital = 490/f.2,190 Appendix 3. “Bankruptcy Forecasting Models”1. Altman coefficient (2 factor): Z= -0.3877-1.0736*(290/690) + 0.0579*(300/490) If Z=0, then probability of bankruptcy = 50% If Z>0, then the probability of bankruptcy is > 50% If Z<0, то вероятность банкротства < 50% 2. Altman coefficient (5 factor): Z=1.2*((290-690)/300)+1.4*(form 2,190)/300 + 3.3*((form 2,050)/300)+ 0.6*(price shares/(590+690))+ f.2 010/300 If Z<1,81 – организация банкрот. If Z>2.99 is a financially stable enterprise. If Z<=2,99 и Z>=1.81 – uncertainty. 3. Taffler model Z = 0.53 * (f.2 050 / 690) + 0.13 * (290 / (690 + 590)) + 0.18 * (690 / 300) + 0.16 * (f.2 010 / 300 ) If Z>0.3 – a financially stable enterprise If Z<0,2 – организация банкрот. 4. IGEA model R=8.38 * (290/300) + (form 2 190/490) + 0.054 * (form 2 010/300) + 0.63 * (form 2 190/(form 2 020+030+ 040+070+100+130)) If R< 0 – максимальная (90 – 100%) If R > 0 and R< 0,18 – Высокая (60 - 80%) If R > 0.18 and R< 0,32 – Средняя (35% - 50%) If R > 0.32 and R< 0,42 – Низкая (15% - 20%) If R > 0.42 – Minimum (up to 10%) Appendix 4. “Credit rating models”1. Indicators for assessing the financial condition of an enterprise as a borrower based on the “Regulations for the provision of loans to legal entities by Sberbank of Russia and its branches 285-R” K1=(260+253)/(690-640-650) K2=(260+250+240)/(690-640-650) K3=290/(690-640-650) K4=490/(590+690-640-650) K5=50 f.2/ 10 f.2 Then you need to define a category for each indicator depending on its actual value:
|
Carrying out an inventory
Ulyukaev, Navka and Patrushev
Income tax refund for treatment: registration procedure and calculation of the deduction amount
Import substitution - what is it?
OSAGO minimum insurance period