brill06/East-Africa-Financial-Health-Tracker

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 …