CN105608151A - Financial statement analysis device and method - Google Patents
Financial statement analysis device and method Download PDFInfo
- Publication number
- CN105608151A CN105608151A CN201510956691.7A CN201510956691A CN105608151A CN 105608151 A CN105608151 A CN 105608151A CN 201510956691 A CN201510956691 A CN 201510956691A CN 105608151 A CN105608151 A CN 105608151A
- Authority
- CN
- China
- Prior art keywords
- financial
- financial index
- index result
- result
- parts
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Development Economics (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a financial statement analysis device and method. The device comprises a financial statement tool, an index defining tool, a mapping analysis unit and an index updating unit, wherein the financial statement tool is used for defining a financial statement and a figure selection formula, and filling or modifying project to the financial statement according to the figure selection formula; the index defining tool is used for defining an analysis index system corresponding to the financial statement and financial indexes contained in the analysis index system; the mapping analysis unit is used for establishing a mapping relation between the financial indexes and project cells in the financial statement, and determining a financial index result according to the mapping relation; and the index updating unit is used for setting a financial index data view, monitoring the change of the project data in the project cells with the mapping relation in real time through the financial index data view, and updating the financial index result in real time according to the change of the project data. According to the financial statement analysis device and method, the financial statement analysis efficiency can be effectively improved.
Description
Technical field
The present invention relates to Computer Applied Technology field, particularly a kind of financial statement analysis apparatus and method.
Background technology
Financial statement analysis, by collecting, arrange the related data in Enterprise accounting report, financial situation, management performance and cash flow situation to enterprise carries out comprehensively comparing and evaluating, represent as net profit margin, financial ratios etc. by financial index, and financial index data mainly depend on the project data in financial statement. in existing financial statement analysis technology, between financial index data and project data, undertaken associated by computing formula, computing formula only triggers as more when New Set receiving, just can carry out computing, so, when after destination item Data Update, need to be by find the destination item data relevant to index in all items data, the computing formula corresponding substitution of destination item data is calculated, could upgrade achievement data, complete financial statement analysis, because be just starts to carry out to search destination item data and parameter data in starting renewal achievement data, cause financial statement analysis efficiency lower.
Summary of the invention
The invention provides a kind of financial statement analysis apparatus and method, can effectively improve financial statement analysis efficiency.
A kind of financial statement analysis device, comprising:
Financial statement instrument, for defining financial statement and figure selection formula, and according to described figure selection formula, makes a report on or revises project data to described financial statement;
Index definition instrument, each financial index comprising for defining analysis indexes system corresponding to described financial statement and described analysis indexes system;
Map analysis unit, for setting up the mapping relations of project cell of described each financial index and described financial statement, and according to described mapping relations, determines financial index result;
Index updating block, be used for arranging financial index Data View, there is the change of project data in the project cell of mapping relations by the in real time monitoring of described financial index Data View, and according to the change of described project data, financial index result described in real-time update.
Preferably, this device further comprises: index model instrument, for the layout of figure, table parts and each parts is set, obtain the definite financial index result in described map analysis unit, and by described figure, table parts, according to the layout of described each parts, export described financial index result graph of a correspondence and/or form.
Preferably, described map analysis unit, for determining the weight coefficient with described each financial index with the project cell financial indicator of mapping relations, and according to following formula, calculates financial index result;
W=A*P1+B*P2+…+N*Pn
Wherein, W characterizes financial index result, comprising: any one or more in profitability, operation ability, debt paying ability, growth ability, integration capability; A, B ..., N characterizes with financial index has the project data of mapping relations; P1、P2、…、PnCharacterize the weight coefficient that each project data is corresponding.
Preferably, described index model instrument, comprising: model definition subelement, data engine and model represent subelement, wherein,
Described model definition subelement, for the layout of figure, table parts and each parts is set, and is schemed, is shown parts and described financial index result is set originates for described;
Described data engine, be used for passing through data-interface, obtain described figure, table parts that described model definition subelement arranges, the layout of each parts and described financial index result source, and according to described financial index result source, obtain described financial index result, and by described figure, table parts, the layout of each parts and described financial index result offer model and represent subelement;
Described model represents subelement, for described financial index result being written into described figure, table parts, forms and pass through corresponding figure, the table of financial index result described in showing interface.
Preferably, described index definition instrument, for setting target standard value;
Described model represents subelement, is further used for described financial index result and described index standard value to contrast, and described financial index result is carried out to data early warning and numeric format.
Preferably, described model definition subelement, is further used for arranging data linkage between each parts/review relation;
Described model represents subelement, for identifying interlock between each parts/review relation, represent the figure/table corresponding with current financial index result the figure/table with the relation of linking/review.
Preferably, described model represents subelement, for be set update time, and in the time that the project data in described financial statement changes, according to described update time, current figure/table corresponding to financial index result representing of real-time update.
A kind of financial statement analysis method, definition financial statement and figure selection formula, define each financial index that analysis indexes system corresponding to described financial statement and described analysis indexes system comprise, and financial index Data View be set; Also comprise:
According to described figure selection formula, make a report on or revise project data to described financial statement;
Set up the mapping relations of the project cell in described each financial index and described financial statement, and according to described mapping relations, determine financial index result;
There is the change of project data in the project cell of mapping relations by the in real time monitoring of described financial index Data View, and according to the change of described project data, financial index result described in real-time update.
Preferably, the method further comprises: the layout that figure, table parts and each parts are set;
After described definite financial index result, further comprise: obtain described financial index result, and by described figure, table parts, according to the layout of described each parts, export described financial index result graph of a correspondence and/or form.
Preferably, the method further comprises: determine the weight coefficient with described each financial index with financial indicator in the project cell of mapping relations;
Described according to described mapping relations, determine financial index result, comprising: according to following formula, calculate financial index result;
W=A*P1+B*P2+…+N*Pn
Wherein, W characterizes financial index result, comprising: any one or more in profitability, operation ability, debt paying ability, growth ability, integration capability; A, B ..., N characterizes with financial index has the project data of mapping relations; P1、P2、…、PnCharacterize the weight coefficient that each project data is corresponding.
Preferably, the method further comprises: schemed, show parts described financial index result source is set by described;
Describedly obtain described financial index result, comprising: according to described financial index result source, obtain described financial index result;
Described output described financial index result graph of a correspondence and/or form, comprising: described financial index result is written into described figure, table parts, forms and pass through corresponding figure, the table of financial index result described in showing interface.
Preferably, the method further comprises: setting target standard value;
Described obtain described financial index result after, in described formation and before by figure corresponding to financial index result described in showing interface, table, further comprise: described financial index result and described index standard value are contrasted, described financial index result is carried out to data early warning and numeric format;
Described by corresponding figure, the table of financial index result described in showing interface, comprising: by the described financial index result of described data early warning and vertical format, show by figure/table mode.
Preferably, the method further comprises: data linkage between each parts/review relation is set;
Described by figure corresponding to financial index result described in showing interface, table after, further comprise:
Identify interlock between each parts/review relation, represent the figure/table corresponding with current financial index result and have the figure/table of the relation of linking/review.
Preferably, the method further comprises: be set update time;
Described by figure corresponding to financial index result described in showing interface, table after, further comprise: in the time that the project data in described financial statement changes, according to described update time, current figure/table corresponding to financial index result representing of real-time update.
The embodiment of the present invention provides a kind of financial statement analysis apparatus and method, and this device comprises: financial statement instrument, for defining financial statement and figure selection formula, and according to described figure selection formula, make a report on or revise project data to described financial statement, index definition instrument, each financial index comprising for defining analysis indexes system corresponding to described financial statement and described analysis indexes system, map analysis unit, for setting up the mapping relations of project cell of described each financial index and described financial statement, and according to described mapping relations, determines financial index result, index updating block, be used for arranging financial index Data View, monitor in real time the change of project data in the project cell with mapping relations by described financial index Data View, and according to the change of described project data, financial index result described in real-time update, because financial index is often relevant to the project data in financial statement, in apparatus of the present invention, set up the mapping relations of the project cell in each financial index and financial statement by map analysis unit, and the financial index Data View arranging by index updating block, the variation according to project data in the project cell of mapping that financial index data can be real-time is changed, thereby effectively raise financial statement analysis efficiency.
Brief description of the drawings
The structural representation of a kind of financial statement analysis device that Fig. 1 provides for the embodiment of the present invention;
The structural representation of a kind of financial statement analysis device that Fig. 2 provides for another embodiment of the present invention;
The flow chart of a kind of financial statement analysis method that Fig. 3 provides for the embodiment of the present invention;
The flow chart of a kind of financial statement analysis method that Fig. 4 provides for another embodiment of the present invention;
The schematic diagram of the displaying analysis of balance sheet result chart that Fig. 5 provides for the embodiment of the present invention;
The graph structure schematic diagram of the displaying profitability that Fig. 6 provides for the embodiment of the present invention.
Detailed description of the invention
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described. Obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiment. Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
A kind of financial statement analysis device that Fig. 1 provides for the embodiment of the present invention, this device comprises:
Financial statement instrument 101, for defining financial statement and figure selection formula, and according to figure selection formula, makes a report on or revises project data to described financial statement;
Index definition instrument 102, each financial index comprising for defining analysis indexes system corresponding to financial statement and analysis indexes system;
Map analysis unit 103, for setting up the mapping relations of project cell of the financial statement that each financial index that index definition instrument 102 defines and financial statement instrument 101 define, and according to mapping relations, determines financial index result;
Index updating block 104, be used for arranging financial index Data View, monitor in real time the change of project data in the project cell with mapping relations by financial index Data View, and according to the change of project data, the financial index result that real-time update map analysis unit 103 is definite.
In another embodiment of the present invention, said apparatus further comprises: index model instrument (not shown), for the layout of figure, table parts and each parts is set, obtain the definite financial index result in map analysis unit 103, and by figure, table parts, according to the layout of described each parts, output financial index result graph of a correspondence and/or form.
In further embodiment of this invention, map analysis unit 103, for determining the weight coefficient with each financial index with the project cell financial indicator of mapping relations, and according to following formula, calculates financial index result;
W=A*P1+B*P2+…+N*Pn
Wherein, W characterizes financial index result, comprising: any one or more in profitability, operation ability, debt paying ability, growth ability, integration capability; A, B ..., N characterizes with financial index has the project data of mapping relations; P1、P2、…、PnCharacterize the weight coefficient that each project data is corresponding.
As shown in Figure 2, in another embodiment of the present invention, index model instrument 201, comprising: model definition subelement 2011, data engine 2012 and model represent subelement 2013, wherein,
Model definition subelement 2011, for the layout of figure, table parts and each parts is set, and is arranged financial index result source by scheming, show parts;
Data engine 2012, be used for passing through data-interface, obtain figure, table parts that model definition subelement 2011 arranges, the layout of each parts and financial index result source, and originate according to financial index result, obtain financial index result, and will scheme, show parts, the layout of each parts and financial index result offer model and represent subelement 2013;
Model represents subelement 2013, for financial index result being written into figure, table parts, forms and pass through showing interface financial index result corresponding figure, table.
In further embodiment of this invention, index definition instrument 102, for setting target standard value;
Model represents subelement 2013, is further used for financial index result and index standard value to contrast, and financial index result is carried out to data early warning and numeric format.
In another embodiment of the present invention, model definition subelement 2011, is further used for arranging data linkage between each parts/review relation;
Model represents subelement 2013, for identifying interlock between each parts/review relation, represent the figure/table corresponding with current financial index result the figure/table with the relation of linking/review.
In another embodiment of the present invention, model represents subelement 2013, for be set update time, and in the time that the project data in financial statement changes, current figure/table corresponding to financial index result representing of real-time update.
As shown in Figure 3, the embodiment of the present invention provides a kind of financial statement analysis method, and the method can comprise the steps:
Step 301: definition financial statement and figure selection formula;
Step 302: each financial index that the analysis indexes system that definition financial statement is corresponding and analysis indexes system comprise, and financial index Data View is set;
Step 303: according to figure selection formula, make a report on or revise project data to financial statement;
Step 304: set up the mapping relations of the project cell in each financial index and financial statement, and according to mapping relations, determine financial index result;
Step 305: monitor in real time the change of project data in the project cell with mapping relations by financial index Data View, and according to the change of project data, real-time update financial index result.
In one embodiment of the invention, in order to show intuitively financial index result, the method further comprises: the layout that figure, table parts and each parts are set; After step 304, further comprise: obtain financial index result, and by figure, table parts, according to the layout of each parts, output financial index result graph of a correspondence and/or form.
In one embodiment of the invention, in order to make financial index result more accurate, the method further comprises: determine the weight coefficient with each financial index with financial indicator in the project cell of mapping relations; The detailed description of the invention of step 304: according to following formula, calculate financial index result;
W=A*P1+B*P2+…+N*Pn
Wherein, W characterizes financial index result, comprising: any one or more in profitability, operation ability, debt paying ability, growth ability, integration capability; A, B ..., N characterizes with financial index has the project data of mapping relations; P1、P2、…、PnCharacterize the weight coefficient that each project data is corresponding.
In one embodiment of the invention, in order to make to show that chart peek has flexibility, the method further comprises: for figure, table parts arrange described financial index result source; The detailed description of the invention of step 304: according to financial index result source, obtain financial index result; Output financial index result graph of a correspondence and/or form, comprising: financial index result is written into figure, table parts, forms and pass through showing interface financial index result corresponding figure, table.
In one embodiment of the invention, in order to obtain financial index result accurately, the method further comprises: setting target standard value; After obtaining financial index result, before forming and pass through figure corresponding to showing interface financial index result, table, further comprise: financial index result and index standard value are contrasted, financial index result is carried out to data early warning and numeric format; By showing interface financial index result corresponding figure, table, comprising: by the financial index result of data early warning and vertical format, show by figure/table mode.
In one embodiment of the invention, the flexibility and comprehensive of showing in order to improve result, the method further comprises: data linkage between each parts/review relation is set; After by figure corresponding to financial index result described in showing interface, table, further comprise: identify interlock between each parts/review relation, represent the figure/table corresponding with current financial index result and have the figure/table of the relation of linking/review.
In one embodiment of the invention, for can be in real time for user provides up-to-date result, the method further comprises: be set update time; After the figure corresponding by showing interface financial index result, table, further comprise: in the time that the project data in financial statement changes, current figure/table corresponding to financial index result representing of real-time update.
As shown in Figure 4, another embodiment of the present invention provides a kind of financial statement analysis method, and the method can comprise the steps:
Step 401: definition financial statement and figure selection formula;
In the daily financial statement analysis of enterprise, analyzing and evaluate enterprise getting profit, payment of debts, operation, the large ability ratio analysis of development four for balance sheet, profit flow table, cash flow statement report item is conventional financial statement analysis method, the analysis indexes part relating to is directed to financial statement project, and part ratio index and formation, Comparative indices can be calculated and be generated by financial statement project and achievement data. In this step, can also define balance sheet, profit flow table, cash flow statement form, can also report tableau format etc. attribute to define to these, the figure selection formula defining by this step can avoid user to input in turn data, improves financial statement and fills in speed.
Step 402: each financial index that the analysis indexes system that definition financial statement is corresponding and analysis indexes system comprise, and financial index Data View and index standard value are set;
Step 403: the layout of figure, table parts and each parts is set, by being schemed, show parts, described financial index result source is set;
In this step, chart layout will directly have influence on user and check, as shown in Figure 5, for a kind of chart layout mode that the embodiment of the present invention provides, can find out in the drawings, chart is positioned at up-down structure, figure and figure are directly in same a line, to facilitate user to compare, user can also set color, the layout etc. of chart according to demands of individuals, to meet the daily custom of user.
Step 404: data linkage between each parts/review relation and update time is set;
Can make to have between the figure and table of correlation by arranging of this step, between figure and figure and between table and table, there is linkage, for example: table a and figure b have correlation, by table a and figure b interlock are set, so in the time that user checks table a, it can be directly be transferred to figure b from table a, facilitates user to check that it wants the result of checking.
Step 405: according to figure selection formula, make a report on or revise project data to financial statement;
Step 406: the mapping relations of setting up the project cell in each financial index and financial statement;
In embodiments of the present invention, suppose that financial index all can corresponding corresponding project data, so, by setting up this mapping relations, can make financial index directly from financial statement, get corresponding project data.
Step 407: determine the weight coefficient with each financial index with financial indicator in the project cell of mapping relations;
This step is mainly to consider the affect difference of projects on financial index, for example: for profitability, return on total assets, net assets income ratio and income from main operation rate reduce successively on the impact of profitability, and the weight coefficient that return on total assets can be set is 0.49, the weight coefficient of net assets income ratio is 0.31, income from main operation rate weight coefficient is 0.2.
Step 408: according to mapping relations and weight coefficient, calculate financial index result;
According to following formula, calculate financial index result;
W=A*P1+B*P2+…+N*Pn
Wherein, W characterizes financial index result, comprising: any one or more in profitability, operation ability, debt paying ability, growth ability, integration capability; A, B ..., N characterizes with financial index has the project data of mapping relations; P1、P2、…、PnCharacterize the weight coefficient that each project data is corresponding.
Step 409: according to financial index result source, obtain financial index result;
Step 410: financial index result and index standard value are contrasted, financial index result is carried out to data early warning and numeric format;
Step 411: by figure, table parts, according to the layout of each parts, by the financial index result of data early warning and vertical format, show by figure/table mode;
Be illustrated in figure 5 the analysis result to balance sheet, from figure, can see intuitively composition of assets analysis, make user can clearly check analysis result, therefrom get the information of oneself wanting. What deserves to be explained is, in figure, the setting of the color of sector region and form color can be set according to user's request.
In this step, the displaying table of the capabilities analysis result obtaining, as shown in the table:
Step 412: identify interlock between each parts/review relation, represent the figure/table corresponding with current financial index result and have the figure/table of the relation of linking/review;
For example: in this step, be provided with the interlock of Analyzing profitability table in step 411 and Fig. 6 and review relation, so, user is in the time of the Analyzing profitability table of checking in step 411, can select to review, check profitability over the years, can also check the profitability of the different company of the same period.
Step 413: monitor in real time the change of project data in the project cell with mapping relations by financial index Data View, and according to the change of project data, real-time update financial index result;
For example: financial index A and project cell B have mapping relations, so, in the time that the data in project cell B change, financial index A also changes thereupon.
Step 414: according to update time, current figure/table corresponding to financial index result representing of real-time update.
For example: be set update time is 10s, in the time that user checks chart, the every 10s of this chart refreshes once so, to ensure providing up-to-date information as user.
The scheme that the embodiment of the present invention provides, at least can reach following beneficial effect:
1. by financial statement instrument, for defining financial statement and figure selection formula, and according to described figure selection formula, make a report on or revise project data to described financial statement, index definition instrument, each financial index comprising for defining analysis indexes system corresponding to described financial statement and described analysis indexes system, map analysis unit, for setting up the mapping relations of project cell of described each financial index and described financial statement, and according to described mapping relations, determines financial index result, index updating block, be used for arranging financial index Data View, monitor in real time the change of project data in the project cell with mapping relations by described financial index Data View, and according to the change of described project data, financial index result described in real-time update, because financial index is often relevant to the project data in financial statement, in apparatus of the present invention, set up the mapping relations of the project cell in each financial index and financial statement by map analysis unit, and the financial index Data View arranging by index updating block, the variation according to project data in the project cell of mapping that financial index data can be real-time is changed, thereby effectively raise financial statement analysis efficiency.
2. the layout of figure, table parts and each parts is set by index model instrument, obtain the definite financial index result in map analysis unit 103, and by figure, table parts, according to the layout of described each parts, output financial index result graph of a correspondence and/or form, realized these indexs carried out to intuitively representing of figure, form.
3. by described financial index result source being set for figure, table parts; According to financial index result source, obtain financial index result; Financial index result is written into figure, table parts, forms and pass through showing interface financial index result corresponding figure, table, make to show that chart peek has flexibility.
4. by data linkage between each parts/review relation is set; After by figure corresponding to financial index result described in showing interface, table, by identifying interlock between each parts/review relation, represent figure/table that the figure/table corresponding with current financial index result has the relation of linking/review, effectively improved flexibility that result shows and comprehensive.
5. by be set update time; After the figure corresponding by showing interface financial index result, table, in the time that the project data in financial statement changes, current figure/table corresponding to financial index result representing of real-time update, can be in real time for user provides up-to-date result.
It should be noted that, in this article, relational terms such as first and second is only used for an entity or operation to separate with another entity or operating space, and not necessarily requires or imply and between these entities or operation, have the relation of any this reality or sequentially. And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thereby the process, method, article or the equipment that make to comprise a series of key elements not only comprise those key elements, but also comprise other key elements of clearly not listing, or be also included as the intrinsic key element of this process, method, article or equipment. The in the situation that of more restrictions not, the key element being limited by statement " comprising ... ", and be not precluded within process, method, article or the equipment that comprises described key element and also have other same factor.
The foregoing is only preferred embodiment of the present invention, in order to limit the present invention, within the spirit and principles in the present invention not all, any amendment of making, be equal to replacement, improvement etc., within all should being included in the scope of protection of the invention.
Claims (10)
1. a financial statement analysis device, is characterized in that, comprising:
Financial statement instrument, for defining financial statement and figure selection formula, and according to described figure selection formula,Make a report on or revise project data to described financial statement;
Index definition instrument, for defining analysis indexes system corresponding to described financial statement and described pointAnalyse each financial index that index system comprises;
Map analysis unit, for setting up the menu of described each financial index and described financial statementThe mapping relations of unit's lattice, and according to described mapping relations, determine financial index result;
Index updating block, for financial index Data View is set, looks by described financial index dataFigure monitors the change of project data in the project cell with mapping relations in real time, and according to described projectThe change of data, financial index result described in real-time update.
2. device according to claim 1, is characterized in that,
Further comprise: index model instrument, for the layout of figure, table parts and each parts is set, obtainsGet the definite financial index result in described map analysis unit, and by described figure, table parts, according to instituteState the layout of each parts, export described financial index result graph of a correspondence and/or form;
And/or,
Described map analysis unit, for determining the project with described each financial index with mapping relationsThe weight coefficient of financial indicator in cell, and according to following formula, calculate financial index result;
W=A*P1+B*P2+…+N*Pn
Wherein, W characterizes financial index result, comprising: profitability, operation ability, debt paying ability,Any one or more in growth ability, integration capability; A, B ..., N characterize with financial index toolThere is the project data of mapping relations; P1、P2、…、PnCharacterize the weight coefficient that each project data is corresponding.
3. device according to claim 2, is characterized in that, described index model instrument, comprising:Model definition subelement, data engine and model represent subelement, wherein,
Described model definition subelement, for the layout of figure, table parts and each parts is set, and described in beingInstitute schemes, shows parts described financial index result source is set;
Described data engine, for by data-interface, obtains the institute that described model definition subelement arrangesState figure, table parts, the layout of each parts and described financial index result source, and according to described financeIndex result source, obtains described financial index result, and by described figure, table parts, the cloth of each partsOffice and described financial index result offer model and represent subelement;
Described model represents subelement, for described financial index result being written into described figure, table parts,Form and pass through corresponding figure, the table of financial index result described in showing interface.
4. device according to claim 3, is characterized in that,
Described index definition instrument, for setting target standard value;
Described model represents subelement, is further used for described financial index result and described index standardValue contrasts, and described financial index result is carried out to data early warning and numeric format.
5. device according to claim 3, is characterized in that,
Described model definition subelement, is further used for arranging data linkage between each parts/review relation;
Described model represents subelement, for identifying interlock between each parts/review relation, represents with currentFigure/table corresponding to financial index result has the figure/table of the relation of linking/review;
And/or,
Described model represents subelement, for be set update time, when the item number in described financial statementWhen changing, according to described update time, the current financial index result correspondence representing of real-time updateFigure/table.
6. a financial statement analysis method, is characterized in that, definition financial statement and figure selection formula are fixedEach finance that the analysis indexes system that the described financial statement of justice is corresponding and described analysis indexes system compriseIndex, and financial index Data View is set; Also comprise:
According to described figure selection formula, make a report on or revise project data to described financial statement;
Set up the mapping relations of the project cell in described each financial index and described financial statement, andAccording to described mapping relations, determine financial index result;
Monitor in real time project in the project cell with mapping relations by described financial index Data ViewThe change of data, and according to the change of described project data, financial index result described in real-time update.
7. method according to claim 6, is characterized in that,
Further comprise: the layout that figure, table parts and each parts are set;
After described definite financial index result, further comprise: obtain described financial index result,And by described figure, table parts, according to the layout of described each parts, export described financial index result pairThe figure of answering and/or form;
And/or,
Further comprise: determine with described each financial index and there is wealth in the project cell of mapping relationsThe weight coefficient of business project;
Described according to described mapping relations, determine financial index result, comprising: according to following formula, meterCalculate financial index result;
W=A*P1+B*P2+…+N*Pn
Wherein, W characterizes financial index result, comprising: profitability, operation ability, debt paying ability,Any one or more in growth ability, integration capability; A, B ..., N characterize with financial index toolThere is the project data of mapping relations; P1、P2、…、PnCharacterize the weight coefficient that each project data is corresponding.
8. method according to claim 7, is characterized in that, further comprises: by describedly being schemed,Table parts arrange described financial index result source;
Describedly obtain described financial index result, comprising: according to described financial index result source, obtainDescribed financial index result;
Described output described financial index result graph of a correspondence and/or form, comprising: described finance are referred toMark result is written into described figure, table parts, forms and to pass through described in showing interface financial index result correspondingFigure, table.
9. method according to claim 8, is characterized in that,
Further comprise: setting target standard value;
Described obtain described financial index result after, in described formation and by wealth described in showing interfaceBefore figure corresponding to business index result, table, further comprise: by described financial index result and described fingerMark standard value contrasts, and described financial index result is carried out to data early warning and numeric format;
Described by corresponding figure, the table of financial index result described in showing interface, comprising: by described dataEarly warning and the vertically described financial index result of format, show by figure/table mode.
10. method according to claim 8, is characterized in that, further comprises: each portion is setData linkage between part/review relation;
Described by figure corresponding to financial index result described in showing interface, table after, further comprise:
Identify interlock between each parts/review relation, represent the figure/table corresponding with current financial index resultThere is the figure/table of the relation of linking/review;
And/or,
Further comprise: be set update time;
Described by figure corresponding to financial index result described in showing interface, table after, further comprise:In the time that the project data in described financial statement changes, according to described update time, real-time update is worked asBefore figure/table corresponding to financial index result that represent.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510956691.7A CN105608151B (en) | 2015-12-17 | 2015-12-17 | A kind of financial statement analysis device and method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510956691.7A CN105608151B (en) | 2015-12-17 | 2015-12-17 | A kind of financial statement analysis device and method |
Publications (2)
Publication Number | Publication Date |
---|---|
CN105608151A true CN105608151A (en) | 2016-05-25 |
CN105608151B CN105608151B (en) | 2019-02-19 |
Family
ID=55988091
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510956691.7A Active CN105608151B (en) | 2015-12-17 | 2015-12-17 | A kind of financial statement analysis device and method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105608151B (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107808336A (en) * | 2017-11-02 | 2018-03-16 | 中国银行股份有限公司 | The computational methods and device of a kind of financial index |
CN109408584A (en) * | 2018-10-17 | 2019-03-01 | 平安科技(深圳)有限公司 | Report display method, apparatus, computer installation and storage medium |
CN109740134A (en) * | 2018-12-17 | 2019-05-10 | 泰康保险集团股份有限公司 | Report generation method and device |
CN110795474A (en) * | 2018-08-03 | 2020-02-14 | 上海小渔数据科技有限公司 | Data processing method and device for content generation |
CN114154471A (en) * | 2021-11-12 | 2022-03-08 | 航天信息股份有限公司 | System and method for one-key conversion of report |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101847152A (en) * | 2010-02-01 | 2010-09-29 | 浪潮集团山东通用软件有限公司 | Statistical analysis method and statistical analysis system for statements of various criterions based on data unit |
US20130024480A1 (en) * | 2011-07-18 | 2013-01-24 | Okun Justin A | Method and system for analysis of database records |
US20130317878A1 (en) * | 2011-09-27 | 2013-11-28 | Shariq Mansoor | Systems, Methods, and Apparatuses for Creating, Linking and Discovering Navigation Maps for Analyzing Data |
CN103744831A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Compilation method and device for multi-dimensional report |
CN104346398A (en) * | 2013-08-06 | 2015-02-11 | 航天信息股份有限公司 | Method and device for automatically filling and submitting data on line |
-
2015
- 2015-12-17 CN CN201510956691.7A patent/CN105608151B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101847152A (en) * | 2010-02-01 | 2010-09-29 | 浪潮集团山东通用软件有限公司 | Statistical analysis method and statistical analysis system for statements of various criterions based on data unit |
US20130024480A1 (en) * | 2011-07-18 | 2013-01-24 | Okun Justin A | Method and system for analysis of database records |
US20130317878A1 (en) * | 2011-09-27 | 2013-11-28 | Shariq Mansoor | Systems, Methods, and Apparatuses for Creating, Linking and Discovering Navigation Maps for Analyzing Data |
CN104346398A (en) * | 2013-08-06 | 2015-02-11 | 航天信息股份有限公司 | Method and device for automatically filling and submitting data on line |
CN103744831A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Compilation method and device for multi-dimensional report |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107808336A (en) * | 2017-11-02 | 2018-03-16 | 中国银行股份有限公司 | The computational methods and device of a kind of financial index |
CN107808336B (en) * | 2017-11-02 | 2022-02-25 | 中国银行股份有限公司 | Financial index calculation method and device |
CN110795474A (en) * | 2018-08-03 | 2020-02-14 | 上海小渔数据科技有限公司 | Data processing method and device for content generation |
CN109408584A (en) * | 2018-10-17 | 2019-03-01 | 平安科技(深圳)有限公司 | Report display method, apparatus, computer installation and storage medium |
CN109408584B (en) * | 2018-10-17 | 2023-07-18 | 平安科技(深圳)有限公司 | Report display method, report display device, computer device and storage medium |
CN109740134A (en) * | 2018-12-17 | 2019-05-10 | 泰康保险集团股份有限公司 | Report generation method and device |
CN114154471A (en) * | 2021-11-12 | 2022-03-08 | 航天信息股份有限公司 | System and method for one-key conversion of report |
Also Published As
Publication number | Publication date |
---|---|
CN105608151B (en) | 2019-02-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9727836B2 (en) | Systems and methods for generating data visualization dashboards | |
US8041714B2 (en) | Filter chains with associated views for exploring large data sets | |
US6647390B2 (en) | System and methods for standardizing data for design review comparisons | |
Goldstein | Power and sample size via MS/PC-DOS computers | |
CN105608151A (en) | Financial statement analysis device and method | |
US7730023B2 (en) | Apparatus and method for strategy map validation and visualization | |
US8370181B2 (en) | System and method for supply chain data mining and analysis | |
US20120246170A1 (en) | Managing compliance of data integration implementations | |
US20040102926A1 (en) | System and method for monitoring business performance | |
US20100100562A1 (en) | Fully Parameterized Structured Query Language | |
CN103678468B (en) | The system and method for improved consumption model for profiling | |
US20040041838A1 (en) | Method and system for graphing data | |
US7523090B1 (en) | Creating data charts using enhanced SQL statements | |
US9026466B2 (en) | Financial audit scoping workbench | |
CN112860769B (en) | Energy planning data management system | |
US8145635B1 (en) | Dimensional data explorer | |
CN112667612A (en) | Data quality checking method and device, electronic equipment and storage medium | |
US7992126B2 (en) | Apparatus and method for quantitatively measuring the balance within a balanced scorecard | |
CN117056352A (en) | Data display method, device, terminal equipment and readable storage medium | |
US20090177534A1 (en) | System for performing personnel evaluations and computer program thereofor | |
CN115906213A (en) | Editing method and system of visual chess evaluation statistical model | |
CN113050846B (en) | Component-based time-space big data visualization configuration method and system | |
JP2003296538A (en) | Cost diagnostic device, and cost diagnostic program | |
CN113010611A (en) | Method and system for automatically generating relations between relational database tables | |
US8200732B2 (en) | Apparatus and method for calculating and visualizing targets |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |