Recommendation System Development for Potential Factoring Service Customer Identification
Development of an algorithm for identifying potential clients of factoring services based on information from databases of Russian banks. Its implementation in the VBA programming language. Recommendations for improving the efficiency of sales staff.
Рубрика | Программирование, компьютеры и кибернетика |
Вид | дипломная работа |
Язык | английский |
Дата добавления | 01.12.2019 |
Размер файла | 1,6 M |
Отправить свою хорошую работу в базу знаний просто. Используйте форму, расположенную ниже
Студенты, аспиранты, молодые ученые, использующие базу знаний в своей учебе и работе, будут вам очень благодарны.
Размещено на http://www.allbest.ru/
Размещено на http://www.allbest.ru/
Recommendation System Development for Potential Factoring Service Customer Identification
Abstract
algorithm factoring service
Today, an extremely urgent problem is Big Data handling, namely the processing and monetization of information accumulated by banks and other financial institutions over the past decades. The business goal of this work is due precisely to this tendency. The business goal is to create a recommendation system for potential factoring service customer identification on the basis of the information contained in the databases of the largest Russian banks.
To achieve this goal, the financial statements of many companies from different industries and market segments were analyzed, which resulted in the identification of key economic indicators that most accurately reflect the client's need for factoring. The results formed the basis for building a recommendation system, which allowed to increase the efficiency of sales staff by 20% or more percent.
The algorithm is implemented in a simple and extremely common programming language VBA, which is used in freely distributed open source software, thus providing a competitive advantage over existing solutions on the market and can be easily translated into another programming language.
Keywords: factoring, recommendation systems, IFRS, cluster.
Introduction
High technology develops from year to year. The banking sector is no exception. Under the influence of financial institutions, namely banks, which are deeply connected with many sectors of the economy, there is a money turnover in the country and the world.
This work is focused on factoring, a specific and, to some extent, new financial instrument for the Russian market.
First of all, it is necessary to determine what the term factoring means and what trends and problems the Russian factoring market has faced.
Factoring is a financial service of a specialized company or bank. In general terms, factoring is used as follows: the supplier sells the product to the buyer, without requiring immediate payment for it. A specialized factoring company or bank pays the seller for the buyer of this product, after which it receives a debt from the buyer of the product.
Thus, by concluding a factoring agreement, the seller has the opportunity to sell the goods with payment deferral, usually up to 180 days, and at the same time to receive payment with a certain discount from the factoring company or bank immediately, assigning it the right to claim the debt for the delivered products.
Initially, factoring is used in international trade, since work on the international market obviously carries more risks. It is much more difficult for the manufacturer (supplier) to evaluate its potential counterparties (buyers), their reliability and financial sustainability. In such cases, when providing factoring services, banks and other financial institutions also realized a kind of insurance, as they knew the local market and had more detailed information about the state of the local economy. Currently, the factoring service is offered on the domestic market by such companies and banks as VTB Factoring, Sberbank Factoring, Gazprombank, Metallinvestbank, SMP Bank, NOMOS Bank and others. According to the results of 2010, for example, the turnover of Gazprombank on factoring operations amounted to 18.5 billion rubles. The distribution of factoring services began with the growth of the number of companies and with the development of the internal trading network within the Russian Federation. The larger and more extensive the trading network, the more difficult it is for suppliers to correctly assess its potential and notice new trends in the economy and trade.
The relevance of this work is confirmed by the realities of the banking business and modern trends in working with Big Data. Practically all business giants, whether in the FMCG sector, the oil and gas industry or financial institutions and funds, have been accumulating data on their customers, market performance and the global economy for decades. However, how to navigate in such huge amounts of information and most importantly, how to use this information for commercial purposes?
That is why the second integral part of this work is the process of developing a recommendation system. The work will present an algorithm of actions that will allow to process efficiently large amounts of data of the bank customers, both economically and programmatically.
1.Work's scientific value
Recommendation system is a program which gives recommendations based on the data about the user and the item. In this work, the user is a sales person, and the item is a company.
Such system includes the whole process -- from receiving information to presenting it to the user.
Every stage is important. The information you collect will determine which algorithms you can apply. Good algorithms give good, useful recommendations. Criteria for the evaluation of the results allow you to choose the most suitable algorithms. However, none of this will work unless you properly present and explain the advice to the user.
This work has a certain degree of uniqueness and there are several reasons for that. First, the Russian factoring market is very young, and not all Russian companies are aware of the very fact of existence of such financial service.
Chart 1 Chart 2
Let us consider, for example, the segment of small and medium-sized enterprises (SMEs) on chart 1. According to the website bankir.ru of 03/15/2017, more than 2 million small and medium-sized enterprises, including sole proprietors, are registered in Russia. However, only 6 thousand of them use factoring services, which is less than one percent.
Typically, the extent of a financial service is measured by such indicator as the market share of that financial product in GDP. The share of factoring in GDP has been growing steadily since 2009 and reached 2.3% in 2012. On this basis, the Russian market can be called developing, since in developed European countries this figure can reach 10%, and in Eastern Europe - 5-7%. Thus, there is a great potential for the development of factoring in our country. Small and medium-sized enterprises account for a quarter of the total volume [8].
The composition of the Russian factoring market has not changed significantly over the past year. The most active are still about 35-40 factoring companies and banks. Most market participants are banks (seven out of ten market leaders). A sharp increase in the number of market participants is unlikely in the near future.
Let us consider the main factors that made the high growth rate of factoring in our country possible. Statistics show that the market is developing quantitatively due to the growth of factoring services without recourse (with the protection of the client from credit risk, i.e. the risk of non-payment of the buyer) and the increase in the number of transactions with large buyers.
This is primarily due to the expansion of the market leader - VTB Factoring, which actively offers factoring services to major corporate clients of VTB Group. In addition, other major banks, such as Promsvyazbank, Alfa-Bank and Petrocommerz, are the leaders of the factoring market. These players are focused on working with large customers and are ready to offer them a product such as factoring without recourse.
It is worth noting a number of events that indicate the qualitative growth of the market. This is primarily the development of electronic factoring technology.
In addition, in 2012, we saw the first example of real cooperation of factors in customer service. Promsvyazbank and the National Factoring Company (NFC) implemented a joint transaction when the first factor provided financing to the client, and the second provided protection against the risk of non-payment of the buyer.
In addition, the same NFC actively offers banks and other factors joint products, such as syndicated factoring (when the bank attracts a client and can provide funding for the transaction, and NFC provides a full range of factoring services: evaluation and analysis of buyers, management of receivables, debt collection, surety for the buyer).
Another driver of market development is the improvement of market infrastructure. Last year, electronic factoring began to develop actively. Amendments to the Law on Electronic Digital Signature were adopted, which allowed launching electronic factoring with a legally significant electronic digital signature. This technology allows the use of fully paperless electronic document circulation.
The supplier and the buyer can sign a contract with the certification authority, which is the guarantor of the authenticity of the electronic digital signature. After that, the whole process of document exchange within the framework of factoring transaction takes place remotely and is confirmed by electronic digital signature.
The supplier certifies the invoice with information about the delivered goods, the buyer confirms the acceptance of the goods. The supplier transfers to the factor a signed registry of monetary claims for funding. The factor checks it and confirms the electronic digital signature.
Due to the use of electronic factoring, suppliers and buyers receive a number of advantages: a significant reduction of the document circulation period, cost savings and information protection. The client has the opportunity to receive funding within a few hours after the physical delivery of the goods.
In addition, it saves a significant amount of money on the delivery of documents to the factor, stamp producing, drawing up of paper documents and its storage (and the set of documents for each delivery may consist of several items). Another advantage of electronic factoring is the legal protection of signatures. The certifying center confirms its authenticity, which can further serve as proof of the rightness of the factor in court.
Electronic factoring as a technology can be successfully applied to any product: factoring with recourse, non-recourse factoring, reverse factoring, guarantee factoring.
As for the product line of Russian factors, the main product on the market is traditionally factoring with recourse (almost 67% of the market in 2012). The share of non-recourse factoring accounts for 32%, international factoring accounts for about 1% of operations.
The volume of international factoring operations is constantly increasing, which is facilitated by the intensification of Russia's foreign trade turnover. In particular, the creation of a Single Economic Space with Belarus and Kazakhstan will allow to actively develop factoring operations for export/import from/to these countries.
Currently, only eight players offer this type of factoring in Russia. For the successful development of export and import factoring it is necessary to cooperate closely with international factoring associations (IFG and FCI), which provide the infrastructure for cooperation of factors from different countries.
Despite certain difficulties in the development of the market, factoring has great potential, which allows to predict the continuation of growth rates at the level of 15-20% in 2018. A number of factors are lobbying for changes in public procurement legislation so that factoring and changes regarding deliveries to state structures could be applied on clear legal grounds.
If these gaps in the legislation are eliminated, it will give the market an additional 30 or even more percent growth. In the usual situation, new products, the penetration of factoring into new industries and regions will remain the main drivers of growths.
Moreover, historically, factoring transactions in the segment of state-guaranteed order were practically inaccessible due to the lack of regulated rules in the regulatory enactment, according to which the company-contractor of state-guaranteed order could assign receivables of the state body. According to the "Law on Public Procurement", the change of supplier is not allowed under state contracts, which actually means a ban on factoring in the field of public procurement. Only in 2018, the factoring community together with entrepreneurs initiated appropriate amendments to the legal acts, which were approved by a number of ministries [4].
Now, the use of factoring in procurement is also extremely rare. The reason for the unpopularity is, first of all, the lack of clear regulation of this procedure and contradictory law enforcement practice. Although there is no direct prohibition in the legislation on the contract system for the assignment of rights of claim under government contracts, in practice, the customer may have problems at the stage of transfer of funds to the account of the financial agent. To make such payment, it is necessary to make changes to the contract in terms of the name and bank details of the recipient of funds, but because of the rules of paragraph 5 of article 95 and paragraph 2 of article 34 of the “Law on the Contract System” the cases of introducing changes to the contract concluded at the end of the tender are strictly limited. The current edition of paragraph 7 of article 448 of the Civil Code of the Russian Federation is an additional obstacle. According to it, there is a ban on the transfer of obligations from the contractor to third parties under contracts concluded on the basis of tender. The new edition clarifies that this restriction does not apply to monetary obligations. This amendment appears to be the first step to simplify the use of factoring in procurement.
The opinions of public authorities on the use of factoring in public procurement are different. Thus, the Ministry of Finance of Russia is of the opinion that, in accordance with the budget legislation, factoring under the state or municipal contract is not allowed (Letter № 02-02-04/13740 of March 11, 2016) [4].
The Federal Antimonopoly Service of Russia and the Ministry of Economic Development of the Russian Federation adhere to the opposite opinion. In accordance with the clarifications of the FAS (Letter № AD/38430/13 of October 2, 2013), the law does not prohibit the assignment of a monetary claim in public procurement [4].
Judicial arbitration practice has recently tended to the fact that factoring on government contracts does not contradict the current legislation.
The following risks can be identified for the customer:
Ш non-receipt from the bodies of the Federal Treasury of authorization of payment on details of the factor;
Ш payment to the improper person if the monetary claim is assigned several times;
Ш non-return of paid funds upon detection of defects of goods, works, services. In accordance with the new edition of article 833 of the Civil Code of the Russian Federation, in case of a supplier's failure to fulfill its obligations under the contract the customer will be able to make a claim to return the money only to the supplier, but not to the financial agent;
All these events once again confirm the fact that the Russian factoring market is at the stage of formation.
Secondly, the construction of a high-quality recommendation system, especially for such specific product, is simply impossible without access to private banking data. In other words, such system can be built only by a person working within the system and having access rights to customer databases.
Unfortunately, despite the serious efforts of banks to update and develop their IT platforms, the main forces are still focused on the development of platforms for servicing individuals and classic credit products. As a result, such areas as leasing or factoring are left out of modern IT approaches for processing, storing and using data.
The building of a recommendation system for internal use by employees of a factoring company would also not be possible without modern IT architectures for Big Data processing. Technical limitations in computing and resource power were a stop factor that prevented implementation of such ideas and algorithms 5-10 years ago [1]. To confirm this conclusion, it is enough to look at the chart MIPS (million instructions per second):
Chart 3 The computing power of modern computers has more than doubled in the last 8 years [1].
2.Theory background and market research
The measured factoring portfolio of the Russian factoring market as of April 1, 2019 amounted to about 521 billion rubles. The collection of statistical indicators of Russian factors was made on the basis of the Association of Factoring Companies data. 29 organizations took part in the survey, of which 14 were banks, 9 were factoring companies, 9 were groups uniting a bank and a company. According to the results of the received questionnaires, the measured factoring portfolio of the market, reflecting the volume of credit risk that factors accepted under factoring agreements, amounted to 521.5 billion rubles as of April 1, 2019.
Growth of the measured factoring portfolio by 36% from year to year. From January to April 2019, the measured total factoring portfolio of the market decreased by 90 billion rubles (-15%), including due to the disposal of open data by Raiffeisenbank and Capital Factoring. However, from year to year growth amounted to 137 billion rubles (+36%). The average turnover of the portfolio, according to the questionnaires, was 67 days with a minimum of 37 days and a maximum of 107 days [2].
Credit risk without recourse is 68% of the measured market portfolio as of April 1, 2019. In the measured market portfolio during the first quarter of 2019, the share of assets under non-recourse contracts has not changed fundamentally and is 68% (a year ago - 58%), as well as the share of assets with recourse, which amounted to 30.5% (a year ago - 41.3%), the share of international operations increased to 1.1% (eight organizations, including a new participant, Bank Vozrozhdenie, provided non-zero indicators).
The amount of funding paid in January-March 2019 amounted to 614 billion rubles. Russian factors financed trade turnover in the amount of more than 614 billion rubles, which is 131 billion rubles more than in the same period last year (+27%). In the structure of the paid funding, the share of transactions without recourse amounted to 66.6%, with recourse - 26.7%, the share of international funding increased from 0.14% to 0.5% for the year.
The customer base is growing, the number of debtors continues to reduce. The number of active (funded) customers, according to the questionnaires of factors for the first quarter of 2019 amounted to 5.4 thousand companies (760 companies were attracted), the number of active debtors - 6.8 thousand (including 707 new ones). From year to year, the number of customers increased by 39% (+1.5 thousand), the number of debtors decreased by 294 companies (-4%). Also, compared to last year, the questionnaires reflect the positive dynamics of attracting new customers (it doubled) and debtors (+44%) [5].
Over 2.5 million deliveries were transferred to factoring. In January-March 2019, 2 507 204 deliveries were transferred to factoring, which is 4% more than in the same period last year. The average cost of the financed delivery increased over the year from 199.7 thousand rubles to 245 thousand rubles in the first quarter of 2019 [2].
The income of factors for the 1st quarter of 2019 amounted to 11.8 billion rubles. At the end of January-March 2019, the factors reported receiving 11 886 million rubles in the form of commissions and other types of income (excluding VAT). Income data were provided by 15 organizations. From year to year, income increased by 41%, with almost half of it accounted for the market leader - VTB Factoring.
Plans are fulfilled, risks are constant. In the answers to additional questions of the questionnaire (ten respondents), the level of competition on a 5-point scale in the 1st quarter of 2019 was estimated at 3.5 points on average. 20% of the respondents reported over-fulfillment of quarterly plans, 40% - the implementation, and 40% are not satisfied with the results. The number of cases of fraud and realized risks in the 1st quarter of 2019 has not changed.
Chart 4
Chart 5
Since further research will be conducted on the basis of Sberbank's customer base, its factoring portfolio will be considered in more detail.
3.Task definition
Despite the fact that Sberbank holds the second place in terms of the value of the portfolio, the profitability of Sberbank from factoring services is significantly lower than its competitors'. This indicates that the main priority of the bank is to increase the market share, while maintaining the current rates and this is done in order to gain a firm foothold in the Russian factoring market.
The peculiarity of the Sberbank factoring business model is that the parent company PJSC Sberbank already has a huge database of customers, millions of companies, and the majority of customers who apply for factoring services have previously been served or are now served in Sberbank.
Based on this, the need for the formation of the customer base disappears. However, such a huge amount of data creates another kind of problem - the problem of technical development of the database. In other words, what is the point of having a multi-million base of potential customers, if it is impossible to determine the client's need for a particular financial service in time and offer it to the client.
The problem described above is very similar to the problem of choosing a movie in an online store or a book in an online library. To be more precise, modern online services such as iTunes, Netflix, Amazon have such rich product range that without a "wise" recommendation system, the search for the right movie, book or any other product can take a huge amount of time. As a result, if the customer could not quickly find the product he was looking for, it is highly likely that the customer will simply switch his attention to something else or turn to the service of a competitor.
Now we are very close to the next stage of our research, which is quite strongly correlated with the title of this work: "Recommendation System Development for Potential Factoring Service Customer Identification."
Recommendation systems have been one of the most well-known, easily monetized and replicated applications of artificial intelligence systems for several decades.
Many have heard the story of the recommendation system in the supermarket, which, based on the shopping list, understood that a young girl was pregnant, and began to send the advertisements of diapers before her parents found out about the pregnancy...
Ten years ago, a famous competition organized by Netflix for movie recommendations led to new models and major breakthroughs in recommendation systems. The market of such systems has since increased more than tenfold, and since then research, new ideas and models have been increasing, and the market continues to grow. But first, let's look at what is a recommendation system.
In the supermarket the recommendation system draws conclusions concerning what else can be offered to you in a way that will encourage you to buy it. The recommendation system draws conclusions on the basis of your behavior in the store, how often you go there, what is your route through the store, which counters with goods you pass by, what are you interested in, what you look at, everything you touch and buy. The aim of the system is to sell you more; ideally, it works absolutely magically: you've just thought about something, and there is a discount on the necessary product right in front of you just in time. In general, the aim of the recommendation system is to help the business to sell more by means of timely recommendations to the client in the right place, at the right time and through the right communication channel.
However, there are two harmful stereotypes that still prevent the wider use of recommendation systems and other similar models and methods. Firstly, in the minds of both the general public and businessmen, recommendation systems are still associated more with "entertainment" applications. For business, "recommendation systems" is something about Netflix, IMDB, last. fm, Pandora... O'f course, you can also recommend products in supermarkets and online stores -- Amazon is also at the forefront, but that's all. Secondly, it seems to many that even if theoretically a recommendation system could be useful, in reality it is too difficult, abstruse and requires a complete restructuring of the entire process of data collection and processing, as well as changes in business processes, logistics and inventory management principles, and not many people are ready to go for it. Businessmen who have gone further, can not understand what the ROI is from investing in such stories (considering the transformation of the business model), and therefore also refrain from investing so far, reading in the media and social networks stories about how well it turned out for someone. We will try to dispel these stereotypes, because in fact recommendation systems can be useful for almost any business, and to start recommending, the data that is collected along the way is usually enough, and the ROI is sufficient to start the project right away [3].
What is a recommendation system, how does it usually work? The classic task of the collaborative filtering is to predict what products (in the broadest sense of the word) users will like based on what products they liked in the past. Mathematically, this task can be thought of as the task of adding a table: imagine a huge table where the rows are users, the columns are products, and in the cells there are estimates of how much this user liked this product: for example, the rating of a movie in the form of stars or the rating of a product bought in the online store. We don't know anything about the vast majority of the elements of this table -- usually one client can estimate only a very small part of all products -- but in some cells there are known estimates, which are the input data for this task. The task of the system we want to build is to predict how much the customer will like those products that he has not yet estimated, and then recommend the best products personally for him. You can recommend either just those products that are likely to please him, or taking into account the profits that they will bring to the business. This problem is usually solved according to the "like like like" principle: alike users will like the same products, and the likeness between users can be estimated through what products they liked in the past.
At this point, the head of the content provider or even the store usually sighs sadly and says: "But I do not have any ratings... Yes, I have the customer base, I know what products they bought/read/used, but how do I know that customers did not like?.."It does not matter: there are many methods for one-class collaborative filtering, in which it is enough to know only the fact of consumption, without any negative estimates. For example, Facebook knows what users “like”, but it hardly has the technical ability to record what the user could have “liked”, but did not do it. These methods are a little more complicated mathematically (many of them are based, for example, on non-negative matrix decomposition), but for business the essence does not change: by using the database consisting of customer actions, you can evaluate the likeness between customers or products and extrapolate this likeness to new recommendations.
The main difficulty in all collaborative filtering systems, with or without ratings, is the cold start: how to recommend products that almost no one has yet seen, and what to recommend to users who have just come to the system; usually you have to resort to simpler, non-personalized schemes of recommendations (the most popular products, etc.), and then, as statistics are collected, move to personalized schemes.
At this point, content providers and stores are already in business, but the head of the bank sighs no less sadly: "It's convenient for you, you have one user read a dozen articles on the website, and you have the statistics, you can recommend something. And all our customers are new -- how many deposits or mortgages one person needs in one bank? One long cold start; your recommendations don't work for us..." But even here the answer will be found! The answer is usually to use the additional information that the business has about its customers.
For example, what might a recommendation system look like for a bank? When a person becomes a bank customer, and often even when he is just thinking about it, the bank usually already knows a lot about the person. Passport data already provide information about the gender, age and marital status, as well as geo-referencing (where the client lives); questionnaires that are usually filled out by new clients, provide information about the level of income, the structure of consumption of the client and so on. This allows us to move from the consideration of individual customers, which are determined only by their wishes and their experience of interaction with products, to generalized models that highlight the general preferences of customers, similar to each other in something, for example, "25-30-year-old girls from the Tverskoy District of Moscow." In such models, collaborative filtering is usually supplemented by clustering methods, splitting a large set of objects into subsets of objects similar to each other. It should be noted that not only natural demographic segmentation, which many banks do manually (or even automatically), is possible here, but also the use of much more detailed and interesting information, for example, the structure of the client's expenses, which can be estimated by the flow of funds on his bank card.
All of the above, as a rule, does not require any serious movements and large additional costs from business: you just need to prepare for analysts special data sets that already exist in the CRM-system that you use. The main substantive part of the project will be training the artificial intelligence systems and testing models on these (already historical) data, analysis and improvement of the resulting recommendations, taking into account the wishes of the business. And only at the stage of final application, the integration of ready recommendations into business processes some meaningful interaction between the team of analysts, the business function and the IT Department of business may be required.
Thus, recommendation systems are a large class of models that can help almost every business, whatever its specifics and subject area.
Now we are very close to the main part of our study, which in turn will consist of two global tasks and several subtasks:
1. Theoretical: identification of key economic criteria in determining the company's need for factoring.
Ш Identification of the data source for the analysis of the economic potential of a company when using factoring
Ш Identification of key economic indicators
Ш Analysis of the obtained indicators
Ш Risk analysis of the factoring market and the algorithm for their minimization
2. Practical: building a recommendation system
Ш Clustering of the customer database
Ш Building a recommendation system
Ш Cold start problem and its solution
Ш Calibration of recommendation system
Ш Economic effect and analysis of the results
4.Theoretical part
Analysis and assessment of financial position
Financial analysis and assessment of the financial position of the enterprise is an integral part of this work. Financial position is the state of the company's finances, characterized by a set of indicators reflecting the process of formation and use of its financial resources. The purpose of financial analysis is to assess the financial results and financial position of the enterprise, as well as the economic diagnostics of future potential.
The objectives of financial analysis can be classified as follows:
1. Identification of changes in financial position indicators;
2. Identification of factors affecting the financial position;
3. Assessment of quantitative and qualitative changes in financial position;
4. Assessment of the financial position on a specific date;
5. Identification of trends in the financial position of the organization.
There are the following main stages of financial analysis:
1. Identification of the purpose of the analysis and approaches to it;
2. Assessment of the quality of the information submitted for analysis;
3. Identification of methods of analysis, realization of the analysis and generalization of the results;
At the first stage, the approach to analysis is determined, and it is related to its purpose. The following main approaches are possible:
Ш Comparison of the enterprise performance with the average indicators for the economy or industry (with regulatory);
Ш Comparison of indicators of this accounting period with data of the previous periods or planned figures;
Ш Comparison of indicators with similar indicators of other competitors.
Each of these types of comparison has its own peculiarities and is subject to certain requirements. Indicators of a particular enterprise, when compared with the average industry or regulatory indicators, will depend on the peculiarities of the organization of production, technology, proprietary forms, geographical location and other factors. To a lesser extent, these factors affect the time comparisons of the indicator of one enterprise, but the characteristics of the economy, factors of seasonality of production, condition in a particular market have an impact [6].
At the second stage, the quality of information is assessed. It must be objective, reliable, complete, sufficient for the analysis.
The third stage is the actual analysis as a set of methods and operations. There are the following main methods or standards of financial analysis:
Ш Analysis of absolute figures;
Ш Horizontal (time) analysis - comparison of each item of the accounts with the previous period;
Ш Vertical (structural) analysis - identification of the structure of the final financial indicators with the identification of the impact of each item of the accounts on the result as a whole;
Ш Trend analysis - comparing each item of the accounts with a number of previous periods and identification of the trend, i.e. the main trend of the indicator dynamics, cleared of random influences and individual characteristics of particular periods. With the help of the trend, possible values of indicators in the future are formed, and, consequently, a prospective or predictive analysis is conducted;
Ш Spatial analysis - a comparative analysis of summary figures of accounts on their constituent elements (structural units, ubits, subsidiaries, etc.);
Ш Analysis of relative indicators (coefficients) - calculation of correlations between individual items of the accounts or items of different accounts forms, identification of the interconnection of indicators;
Ш Factor analysis - analysis of the influence of individual factors on the resulting indicator using deterministic and stochastic methods of research. Factor analysis can be direct (actual analysis) - the fragmentation of the output indicator into component parts, - and reverse, when the individual elements are combined into a general indicator.
Information base of financial analysis is the data of the accounts, first of all, the Form №1 "Balance Sheet", Form №2 "Profit and Loss Statement" the Form №4 "Cach Flow Statement", Form №5 "Condition of the Property of Enterprise", etc.
Direct users of financial analysis information can be:
Ш Owners of the enterprise, the most interesting for which are profitability, economic growth, risks;
Ш Creditors and investors - they are interested in creditworthiness and possible return (effectiveness) on investments.
Ш Suppliers and contractors - for this category payment terms and dynamics of change of solvency are important.
Analysis of the financial position of the company includes a number of stages:
Ш Preliminary (general) assessment of the financial position of the company and changes in its financial indicators for the accounting period;
Ш Analysis of financial sustainability of the enterprise;
Ш Analysis of solvency and liquidity of the balance of the enterprise;
Ш Analysis of current assets turnover;
Ш Analysis of financial performance of the company.
General analysis of financial position
The financial position of the enterprise is characterized by the placement and use of funds (assets) and the sources of their formation (liabilities). These data are presented in Form №1. For the general assessment of dynamics of financial position of the enterprise it is necessary to assort balance sheet accounts into separate groups, on the basis of liquidity (asset items) and urgency of obligations (liability items). The analysis of the structure of property and sources of funds of the enterprise is carried out on the basis of the aggregated (comparative analytical) balance, which in a simplified form can be represented as follows.
Table 6
Assets |
Liabilities |
|
Property |
Sources of funds |
|
Dead (noncurrent) assets |
Equity |
|
Mobile (current) assets |
Loan capital |
|
Inventories and costs |
Long-term liabilities |
|
Accounts receivable |
Short-term loans |
|
Fund and short-term financial investments |
Accounts payable |
Comparative analytical balance allows to simplify the work on the horizontal and vertical analysis of the main financial indicators of the enterprise. Horizontal or dynamic analysis allows to set their absolute increments and growth rates, which is important for characterizing the financial position of the enterprise. The dynamics of the value of the property provides additional information, aside from the financial results, about the financial strength of the enterprise and its capabilities. The vertical analysis is equally important, it characterizes the structure of property assets and sources of financial resources of the enterprise. The trend analysis of individual balance sheet items has a particular importance in the adjustment of the financial strategy of the enterprise. It involves the use of, as a rule, specific economic, mathematical and statistical methods of research [9], [10].
Table 7
Indicators |
Beggining of a period |
End of a period |
Absolute change (+/- thousand rubles) p.4-p.2) |
Change in share (+/-%) p.5-p.3 |
Growth rate (%) (p.4/p.2)*100% |
|||
Thousand rubles |
% |
Thousand rubles |
% |
|||||
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
|
ASSET 1. Noncurrent assets |
300 |
30 |
400 |
33.3 |
+100 |
+3.33 |
133.33 |
|
2. Current assets, including |
700 |
70 |
800 |
66.7 |
+100 |
-3.3 |
114.29 |
|
2.1. inventories |
400 |
40 |
450 |
37.5 |
+50 |
-2.5 |
112.5 |
|
2.2. accounts receivable |
250 |
25 |
340 |
28.33 |
+90 |
+3.33 |
136 |
|
2.3. fund and short-term financial investments |
50 |
5 |
10 |
0.83 |
-40 |
-4.17 |
20 |
|
LIABILITIES 1. Capital and reserves |
250 |
25 |
250 |
20.83 |
0 |
-4.17 |
0 |
|
2. Long-term loans |
50 |
5 |
10 |
0.83 |
-40 |
-4.17 |
20 |
|
3. Short-term loans |
200 |
20 |
250 |
20.83 |
+50 |
+0.83 |
125 |
|
4. Accounts payable |
500 |
50 |
690 |
57.5 |
+190 |
+7.5 |
138 |
|
BALANCE |
1000 |
100 |
1200 |
100 |
+200 |
0 |
+120 |
For analytical purposes, for a more detailed study of the nature of changes in the structure and dynamics of individual balance sheet items, a financial analyst can analyze smaller groups of assets and liabilities (inventories, receivables, goods and finished products, etc.).
The result of the preliminary analysis is a general assessment of the financial position of the enterprise, as well as the identification of solvency and satisfactory balance sheet structure of the enterprise.
Financial sustainability analysis
The purpose of the company's policy in the field of working capital management is to identify the volume and structure of current assets, sources of their financing and the ratio between them, sufficient to ensure long-term production and efficient financial activity. This interpretation is of a strategic nature, with a focus on the qualitative growth of production efficiency indicators (return on assets, turnover of current assets, etc.), implies the establishment of optimum size of current assets, and allows making investments in non-current assets as assets that give higher returns.
An equally important aspect of the finance services is the operational or current management of current assets, the purpose of which is to maintain the liquid structure of the assets of the enterprise and prevent the risk of insolvency, and the relation between the level of liquidity and the amount of current capital is diametrically opposed to its ratio to profit.
The analysis begins with the verification of the availability of inventories and costs by the sources of formation. Thus, the ratio of the cost of the inventories and the amount of own and borrowed sources of their formation determines the financial sustainability of the enterprise.
There are several types of financial sustainability:
Ш absolute sustainability - surplus of sources of formation of inventories and costs; it is extremely rare.
Ш normal - inventories and costs are provided by the amount of own funds
Ш unstable state - inventories and costs are provided by own and borrowed funds
Ш crisis state - inventories and costs are not provided by sources of formation, the enterprise is on the verge of bankruptcy.
Analytical table is used for analysis
Table 8
Indicators |
Beggining of a period |
End of a period |
Change for the period |
||
1. |
Capital and reserves, i.e. sources of equity (authorized, supplementary, reserve, mutual funds, social sphere, directed receits, unappropriated balance of accounts of past years) |
22069 |
39322 |
+17253 |
|
2. |
Fixed assets and other noncurrent assets (intangible asset, fixed assets, work-in-progress, long-term financial investments) |
20987 |
24161 |
||
3. |
Own working capital /1-2/, EC |
1082 |
15161 |
||
4. |
Long-term loans |
0 |
0 |
||
5. |
Own and long-term loan sources for inventories formation /3+4/, ET |
1082 |
15161 |
||
6. |
Short-term loans |
2284 |
|||
7. |
Total value of the main sources of formation of inventories and costs /5+6/, EO |
3366 |
15161 |
||
8. |
Total value of inventories and costs |
5346 |
39457 |
||
9. |
Surplus /+/ or deficiency /-/ of own working capital /3-8/, EC |
-4180 |
-24294 |
||
10. |
Surplus or deficiency of own or long-term loan sources for inventories formation /5-8/, ET |
-4180 |
-24294 |
||
11. |
Surplus or deficiency of the total value of the main sources of formation of inventories and costs /7-8/, EO |
-1980 |
-24294 |
||
12. |
Type of financial sustainability |
Crisis |
Crisis |
Inequalities are applied in determining the type of financial sustainability:
EU ? O - absolute sustainability;
ET ? O - normal sustainability;
EO ? O - unstable state;
EO < O - crisis state.
Sources that weaken financial stringency can be: temporarily free equity (funds, economic incentives, financial reserves, etc.), borrowed funds, the excess of normal accounts payable over receivables, bank loans to replenish working capital.
Analytical ratios can be used to characterize financial sustainability:
Proprietorship ratio (NW/TA), calculated as the ratio of ownner's equity to the total value of the enterprise assets.
Proprietorship ratio = owner's equity / total assets x 100%
Characterizes the share of owner's equity in the capital structure of the company, and as a consequence, the ratio of interests of owners and creditors. This indicator is of particular importance for investors and creditors, as it characterizes the share of funds invested by owners in the total value of the enterprise's property. In Western Europe and the United States, the normal value of this indicator is 0.6(60%), although it has decreased slightly in recent years. In Japan, the rate fell from 0.61(61%) in 1936 to 0.19(19%) in 1970, but there has been an upward trend in recent decades. In Russian conditions, it is estimated that the ratio should be greater than or equal to 0.5, which minimizes the risk of creditors and investors, assuming that by selling half of the property formed by the owner's equity, the company will be able to repay its debt obligations.
Total debt to Net Worth ratio
Total debt to Net Worth ratio = owner's equity/debt capital
It shows which part of the organization's activities is financed from its own funds, and which from borrowed funds. The critical value of the indicator is 1. A situation in which the actual value below this value indicates a questionable financial situation, the risk of insolvency and prevents the possibility of obtaining loans. High dependence on external loans can significantly worsen the situation of the enterprise in the event of a slowdown in the rate of progress, since in the short term the organization will not be able to reduce this part of fixed costs, with declining sales rates. It is believed that the ratio plays a crucial role in the decision of the enterprise on the choice of sources of funding.
Investment ratio - shows the extent to which owner's equity covers productive investments and is calculated as the ratio of owner's equity (total of the forth section of the liability balance sheet) to the value of fixed assets and other non-current assets (total of the first section of the asset balance sheet).
Investment ratio = owner's equity / fixed assets and other non-current assets
The security of inventories and costs with owner's equity ratio. It is calculated as the ratio of own working capital to the amount of inventories and costs.
The security of inventories and costs with owner's equity ratio = own working capital / inventories and costs x 100%
The situation is regarded as successful if the ratio is higher than 0,25(25%). The adequacy of the organization's own working capital, as well as the share of their participation in the formation of inventories are important indicators that characterize the creditworthiness of the enterprise, since financial sustainability depends largely on the state of such component of current assets as inventories. The minimum values of inventories and the high share of equity in their formation indicates the financial sustainability of the organization, excess inventory or a decrease in the share of equity in their formation lead to its reduction. Excessive inventories due to reduced demand determine the financial position as a crisis.
Maneuverability (mobility) ratio is calculated as the quotient of the division of working capital by the amount of owner's equity.
Mobility ratio = own working capital / owner's equity x 100%
It characterizes the efficiency of the company's asset structure and the possible flexibility in the use of its own working capital.
As a basic premise, we assume that the bank has the data of Form 1 (Balance sheet) and Form 2 (Financial results statement) for all analyzed companies for the year in quarterly breakdown. This premise is taken from real banking practice, because in the implementation of credit analysis of the enterprise, these two documents are its basis. The time periods are also not chosen by chance, as most Russian companies close their financial statements in accordance with Russian Accounting Standards (RAS) on a quarterly basis. As a result, we get 4 accounting dates of 1 - 4 quarters.
It is worth noting that usually banks have much more detailed information about their customers, such as fiscal data, turnover on current accounts and acquiring, etc. However, to simplify the model and to maintain its flexibility, we will use only the information from these two documents.
The main question is: When can a company be interested in factoring?
Let's start the answer to this question with the consideration of working capital, or rather with its deficit. Working capital is a part of capital goods, entirely consumed during one production cycle. They usually include materials, raw materials, fuel, energy, semi-finished products, work in progress, deferred expenses. The value of production fixed assets is determined by the summation of the values of their individual types. Working capital ensures the continuity of economic activity. Its lack leads to untimely performance of contractual obligations and, accordingly, to penalties, loss of income as a result of refusal of some orders, decrease in profitability of economic activity due to the attraction of credit resources at any cost, even on unfavorable conditions for the enterprise [9]. It is believed that the deficit of working capital is the norm in the work of the enterprise, including actively developing one. Is it possible to have the company's turnover functioning without deficit and always have only positive cash flow, or is it an economic utopia?
First of all, we will try to answer the question: Why can there be a working capital deficit?
Among the factors that have a significant impact on the working capital there are the following ones:
Ш general slowdown of the turnover ratio;
Ш creation (formation) of excess inventories;
Ш decline in production volume and sales;
Ш extension of the technological cycle due to problems in production or increase in the complexity of processing of raw materials, lack of components, etc;
Ш difficulty in products sales (decrease in consumer demand);
Ш capital investments, for example, in the construction of new production or expansion of the old one;
Ш non-payment or late payment for shipped products. In this case, the company is forced to respite a delay on payments. In general, the reasons for the delay may be quite different, but most often this condition is dictated by the market;
The last two criteria are the most obvious and understandable for the analysis, however, neither in Form 1 nor in Form 2 the fact that the company works on an advance payment or provides a deferral of payments is explicitly reflected.
To determine this fact, it is required to analyze the company's receivables in more detail. Receivables are funds that the debtor is obliged to pay. In business, debtors are most often buyers, as well as companies that have issued a loan. The debtor may also be an individual who has borrowed funds. It can be an employee of the company or the owner of a share in the authorized capital. Accounts receivable are included in the financial statements and recorded on the account 62 "Settlements with customers" and 76 "Settlements with different debtors and creditors". It is quite dynamic and depends on the company's interaction with customers and partners. We can say that this type of debt forms the company's profit. At the same time, it is also a source of formation of the organization's own capital [10].
Подобные документы
Consideration of a systematic approach to the identification of the organization's processes for improving management efficiency. Approaches to the identification of business processes. Architecture of an Integrated Information Systems methodology.
реферат [195,5 K], добавлен 12.02.2016Lists used by Algorithm No 2. Some examples of the performance of Algorithm No 2. Invention of the program of reading, development of efficient algorithm of the program. Application of the programs to any English texts. The actual users of the algorithm.
курсовая работа [19,3 K], добавлен 13.01.2010IS management standards development. The national peculiarities of the IS management standards. The most integrated existent IS management solution. General description of the ISS model. Application of semi-Markov processes in ISS state description.
дипломная работа [2,2 M], добавлен 28.10.2011Review of development of cloud computing. Service models of cloud computing. Deployment models of cloud computing. Technology of virtualization. Algorithm of "Cloudy". Safety and labor protection. Justification of the cost-effectiveness of the project.
дипломная работа [2,3 M], добавлен 13.05.2015Overview history of company and structure of organization. Characterization of complex tasks and necessity of automation. Database specifications and system security. The calculation of economic efficiency of the project. Safety measures during work.
дипломная работа [1009,6 K], добавлен 09.03.2015Practical acquaintance with the capabilities and configuration of firewalls, their basic principles and types. Block specific IP-address. Files and Folders Integrity Protection firewalls. Development of information security of corporate policy system.
лабораторная работа [3,2 M], добавлен 09.04.2016The material and technological basis of the information society are all sorts of systems based on computers and computer networks, information technology, telecommunication. The task of Ukraine in area of information and communication technologies.
реферат [29,5 K], добавлен 10.05.2011Basic assumptions and some facts. Algorithm for automatic recognition of verbal and nominal word groups. Lists of markers used by Algorithm No 1. Text sample processed by the algorithm. Examples of hand checking of the performance of the algorithm.
курсовая работа [22,8 K], добавлен 13.01.2010Архитектура операционной системы Android. Инструменты Android-разработчика. Установка Java Development Kit, Eclipse IDE, Android SDK. Настройка Android Development Tools. Разработка программы для работы с документами и для осуществления оперативной связи.
курсовая работа [2,0 M], добавлен 19.10.2014Основные алгоритмические структуры. Запись алгоритма в словесной форме, в виде блок-схемы. Система команд исполнителя. Язык высокого уровня. Создание программы и её отладка. Интегрированные среды разработки: Integrated Development Environment, IDE.
лекция [61,7 K], добавлен 09.10.2013