IDA (World Bank) Statement of Credit and Grants - Cape Verde

📊 Project description

This project is part of the Data Analytics Accelarator Bootcamp by Avery Smith.

About IDA (International Development Association)

The International Development Association (IDA) credits are public and publicly guaranteed debt extended by the World Bank Group. IDA provides development credits, grants and guarantees to its recipient member countries to help meet their development needs. Credits from IDA are at concessional rates. Data are in U.S. dollars calculated using historical rates. This dataset contains historical snapshots of the IDA Statement of Credits and Grants including the latest available snapshot. Source: World Bank

💾 The Data

The data for this project can be found on the website of World Bank. We downloaded the CSV file from the website and imported it to SQL and Tableau for analysis.

In this dataset we have the following information 👇

Nº Rows: 1.12 million
Each row is a Credit or Grant at a specific time (month and year).
Nº columns: 30

The main columns used in this project are:

End of Period;
Credit Number;
Country;
Credit Status;
Project Name;
Disbursed Amount;
Repaid to IDA;
Due to IDA

👉 Visit this link for more information about the dataset and data dictionary.

🕵️ The Task

We will analyze the loans and credit of IDA, and answer the following questions:

What are the Top 10 debtors of IDA
How much did Cape Verde disburse from 2012 to 2022?
How much does Cape Verde owe to IDA?
What are the Top 10 Cape Verde Projects by amount disbursed?

📈 Analyses

To analyze our data, we had to use SQL because the CSV file had more than 1 million rows, making it very difficult to use Excel.

2. What are the Top 10 debtors of IDA?

To answer the first question, I executed the following SQL query, and used Tableau to plot the data:

SELECT country, SUM ("Due to IDA") AS "Total_Due" 
FROM "IDA_Finance" 
WHERE "End of Period" = '12/31/2021 12:00:00 AM' 
GROUP BY "country"
ORDER BY "Total_Due" Desc
LIMIT 10;

As we can see India, Bangladesh,and Pakistan are the Top 3 debtors. The Top 10 countries are from the Asian and African Continent, as we can see below

2. How much did Cape Verde disburse from 2012 to 2022?

By ploting the data, of disbursed amount, it’s possible to see a trend in the stock of amout Cape Verde disbursed each year.

Taking a closer look to the individual amount disbursed for year, it’s possible to see that from 2019 to 2021 the amout disbursed were significantly greater than in the previous years. This may be due to face the economic consequence of Covid-19.

3. How much does Cape Verde owe to IDA?

First I filtered the data only for “Cape Verde” and “Cabo Verde” (they are the same country) using the following query:

SELECT * 
FROM "IDA_Finance" 
WHERE "country" = ('Cabo Verde', 'Cape Verde');

As of November 2022, Cape Verde owed 458 Million USD to the World bank.

Cape Verde also repays to IDA every year, as we can see in the chart below:

4. What are the Top 10 Cape Verde Projects by amount disbursed?

After plotting a bubble chart, we can see that the top projects, by amount disbursed are:

Cabo Verde - Transport Sector Reform
Cabo Verde DPO
Cabo Verde DPF FY22
(…)

✏️ Conclusion

The Top Five countries with the most amount due to IDA are, India, Bangladesh, Pakistan, Nigeria and Vietnam
As of Nov 2022, Cape Verde owed about 458 Million USD to IDA.
The stock of repayment Cape Verde made to IDA was 96.6 Million USD as of Nov2022.

Thank you for reading, if you have any feedback feel free to conect with on LinkdIn