← Back to Work

Project Brief

View on GitHub

Problem Statement

How does India's CPI basket design affect real purchasing power for working households — and are fixed deposits keeping up?

Tools & Stack

PythonSQLExcelReact/JS

Methods

Basket weight analysis, category-level CPI decomposition, purchasing power modelling, FD real-return comparison

Output

Interactive inflation calculator showing real returns on savings vs. category-level price rises

Data Analysis · Economics · Policy

When Wars Raise Prices

How geopolitical conflicts thousands of kilometres away end up in your grocery bill, fuel tank, and savings account — and what the data says you can do about it.

India CPI — 2020 to 2024
Jan 2020▲ 7.79% (Apr 2022)Oct 2024
7.79%
CPI peak — Apr 2022
6.5%
RBI rate hikes (250 bps)
₹2.25L Cr
Fertilizer subsidy 2022–23

MOSPI CPI releases [1] · RBI Monetary Policy Reports [3] · Ministry of Finance notifications

Section 01 · Geopolitical Triggers

Three conflicts. One price basket.

India is not a direct participant in any of these wars. But its economy is deeply integrated into global commodity and shipping markets — which means every major conflict sends ripple effects into Indian households within weeks, not years.

Feb 2022 — ongoing

Russia-Ukraine War

+1.8% CPI spike within 60 days
Oil & gasWheat & sunflower oilFertilizer
  • Russia + Ukraine supply ~30% of global wheat exports — disruption caused global wheat prices to spike 60% in 4 weeks (FAO, March 2022)
  • Ukraine supplies ~45% of global sunflower oil — India's edible oil imports (70% dependent on imports) spiked 30-40%
  • Russia supplies ~14% of global fertilizers — urea prices rose 80% in 2022, directly raising Indian farming costs
  • India's crude oil imports: 85% imported. Brent crude rose from $90 (Jan 2022) to $123/barrel (Jun 2022) — a 37% spike
  • India CPI peaked at 7.79% in April 2022 — highest since August 2014
India CPI Apr 2022: 7.79% | Wheat import price: +60% | Edible oil: +35% | Urea: +80%

MOSPI CPI data [1] · FAO Food Price Index [2] · RBI Monetary Policy Report 2022 [3]

Section 02 · Transmission Channels

How a war in Europe ends up in your grocery bill.

War doesn't directly raise prices in India. It travels through five distinct transmission channels — each with a different speed, magnitude, and policy response. Click any channel to see the full mechanism.

The cascade — how oil alone ripples into 18 sectors

💣
War / Geopolitical shock
🛢️
Oil price spike
Petrol / diesel rises
🚛
Transport costs up
🛒
Every retail price rises
The CPI basket breakdown matters: Food & beverages = 45.9% of India's CPI. Fuel & light = 6.8%. Housing = 10.1%. Transport (embedded in manufacturing costs) = indirect. This is why food inflation is the most politically and economically significant component.

MOSPI CPI base revision 2012 — item-wise weights [1]

Section 03 · Historical Playbook

India has been here before. What worked?

War-driven inflation is not new to India. Four major crises over 50 years — each triggered differently, each handled differently, each leaving a different structural legacy. The data analyst's job: identify what actually worked and what just delayed the pain.

1973–75

First Oil Shock

Trigger: Yom Kippur War → OPEC embargo

~20%+
Peak inflation

OPEC's oil embargo triggered by the Arab-Israeli war caused global oil prices to quadruple. India, heavily dependent on oil, faced severe balance of payments pressure and double-digit inflation.

What the government did

  • 1.Government imposed price controls on essential commodities (kerosene, LPG, sugar, wheat)
  • 2.Public Distribution System (PDS) expanded — ration shops to 400M+ people
  • 3.Import substitution push: Coal India expanded, domestic coal promoted as oil alternative
  • 4.Foreign exchange crisis managed through IMF support

Outcome

Inflation eventually contained by mid-1975. PDS became permanent infrastructure. Long-term: heavy industry investment to reduce oil dependency.

🔑 Analyst's key lesson

Supply-side shocks need supply-side responses. Price controls alone don't work — they cause shortages. Building buffers (grain reserves, diversified energy) is the durable solution.

RBI History of the Indian Economy · Planning Commission archives [11]

What actually tamed inflation — across all four episodes

Effectiveness is assessed by how quickly inflation returned to the 4–6% zone and whether the intervention created lasting structural improvements.

Monetary tightening (rate hikes)High effectiveness
Strategic food reserves / PDS expansionHigh — especially for food inflation
Selective import duty cuts (edible oil, fertilizer)Medium-high — fast transmission
Fuel excise duty cutsMedium — short-term relief
Oil price subsidies (administered pricing)Low — delays pain, creates fiscal deficit
Price controls on non-essential goodsLow — causes shortages, black markets

Synthesised from RBI Annual Reports, IMF Working Papers on India inflation, and Ministry of Finance assessments [3][11][12][13]

Section 04 · The RBI's 2022 Response

250 basis points in 9 months — the fastest tightening in a decade.

The Reserve Bank of India's response to the 2022 inflation wave was its most aggressive rate-hike cycle since 2011. Here's the anatomy of what happened, what it cost, and what it achieved.

RBI Repo Rate Cycle — 2020 to 2024

Each rate hike is a deliberate signal: borrowing becomes costlier, demand cools, inflationary pressure eases — but so does growth.

Feb 2020 (pre-COVID)5.15% — easing cycle
May 2020 (COVID cut)4.00% — emergency low
May 2022 (emergency hike)4.40% — war shock response
Jun–Aug 20225.40% — aggressive tightening
Sep–Dec 20226.25% — nearing neutral rate
Feb 2023 (final hike)6.50% — peak rate
2024 (pause, then cut)6.25% — first cut Oct 2024
Speed matters: The MPC's May 2022 inter-meeting hike (the first unscheduled hike since 2013) signalled urgency and helped anchor inflation expectations quickly. The 250 bps cycle was completed in 9 months — by contrast, the Fed's 2004–06 cycle took 24 months.

RBI Monetary Policy Committee resolutions 2022–2024 · rbi.org.in/Scripts/BS_PressReleaseDisplay.aspx [3]

🏠

Home loans got expensive

A ₹50L home loan at 7% (2021) had EMI ₹38,765. At 9.5% (Dec 2022) the same loan = EMI ₹45,224. A ₹6,500/month increase — real household income squeeze.

🏭

Business borrowing slowed

Corporate credit demand cooled. New investment projects faced higher hurdle rates. This was intentional — less credit = less demand = less price pressure. The cost: GDP growth slowed from 9.1% (FY22) to 7.2% (FY23).

💵

FD rates became attractive

Banks raised FD rates to 7–8.5% — above CPI for the first time since 2019. This encouraged savings over consumption, reducing demand-side pressure. Depositors finally got a real positive return.

📉

Rupee stabilised

Higher rates made Indian assets more attractive to foreign investors. Capital inflows stabilised the rupee at ~₹83/$, preventing further import price amplification from currency depreciation.

Section 05 · What It Means for You

Your money, your inflation, your strategy.

Inflation is abstract until you calculate what it does to your specific income and savings. Use both calculators below — the results should inform where you keep your money and how you budget.

Purchasing power erosion calculator

How much will your ₹ salary buy in the future if inflation continues?

₹50,000
6%
3 yrs
₹41,981
Real purchasing power in 3 yrs
(at today's prices)
-₹8,019
Monthly purchasing power lost
per month in real terms
₹2,88,684
Total real value eroded
over 3 years

Standard compound purchasing power formula. Real value = nominal × (1/(1+r))^n. Not a financial forecast.

Is your FD beating inflation?

Fixed deposits feel safe — but if the FD rate is below inflation, you're losing money in real terms. Enter your numbers.

₹2,00,000
7%
6%
+1.00%
Real return (FD − Inflation)
2,06,060
Real value of savings in 3 yrs

Barely keeping up. Consider inflation-indexed options.

Real return = nominal FD rate − CPI inflation. Simplified Fisher equation. Tax on FD interest (as per your slab) further reduces real returns.

What historically beats inflation in India — asset comparison

Long-run average annual returns (India, 10-year periods 2010–2024). Inflation avg: ~5.5%/year. The goal: find assets with real positive returns above this.

Equities — Sensex/Nifty 50 (annualised 10yr)~13.5% p.a. ↑ beats inflation
Real estate — metro residential (annualised)~8.5% p.a. ↑ beats inflation
Gold (INR returns, 10yr annualised)~9.2% p.a. ↑ inflation hedge
Bank Fixed Deposits (avg SBI, 10yr)~6.8% p.a. marginal real return
Savings Account~3.5% p.a. loses to inflation
Cash (under mattress / low-yield)0% guaranteed real loss
The gold rule during geopolitical inflation: Gold consistently acts as an inflation hedge in India — it is priced in USD but valued in INR. When the rupee weakens AND global inflation rises (both happen during wars), gold in INR terms rises faster than both. India is the world's 2nd-largest gold consumer for precisely this reason.

Sensex/Nifty returns: NSE/BSE data · Gold: MCX India 10-yr · Real estate: NHB Residex Index · FD: SBI published rates. Past returns do not guarantee future performance. [14]

Section 06 · Problem Solving with Data

What India can structurally do — the analyst's prescription.

Every crisis reveals the same structural vulnerabilities. Data analysis across 50 years of Indian inflation history points to six interventions that would reduce the economy's sensitivity to geopolitical shocks — most of which India has already started, but incompletely.

P0 — Critical

Energy diversification

Reduce crude oil import dependency from 85% to <60% via renewables. India's solar capacity has grown 30× since 2014 (280 GW installed by 2024). Each 10% shift to renewables reduces oil import exposure by ~$8B — insulating CPI from Gulf conflicts.

India's solar target: 500 GW by 2030 · Current: 280 GW (MNRE 2024)

🌾
P0 — Critical

Edible oil self-sufficiency

India imports ~70% of edible oils (palm from Malaysia/Indonesia, sunflower from Ukraine). A National Mission on Edible Oils targeting oilseed production would reduce this vulnerability. Government launched NMEO-OP in 2021 — needs faster execution.

Edible oil imports: $18.9B in FY2023. 70% import-dependent.

🧪
P1 — High

Domestic fertilizer capacity

India produces only ~25M tonnes of fertilizer domestically vs ~30M tonnes consumed. Reversing the historical closure of public sector fertilizer plants and investing in gas-based urea production would reduce the import price shock channel.

India fertilizer imports: ₹1.65L Cr in FY2023. Domestic capacity gap: ~5M tonnes.

📦
P1 — High

Strategic reserves expansion

India's strategic petroleum reserve covers only 9.5 days of oil consumption — vs the IEA's recommended 90 days minimum. Expanding underground storage at Vizag, Mangalore, and Padur to 30+ days would absorb the first phase of any oil shock without retail price impact.

Current SPR: 5.33 MMT (Ministry of Petroleum 2023) = ~9.5 days import cover.

🏦
P1 — High

RBI inflation targeting credibility

The 2016 Monetary Policy Framework Agreement (inflation target: 4% ±2%) gave the RBI a clear mandate. The 2022 response was faster because the target was public and credible. Maintaining this framework — and protecting central bank independence — is structural anti-inflation infrastructure.

RBI hit 4% target for 3 consecutive years (2018–2020) before COVID shocks.

🔗
P2 — Medium

Supply chain redundancy

India's 'China+1' manufacturing push and the PLI scheme aim to reduce single-source import dependency. Every domestic substitute reduces how much global freight volatility can feed into Indian consumer prices. This is a 10-year structural play, not a crisis response.

PLI scheme target: ₹5 lakh crore manufacturing output by 2028 (DPIIT).

Inflation from war is a solved problem in data terms — we know the transmission channels, we know what interventions work, and we have 50 years of India-specific evidence. What remains is the gap between knowing and doing.

The structural answer to war-driven inflation is reducing import dependency in the sectors that transmit most: oil, edible oils, fertilizer. India has started on all three — the question is pace. Every year of delay is another ₹1–2 lakh crore of exposure to the next geopolitical shock.

Three things you can do today

1.Move idle savings account balances into FD / debt mutual funds — any positive real return beats 3.5% savings rate during 6%+ inflation
2.Allocate 10–15% of portfolio to gold (SGBs/gold ETFs) — India's historically most reliable inflation hedge during geopolitical shocks
3.Review monthly variable expenses quarterly against your own 'personal inflation rate' — your food basket inflates differently from CPI's national average

References

Sources — verified and annotated.

1
MOSPI — Ministry of Statistics and Programme Implementation. CPI Press Releases 2020–2024. mospi.gov.in · https://mospi.gov.in/web/mospi/releases-publication/-/reports/view/templateOne/16302
2
FAO Food Price Index (FFPI). Food and Agriculture Organization of the UN. fao.org/worldfoodsituation/foodpricesindex/en · https://www.fao.org/worldfoodsituation/foodpricesindex/en/
3
Reserve Bank of India — Monetary Policy Reports 2022–2024, Annual Reports, RBI Bulletin. rbi.org.in · https://rbi.org.in/Scripts/AnnualReportPublications.aspx
4
Drewry World Container Index — weekly container freight rate tracker. drewry.co.uk/supply-chain-advisors/supply-chain-expertise/world-container-index-assessed-by-drewry · https://www.drewry.co.uk/supply-chain-advisors/supply-chain-expertise/world-container-index-assessed-by-drewry
5
RBI Working Paper on freight cost and inflation (2024). RBI Working Paper Series. Directionally confirmed — exact WP number not retrieved. · https://rbi.org.in/Scripts/BS_ViewBulletin.aspx
6
US EIA — Brent Crude Oil Spot Price Historical Data. eia.gov/dnav/pet/pet_pri_spt_s1_d.htm · https://www.eia.gov/dnav/pet/pet_pri_spt_s1_d.htm
7
PPAC — Petroleum Planning and Analysis Cell, India. Petroleum Statistics, import dependency data. ppac.gov.in · https://www.ppac.gov.in/content/212_1_ImportExport.aspx
8
World Bank Commodity Price Data (Pink Sheet). Fertilizer prices — urea, DAP, potash. worldbank.org/en/research/commodity-markets · https://www.worldbank.org/en/research/commodity-markets
9
Department of Fertilizers, Ministry of Chemicals and Fertilizers. Annual Report 2022–23. fert.nic.in · https://fert.nic.in/annual-report
10
DBIE — RBI Data Warehouse. USD/INR exchange rate history. dbie.rbi.org.in · https://dbie.rbi.org.in
11
Planning Commission of India archives. Economic Survey documents 1973–75. Directionally confirmed from academic citations; original docs not digitally retrieved. · https://planningcommission.gov.in
12
Acharya, S. (2002). India's Macroeconomic Management in the 1990s. National Institute of Public Finance and Policy (NIPFP). Working Paper. · https://nipfp.org.in
13
Ministry of Finance. Union Budget 2008–09 Budget Speech. indiabudget.gov.in · https://www.indiabudget.gov.in/bspeech/bs200809.pdf
14
NSE/BSE Nifty50 historical returns · MCX India gold price history · NHB Residex residential property index. Returns cited as approximate 10-year annualised averages — exact computation not independently audited. · https://www.nseindia.com
← Back to all case studies