Africa Capital Structure - Firms

Data for listed firms in Africa to analyze their capital structure

@kaggle.waalbannyantudre_africa_capital_structure_firms

Table List

1 table(165.74 KB)

Africa Capital Structure Firms

@kaggle.waalbannyantudre_africa_capital_structure_firms.africa_capital_structure_firms

165.74 KB
639 rows
37 columns

company Company	company_id Company ID	year Year	total_equity Total Equity	total_assets Total Assets	receivables Receivables	booklev_debt_ratio BookLev(Debt Ratio)	mkt_debt_ratio Mkt(Debt Ratio)	profitability_ratio Profitability Ratio	size_ln_total_assets Size (ln Total Assets)	tangible_ratio_fixed_asset_ratio Tangible Ratio (Fixed Asset Ratio)	effective_tax_rate Effective Tax Rate	liquidity_ratio Liquidity Ratio	asset_turn_over Asset Turn Over	change_in_receivables Change In Receivables	current_asset Current Asset	ppe PPE	total_liabilities Total Liabilities	current_liabilities Current Liabilities	cashflow_from_operations Cashflow From Operations	operating_expenses Operating Expenses	revenue Revenue	change_in_revenue Change In Revenue	gross_profit Gross Profit	operating_profit Operating Profit	profit_before_tax Profit Before Tax	net_income Net Income	auditor Auditor	audit_fee Audit Fee	audit_days Audit Days	tac TAC	rule_of_law Rule Of Law	financial_sector_rating Financial Sector Rating	institutional_quality Institutional Quality	macroeconomic_mgt Macroeconomic Mgt.	accountability_and_corruption Accountability And Corruption	profit_tax Profit Tax
ARM	1	2008	2127543000	6198192000	795666000	1.024892097566516	0.7491111165880368	0.1137870527405411	22.54752347356692	0.5724233776559358	0.2863363810333829	1.378475374289168	1.3417530527832937	795666000	2344544000	3547990000	6352478000	1700824000	597122000	986509000	4619473000	4619473000	1674670000	705274000	705450000	503454000	Deloitte & Touche	16630	90	-93668000	3.5	4	3.5	3.5	4	17.6
ARM	1	2009	4191030000	10332044000	1140778000	1	0.7114226643753244	0.0908744678206945	23.058515970784956	0.6616317158540943	0.3193164641820401	1.0286114141670455	2.0082412958115947	345112000	3194254000	6836008000	10332044000	3105404000	858094000	934868000	5144822000	525349000	1854831000	938919000	948714000	645774000	Deloitte & Touche	21750	71	-212320000	3.5	4	3.5	3.5	4	17.6
ARM	1	2010	4926859000	14091554000	1287433000	1	0.7409426853859994	0.0950411856634122	23.368841447761916	0.613472509845259	0.0338681823817884	1.7490066567613871	2.3625035416879725	146655000	5073536000	8644781000	14091554000	2900810000	803586000	882799000	5964670000	819848000	2098688000	1339278000	1112962000	1075268000	Deloitte & Touche	33460	111	271682000	3.5	4	3.5	3.5	4	17.6
ARM	1	2011	6102526000	15714579000	1067752000	1	0.7202870866689233	0.104115802275072	23.477854717145718	0.5929609695557228	0.1558530558099129	1.6733207576824936	1.9208647313186469	-219681000	5940702000	9318132000	15714579000	3550247000	2038584000	962496000	8180992000	2216322000	2630539000	1636136000	1362912000	1150498000	Deloitte & Touche	43960	137	-888086000	3.5	4	3.5	4	4	18
ARM	1	2012	7105928000	21413958000	1146518000	1	0.7508430433417581	0.104639926911223	23.78730878934686	0.4421195278332011	0.3042279042124877	2.54883558160116	1.878323617005432	78766000	11485777000	9467529000	21413958000	4506284000	1293458000	1088547000	11400569000	3219577000	3229173000	2240755000	1790296000	1245638000	Deloitte & Touche	36350	126	-47820000	3.5	3.5	3.5	3.5	4	18
ARM	1	2013	8140534000	23514676000	1583961000	1	0.7428374665655353	0.0999134327855506	23.880890573809204	0.4061338969756589	0.3256187314380568	2.659649231268419	1.6583913572605748	437443000	13508401000	9550107000	23514676000	5079016000	2916815000	1322596000	14179208000	2778639000	3446915000	2349432000	2000060000	1348803000	Deloitte & Touche	42850	90	-1568012000	4	3.5	3.5	3	4	18
ARM	1	2014	9211308000	29641033000	1840246000	1	0.7629149811075734	0.0622376419877134	24.11242548831895	0.3286418864011926	0.2600125958001777	1.553837729283499	2.156780469738274	256285000	19366342000	9741285000	29641033000	12463555000	923621000	1721433000	13743185000	-436023000	3724789000	1844788000	2018133000	1493393000	Deloitte & Touche	42850	150	569772000	3.5	3	3.5	2	3.5	18
ARM	1	2015	12053399000	38679348000	2469595000	1	0.7624138310507806	-0.0312896691019714	24.37857165113297	0.3673918184970439	1.8168164952321968	1.3951348804980448	2.624831432492649	629349000	23935453000	14210476000	38679348000	17156372000	-190035000	2031193000	14735936000	992751000	4345141000	-1210264000	3539156000	-2890841000	Deloitte & Touche	46430	119	-2700806000	4	3	3.5	3	3.5	18
ARM	1	2016	25300202000	40850495000	3163292000	1	0.6175368794678007	0.0083711592723662	24.433184775682065	0.3386084060915296	0.2792149430296194	3.412536941268151	4.239416841810749	693697000	26484590000	13832321000	40850495000	7760968000	-1279015000	1629489000	9635876000	-5100060000	2403096000	341966000	-1248368000	-899805000	Deloitte & Touche	56980	118	379210000	4	3	3.5	3	3	18
ARM	1	2017	20852380000	36835714000	2104512000	1	0.6385323460331347	-0.0721032311196682	24.329733700631618	0.3216838690842262	0.1754983094987357	1.8882906544266973	5.319010860766344	-1058780000	24983917000	11849455000	36835714000	13230970000	-522891000	1638266000	6925294000	-2710582000	242658000	-2655974000	-5123924000	-4224684000	Deloitte & Touche	59780	150	-3701793000	4	3	3.5	3.5	3.5	18.5


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,
  "mkt_debt_ratio" DOUBLE,
  "profitability_ratio" DOUBLE,
  "size_ln_total_assets" DOUBLE,
  "tangible_ratio_fixed_asset_ratio" DOUBLE,
  "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,
  "accountability_and_corruption" DOUBLE,
  "profit_tax" DOUBLE
);