Research of Corporate Credit for Anhui Province’s Listed Companies Based on Computer Technology

Abstract

Aiming at the shortcoming that obtained from comprehensive evaluation by principal component analysis, this paper points out the method of based on the EXCEL/VBA one-click technology to achieve principal component comprehensive evaluation. Namely, according to the algorithm of Eigenvalue and Eigenvector with the function in Excel-macro, in this article, an easy-to-implement solution to comprehensive evaluation by principal component analysis with VBA in Microsoft EXCEL is provided, which makes users be completely free from manual operation. It is raising the comprehensive evaluation by principal component analysis method practical. Meantime, as the dishonesty violations of listed companies occur from time to time, the credit risk of listed companies has become an issue related to the financial system stability. By understanding the concepts of credit and credit risk, a quantitative research has been carried out on the credit taking listed company in Anhui Province as an example on the premise of considering the availability of data. According to analysis of the company’s credit system, combined with 46 financial statements of listed companies in Anhui Province, 12 indicators are selected for analysis and ranks with the company credit. Then through the cluster analysis of listed companies, these companies will be divided into three types. As results, some conclusions have been drawn from the Empirical Analysis that being work along both effective regulation and institutional innovation is an effective solution to the problem for the way of enhancing the company credit.