Africa Capital Structure - Firms
Data for listed firms in Africa to analyze their capital structure
@kaggle.waalbannyantudre_africa_capital_structure_firms
Data for listed firms in Africa to analyze their capital structure
@kaggle.waalbannyantudre_africa_capital_structure_firms
This is a panel data for listed firms in Africa to analyze their capital structure.
Cite this dataset
{Asiedu, Michael (2021), “Africa capital structure - firms”,
Mendeley Data, V1,
doi: 10.17632/8dv486w9w7.1}
CREATE TABLE africa_capital_structure_firms (
  "company" VARCHAR,
  "company_id" BIGINT,
  "year" BIGINT,
  "total_equity" DOUBLE,
  "total_assets" BIGINT,
  "receivables" BIGINT,
  "booklev_debt_ratio" DOUBLE  -- BookLev(Debt Ratio),
  "mkt_debt_ratio" DOUBLE  -- Mkt(Debt Ratio),
  "profitability_ratio" DOUBLE,
  "size_ln_total_assets" DOUBLE  -- Size (ln Total Assets),
  "tangible_ratio_fixed_asset_ratio" DOUBLE  -- Tangible Ratio (Fixed Asset Ratio),
  "effective_tax_rate" DOUBLE,
  "liquidity_ratio" DOUBLE,
  "asset_turn_over" DOUBLE,
  "change_in_receivables" DOUBLE,
  "current_asset" BIGINT,
  "ppe" BIGINT,
  "total_liabilities" DOUBLE,
  "current_liabilities" BIGINT,
  "cashflow_from_operations" DOUBLE,
  "operating_expenses" BIGINT,
  "revenue" BIGINT,
  "change_in_revenue" DOUBLE,
  "gross_profit" VARCHAR,
  "operating_profit" BIGINT,
  "profit_before_tax" BIGINT,
  "net_income" BIGINT,
  "auditor" VARCHAR,
  "audit_fee" DOUBLE,
  "audit_days" DOUBLE,
  "tac" BIGINT,
  "rule_of_law" DOUBLE,
  "financial_sector_rating" DOUBLE,
  "institutional_quality" DOUBLE,
  "macroeconomic_mgt" DOUBLE  -- Macroeconomic Mgt.,
  "accountability_and_corruption" DOUBLE,
  "profit_tax" DOUBLE
);Anyone who has the link will be able to view this.