Data for 'Monopsony Rent Surcharges for SDG Financing: The Case of Japan'

Published: 19 February 2024| Version 1 | DOI: 10.17632/yktyfs9hrm.1
Mihoko Shimamoto


The shortage of financial resources for achieving the Sustainable Development Goals (SDGs) is a serious issue. This study attempts to estimate the amount of monopsony rent surcharges which would be able to be imposed on large corporations in Japan as a financial resource for achieving SDGs. Using the dynamic pseudo-equilibrium approach and mathematical programming, the results show that the average total amount of monopsony rent of 5581 Japanese companies was 10,098.4 billion yen per year in the 2010s. Additionally, the sum of the corporate income tax rate and monopsony rent rate consistently remained at approximately 50% from 1980 to 2020, while the corporate income tax rate declined from approximately 44.7% to less than 27.9%. These folders contain the data and programs used for the above estimation, and a brief explanation of them is given below. You can obtain the results by loading the programs in the folder 'ExcelMacro&MatlabPrograms' while referring to the explanations from 1) to 7). 1) ExcelMacro&MatlabPrograms This folder includes the program files available for Macro in Excel and MATLAB to do data processing, calculations, and processing of results. 2) 1RawData This folder includes the files that had been downloaded accounting data of Japanese listed companies from Nikkei Needs Financial Quest data base. 3) 2ProcessedData They are the data files processed by loading the programs from 1 to 8 in dataprocessing.xlsb one by one. 4) 3InputData This folder includes the processed data after loading ReturntoScale2023L.m and processing the program 9 in dataprocessing.xlsb. They are input data for rent calculation by RentCal2023Japan.m. 5) 4Results The rent calculation results by RentCal2023Japan.m are in the folder ‘4Results’. 6) 5ProcessedResults Macro 123, 13(Ave), 14(T), and 15(TS) in resultprocessing.xlsb were loaded to process the results of the calculation together with input data files to create summary tables of results. 7) Tables This folder includes the tables quoted in the manuscript which were created by data extracted from the files in ‘5ProcessedResults’.



Hosei Daigaku


Environmental Economics, Ecological Economics