Jeremiah Kasuzumira
Health Financing & Catastrophic Cost Burden
SQL
R
Case Study 06

Health Financing & Catastrophic Cost Burden Tracker

Malawi's health system runs mostly on donor funding and household out-of-pocket payments — government contributes under 10% of total health spending. This tracks where the money actually comes from, and models the share of households pushed into catastrophic health spending at different cost thresholds, using the same purchasing-power lens applied to the Kwacha tracker.

⚠ Population-level economic data only — WHO/World Bank/NSO household survey statistics, not individual medical information or advice. No personal health data is used or implied anywhere in this tool.
Govt Share of Health Spending
9.4%
Down from 21.6% in 2005/06
Catastrophic Expenditure
1.37%
Of households nationally (combined threshold)
Health Spend Per Capita
$39.66
−16.7% from 2021 peak
Impoverished by Health Costs
1.6%
Of the population, pushed below the poverty line
Health Spending vs. GDP Per Capita 2018–2023, current US$
Health spending is a small, volatile slice of an already-low national income
GDP per capita
Health spend per capita
Government Share of Health Financing confirmed years only
Government's own contribution has fallen sharply since the mid-2000s; the gap is filled mostly by external donors
Catastrophic Expenditure Threshold Simulator
Move the threshold to see the modeled share of Malawian households whose out-of-pocket health spending exceeds it, as a percentage of non-food expenditure. Curve is fit to two published anchor points from a national household survey study — not a live national statistic.
4.0% of households exceed this threshold
Anchored at two confirmed points: 9.37% of households at a 10% threshold, 0.73% at a 40% threshold (Malawi IHS-based catastrophic expenditure study). Values in between are modeled with an exponential decay fit, not independently confirmed.
Household Impact
52%+
Of non-food budget spent on health by households already over the threshold
60.7%
Of total health spending came from external donors (2005/06, last full breakdown)
−41%
Real decline in public health spending, 2019–2021 (pandemic-era shock)
9.3%→9.4%
Government health share, 2012 to 2019 — essentially flat for seven years
Methodology — SQL & R
SQL classifies households from survey microdata into catastrophic-expenditure bins across multiple thresholds. R fits the exponential decay curve that powers the live simulator above, anchored to the two confirmed published data points.
SQLcatastrophic expenditure classification
-- Classify households against a given
-- threshold of non-food expenditure
WITH household_ratios AS (
  SELECT
    household_id,
    region,
    health_expenditure,
    nonfood_expenditure,
    health_expenditure / NULLIF(nonfood_expenditure, 0)
      AS health_share
  FROM household_survey
)
SELECT
  region,
  COUNT(*) AS total_households,
  SUM(CASE WHEN health_share > 0.10 THEN 1
      ELSE 0 END) AS above_10pct,
  SUM(CASE WHEN health_share > 0.40 THEN 1
      ELSE 0 END) AS above_40pct
FROM household_ratios
GROUP BY region;
Rexponential decay fit, two anchor points
# Fit incidence(threshold) = a * exp(-b * x)
# using the two confirmed survey anchors
anchors <- data.frame(
  threshold = c(10, 40),
  incidence = c(9.37, 0.73)
)

b <- log(anchors$incidence[1] / anchors$incidence[2]) /
     (anchors$threshold[2] - anchors$threshold[1])
a <- anchors$incidence[1] / exp(-b * anchors$threshold[1])

catastrophic_incidence <- function(threshold_pct) {
  a * exp(-b * threshold_pct)
}

# catastrophic_incidence(20) -> ~4.0%
Data & Scope Notes

Government health spending share (9.3% in 2012, 9.4% in 2019) and the historical 2005/06 financing mix (government 21.6%, external donors 60.7%, private 18.2%, of which out-of-pocket accounted for 12.1 percentage points) are drawn from published National Health Accounts research and Oxford Health Policy and Planning journal analysis. Catastrophic expenditure figures (1.37% national incidence, 1.6% impoverished, 52%+ average overshoot) are from a peer-reviewed multilevel logistic regression study using Malawi's Integrated Household Survey. The 9.37%/0.73% threshold anchors are from a separate IHS-based catastrophic expenditure sensitivity analysis — the two studies use related but distinct methodologies, which is why the headline national figure (1.37%) and the 10%-threshold figure (9.37%) aren't directly comparable. Health and GDP per capita figures (2018–2023) are World Bank/WHO Global Health Expenditure Database series; 2018, 2019, and 2023 GDP figures are approximated between confirmed years and flagged accordingly.

Scope note: Every figure here is a population-level statistic from public household surveys and international databases. This tool does not collect, display, or infer any individual's health status, diagnosis, or personal medical information, and it is not a substitute for medical or financial advice. A natural next iteration — not yet built — would test whether kwacha devaluation correlates with rising landed costs for imported pharmaceuticals, extending the analysis from the Kwacha Forex tracker into this one.