Boldwin0732/Zambia-Economic-recovery

Zambia macroeconomic analysis (2015-2025): Power BI dashboard + Storytelling with Data PPTX examining whether debt restructuring or copper prices drove the recovery. IMF, World Bank, Bank of Zambia data. \# Zambia Macroeconomic Analysis — Impact of Debt Restructuring (2015–2025) \*\*Tools:\*\* Power BI Desktop · Power Query · DAX \*\*Period:\*\* 2015–2025 | \*\*Country:\*\* Zambia \## Overview This project analyses Zambia's macro-fiscal transition across a decade of data (2015–2025), with a focus on two central questions: Did debt restructuring restore investor confidence? And how much of Zambia's economic recovery was copper-driven versus structurally anchored? The analysis covers monetary policy, external trade, industrial composition, and sovereign debt dynamics — built and visualised entirely in Power BI Desktop. \## The analytical question | Period | Phase | |--------|-------| | 2015–19 | Debt spiral — external debt tripled from $12.3B to $29.1B | | Nov 2020 | COVID shock + Eurobond default (first African sovereign default of the pandemic era) | | 2021–22 | Copper price supercycle + IMF ECF programme ($1.3B) approved | | Nov 2023–24 | G20 Common Framework deal finalised; bilateral agreements implemented | \## Key findings 1\. \*\*Copper front-loaded the recovery.\*\* The current account swung from -3.6% to +11.9% of GDP between 2015 and 2021 — before the restructuring deal was signed. 2\. \*\*Debt restructuring locked in sustainability.\*\* PPG debt service fell from 12.5% to 3% of exports post-deal. Growth of 5.2–5.4% persisted as copper prices cooled. 3\. \*\*Investor confidence confirmed.\*\* FDI net inflows hit a decade-high 9.32% of GDP in 2024, the same year bilateral restructuring agreements were implemented. 4\. \*\*The verdict: both were necessary.\*\* Copper created the fiscal breathing room; debt restructuring converted it into a durable institutional framework. \## Dashboard pages \- \*\*Welcome\*\* — project context and navigation \- \*\*Overview\*\* — KPI cards, GDP vs external debt combo chart, debt service and reserves trends \- \*\*Trend analysis\*\* — inflation/exc …