brill06/East-Africa-Financial-Health-Tracker
Domain:
socioeconomicCreator:
bri
Host:
Built an interactive Excel dashboard to monitor key financial indicators, helping track performance and support data-driven decision-making.
# East Africa Financial Health Tracker
A multi-sheet Excel dashboard comparing the economic health of five East African countries — Kenya, Uganda, Tanzania, Rwanda, and Ethiopia — across GDP, Inflation, and FDI from 2020 to 2024.
---
## Overview
This workbook is designed as a decision-support tool for analysts, investors, and policymakers who need a clean, formula-driven reference for regional economic performance.
**Countries:** Kenya · Uganda · Tanzania · Rwanda · Ethiopia
**Indicators:** GDP (USD B) · Inflation Rate (%) · FDI Inflows (USD B)
**Period:** 2020 – 2024
---
## Workbook Structure
| Sheet | Contents |
|-------|----------|
| Dashboard | KPI highlight boxes and navigation overview |
| GDP Data | Annual GDP with CAGR and delta formulas |
| Inflation Data | Annual inflation rates with year-on-year change |
| FDI Data | FDI inflows with trend formulas |
| Country Summary | Scorecard with RAG health ratings per country |
| Charts | GDP line chart and Inflation bar chart |
---
## Key Features
- **CAGR formula** — auto-calculates compound annual growth rate across all indicators
- **RAG health ratings** — each country rated 🟢 Strong / 🟡 Moderate / 🔴 Caution based on 2024 data
- **Colour-coded tabs** — each sheet has a distinct tab colour for quick navigation
- **Dynamic formulas** — update any year column and all calculations refresh automatically
---
## Key Findings
| Country | Highlight |
|---------|-----------|
| Ethiopia | Highest GDP growth (+26.7%) but inflation peaked at 33.9% in 2022 |
| Tanzania | Most consistent FDI growth — $1.05B (2020) to $1.21B (2024) |
| Kenya | Best overall stability — moderate inflation, solid growth, improving FDI |
| Rwanda | Small but high-reform economy with strong upward momentum |
| Uganda | Stable growth but FDI declining — needs structural investment |
---
## How to Open
Open `EastAfrica_Financial_Health_Tracker.xlsx` in:
- Microsoft Excel 2016 or later *(recommended)*
- LibreOffice Calc 7+
- Google She …