Eighteen years of Malawi's currency and price history, modeled end to end: SQL for the source tables, R for the index construction and trend projection, and an interactive front end for the two questions that matter — what your money was really worth, and whether earning in USD actually protects you the way it looks like it should.
-- Monthly real income for a fixed USD earner, -- joining FX and CPI fact tables on year WITH real_income AS ( SELECT fx.year, fx.usd_mwk_rate, cpi.index_value, 500 * fx.usd_mwk_rate AS nominal_mwk, 500 * fx.usd_mwk_rate * (SELECT index_value FROM cpi_index WHERE year = 2026) / cpi.index_value AS real_equiv_2026 FROM fx_rates fx JOIN cpi_index cpi ON cpi.year = fx.year ) SELECT year, usd_mwk_rate, nominal_mwk, real_equiv_2026, ROUND( (nominal_mwk / real_equiv_2026 - 1) * 100, 1 ) AS real_change_pct FROM real_income ORDER BY year;
# Compound annual inflation into a # purchasing-power index, base year 2008 = 100 build_cpi_index <- function(inflation_df) { inflation_df <- inflation_df[order(inflation_df$year), ] idx <- numeric(nrow(inflation_df)) idx[1] <- 100 for (i in 2:nrow(inflation_df)) { idx[i] <- idx[i - 1] * (1 + inflation_df$rate[i] / 100) } inflation_df$cpi_index <- idx inflation_df } # Linear trend on the last four confirmed # FX points, projected two years forward recent <- subset(fx_rates, year >= 2022) model <- lm(rate ~ year, data = recent) future <- data.frame(year = 2027:2028) predict(model, future)
Confirmed exchange-rate anchors: 2008 (140.60), 2009 (145.99), and 2010 (150.80) are RBM Bank Supervision Annual Report year-end closing rates. May 2012 (−49%), May 2022 (−25%), and November 2023 (−44%) are RBM-announced devaluations. The 31 July 2026 rate (1,734.01) is from Trading Economics. Years without a confirmed anchor are linearly interpolated between the nearest confirmed points and marked accordingly.
Confirmed inflation figures: 2019 (9.38%, back-calculated from the reported 2020 year-over-year change), 2020 through 2024 (NSO annual averages), and February 2026 (24.1%, latest published reading). The 2008–2018 and 2025 figures are modeled estimates built from historical trend commentary and RBM/IMF summaries rather than confirmed NSO annual averages, and should be replaced with exact NSO series before this ships as a public tool. The 2027–2028 exchange-rate projection is a simple linear model on 2022–2026 data — illustrative of the direction implied by recent stabilization, not a forecast to rely on financially.