JP6866054B2 - Systems, methods, and programs to support ESG management - Google Patents

Description

The present invention relates to systems, methods, and programs for supporting ESG management.

Conventionally, various systems for supporting management have been provided (see, for example, Patent Document 1 below). Recently, "Environmental" and "Socia"
E, which is an acronym for "l (society)" and "Governance (corporate governance)"
The concept / viewpoint of SG is drawing attention. Since ESG is a source of future corporate value enhancement and should be closely linked to corporate vision, strategy, and business plans, it is also considered that ESG should be applied to the management support system as described above.

Japanese Unexamined Patent Publication No. 2019-8691

However, conventionally, there is no technology for quantitatively collecting information on ESG as data and visualizing it in a format useful for business management, and as a result, ESG information separated from management and business is not available. It was merely qualitatively managed and disclosed. Therefore, ES
It is desired to realize a mechanism for actively supporting ESG management that utilizes G information for management.

An object of the present invention is to provide a platform for supporting ESG management.
Let's do it. Other objects of the present invention will become apparent by reference to the entire specification.

The system according to the embodiment of the present invention is a management support system for supporting ESG management, and is a storage unit configured to store information and the storage unit that collects ESG data in a specific company. It includes a data collecting unit configured to be stored in the storage unit, and an information output unit configured to output information based on at least the ESG data stored in the storage unit.

According to this configuration, ESG information in a specific company is quantitatively collected as data.
Since the information based on the data is output, for example, quantitative analysis of ESG data and visualization of the result are realized, and as a result, ESG management in the company is supported.

Further, in the above system, the data collecting unit is configured to collect financial data in addition to ESG data and store it in the storage unit, and the information output unit is stored in the storage unit. In addition to the ESG data, the information may be configured to output at least information based on the financial data stored in the storage unit. In this way, visualization of the result of analysis (for example, correlation analysis) of the combination of ESG information and financial information (sales, operating profit, etc.) is realized, and as a result, for example, both ESG target and performance target are compatible. (For example, providing an index that can evaluate the status of compatibility).

The method according to the embodiment of the present invention is a management support method for supporting ESG management, which is executed by one or more computers, and includes a step of collecting ESG data in a specific company and storing it in a storage unit. The step of outputting information based on at least the ESG data stored in the storage unit is provided.

According to this configuration, ESG information in a specific company is quantitatively collected as data.
Since the information based on the data is output, for example, quantitative analysis of ESG data and visualization of the result are realized, and as a result, ESG management in the company is supported.

The program according to the embodiment of the present invention is a management support program for supporting ESG management, which includes a process of collecting ESG data of a specific company on one or a plurality of computers and storing the ESG data in a storage unit. A process of outputting information based on at least ESG data stored in the storage unit and a process of outputting information are executed.

According to this configuration, ESG information in a specific company is quantitatively collected as data.
Since the information based on the data is output, for example, quantitative analysis of ESG data and visualization of the result are realized, and as a result, ESG management in the company is supported.

Various embodiments of the present invention provide a platform for supporting ESG management.

It is a block diagram which shows schematic structure of the network including the management support system 10 which concerns on one Embodiment of this invention. It is a figure which illustrates the basic menu screen 50. It is a figure which illustrates the visualization / analysis function menu screen 60. It is a figure which illustrates the CO2 emission amount data screen 611. It is a figure which illustrates the financial data correlation analysis result (CO2 emission amount) screen 612. It is a figure which illustrates the occupational accident number data screen 621. It is a figure which illustrates the financial data correlation analysis result (the number of occupational accidents) screen 622. It is a figure which illustrates the emergency situation number data screen 631. It is a figure exemplifying the financial data correlation analysis result (number of emergencies) screen 632. It is a figure which illustrates a part of the analysis screen 70 which shows the result of the empirical analysis. It is a figure which illustrates a part of the materiality evaluation screen 80.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a configuration diagram schematically showing a configuration of a network including a management support system 10 according to an embodiment of the present invention. As shown in the figure, the system 10 is communicably connected to the information processing terminal 30 and the core system 40 of the target company via a communication network NW such as the Internet. The system 10 provides an ESG management support service for supporting ESG management by the target company via the information processing terminal 30. In FIG. 1, only the information processing terminal 30 and the core system 40 in one target company are shown, but the system 10 includes the information processing terminal 30 and the core system 40 in each of the plurality of target companies. It is connected so that it can communicate. ESG management support services can be said to be a platform built on the cloud of service providers. System 10
This is an example of a device that implements all or part of the management support system of the present invention.

The management support system 10 has a configuration as a general computer. Specifically, as shown in the figure, the system 10 includes a computer processor 11 configured as a CPU or GPU, a main memory 12 composed of a DRAM or the like for temporarily storing data or programs, and a user or the like. It includes an input / output interface 13 for exchanging information between them, a communication interface 14 for controlling wired or wireless communication, and a storage 15 composed of a magnetic disk, a flash memory, or the like for storing data or programs. The computer processor 11 reads the program stored in the storage 15 or the like into the main memory 12 and executes the instructions included in the program.

The input / output interface 13 includes, for example, an information input device such as a keyboard, a mouse, and a touch panel, a voice input device such as a microphone, an image input device such as a camera, an image output device such as a display, and a voice output device such as a speaker. .. The communication I / F 14 is implemented as hardware such as a network adapter, various communication software, or a combination thereof.

In the present embodiment, the storage 15 of the management support system 10 is as shown in the figure.
It has an ESG database 151 that manages ESG data and a financial database 152 that manages financial data. These ESG and financial data are associated with the corresponding target company. That is, ESG database 151 and financial database 152
Is configured to store ESG data and financial data in association with each of the plurality of target companies.

Further, in the present embodiment, the management support system 10 executes the instructions included in the program stored in the storage 15 or the like by the computer processor 11, and as shown in the figure, the data collection unit 111 and the information output. It is configured to function as part 112.

The data collection unit 111 is configured to perform various processes related to the collection of ESG data and financial data. For example, the data collection unit 111 collects ESG data and financial data of the target company from the core system 40 of the target company, and stores the collected ESG data and financial data in the ESG database 151 and the financial database 152, respectively. It is configured in. Some ESG data and financial data include data by company, location, and area within a corporate group. Such data collection and storage in the database is realized by, for example, batch processing executed at a predetermined timing (for example, at night), or is performed according to an instruction from a person in charge of the target company or the like.

In this embodiment, the ESG data may include various information about the ESG. For example, ESG data includes information on climate change, pollution, resources, etc. as environmental data on the environment (E), and is composed of, for example, data on CO2 emissions, data on resource utilization, and the like. Data on resource utilization shows the degree of realization of recycling of resources in the target company, for example, recycling material usage amount, recycling material usage rate, waste amount, recycling amount, recycling rate, final disposal. It is composed of the amount and final disposal rate. Environmental data includes various other data, specifically, data such as CO2 emissions, water usage, waste treatment, number of environmental accidents / complaints, energy utilization, and pollutant emissions. .. For example, CO2 emissions for each plant, equipment, and production base are collected from the environmental compliance module of the ERP package included in the core system 40 and the like.

In addition, for example, ESG data includes information on safety / health, labor standards, human rights, etc. as social data on society (S), for example, data on employee attribute diversity (diversity), employees. It is composed of data on work styles. Diversity data shows the degree of promotion of diversity, and is calculated from three indicators, for example, gender, nationality, and employee ratio by age. The value increases as each is divided into equal parts, and 100 is set to be the maximum value. Data on work styles show the degree of realization of diverse and flexible work styles, and are composed of, for example, paid leave acquisition rate, childcare leave acquisition rate, remote work system application rate, flextime system application rate, etc. There is. Social data includes various other data, specifically, total working hours, number of occupational accidents, number of illness deficiencies,
Includes data such as occupational accident loss costs, overtime work hours, ratio of female managers, and the number of harassment cases. For example, the total working hours per person is E included in the core system 40 and the like.
Collected from the personnel module of the RP package or obtained from admission / exit management data.

In addition, for example, ESG data includes information on compliance risk management, anti-corruption, etc. as corporate governance data related to corporate governance (G), for example, data on diversity of raw material procurement (sustainable procurement). It is composed of data on R & D efficiency. Data on sustainable procurement is provided by the supplier E
E that SG's efforts were scored and classified into three ranks (A, B, C; in descending order of evaluation)
Includes SG evaluation and sustainable procurement index. The Sustainable Procurement Index is calculated by calculating the degree of sustainable procurement for each raw material from the number of trading companies and the ratio of transaction amount with suppliers with high ESG evaluation (that is, A rank). It is set to approach 100 as the number of trading companies increases and the number of transactions with suppliers with high ESG evaluation increases. Data on R & D efficiency includes input item data and output item data.
Input item data is composed of, for example, R & D expenses, number of researchers, number of alliances, number of qualified personnel, etc., and output item data is, for example, sales, gross profit, operating profit, etc.
It is composed of new product sales, number of defects, number of complaints, number of patent applications, number of treatises, number of awards, etc. per total sales. Corporate governance data includes various other data, specifically, compliance-related training attendance rate, awareness survey score, number of emergencies, number of reports, number of outside directors, executive compensation / employee salary ratio, and Includes data such as the number of internal audits conducted.

The information output unit 112 is configured to execute various processes related to the output of information based on ESG data and financial data, and as shown in the figure, the scoring unit 1121, the visualization / analysis unit 1122, and the future prediction unit 112. It has a part 1123 and.

The scoring unit 1121 is configured to execute various processes related to the scoring function in the ESG management support service. For example, the scoring unit 1121 calculates and outputs the achievement level of the ESG target for each instruction based on the ESG data of the target company stored in the ESG database 151 (transmits to the information processing terminal 30). )
It is configured as follows. ESG targets for each index of the target company are E, as with ESG data.
It is stored in the SG database 151. Also, for example, the scoring unit 1121
Is configured to set and output company rankings within the industry based on the degree of achievement of ESG goals. As the index, various items included in the ESG data can be applied.

The visualization / analysis unit 1122 is configured to execute various processes related to the visualization / analysis function in the ESG management support service. For example, the visualization / analysis unit 1122 is configured to process and output ESG data and / or financial data so as to have a specific expression format (graph expression, etc.). Also, for example, the visualization / analysis unit 1122
It is configured to perform a correlation analysis of ESG data and financial data and output the result of the correlation analysis. Furthermore, the visualization / analysis unit 1122 has a function to analyze the impact of ESG and finance on corporate value and visualize the analysis results (hereinafter referred to as corporate value evaluation / analysis function).

The future prediction unit 1123 is configured to execute various processes related to the future prediction function in the ESG management support service. For example, the Future Prediction Unit 1123 will use ESG data and financial data, as well as aging data as a result of their correlation analysis.
It is configured to calculate and output the future fluctuation range of G data and financial data. Further, for example, the future prediction unit 1123 proposes K based on the calculated future fluctuation range.
It is configured to set the PI index.

The information processing terminal 30 has a configuration as a general computer. Specifically, as shown in FIG. 1, the information processing terminal 30 includes a computer processor 31 configured as a CPU or GPU, and a main memory 32 composed of a DRAM or the like and temporarily storing data or programs. A storage 35 that is composed of an input / output interface 33 that exchanges information with users, a communication interface 34 that controls wired or wireless communication, a magnetic disk, a flash memory, or the like, and stores data or programs.
And. The computer processor 31 reads the program stored in the storage 35 or the like into the main memory 32 and executes the instruction included in the program.

The input / output interface 33 includes, for example, an information input device such as a keyboard, a mouse, and a touch panel, a voice input device such as a microphone, an image input device such as a camera, an image output device such as a display, and a voice output device such as a speaker. .. The communication I / F 34 is implemented as hardware such as a network adapter, various communication software, or a combination thereof.

The information processing terminal 30 is configured as, for example, a personal computer, a smartphone, a tablet terminal, or the like. The information processing terminal 30 displays various screens with communication with the system 10 via a web browser or other application installed in the storage 35 or the like. The information processing terminal 30 is operated by a person in charge of the target company or the like.

FIG. 2 illustrates a basic menu screen 50 of the ESG management support service displayed on the information processing terminal 30. The screen 50 is a screen that serves as a starting point when using the ESG management support service, and as shown in the figure, the first screen displayed as "ESG Scoring".
Menu button 51 and "ESG Visualize and Analytics"
2nd menu button 52 displayed as "ESG Future prophecy"
It has a third menu button 53 labeled "ion".

The first menu button 51 corresponds to the scoring function in the ESG management support service of the present embodiment, and when the button 51 is selected, a screen for using the scoring function on the information processing terminal 30 is displayed. Then, the person in charge of the target company can use the scoring function through the screen. The scoring function is E for each index.
A function to display the achievement level of the SG goal is included.

The second menu button 52 is visualized in the ESG management support service of the present embodiment.
Corresponding to the analysis function, when the button 52 is selected, the information processing terminal 30 displays a screen for using the visualization / analysis function.

The third menu button 53 corresponds to the future prediction function in the ESG management support service of the present embodiment, and when the button 53 is selected, a screen for using the future prediction function on the information processing terminal 30 is displayed. Then, the person in charge of the target company can use the future prediction function through the screen. The future forecasting function includes a function of displaying the future fluctuation range of ESG data and financial data.

Here, the visualization / analysis function corresponding to the second menu button 52 will be described. FIG. 3 is a diagram illustrating a visualization / analysis function menu screen 60 displayed on the information processing terminal 30 according to the selection of the second menu button 52. As shown in the figure, the screen 60 includes a first menu button 61 for visualizing and analyzing an index related to the environment (E).
It has a second menu button 62 for visualizing and analyzing indicators related to society (S), and a third menu button 63 for visualizing and analyzing indicators related to corporate governance (G).

When any of the first to third menu buttons 61 to 63 is selected, a plurality of indicators included in the corresponding classification (any of environment (E), society (S), and corporate governance (G)) ( A screen for selecting a desired index is displayed from (preset for each classification), and the person in charge of the target company can select an index for visualization / analysis through the screen. it can.

FIG. 4 is a diagram illustrating a CO2 emission data screen 611 displayed on the information processing terminal 30 when "CO2 emission" is selected as an index related to the environment (E). The screen 611 is a diagram exemplifying the CO2 emission data screen 611. It is a screen that displays the result of visualization of CO2 emissions, and as shown in the figure, a graph (for example, a pie chart) showing CO2 emissions by country (area) in a specific period (for example, a specific year) is displayed. The first display area 6111 to be displayed and a graph showing the CO2 emissions and emission intensity of each year in a specific period (for example, 10 years) in chronological order (for example, a composite graph of a bar graph and a line graph) are displayed. The second display area 6112 to be displayed and
A third display area 6113 that displays a bubble chart showing CO2 emissions by country (area) in a specific period (for example, a specific year) and a continuation button 6114 that displays "Next". And have.

When the continue button 6114 is selected, the correlation analysis between the CO2 emission data and the financial data is executed, and the information processing terminal 30 executes the financial data correlation analysis result (CO2 emission) screen 612 illustrated in FIG. Is displayed. The screen 612 is a screen that displays the result of the correlation analysis between the CO2 emission data and the financial data (sales and operating profit margin), and as shown in the figure, the correlation between the CO2 emission and the sales. First display area 6 for displaying the analysis results
It has 121 and a second display area 6122 that displays the result of the correlation analysis between the CO2 emission intensity and the operating profit margin. The first display area 6121 displays a graph (for example, a composite graph of a bar graph and a line graph) showing CO2 emissions and sales for each year in a specific period (for example, 10 years) in chronological order. Along with, a scatter plot as a result of these correlation analyzes is displayed. A regression line is automatically added to the scatter plot. In addition, the second display area 61
22 displays a graph (for example, a composite graph of a bar graph and a line graph) showing the CO2 emission intensity and the operating profit ratio of each year in a specific period (for example, 10 years) in chronological order, and correlates these. Display a scatter chart as a result of the sexual analysis. A regression line is automatically added to the scatter plot.

In the example of FIG. 5, the correlation analysis is a combination of CO2 emissions and sales, as well as CO.
Although it is performed for a combination of 2 emission intensity and operating profit margin, in the present embodiment, it is performed.
The items of financial data used in the correlation analysis are not limited to sales and operating profit margin, and other items may be selected as the items used in the correlation analysis. The selection of the items to be used for the correlation analysis may be performed manually by the person in charge of the target company, or may be automatically performed by the system 10 (for example, the items of ESG data (in the example of FIG. 5). ,
It is automatically selected according to the amount of CO2 emissions). ) You may do it. Further, the correlation analysis may be executed in advance in a batch process at night or the like.

When "resource use" is selected as an index related to the environment (E), various information related to resource use is displayed on the information processing terminal 30. As an example, data on the amount of circulating materials used and performance management data (sales / gross profit / operating profit / sales volume / production) collected in the core system 40 are combined and information on the same graph. It is displayed on the processing terminal 30.

FIG. 6 is a diagram illustrating a work accident number data screen 621 displayed on the information processing terminal 30 when “work accident number” is selected as an index related to society (S). The screen 621 is a screen that displays the result of visualization of the number of occupational accidents, and as shown in the figure, a graph (for example, a graph showing the number of occupational accidents by country (area) in a specific period (for example, a specific year)). The first display area 6211 for displaying pie charts, etc., and graphs (for example, bar graphs and line graphs) showing the number of occupational accidents and the annual occupational accident rate of 1,000 people in a specific period (for example, 10 years) in chronological order. Second display area 621 for displaying a composite graph of a graph, etc.
2, the third display area 6213 that displays a bubble chart showing the number of occupational accidents by country (area) in a specific period (for example, a specific year) on a map, and the continuation that displays "Next". It has a button 6214 and.

When the continue button 6214 is selected, the correlation analysis between the occupational accident number data and the financial data is executed, and the financial data correlation analysis result (occupational accident number) screen 622 illustrated in FIG. 7 is executed on the information processing terminal 30. Is displayed. The screen 622 is a screen that displays the result of the correlation analysis between the number of occupational accidents data and the financial data, and as shown in the figure, the first screen that displays the result of the correlation analysis between the number of occupational accidents and sales. It has a display area 6221 and a second display area 6222 that displays the result of the correlation analysis between the annual occupational accident rate of 1,000 people and the operating profit rate. The first display area 6221 is a graph showing the number of occupational accidents and sales in each year in a specific period (for example, 10 years) in chronological order (for example, a composite graph of a bar graph and a line graph).
And a scatter plot as a result of these correlation analyzes. A regression line is automatically added to the scatter plot. In addition, the second display area 6222 is a graph (for example, 10 years) showing the annual occupational accident rate of 1,000 people and the operating profit rate of each year in a time series (for example, 10 years).
For example, a composite graph of a bar graph and a line graph) is displayed, and a scatter diagram as a result of these correlation analyzes is displayed. A regression line is automatically added to the scatter plot.

In the example of FIG. 7, the correlation analysis is performed on the combination of the number of occupational accidents and sales, and the combination of the annual labor accident rate of 1,000 people and the operating profit margin. In the embodiment, the items of financial data used in the correlation analysis are not limited to sales and operating profit margin, and other items may be selected as the items used in the correlation analysis.
The selection of the items to be used for the correlation analysis may be performed manually by the person in charge of the target company, or may be automatically performed by the system 10 (for example, the items of ESG data (in the example of FIG. 7). , It may be automatically selected according to the number of occupational accidents).

When "diversity" is selected as an index related to society (S), various information related to diversity is displayed on the information processing terminal 30. As an example, the information processing terminal 30 displays data on diversity in the base year and an index showing a relative evaluation when the company-wide value of sales per employee is set to 100. Further, when "work style" is selected as an index related to the society (S), various information about the works tile is displayed on the information processing terminal 30. As an example, data on work styles (paid leave acquisition rate, childcare leave acquisition rate, remote work system application rate,
The flextime system application rate, etc.) and the profit data (operating profit margin / sales / operating profit) collected in the core system 40 are combined on the same graph and displayed on the information processing terminal 30.

FIG. 8 is a diagram illustrating an emergency situation number data screen 631 displayed on the information processing terminal 30 when "emergency number number" is selected as an index related to corporate governance (G). The screen 631 is a screen that displays the result of visualization of the number of emergencies, and as shown in the figure, is a classification (for example, "terrorism", "strike", "for example" in a specific period (for example, a specific year). The first display area 6311 that displays a graph (for example, a pie chart) showing the number of emergencies by different (for example, "robbery / theft", "natural disaster", etc.) and each year in a specific period (for example, 10 years) A second display area 6312 that displays a graph showing the number of emergencies and the emergency pre-recognition rate in chronological order (for example, a composite graph of a bar graph and a line graph), and a continuation button 6314 displayed as "Next". Has.

When the continue button 6314 is selected, the correlation analysis between the emergency number data and the financial data is executed, and the financial data correlation analysis result (emergency number) screen 632 illustrated in FIG. 9 is executed on the information processing terminal 30. Is displayed. The screen 632 is a screen that displays the result of the correlation analysis between the number of emergencies data and the financial data, and as shown in the figure, displays the result of the correlation analysis between the pre-emergency recognition rate and the operating profit margin. It has a display area 6321 to be used. The display area 6321 displays a graph (for example, a composite graph of a bar graph and a line graph) showing the emergency pre-recognition rate and the operating profit rate of each year in a specific period (for example, 10 years) in chronological order. At the same time, a scatter plot as a result of these correlation analyzes is displayed.
A regression line is automatically added to the scatter plot.

In the example of FIG. 9, the correlation analysis is performed for the combination of the emergency advance recognition rate and the operating profit rate. As described above, the financial data used in the correlation analysis in the present embodiment. The item of is not limited to the operating profit margin, and other items may be selected as the items used for the correlation analysis. The selection of the items to be used for the correlation analysis may be performed manually by the person in charge of the target company, or may be automatically performed by the system 10 (for example, the items of ESG data (in the example of FIG. 9). , It may be automatically selected according to the number of emergencies).

When "sustainable procurement" is selected as an index related to corporate governance (G), various information related to sustainable procurement is displayed on the information processing terminal 30. As an example, the information processing terminal 30 shows a supplier distribution map in which the ESG evaluation of a supplier is set on the vertical axis and an arbitrary QCD evaluation (non-defective product rate, cost reduction, delivery date compliance rate) is set on the horizontal axis.
Is displayed in. In addition, when "R & D efficiency" is selected as an index related to corporate governance (G), a part of input item data and output item data collected in the core system 40 (for example, R & D cost / (Sales / Gross profit / Operating profit) and other data are combined on the same graph and displayed on the information processing terminal 30.

In this way, the person in charge of the target company obtains the results of the correlation analysis of the visualized ESG data and the similarly visualized ESG data and financial data through the screens exemplified in FIGS. 4 to 9. It can be easily recognized. Next, the corporate value evaluation / analysis function realized by the visualization / analysis unit 1122 will be described in detail.

<Corporate value evaluation / analysis function>
The corporate value evaluation / analysis function is a "price book value ratio (PBR)" as an index showing corporate value.
This is a function to empirically analyze PBR by a regression model that explains “return on equity (ROE)” and “non-financial capital (ESG)”. In this embodiment, in order to measure how many years later the key performance indicator (KPI of ESG) will affect PBR in the target company (so-called delayed penetration effect), ROE and ESG are used as explained variables. Let's use the KPI of the above as an explanation variable, and use a regression model that considers the shift of the year between the PBR (explained variable) and the KPI (explanatory variable) of ESG. The regression model to be used is shown in the following equations (1) and (2). The visualization / analysis unit 1122 enables a large amount of regression analysis at one time while applying KPIs of multiple ESGs one by one to the regression models shown in the following equations (1) and (2) and shifting the year. It has a verification tool to do. The PBR, ROE, and ESG indicators are obtained from the storage 15 of the management support system 10 and the core system 40 of the target company.
<Regression model>
PBRi = α + β1 ・ ROEi + β2 ・ (ESG KPIi-t) + εi-t ・
・ ・ (1)
ln (PBRi) = α + β1 ・ ln (ROEi) + β2 ・ ln (ESG KPIi)
−T) + γi−t ・ ・ ・ (2)

When the above empirical analysis is performed, the visualization / analysis unit 1122 determines which ESG KPI correlates with the PBR after how many years (in other words, how much time difference is associated with the PBR). After grasping it, the significance of the correlation and the positive / negative are displayed in a table format so that it can be discriminated by the color (color type, shade of color, etc.).

FIG. 10 is an analysis screen 70 showing the result of the empirical analysis displayed on the information processing terminal 30.
It is a figure which illustrates a part of. Note that FIG. 10 shows the result (regression coefficient) of the logarithmic conversion model shown in (2) above, and only the values with the degree of freedom adjusted count of 0.5 or more and the p-value of 0.1 or less are colored.
As shown in FIG. 10, for example, in the case of ESG KPI “labor cost (million yen)”, 7
It can be seen that there is a significant positive correlation with the PBR after 4 years, and that the ESG KPI "renewable energy consumption (TJ)" has a significant positive correlation with the PBR after 4 years.

By checking the analysis screen 70, the management of the target company will check each ESG in the target company.
Each of these efforts has a correlation with PBR with a time difference, and when they have a correlation, it is possible to quickly grasp the significance and positive / negative. In addition, it should be noted.
In the above example, the significance of the correlation and the sign of the correlation can be discriminated by the color, but symbols and numbers may be used instead of (or in addition to) the color. In addition, either the significance level or the positive / negative value may be discriminated by the color.

In addition, the analysis results explained above may be used for management decisions by plotting them according to the important issues (materiality) of the target company. The visualization / analysis unit 1122 plots the ESG analysis results on the materiality matrix according to the instructions input via the input / output I / F 13. Information necessary for materiality evaluation is obtained from the storage 15 of the management support system 10.
FIG. 11 is a diagram illustrating a part of the materiality evaluation screen 80 displayed on the information processing terminal 30. In FIG. 11, among the results of regression analysis using the measured values of ESG KPIs, only significant results are displayed. The extraction conditions for significant results are as follows.
<Extraction conditions for significant results>
-Targets ESG KPIs with 10 or more data observations, 0.5 or more degrees of freedom-adjusted decision counts, and 0.1 or less p-values.

In FIG. 11, the correlation between the ESG KPIs and PBRs (here, “concatenation” is represented) for which significant results were obtained is displayed in the “correlation” column for colors (color types, shades of color, etc.). It is expressed by. Specifically, if there is a positive correlation with PBR, the "correlation" column is painted in red, and if there is a negative correlation with PBR, the "correlation" column is painted. It is applied in blue. The strength of significance is expressed by the shade of color. The stronger the significance, the darker the color, and the weaker the significance, the lighter the color.
In addition, in FIG. 11, the number of years after which the KPI of the ESG for which a significant result was obtained affects the PBR is shown in the column of “years”. ESG that works positively for PBR
KPIs are written in red, and ESG KPIs that work negatively against PBR are written in blue.
To give an example, for the materiality of "promoting diversity"
It can be seen that the ESG KPI of "female manager ratio (%)" has a correlation with PBR two years later, and although it is less significant, it has a positive correlation with PBR.
By checking the materiality evaluation screen shown in Fig. 11, the management team of the target company can determine which ESG KPI has a correlation with PBR for each materiality of the target company. It is possible to quickly grasp how many years later the correlation with PBR will be. In addition, the management of the target company said that the ESG KPI (that is, ESG activity), which had been emphasized so far, has a correlation with PBR, or unlike the assumption, there is no correlation with PBR. It can be confirmed promptly.

The management support system 10 according to the embodiment of the present invention described above quantitatively collects ESG information in a specific company as data, and information based on the data (for example, achievement degree of ESG target of each index, each index). Since each of the ESG data and financial data of the above, and the results of their correlation analysis and future forecasts, etc.) are output, for example, quantitative analysis of ESG data and visualization of the results are realized, and this result is realized. , ESG management in the company is supported.

In another embodiment of the present invention, the data collection unit 111 is configured to collect ESG data from the outside and store it in the ESG database 151 in addition to the ESG data of the target company. External ESG data includes, for example, the supplier company (for example, raw material producer / broker, processor, manufacturer, distributor, distributor, etc.) and / or customer of the target company. Includes ESG data in the enterprise. In addition, ESG data from the outside includes, for example, various statistical data. In this way, ESG data can be enriched by connecting ESG data in various companies.

10 ... Management support system, 11 ... Computer processor, 111 ... Data collection department,
112 ... Information output unit, 1121 ... Scoring unit, 1122 ... Visualization / analysis unit, 112
3 ... Future Prediction Department, 15 ... Storage, 151 ... ESG Database, 152 ... Financial Database, 30 ... Information Processing Terminal, 40 ... Core System, 50 ... Basic Menu Screen, 60
… Visualization / analysis function menu screen, 70… analysis screen, 80… evaluation screen, 611… CO2
Emissions data screen, 612 ... Financial data correlation analysis result (CO2 emissions) screen, 621
… Occupational accident number data screen, 622… Financial data correlation analysis result (occupational accident number) screen, 631… Emergency number data screen, 632… Financial data correlation analysis result (emergency number) screen.

Claims (7)

A management support system to support ESG management
A storage unit configured to store information,
Environmental data related to the environment (E) in a specific company, social data related to society (S), ESG data including corporate governance data related to corporate governance (G), and financial data including sales and operating income in the specific company. , A data collection unit configured to collect from the core system of the specific company and store it in the storage unit.
And an information output unit configured to output information based on the ESG data and the financial data stored in the storage unit,
The information output unit
Correlation analysis of the ESG data and the financial data stored in the storage unit is executed, and the result of the correlation analysis is visualized and displayed using a graph and a scatter diagram.
Management support system. The information output unit
The management support system according to claim 1, wherein a regression line is added to the scatter plot. The management support system according to claim 1 or 2 , wherein the ESG data includes at least one of data indicating carbon dioxide emissions as the environmental data and data indicating the degree of realization of recycling of resources in the specific company. .. A management support system to support ESG management
A storage unit configured to store information,
Environmental data related to the environment (E) in a specific company, social data related to society (S), ESG data including corporate governance data related to corporate governance (G), and financial data including sales and operating income in the specific company. , A data collection unit configured to collect from the core system of the specific company and store it in the storage unit.
An information output unit configured to output information based on the ESG data and the financial data stored in the storage unit is provided.
The information output unit
It is a regression model that explains the price-to-book value ratio (PBR) of the specific company by return on equity (ROE) and non-financial capital (ESG). Using the evaluation index (KPI) as an explanatory variable, we analyzed using a regression model that takes into consideration the shift of KPI years between PBR and ESG.
As a result of the above analysis, a management support system that displays which ESG KPI has a correlation with PBR after how many years, the significance of the correlation, and / or whether it is positive or negative by color. .. In the storage unit, important issues of the specific company are stored.
The information output unit
Which ESG KPI correlates with PBR after how many years with respect to the important issue of the specific company stored in the storage unit, the significance of the correlation, and / or positive or negative. The management support system according to claim 4 , wherein is displayed in a distinguishable manner by color. A management support method for supporting ESG management, which is executed by one or more computers.
The computer performs sales and operating income of the specific company together with ESG data including environmental data related to the environment (E), social data related to society (S), and corporate governance data related to corporate governance (G) in the specific company. A storage process that collects financial data including the data from the core system of the specific company and stores it in the storage unit.
The computer includes an output step of outputting information based on the ESG data and the financial data stored in the storage unit .
In the output step, the correlation analysis of the ESG data and the financial data stored in the storage unit is executed, and the result of the correlation analysis is visualized and displayed using a graph and a scatter diagram.
Management support method. A management support program to support ESG management, with one or more computers
Environmental data related to the environment (E) in a specific company, social data related to society (S), ESG data including corporate governance data related to corporate governance (G), and financial data including sales and operating income in the specific company. , The storage process that collects from the core system of the specific company and stores it in the storage unit,
An output process for outputting information based on the ESG data and the financial data stored in the storage unit is executed .
In the output process, the correlation analysis of the ESG data and the financial data stored in the storage unit is executed, and the result of the correlation analysis is visualized and displayed using a graph and a scatter diagram.
Management support program.

Images