federal agency of Education
Russian State Trade and Economic University
GOU VPO RGTU Tula branch
Department of Economics and Finance
Subject: "Automated workplace"
Completed by a student Checked:
distance learning
based on SPO 2 courses, group II
Specialty: finance and credit
software creditworthiness financial
1.2 Programs of the "Intalev" series
1.5 Alt-Finance program
1.7 Program "OLYMP: FinExport"
2. Financial calculations
1. Financial analysis programs
To date, a number of software products have been created that are designed to perform a comprehensive assessment of the activities of an enterprise, identify the main trends in its development, calculate basic standards for planning and forecasting, and assess the creditworthiness of an enterprise.
Such programs include:, "Inek-Analytic", software products of the "Intalev" series (for example, "Intalev: Corporate Finance", "Intalev: Budget Management", "Intalev: Business Processes"), "Financial Analysis 3.0" " Investment Analysis 1.6", "Microsoft Project", "Alt-Finance", "Business Plan", "Marketing Analytic", "Commerce", "Analyzer", "Predictor", "Portfolio", etc.
Some programs, such as "INEK-Analyst" and "Financial Analysis", are made on the platform of the MS Excel program, which significantly expands the capabilities of an analyst using this program.
The use of these programs allows, if necessary, to change all the formulas and macros in the program at your discretion.
Other programs are implemented on the platform of one of the specialized accounting programs. So, the program "Intelev: Corporate Finance" is implemented on the platform of the program "1C: Enterprise 7.7" and is compatible with any accounting systems ("1C", "Parus", "BEST", "Comtech"), and for the successful use of the BEST programs -F" and "BEST-ANALYZE" will require Windows skills and accurate registration of all business transactions in the "BEST-4" system.
Consider the possibilities of some of the analysis programs financial condition enterprises in more detail.
1.1 Software package"INEK-Analyst"
Over the past decade, INEC has taken a leading position among analytical programs. This firm was the first to launch programs for the domestic market in 1990 economic analysis activities of enterprises, and today its developments are trusted by specialists from government controlled, large and medium industrial enterprises commercial banks, audit and consulting firms, educational institutions, insurance organizations.
The software complex "INEK-Analyst" is intended for assessing the financial and economic condition, developing, analyzing and evaluating business plans of enterprises and organizations involved in the production and provision of services.
The software product of the "Analyst" series solves the following main tasks:
Detailed analysis of the financial and economic condition of enterprises engaged in the production and provision of services;
Preparation, analysis and evaluation of enterprise development plans (investment project, business plan, feasibility study, financial recovery plan);
Consolidation (combination) of these enterprises and analysis of the combined option;
Comparison of actual and planned data of enterprises in terms of financial and economic indicators.
The program allows you to view the results of work in tabular, graphical and textual forms, as well as export them to MZ V/ora and Exce1.
Software products of the "Analyst" series ("INEK-AFSP", "INEK-ADP", "INEK-Analyst", "INEK-Holding", "Bank Analyst") differ in the range of tasks to be solved. The first of the programs contains a minimum set of calculations, each subsequent one, along with new functions, includes the capabilities of the previous one.
The INEK-AFSP program is designed to analyze the financial condition of enterprises and organizations of any type of activity based on balance sheet and report data.
The program "INEK-ADP" allows you to conduct a comprehensive financial and economic analysis of the activities of enterprises of any type of activity. The initial information for the analysis is the data of the external financial statements(balance sheet, income statement), as well as data on the structure of revenue, cost, receipts and expenditures.
The software complex "INEK-Analyst" solves the problems of a comprehensive financial and economic analysis, development, analysis and evaluation of the business plan of enterprises and organizations involved in the production and provision of services. "INEK-Analyst (T)" is intended for analysis and planning of activities trade organizations
The software complex "INEK-Holding" is intended for analysis, planning and comparison of enterprises of various types of activity.
The software complex "Bank Analyst" is intended for analysis, planning and comparison of enterprises of various types of activity.
The demo version of the program contains the following examples of enterprises and organizations:
JSC "Metallurg" (production) - plan and fact;
CJSC "Telecom" >> (services) - plan and fact;
holding "Prometheus" (holding, which combines the data of several enterprises).
A demo version of INEC-Analyst is available at www. inec. en
1.2 Programs of the "Intalev" series
The consulting and implementation company "Intalev" is engaged in setting up and automating control systems at enterprises. One of the activities of the company is the development of standard software products and methodological guidelines in the field of optimizing the enterprise management system.
Today, "Intalev" offers standard solutions in the field of budgeting, financial analysis, management accounting and management process, which are used in their work by hundreds of enterprises in Russia and the CIS.
Region financial management is currently the most relevant Russian enterprises. Experts in this field identify a number of tools, the use of which allows you to effectively manage the finances of the company and the company as a whole: budgeting (or budget management), management accounting, financial analysis.
A series of programs "Intalev" offers a number of specialized programs for analyzing the activities of the organization. "ITRP + Intalev: Production and Finance PROF" - The program is intended for integrated automation manufacturing enterprises of medium and large scale.
"Intalev: Leasing Management" is a comprehensive software to automate the management of leasing activities. It allows you to automate all stages of leasing management: planning leasing transactions, calculating payment schedules, budgeting cash flows and income and expenses of a leasing company.
"Intalev: Budget Management" version 3.0 is a program for automating budgeting for small and medium-sized enterprises, implemented on the platform "1C: Enterprise 7.7". Allows you to plan, take into account and analyze the financial and economic operations of the enterprise in a single information system. Characteristics of the program: visibility, ease of implementation and operation, versatility.
"Intalev: Corporate Finance" is a software product implemented on the platform "1C: Enterprise 7.7", designed to automate management accounting, budgeting, control and analysis in all areas economic activity enterprises. Focused on large retail and manufacturing enterprises including holdings. The program implements a system of customizable and expandable budgets, and it is also possible to keep records of several charts of accounts. The program has ample opportunities for financial analysis.
"Intalev: Corporate Finance" includes the following features: budgeting, management accounting, business design, forecasting, economic modeling, workflow, bookkeeping and other features of "1C: Enterprise 7.7".
The features of the program include: wide opportunities for managing the finances of enterprises in various industries, step by step guide for self-staging and budget management in the company, the possibility of business design (creating an enterprise model), the ability to describe the routes of information flow and automate information processes in the company, making long-term forecasts and economic models enterprise development. The program has special capabilities for automating planning, accounting and analysis for distributed holdings with heterogeneous types of business, the implementation of national and international standards planning, management accounting, analysis and control(all-Russian, GAAP, IAS, user) in a single database, no double data entry and special implementation support.
"Intalev; Financial Management" is a universal program for automating management accounting and financial management, compatible with any accounting systems ("1C", "Parus", "BEST", "Comtech", etc.) thanks to the import-export mechanism ha of information while maintaining the principle of one-time data entry into the system. It is characterized by holding accounting, the ability to evaluate performance various divisions companies. The goal of the "Intalev: Financial Management" program is to increase the efficiency of the management system, which allows the company to receive maximum profit with the available resources. This goal is achieved by automating the company's management accounting, built on the basis of budget management technology.
Let's list the features of the program:
· Preparation and control of budget execution Money, income and expenses, purchases, sales, production;
a wide range of reporting characterizing the state and dynamics of the company's performance indicators, including the use of the latest technologies(OLAP analysis);
· A customizable security system that limits the work of users only to their functional areas.
The features of the program include:
· the possibility of organizing joint work of the program with any accounting systems ("1C", "Parus", "BEST", "Comtech", etc.) due to the mechanism of import-export of information;
· preservation of the principle of single entry of data into the system; "holding accounting;
The ability to evaluate the performance of various departments of the company.
1.3 Programs for the analysis of business processes of the BEST series
One of the foundations of successful business management in a trading company is a comprehensive analysis of business processes. To solve this important task programs of the "BEST" series were created: "BEST-F", "BEST-ANALYSIS", etc.
For successful work with these programs, only Windows skills and accurate registration of all business transactions in the "BEST-4" system are required.
"BEST-F" is a financial analysis program designed to conduct a comprehensive analysis of the financial and property status of an enterprise. It is addressed to managers and financial directors of enterprises, as well as employees of audit and consulting firms. The program allows you to analyze the structure of property, solvency and financial stability of the enterprise, business activity and profitability of economic activities, the policy of attracting borrowed funds, the use of profits, analyze the business viability of banks and business partners. The program also allows you to analyze commercial activities, predict the state of stocks for subsequent procurement planning, compare the conditions of supplier firms and choose the most profitable partner, evaluate the work of distributors and sales departments, investigate factors affecting profits, and conduct a structural analysis of distribution costs.
The "BEST-F" program works in a Windows system, it is easy to learn and operate, does not require any special settings. The program can work in conjunction with "BEST-4".
"BEST-ANALYSIS" - information and analytical system for managers trading companies. With the help of this system, heads and managers of trading companies will be able to study the market situation, identify the main patterns and trends in demand, predict the course of sales, rationally use labor resources, warehouse and commercial premises. The program helps to optimize the work schedule of trade departments and regulate the timing and volume of purchases. The results of the analysis carried out can be used in the development of a turnover plan. Data analysis uses well-known statistical methods(mean, average smoothed, calculation of quadratic deviations, correlation curves, etc.).
The program will allow a financial specialist to analyze the turnover of the enterprise, structural divisions, nomenclature groups and goods, analysis of purchases, calculation of marginal and specific contribution margin, as well as analysis of changes in purchase and selling prices.
The program allows you to evaluate the management of commodity stocks: assessing turnover, identifying illiquid commodity items, calculating the number of turnovers by item, as well as conducting a study of the dynamics of commodity turnover by certain types goods, product groups, sales divisions and the enterprise as a whole.
"BEST-MARKETING" - a means of assessing the market position of the enterprise. The "BEST-Marketing" program is a convenient and effective tool that allows you to evaluate the market position of an enterprise in a competitive environment. The system is designed for the most common user who does not have a special education in the field of marketing.
The input of information is carried out in the form of natural self-evident assessments according to the principle "worse / better", "important / secondary". The entered qualitative data is converted by the system into quantitative data, which allows to carry out the corresponding calculations.
The program will help identify promising market niches, analyze the competitiveness of the product, advertising campaigns, will offer recommendations to improve their efficiency, stimulate sales. Program tools can also be used to comparative analysis own goods with analogues of competing firms, sales forecasting and the development of a consolidated budget.
1.4 Program "Financial Analysis"
The program "Financial analysis" allows you to determine the state of the enterprise in dynamics, to make a vertical and horizontal analysis of financial statements, taking into account inflation and without it, to calculate more than 50 financial ratios. It automatically compiles about 40 analytical tables, helps to predict the further development of the enterprise, avoid unpleasant relations with shareholders and counterparties who have access to the balance sheet.
The program "Financial Analysis" allows you to analyze not only new forms of reporting, but also to transform the old ones. "Financial analysis" allows you to determine the state of the equipment fleet and intangible assets at the enterprise, to analyze accounts payable and receivable, i.e. reveal the real value of debts of debtors. Using the program, it is possible to determine the real value of property and other balance sheet items in dynamics, since the program introduces the possibility of adjusting the value of property taking into account inflation.
"Financial analysis" version 3.0. calculates the break-even point, the effect of financial leverage and analyzes the creditworthiness of the enterprise according to various methods given in it. It predicts further changes in balance sheet items and analytical coefficients for the period ahead, allows you to view reports both in Russian and in English.
The demo version of the program "Financial Analysis" is available at www. financialis.ru
1.5 Alt-Finance program
A comprehensive assessment of the enterprise's activities, identification of the main trends in its development, calculation of basic standards for planning and forecasting, assessment of the enterprise's creditworthiness - these are the tasks that the Alt-Finance program solves.
The openness and adaptability of the software product "Alt-Finance" provide the user with the opportunity to independently make changes to the program, taking into account their requirements or specific conditions.
Using the data of the standard accounting reporting program "Alt-Finance" allows you to calculate financial indicators that characterize liquidity, solvency, turnover, financial stability, profitability and efficiency of use financial resources. The user also has the ability to perform financial analysis using both old and new accounting forms. With the help of a specially written macro, the financial statements are automatically transferred from the old to new format. The software product "Alt-Finance" uses the following main methods of analysis:
horizontal - trend analysis, in which indicators are compared with similar ones for other periods;
vertical - analysis, in which the structure of indicators is studied by gradually deepening and detailing;
Comparative - analysis in which the studied indicators are compared with similar industry averages or indicators of the main competitors.
In addition, the user has the opportunity to conduct a factor analysis of changes in the indicator of total liquidity, profitability equity and other indicators.
1.6 Project management program Microsoft Project
Microsoft Project is one of the most widely used project management systems in the world. In many Western Microsoft companies Project has become a familiar addition to Microsoft Office, even for ordinary employees who use it to schedule simple work packages.
The Microsoft Project program, due to its flexibility and accessibility, has become the de facto standard of the package. general purpose designed to work with projects of small and medium scale. It is a tool that allows you to efficiently manage projects with minimal cost time and money.
A project of five to ten stages (works), in which two or three performers are involved, is quite manageable with the help of notebook or organizer. However, projects with more than ten works already need serious management tools, and this program is the undisputed leader among them. The package is simple. The developers of the program did not seek to invest in it complex scheduling or resource planning algorithms. At the same time, much attention is paid to the use modern standards, allowing you to effectively integrate the package with other applications.
Microsoft Project makes it easy and organized group work with projects.
Setting up messages for the project team includes the ability to determine the composition of project data sent to project participants by e-mail, and setting restrictions on the correction of information sent by recipients.
The creation of a new project begins with the selection of a template supplied with the program or previously created by the user. Then you need to specify the basic information about the project in a special window. First of all, this, of course, is the start and end dates, as well as the way the project is tied to these dates. Next, you will work with the resources necessary to implement the project.
For quick inclusion in the work of a novice user, Microsoft Project provides, in addition to the usual means of assistance, the possibility of step-by-step project development and intellectual prompting.
Among the advantages of the package, it should be noted quite convenient and flexible reporting tools. The main types of reports can be selected from presets.
The ability to simultaneously have several plans for each project will improve the efficiency of the analysis on the principle of "what if ...". At the same time, Microsoft Project provides a minimal set of tools for planning and managing resources.
Additional features Microsoft Project includes import / export of data in various formats, macro recording tools, Visual Basic.
1.7 OLIMP: FinExport program
Another well-established firm developing targeted analytical software packages is Rosexpertiza. It offers a software product of the OLIMP series: OLIMP: FinExport - professional program analysis of the financial condition of the enterprise and the forecast of its development, the program uses the best domestic and foreign methods of financial analysis. It was created by specialists of the department of information technologies of the Rosexpertiza company, and is addressed to the management of enterprises, financial managers, analysts, employees of audit and consulting firms, credit and investment departments of banks.
The methodology of financial analysis implemented in the OLIMP: Fin Expert program uses data from external financial statements and is a synthesis of the best methods and techniques of domestic financial analysis (V.V. Kovalev, A.D. Sheremet) and Western methods adapted to domestic practice (E. N. Stoyanova, V.V. Kovalev). This is primarily the calculation of the effects of financial and operating leverage, widely used in foreign practice.
The OLIMP:FinExpert program also implements a multi-factor model of the DuPont corporation for calculating the key financial and economic indicators of an enterprise's development: return on net assets (RONA), economic growth company (SG), weighted average cost of capital (WACC). Factor analysis allows you to find the root causes of changes in these resulting indicators.
The original method of comparing the financial condition of enterprises and ranking enterprises by the value of the integral indicator, implemented in the program, allows for an effective comparison of enterprises. An important advantage of the methodology incorporated in the OLIMP: FinExpert program is the possibility of mathematical and statistical forecasting of the balance and modeling the consequences management decisions.
The program works in the following modes:
Verification of reporting;
Express analysis;
Full analysis;
Methodology federal government on bankruptcy;
DuPont's multivariate model for profitability and growth analysis;
Comparison and ranking of enterprises according to complex financial indicators;
Modeling and forecasting the financial condition of the enterprise.
The analyzed data are balance sheet data (form No. 1), income statement (form No. 2), cash flow statement (form No. 4) and other forms of external reporting. The main advantages and benefits of the OLIMP: FinExpert program are as follows:
Conducts a complete and detailed analysis of all sections of financial analysis, calculates more than 100 financial and economic parameters and ratios;
Provides detailed financial and economic information support for all sections, tables, financial and economic indicators, contains over 300 information blocks;
Automatically formulates the results of the analysis, generates conclusions on the analysis and expert assessments of the financial condition of the enterprise;
Conducts a detailed analysis of the effects of financial and operating leverage, which allows you to assess the degree of total production and financial risk;
Allows you to clean up data from inflationary distortion and analyze the dynamics of the balance sheet in comparable prices;
It makes it possible to predict the financial condition of the enterprise;
Imports accounting data from text, DBF and Excel files;
Its professional version allows the user to change the formulas for calculating indicators, create new analytical tables, implement their own methods of financial analysis in the program;
Implemented under Windows in the Exce1 environment, which allows using the technological and graphic capabilities of this environment.
Task 2. Run financial calculations With using Excel:
Option 1.
1. Using the BZ(BS) function.
BS (C4/C3; C3*C5; ; -C2)
2. Use of the BZDIST function.
For a bond with a par value of 200 thousand rubles, issued for six years, the following procedure for calculating interest is provided: the first year 15%, the next two 20%, the remaining three years 25%. Calculate the future (accumulated) value of a bond at a compound interest rate.
BZDIST (B2; B3:B8)
3. Using the PZ(PS) function
The company will need 800 thousand rubles. after 11 years. Determine the amount of a single current deposit that must be put on deposit if the interest rate on it is 14% per year = PS (B4 / B5; B3 * B5; ; + B2)
4. Using the function of the refinery(NPV).
Investments in the project by the end of 1 year of its implementation will amount to 10,000 rubles. In the next three years, annual incomes for the project are expected to be 2000, 4500 and 6500 rubles. The cost of raising capital 8%. Calculate the net present value of the project = NPV(B1/B6; B3:B5)
5. Using the CLEAR function.
Investment in the amount of 12 million rubles. dated July 1, 1998, will bring income: 2550 thousand rubles. September 15, 1998, 4750 thousand rubles November 1, 1998, 5350 thousand rubles January 1, 1999 Discount rate 9%. Determine the net present value of the investment as of July 1, 1998 to July 1, 1997.
| | | |
|||
| | | |
|||
| CLEAR (B4; A3: E3; A2: E2) |
|||||
| CLEAR (B4; B3:E3; B2:E2) |
|||||
6. Using the NPER function.
NPER (B4/B5; ; -B3; B2) = n (B8/B5)
7. Using the PPL(PMT) function.
It is required to accumulate 5000 thousand rubles. over three years, a fixed amount is set aside at the end of the month. What should this amount be if the interest rate is 14% per annum
PMT (B5/B4; B4*B3; ; B2)
8. Using the function PLPROC(PRPLT).
Calculate the interest payments for the first month from a four-year loan of 900 thousand rubles. at the rate of 12% per annum.
PRPLT (B3/B5; 1; B5*B4; B2)
| interest payment |
9. Using the GENERAL PAY function.
Loan for real estate is made on the following terms: interest rate 11% per annum; term 25 years, loan amount 150 thousand rubles, interest is calculated monthly. Find the amount of interest payments for the second year and the first month of the loan.
1= (B2/B4; B4*B3; B5; 13; 24; 0)
2= (B2/B4; B4*B3; B5; 1; 1; 0)
10. Using the TOTAL INCOME function.
A loan of 1,000 thousand rubles was issued. For a period of five years at 12% per annum; interest is calculated quarterly. Determine the amount of basic payments for the fourth year.
TOTAL INCOME (B4 / B5; B5 * B3; B2; 13; 16; 0)
| Size payout for 4 years |
Bibliography
1) Fedorova G.V. " Information Technology accounting, analysis and audit": textbook / G.V. Fedorova, - 2nd ed. financial education)
2) Mikheeva E.V. "Information Technology in professional activity economist and accountant ": textbook for students. secondary vocational education / E.V. Mikheeva, O.I. Titova - 2nd ed. ster. - M .: Publishing house "Academy", 2006-208 With.
Tutoring
Need help learning a topic?
Our experts will advise or provide tutoring services on topics of interest to you.
Submit an application indicating the topic right now to find out about the possibility of obtaining a consultation.
- FinEcAnalysis- a powerful tool that implements several dozen different techniques financial analysis, financial management, management evaluation and forecasting. According to financial statements for several periods, the program creates reports with conclusions, tables and graphs, calculates a large number of financial ratios.
Our company has been developing automated systems for financial analysis since 1997. Many years of experience of our specialists has been embodied in latest version programs for financial analysis - FinEkAnalysis 2020.
Purpose of the program
The main goal of the program is to make the financial analysis organizations efficient, convenient and operational, including in the conditions of limited time.
Tasks to be solved
You can use the developed system for:
- constant monthly, quarterly or annual monitoring financial condition of enterprises;
- development of forecast balances and forecast financial results;
- holding express analysis of the financial condition enterprises in a short time;
- preparation of analytical notes for financial statements;
- preparation of analytical materials for meetings of shareholders, members of labor collectives;
- development of health programs financial condition (reorganization) of enterprises for arbitration managers;
- conducting an analysis of the arbitration manager in order to improve the financial condition (reorganization) of enterprises or submit analytical materials to the court and others interested persons;
- development of a strategy for the development of the organization in the medium and long term;
- conducting regulated analyzes in accordance with regulations regulatory agencies;
- holding financial analysis during the audit;
- determine possible options further development enterprises by compiling a matrix of financial strategies.
Who is the program for?
Program for financial analysis- FinEcAnalysis - saves time, improves the quality of financial and economic analysis of organizations and makes it comprehensive. This indispensable assistant For auditor, economist, financier, accountant and arbitration manager, employees of regional and municipal administrations.
Regulated financial analysis Audit Expert provides an opportunity to conduct financial analysis in accordance with methods, indicators, structure and form of reports which are regulated by various regulatory documents.
It is enough to choose the method you need and enter the initial data of the Balance Sheet and Profit and Loss Statement. You automatically receive during the calculation: analytical tables financial indicators, as well as ready-to-report graphs and charts for each analytical table. For a number of regulated methods, expert opinions are automatically generated.
Methodology for estimating the value of net assets. Order of the Ministry of Finance of the Russian Federation dated August 5, 1996 No. 71 “On the procedure for assessing the value of net assets joint-stock companies". Order of the Ministry of Finance of the Russian Federation No. 10n and Order of the Federal Market Commission valuable papers No. 03-6/pz dated January 29, 2003 "On approval of the procedure for assessing the value of net assets of joint-stock companies"
Methodology for calculating the financial performance of the organization. Order of the Ministry of Economic Development of the Russian Federation and the Federal Financial Federal Service of the Russian Federation of June 28, 2001 No. 211, 295 “On the Application of the Government Decree Russian Federation dated September 3, 1999 No. 1002"
Reporting of heads of SUE. Decree of the Government of the Russian Federation of October 4, 1999 No. 1116 “On approval of the reporting procedure for heads of federal state unitary enterprises and representatives of the Russian Federation in the management bodies of open joint-stock companies”.
Analysis according to the FSFR guidelines. Order of the FSFR of the Russian Federation dated January 23, 2001 No. 16 “On Approval” Guidelines on the analysis of the financial condition of organizations"
Signs of fictitious or deliberate bankruptcy. Decree of the Federal Tax Service of the Russian Federation dated October 8, 1999 N 33-r “On methodological recommendations for conducting an examination on the presence (absence) of an enterprise of signs of fictitious or deliberate bankruptcy”
Conducting financial analysis by the arbitration manager. Decree of the Government of the Russian Federation of June 25, 2003 No. 367 “On Approval of the Rules for Conducting a Financial Analysis by Arbitrators”
Assessment of the financial position of the founders of credit organizations. Regulation of the Central Bank of the Russian Federation of March 19, 2003 No. 218-P “On the procedure and criteria for assessing the financial situation legal entities founders (participants) of credit institutions"
Indicators of the financial condition of agricultural producers. Decree of the Government of the Russian Federation of January 30, 2003 N 52 "On the implementation of the Federal Law "On the financial rehabilitation of agricultural producers"
Determining the level of materiality
Earlier, the program implemented the now canceled order of the local government department and the decree of the Government of Moscow that was removed from control:
Evaluation of FCD GUP "s. Order of the Ministry of Property of the Russian Federation dated May 26, 2000 No. 9-r "On Approval of the Approximate Terms of Reference for an Audit of a Federal State Unitary Enterprise".
Complex analysis. Decree of the Government of Moscow dated October 6, 1998 No. 763 “On the procedure for conducting ongoing monitoring and audits of the activities of business entities that have authorized capital share of the city of Moscow.
However, in the course of work, you can use the coefficients and methods introduced by them. It is especially convenient to use such methods for state unitary enterprises and joint-stock companies.
Your financial analyst - is a system of intellectual analysis of the financial condition of the organization according to the financial statements.
The main feature of the system is the complete exclusion of your participation in the analytical process. You enter data and receive a report based on the results of the analysis, which is no different from that compiled by a professional analyst! This is the main difference from most financial programs (see other differences).
Key features of the program:
The program does not require knowledge of financial analysis
Produces a holistic analytical report
The program not only calculates more than 40 financial indicators, but also generates an analytical report complete in form and content with a description of the obtained values, their characteristics and conclusions. You do not have to guess whether the financial condition of the enterprise is good or bad, looking at a lot of tables and graphs - the program will draw a final conclusion and give an unambiguous answer using our unique methodology. The program has the following reports:
Report Standard
fin. reportingReport language Complete financial analysis The report covers almost all indicators that can be calculated according to the main forms of Russian financial statements.
RAS example Complete financial analysis of statements prepared in accordance with IFRS or US GAAP IFRS, US GAAP Explanatory note to the financial statements Section of the explanatory note to the financial statements containing the main financial indicators (abbreviated version of the full report).
RAS example Estimating the value of the organization Report on the valuation of the company based on financial statements. Includes financial analysis and valuation by two methods: the net asset method and the method of discounting future income.
RAS example Financial analysis of the debtor Analytical report in accordance with the Rules for conducting a financial analysis by an arbitration manager (approved by Decree of the Government of the Russian Federation of June 25, 2003 N 367).
RAS example Tips for improving your financial condition Unlike conventional analytical reports, which only state financial position organizations, this report provides advice on how to improve it.
RAS example Certificate of financial condition A unique, counterfeit-proof certificate confirming the financial condition rating assigned to the organization (see).
RAS, IFRS Grade An analysis of the factors by which an organization may arouse increased interest from the tax authorities (in accordance with the Order of the Federal tax service N MM-3-06/ [email protected]).
RAS,
tax. reportingexample Audit report new! Audit report based on the results of verification of compliance of key financial indicators with the principle of business continuity of the organization.
RAS example No training required
To work with the program does not require prior training. Don't waste time and money learning how to use the program, just run it and work!
Convenient information entry
The data is entered in the form in which they are presented in the financial statements, without the need for any recalculations. Information can be entered either manually or downloaded from XML files in which reporting is submitted in tax authorities(most accounting programs can save data in this form).
For the convenience of data entry, data conversion from the Russian reporting form to the IFRS format is provided (not a full-fledged transformation), as well as loading consolidated reporting forms (line-by-line summation).
new! The program added the ability to connect to the Internet database. The database was formed on the basis of public data from Rosstat and contains more than 2.3 million firms in Russia. It is enough to enter the TIN of the company and its reporting will be loaded into the program, saving you from manually entering numbers for several years.
Multiple descriptions
The program repeats the work of a person in terms of text comments to indicators. Multivariant text makes each report unique.
Various options for using the program
The program has a simple and convenient web interface and is available both as a subscription to work on our website (online) and as a distribution kit installed on the user's computer. In the second option, the Internet is not required to work with the program. See comparison of options.
Analysis of indicators in dynamics
You can get an analysis of both one period and several periods in dynamics (by years, half-years, quarters or months).
Flexible approach to the formation of tables
When analyzing a large number data, you do not have to glue sheets with wide tables. The program can "reduce" the columns, finding a compromise between the completeness of displaying information and the width of the tables.
Thus, the table will fit in width on a standard printed sheet, without significantly losing information content.
Color highlighting results
Color is used in the report not only to show positive and negative values, but to indicate the quality of indicators (good/bad value).
Automatic generation of intra-company order
The program allows in one click to receive an intra-company order that regulates the methodology of financial analysis, which is necessary document For large companies and banks.
Information can be saved to a file or database
Information can be stored both in the program database and in separate files on the user's computer, which additionally guarantees data confidentiality.
Additional features for professionals
If you are a professional in the field of financial analysis, you can easily customize the program based on your own needs:
- change or add a formula;
- change the ranges of the qualitative characteristic of the indicator (ie the interval of "good-bad" values), including by industry;
- change the report template by adding your own tables, graphs, descriptions of indicators.
The program takes into account all the changes made, while retaining the ability to form descriptions and draw conclusions.
Analysis probabilities of a tax audit
The program is supplemented with an analysis module probabilities of a tax audit in accordance with the Order of the Federal Tax Service dated May 30, 2007 N MM-3-06 / [email protected](taking into account the changes made by the Order of the Federal Tax Service of October 14, 2008 N MM-3-2 / [email protected] and Order of the Federal Tax Service of September 22, 2010 N MMV-7-2 / [email protected]); see example
We bring to your attention a unique multifunctional and easy-to-use software - automated system integrated financial, economic and management analysis economic activity of the enterprise.
The program of financial analysis - FinEkAnalysis allows you to solve a wide range of financial tasks, accelerates and improves the quality of the analysis of the financial condition of the enterprise and makes it comprehensive. This is an indispensable assistant for an economist, financial specialist, accountant and arbitration manager.
With the help of the program, an analysis of the financial condition of enterprises and an analysis of economic activity is carried out.
Based on the financial statements, the program generates analytical text reports along with visual graphs and recommendations to improve the financial condition.
Opportunities of the program of financial and economic analysis
Using the system FinEkAnalysis 2011 you can:
Quickly conduct a financial analysis of the state of the enterprise
- Effectively manage capital, receivables and working capital
- Build financial models your enterprise
- Increase balance sheet liquidity and profitability
- Improve the financial condition of your company
- save financial resources your organization
The simple and convenient interface of the Financial Analysis - FinEkAnalysis program favorably distinguishes it from other similar packages, which is noted by most users. An important feature program is the openness of the used economic calculations to users.
You can learn more about the capabilities of the application by running it in demo mode. To do this, enough businesses and install on your computer.
Who is the program for?
The Financial Analysis - FinEkAnalysis program is used by:
- departments, departments of economics and finance of regional (regional and regional), district and municipal administrations for monitoring the financial condition of budget-forming enterprises, forecasting tax collection, detection of tax evasion and cases of intentional bankruptcy (presentation for administrations);
- enterprises of various industries, all forms of ownership and organizational structures– for financial and economic analysis, selection financial strategy enterprises, receivables management, determination of methods that ensure the financial stability of the enterprise;
- audit firms - to improve the efficiency and quality of analysis of the financial and economic activities of enterprises, including federal state unitary enterprises (presentation for auditors);
- consulting firms - to assess the business, develop a strategy for the financial and economic activities of enterprises, including for better development of business plans;
- banks - to determine the feasibility of lending to enterprises on a repayable basis and targeted investment in enterprises; investment companies- to assess the degree of investment attractiveness of enterprises;
- investment companies - to assess the degree of investment attractiveness of enterprises;
- insurance organizations - to determine the level of risk of insurance of assets of enterprises;
- arbitration managers and regional bodies for bankruptcy and financial recovery - to determine the likelihood of bankruptcy, develop programs for the financial recovery (sanation) of enterprises;
- students of economic specialties - to study financial analysis in universities, complete coursework and theses(presentation for universities and students).
Financial analysis for a financier:
If your responsibilities include:
Rationale financial plan, as well as business plans for certain areas;
- analysis of the company's assets and sources of their financing;
- control over the efficiency of the use of financial resources;
- development of a policy of relations with creditors and debtors;
- elimination of cash gaps;
- increasing the efficiency of interaction with banks on lending to current activities;
- calculation of the volume of required financial resources and the choice of their form;
- minimization of costs associated with attracting financial resources
