{"text_format":"1","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["COUNTRY - African countries that Low Income (LIC) and Lower Middle Income (LMIC) ","CLIMATE VULNERABILITY - Position on database of all countries: 1- lowest vulnerability. 187 = highest vulnerability.","DEBT STATUS  (World Bank) (extra data marked * from https://data.debtjustice.org.uk/)","EXTERNAL PUBLIC DEBT OWED by each LIC/ LMIC = Total external debt stocks (world Bank) - public and publicly guaranteed  January 2025","DEBT OWED TO THE IMF by each LIC / LMIC  = 'Use of IMF credit  (DOD, current US$)'","TOTAL EXTERNAL DEBT (including IMF) owed by each LIC / LMIC - columns D+E","TOTAL CLIMATE DEBT OWED by Rich Countries based on historic and projected atmospheric appopriation - Low-range estimates - looking only at emmisions from 1992 (working on US$ equivalents 2010)","TOTAL CLIMATE DEBT OWED by Rich Countries based on historic and projected atmospheric appopriation - mid-range estimates looking at emmisions since 1960 (working on US$ equivalents 2010)","ANNUAL DEBT PAYMENTS made in 2023 by low and lower-middle income countries to their creditors in rich countries ","ANNUAL DEBT PAYMENTS  made by LICs / LMICs to the IMF (IMF repurchases and charges)","TOTAL ANNUAL DEBT PAYMENTS  made by low and lower-middle income countries                                      (adding column i + j)","ANNUAL CLIMATE DEBT owed by rich countries based on low-range estimates (total divided by 25 yers to 2050)","ANNUAL CLIMATE DEBT owed by rich countries based on mid-range estimates (total divided by 25 yers to 2050)","EXTERNAL DEBT PAYMENTS AS % OF NATIONAL REVENUE made by low and lower-middle income countries (2024)","HEALTH SPENDING AS % OF NATIONAL REVENUE - World Health Organisation","EDUCATION SPENDING AS % OF NATIONAL REVENUE - UNESCO Global Education Monitoring Report 2024","ILLICIT FINANCIAL FLOWS leaving LICs and LMICs","Presently paying  IMF SURCHARGES?   ","Slavery reparations? ","Failure to meet aid targets"]
["World Bank country classifications by income level for 2024-2025"," Rankings // Notre Dame Global Adaptation Initiative // University of Notre Dame","https://www.worldbank.org/en/programs/debt-toolkit/dsa   (extra data from https://data.debtjustice.org.uk/)","Total external debt stocks (world Bank) - public and publicly guaranteed  January 2025","World Development Indicators | DataBank","columns D+E","(Estimates for the amount each LIC /LMIC is entitled to receive)   https://www.nature.com/articles/s41893-023-01130-8","(Estimates of the amount that each country is entitled to receive) https://www.nature.com/articles/s41893-023-01130-8","Debt service on external debt, public and publicly guaranteed (PPG) (TDS, current US$) | Data","World Development Indicators | DataBank","Adding column i and j","Column G divided by 25 years to give an annual amount of climate debt owed to the country if all is paid by 2050","Column H divided by 25 years to give an annual amount of climate debt owed to the country if all is paid by 2050","Debt data portal","GHO | By category | Domestic general government health expenditure (GGHE-D) as percentage of general government expenditure (GGE) (%) - Data by country","https://unesdoc.unesco.org/ark:/48223/pf0000391406/PDF/391406eng.pdf.multi","State-of-Tax-Justice-2024-English-Tax-Justice-Network.pdf ","International Monetary Fund Lifts Veil on Surcharges - Center for Economic and Policy Research","Cannot find data that is credibly disaggregated by country ","Cannot find data that is credibly disaggregated by country "]
[]
["Burkina Faso  ",162,"Moderate",4900139222.6,632346311,5532485533.6,820000000000,1100000000000,230033179,27800248.5,257833427.5,32800000000,44000000000,8.7,9.84,21.9,11900000]
["Burundi",174,"High",607085974.9,435441543,1042527517.9,480000000000,660000000000,27134797,17299948.3,44434745.3,19200000000,26400000000,6.6,7.33,20.64,1200000]
["Central African Repulblic",186,"High",442796838,504139050,946935888,200000000000,270000000000,6538661,31499566.6,38038227.6,8000000000,10800000000,13.9,6.42,10.74,1700000]
["Chad",187,"High",2215097557.2,964325006,3179422563.2,630000000000,860000000000,367485752,49179718.8,416665470.8,25200000000,34400000000,14.8,4.87,16.72,69000000]
["Democratic Rep Congo",184,"Moderate",6467510546,3997330077,10464840623,3500000000000,4800000000000,399174296,78179277.4,477353573.4,140000000000,192000000000,7.8,4.34,18.41,90600000]
["Eritrea",185,"* IN DEBT CRISIS",628285476.2,40784071,669069547.2,140000000,190000000000,15909396,1550165,17459561,5600000,7600000000,"n/a",2.35,"n/a",800000]
["Ethiopia",155,"IN DISTRESS",31914034150.4,1161232457,33075266607.4,null,"n/a",1413618591,144805689.9,1558424280.9,0,null,6,7.1,23.01,213300000]
["The Gambia",151,"High",982634486.9,251088094,1233722580.9,87000000000,120000000000,39750732,9953340.1,49704072.1,3480000000,4800000000,23,7.54,14.48,10900000]
["Guinea Bissau",182,"High",1018181455,108381409,1126562864,null,"n/a",44962065,7171847.8,52133912.8,0,null,23.7,4.6,"n/a",1500000]
["Liberia ",167,"Moderate",1274045820.7,726948775,2000994595.7,180000000000,250000000000,34731570,55399055.6,90130625.6,7200000000,10000000000,8.4,3.66,11.73,947900000]
["Madagascar ",178,"Moderate",4482340747.7,134353315,4616694062.7,1100000000000,1400000000000,177570163,67532231.8,245102394.8,44000000000,56000000000,15,5.27,13.85,25400000]
["Malawi ",167,"IN DISTRESS",2876075400.8,714608098,3590683498.8,750000000000,1000000000000,110017154,40009465.5,150026619.5,30000000000,40000000000,25.4,5.76,"n/a",51300000]
["Mali ",180,"Moderate",5540991604.5,850776826,6391768430.5,790000000000,1100000000000,306268360,49514565.1,355782925.1,31600000000,44000000000,10.5,4.96,18.19,12800000]
["Mozambique ",153,"High",9523920082.8,1070704644.9,10594624727.699999,1200000000000,1600000000000,581514326,41918489.8,623432815.8,48000000000,64000000000,14.2,8.15,"n/a",134600000]
["Niger ",176,"Moderate",4833771077.5,735782327,5569553404.5,980000000000,1300000000000,147920366,43283221.9,191203587.9,39200000000,52000000000,16.1,8.75,12.37,16300000]
["Rwanda ",126,"Moderate",7230880896.6,813435479,8044316375.6,500000000000,680000000000,304308571,55461755.9,359770326.9,20000000000,27200000000,10.2,9.47,12.5,30100000]
["Sierra Leone ",179,"High",1344715324.1,880219765,2224935089.1,300000000000,410000000000,70217332,75468489.6,145685821.6,12000000000,16400000000,15.5,6.85,9.1,1200000]
["Somalia",164,"Moderate",1996933695.1,374635736,2371569431.1,640000000000,880000000000,60017206,347076877.3,407094083.3,25600000000,35200000000,6.2,"n/a",4.2,25500000]
["Sudan",183,"IN DISTRESS",15364548059.5,2401192744,17765740803.5,null,"n/a",159511441,40715177.5,200226618.5,0,null,41.9,7.86,"n/a",4600000]
["Togo",126,"Moderate",2029689483.5,595137789.5,2624827273,300000000000,410000000000,175126929,27554783.5,202681712.5,12000000000,16400000000,16.2,2.56,14.48,3600000]
["Uganda",163,"Moderate",13158278513.6,1907267824.1,15065546337.7,1700000000000,2300000000000,933848821,26478205.9,960327026.9,68000000000,92000000000,14.3,4.88,8.48,93800000]
["Angola",160,"* IN DEBT CRISIS",45215431910.1,5449429790,50664861700.1,1100000000000,1500000000000,10625843348,472054595.9,11097897943.9,44000000000,60000000000,64.7,8.78,13.1,162000000,"YES "]
["Benin",159,"Moderate",7171518906,1141974132,8313493038,440000000000,600000000000,792534737,38052415.5,830587152.5,17600000000,24000000000,31.4,1.6,17.19,5000000,"YES "]
["Cape Verde",80,"Moderate",1933793921.1,110827273,2044621194.1,16000000000,22000000000,134957527,1626205.8,136583732.8,640000000,880000000,21.8,15.74,15.11,5000000]
["Cameroon ",155,"High",12025447467.6,2055437786,14080885253.6,930000000000,1300000000000,1415171193,90830064.6,1506001257.6,37200000000,52000000000,21,2.86,12.77,35000000]
["Comoros ",167,"High",348112436.8,60773606,408886042.8,null,"n/a",10450028,8447198.6,18897226.6,0,null,20.7,4.72,10.48,500000]
["Rep ,Congo ",174,"IN DISTRESS",6864903469.8,706466847,7571370316.8,180000000000,250000000000,399174296,11985096.8,411159392.8,7200000000,10000000000,22.5,8.22,16.63,72600000]
["Cote d’Ivoire  ",134,"Moderate",29168830424.1,4002292913.2,33171123337.3,930000000000,1300000000000,2774238389,434387720.5,3208626109.5,37200000000,52000000000,29,5.06,16.39,57900000,"YES "]
["Djibouti",142,"High",2836358659.1,103894866,2940253525.1,29000000000,39000000000,49093193,2327915.6,51421108.6,1160000000,1560000000,29.9,4.2,8.6,5100000]
["Egypt",102,"* IN DEBT CRISIS",117380489561.4,19319376392,136699865953.4,2500000000000,3400000000000,15185599031,3916917469.9,19102516500.9,100000000000,136000000000,42.9,6.8,12,224200000,"YES "]
["Eswatini",130,"No risk",773239588.5,257883650,1031123238.5,22000000000,30000000000,74695498,24192979.7,98888477.7,880000000,1200000000,10.1,12.3,16.62,28500000]
["Ghana ",112,"IN DISTRESS",28538104558,3630001073,32168105631,1100000000000,1500000000000,536650504,178184931.5,714835435.5,44000000000,60000000000,9.2,8.2,13.18,66100000]
["Guinea ",154,"Moderate",3931210042.3,845336356,4776546398.3,510000000000,700000000000,205766669,61522340.8,267289009.8,20400000000,28000000000,18.3,4.49,11.95,7200000]
["Kenya",145,"High",35863712408.8,3799188290,39662900698.8,1900000000000,2500000000000,3403904539,118119372.3,3522023911.3,76000000000,100000000000,28.7,9.29,17.9,333300000,"YES "]
["Lesotho ",138,"Moderate",998543298.4,176795824,1175339122.4,70000000000,95000000000,69318176,12658791.6,81976967.6,2800000000,3800000000,7.3,7.95,12.9,17500000]
["Mauritania ",157,"Moderate",3749372024,595950841,4345322865,160000000000,220000000000,359620633,18069694.5,377690327.5,6400000000,8800000000,21,8.34,5.04,35300000]
["Morocco ",67,"* High",45116709743.6,3915614350,49032324093.6,1100000000000,1500000000000,3548290003,164122720.3,3712412723.3,44000000000,60000000000,18.3,7.18,23.87,1128200000]
["Nigeria ",152,"n/a",44073668768.1,7873960876,51947629644.1,7200000000000,9900000000000,3576627085,1168649660.2,4745276745.2,288000000000,396000000000,20.1,4.06,4.4,206600000]
["Sao Tome and Principe",137,"IN DISTRESS",370751010.9,61460541,432211551.9,7500000000,10000000000,4302944,2079782.5,6382726.5,300000000,400000000,12.5,13.14,17.09,19700000]
["Senegal",144,"Moderate",16906911406.3,2266353610,19173265016.3,600000000000,820000000000,1286208264,134147971.8,1420356235.8,24000000000,32800000000,31.2,4.37,22.17,58700000,"YES "]
["Tanzania",148,"Moderate",22575278289.6,1759847854,24335126143.6,2300000000000,3100000000000,1866771584,29167648.8,1895939232.8,92000000000,124000000000,19.4,5.14,14.33,151000000]
["Zambia",133,"IN DISTRESS",15868372366.4,2450342125,18318714491.4,670000000000,910000000000,350918274,71758499.2,422676773.2,26800000000,36400000000,33,9.25,10.45,93800000]
["Zimbabwe",171,"IN DISTRESS",5108699306.2,1363159095,6471858401.2,470000000000,640000000000,107531184,51829140.2,159360324.2,18800000000,25600000000,4.9,5.21,15.7,29400000]
[null,null,null,565651415980.6998,81246499431.7,646897915412.4,36391640000000,49666000000000,52383326807,8248984338.400001,60632311145.399994,1455665600000,1986640000000,null,null,null,2575600000,"that is 10 countries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"that is 42 billion a year"]
[null,null,null,"that is 565 billion","that is 81 billion","that is 646 billion","that is 36 trillion ","that is 49.6 trillion","that is 52 billion","that is 8 billion","that is 60 billion","that is 1.4 trillion","that is 1.9 trillion"]
[null,null,"Of 43 low and lower-middle income African countries studied",null,null,null,"that is roughly US$ 4 trillion every year for 25 years",null,null,null,null,null,null,"Colour code comparing spending on debt servicing and health",null,"Colour code education spending versus debt and banchmarks"]
[null,null,"11 in debt distress/crisis",null,null,null,null,null,null,null,null,null,null,"28 = Debt repayments more than double health spending",null,"7 = Debt repayments more than double education spending"]
[null,null,"12 high risk of crisis",null,null,null,null,null,null,null,null,null,null,"6 = Debt repayments exceed health spending",null,"16 = Debt repayments exceed education spending"]
[null,null,"18 at moderate risk",null,null,null,null,null,null,null,null,null,null,"7 = Debt and health spending about equal",null,"11 = educaiton spending exceeds debt spending but falls short of 20%"]
[null,null,"0 low risk",null,null,null,null,null,null,null,null,null,null,"0 = Health spending  exceeeds debt servicing",null,"4 = education spending spending  exceeds debt servicing and is over 20% benchmark"]
[null,null,"1 no risk",null,null,null,null,null,null,null,null,null,null,"2 = no data",null,"5 = insufficient data"]
[null,null,"1 no data",null,null,null,null,null,null,null,null,null,null,null,null,"60% of countries with data have higher spending on debt than education"]
[null,null,74,null,null,null,null,null,null,null,null,null,null,null,null,"Just 10% of countries are meeting the widely recognised banchmark of spending 20% of revenue on education"]