ESG & Financial Resilience Research

PROJECT TITLE: Academic Panel Data Collection — ESG Disclosure & Financial Resilience of Firms in Emerging Markets ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ DATABASE ACCESS REQUIREMENT ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ You MUST have active access to ALL THREE of the following databases to apply: 1. Refinitiv Eikon (LSEG) 2. Bloomberg Terminal 3. Orbis (Bureau van Dijk) Please do not apply if you do not have verified access to all three. When submitting your proposal, confirm which databases you can access and briefly describe your experience extracting academic panel data from each. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ PROJECT OVERVIEW ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ This is a data collection task for an academic research project. The study is confidential and the title will be shared only with the selected freelancer after hiring. The research examines the relationship between ESG and climate-related disclosure and the financial resilience of firms in emerging market economies. The study uses a quantitative panel design covering fiscal years 2013 to 2022. I need a clean, well-structured panel dataset delivered in Excel (.xlsx) format covering all variables listed below. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ PART 1 — FIRM SELECTION CRITERIA ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Firms must meet ALL of the following criteria to be included: 1. FIRM TYPE Small and medium-sized firms defined as: — Total Assets of USD 500 million or below (in any year of the study period), OR — Fewer than 250 employees (where asset data is unavailable) Important: Do NOT pre-filter by size inside the database. Extract all firm sizes and I will apply the threshold during my own analysis. 2. GEOGRAPHY — EMERGING MARKETS ONLY Include firms headquartered in the following countries only: Asia-Pacific: China, India, Indonesia, South Korea, Malaysia, Thailand, Vietnam GCC / MENA: Saudi Arabia, United Arab Emirates, Egypt Africa: South Africa, Nigeria, Kenya Latin America: Brazil, Mexico EMEA: Turkey, Poland Minimum required: at least 10 different countries must be represented in the final dataset 3. ESG DATA AVAILABILITY — MANDATORY FILTER This is the most critical criterion. Every firm included MUST have at least one non-missing value for each of the following: — ESG Score (from Refinitiv Eikon or Bloomberg) — Emissions Score or Carbon Disclosure score — Energy Efficiency Score Firms with no ESG data at all must be excluded before exporting. If applying all three ESG filters returns fewer than 50 firms, remove the Emissions and Energy filters, keep only ESG Score, and message me before exporting. 4. FINANCIAL DATA AVAILABILITY Each firm must have at least 3 consecutive years of non-missing financial data (liquidity or profitability ratios) within the 2013–2022 window. 5. STUDY PERIOD Fiscal years 2013 to 2022 (10 years). Include all available years for each firm — do not drop firms with partial coverage. 6. SECTOR EXCLUSIONS Exclude the following sectors entirely: — Financial Services (banks, insurance companies) — Real Estate Investment Trusts (REITs) All other sectors are eligible. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ PART 2 — VARIABLES REQUIRED ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Extract ALL variables listed below. For time-varying variables, provide annual data for every available year from 2013 to 2022. The preferred source database is shown — use the alternative if the primary source has missing data for a firm. --- A. FIRM IDENTIFIERS (static, one value per firm) --- Variable | Primary Source | Field Name in Database --------------------------|-----------------------|------------------------------- Unique Firm ID / RIC | Refinitiv Eikon | Instrument (RIC) Company Name | Any | Company Name Country of Headquarters | Any | Country of Headquarters ISIN Code | Any | ISIN Code GICS Sector | Refinitiv / Bloomberg | GICS Sector Name Industry Code | Refinitiv Eikon | TRBC Industry Code Date of Incorporation | Orbis / Refinitiv | Date of Incorporation --- B. DEPENDENT VARIABLES — Financial Resilience (annual, 2013–2022) --- Variable | Primary Source | Field Name --------------------------|-----------------------|------------------------------- Current Ratio | Orbis / Refinitiv | Current Ratio Quick Ratio | Orbis / Refinitiv | Quick Ratio Cash Ratio | Orbis / Refinitiv | Cash Ratio Return on Assets (ROA) | Orbis / Refinitiv | Return on Assets (Actual) Return on Equity (ROE) | Orbis / Refinitiv | Return on Equity (Actual) EBIT Margin (%) | Orbis / Refinitiv | EBIT Margin % Interest Coverage Ratio | Orbis / Bloomberg | Interest Coverage Ratio Operating Status | Orbis | Operating Status (Active / Inactive / Dissolved) NOTE on Operating Status: Orbis is the only reliable source for this. Please flag every firm that shows as inactive, dissolved, or insolvent at any point during 2013–2022. --- C. INDEPENDENT VARIABLES — ESG & Climate Disclosure (annual, 2013–2022) --- Variable | Primary Source | Field Name -------------------------------|-----------------------|------------------------------- ESG Score | Refinitiv Eikon | ESG Score ESG Combined Score | Refinitiv Eikon | ESG Combined Score Emissions Score (Carbon) | Refinitiv Eikon | Emissions Score Energy Efficiency Score | Refinitiv Eikon | Policy Energy Efficiency Score Carbon Emissions (tCO2e) | Bloomberg / Refinitiv | Total CO2 Equivalent Emissions CDP Climate Score | Bloomberg | CDP Climate Change Score (if available) --- D. CONTROL VARIABLES — Firm Level (annual, 2013–2022) --- Variable | Primary Source | Field Name -------------------------------|-----------------------|------------------------------- Total Assets (USD) | Orbis / Refinitiv | Total Assets Number of Employees | Orbis / Refinitiv | Employees Average Total Debt to Equity | Orbis / Refinitiv | Total Debt to Common Equity Cash Flow (USD) | Orbis / Refinitiv | Cash Flow Market Capitalisation | Refinitiv / Bloomberg | Market Cap Long Term Growth Rate | Refinitiv | Long Term Growth Mean --- E. CONTROL VARIABLES — Country Level (annual, per country, 2013–2022) --- Variable | Primary Source | Notes -------------------------------|-----------------------|------------------------------- GDP Growth Rate (%) | Refinitiv / Bloomberg | Annual real GDP growth rate Inflation Rate (%) | Refinitiv Eikon | Inflation Rate Period End Climate Policy Statement | Refinitiv Eikon | Climate Policy Statement ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ PART 3 — DELIVERABLE FORMAT ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Deliver TWO Excel files: FILE 1 — Wide format (raw database export) One row per firm Separate columns for each variable per year Example: Current_Ratio_2013, Current_Ratio_2014 ... Current_Ratio_2022 File name: Data_Wide_[date].xlsx FILE 2 — Long (panel) format One row per firm per year Columns: firm_id, company_name, country, year, then all variables as single columns File name: Data_Panel_[date].xlsx This is the format required for statistical analysis ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ PART 4 — QUALITY CHECKS BEFORE DELIVERY ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Before sending the files, include answers to ALL of the following in your delivery message: Q1. Total number of firms in the dataset? Q2. Total number of firm-year observations (rows in panel format)? Q3. How many firms have a non-missing ESG Score for at least one year? Q4. How many firms have all 3 disclosure variables (ESG + Emissions + Energy) for at least one year? Q5. How many different countries are represented? Q6. What fiscal year range is covered (earliest to latest)? Q7. How many firms have Operating Status data from Orbis? Q8. Which database was used as the primary source for financial variables? MINIMUM THRESHOLDS — do not deliver if any of these are not met: — At least 100 firms total — At least 30 firms with all 3 disclosure variables — At least 10 countries represented — Financial data covering at least 5 years per firm on average If thresholds are not met, message me before delivering and we will adjust the screen together. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ PART 5 — HOW TO APPLY ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ In your proposal please include: 1. Confirmation of which databases you have access to 2. Brief description of your experience with academic panel data collection 3. Estimated delivery time 4. Your proposed price Proposals that do not confirm database access will not be considered.

ID do Projeto: 40318737