Executive Overview
·
Flipkart Supply Chain Finance · FY 2024–25
LIVE
May 2025 00:00:00
CFO
Executive Command Center
Real-time P&L · Supply chain health · Opportunity pipeline · FY 2024–25
⚠ Cash Conversion Cycle at 62 days — 8 days above industry benchmark. ₹42 Cr working capital locked. Immediate action recommended.
Revenue vs EBITDA — Monthly Trend
Net revenue · EBITDA · SC cost · ₹ Crores · FY 2024–25
Margin Waterfall
Revenue to EBITDA bridge · Q4 FY25
GMV by Category
Revenue contribution · ₹ Crores
Cost Structure
Supply chain cost mix · % of revenue
KPI Scorecard
Actual vs target · RAG
Supply Chain Value Network
End-to-end cost flow · ₹ Crores at each node
Live P&L Monitor
Real-time income statement · Margin tracking · Variance vs budget · FY 2024–25
UPDATING LIVE
Net Revenue YTD
₹5,876 Cr
↑ 18.4% YoYvs ₹4,960 Cr
Gross Margin
34.8%
↓ 0.6pp QoQTarget: 36%
EBITDA
₹1,364 Cr
23.2%Margin
vs Budget Variance
−₹86 Cr
−5.9% missBudget ₹1,450 Cr
Free Cash Flow
₹930 Cr
↑ 12.3% QoQFCF margin 15.8%
Income Statement — Q4 FY25₹ Crores · Unaudited
EBITDA Bridge — QoQ
Q3 FY25 vs Q4 FY25 variance waterfall
Gross Margin Trend
Monthly gross margin % vs target
EBITDA Sensitivity Matrix
Impact on EBITDA (₹ Cr) for volume × cost changes
CFO Finance Dashboard
P&L analysis · Cost structure · Margin intelligence · Category profitability · FY 2024–25
₹5,876 Cr
Net Revenue
↑ 18.4% YoY
₹8,420 Cr
Gross GMV
↑ 22.1% YoY
₹1,364 Cr
EBITDA
↓ 1.8pp margin
15.8%
SC Cost / Rev
Benchmark 14%
₹930 Cr
Free Cash Flow
↑ 12.3% QoQ
Quarterly P&L Bridge
Revenue · Cost · EBITDA · ₹ Crores
SC Cost % Trend
vs 14% benchmark · Monthly
Category Contribution Margin
Net contribution % after SC cost · 8 categories
Savings Identified vs Realized
Cost optimization pipeline · ₹ Crores
Treasury & Cash Management
Liquidity · Credit facilities · FX exposure · Rate risk · Short-term investments · MTM
LIVE FX RATES
₹4,280 Cr
Total Cash & Equivalents
₹2,100 Cr
WC Facility Sanctioned
₹620 Cr
Facility Drawn
₹1,480 Cr
Headroom Available
₹89 Cr
Interest Cost YTD
8.40%
Wtd Avg Cost of Debt
Credit Facility Utilisation
Sanctioned vs drawn vs available · ₹ Crores
RBI Repo Rate
6.50%
WC cost impact / 25bp+₹4.2 Cr
Annual interest at current₹52.1 Cr
Wtd Avg Cost of Debt
8.40%
Total debt outstanding₹620 Cr
Net interest outgo₹52.1 Cr/yr
T-Bill 91-day Yield
6.82%
T-Bill portfolio deployed₹480 Cr
Carry income p.a.₹32.7 Cr
Daily Cash Position — 30 Days
Inflows · Outflows · Net · ₹ Crores
Investment Portfolio Mix
₹1,240 Cr deployed · Yield vs duration
Rate Sensitivity — Annual Interest Cost Impact
Change in interest cost (₹ Cr) for ±200bp rate movement
Cash Flow Command Center
Operating · Investing · Financing · 13-week forecast · Liquidity runway analysis
⚠ Projected cash gap of ₹180 Cr in Week 6 due to vendor payment cluster. Recommend drawing ₹200 Cr from CC facility immediately.
Opening Cash
₹4,280 Cr
As of today
Operating CF (QTD)
+₹930 Cr
↑ 12.3% QoQ
Investing CF (QTD)
−₹240 Cr
Capex + WH expansion
Financing CF (QTD)
−₹52 Cr
Debt repayments
13-Week Cash Forecast
Projected inflows · outflows · net position · ₹ Crores
Cash Flow Waterfall — Q4 FY25
Operating to free cash flow bridge
Upcoming Cash Obligations — Next 30 Days
Vendor payments · Debt service · Capex · Tax · Payroll
Working Capital Intelligence Center
CCC · DPO · DSO · DIO · Unlock analysis · Liquidity optimization
38days
Days Sales Outstanding
Target: 32 days · Gap: 6 days
0Target 3260
76days
Days Inventory Outstanding
Target: 68 days · Gap: 8 days
0Target 68120
52days
Days Payable Outstanding
Target: 58 days · Short: 6 days
0Target 5890
62 days
Cash Conversion Cycle
54 days
Industry Benchmark
+8 days
Gap to Benchmark
₹42 Cr
WC Unlock Opportunity
₹1,240 Cr
Total WC Locked
CCC Monthly Trend
Cash conversion cycle vs target · days
WC Components Trend
DSO / DIO / DPO · FY 2024–25
Debt & Capital Structure
Loan schedule · Debt covenants · Capex tracker · DSCR · Capital allocation · FY 2024–25
Total Debt
₹620 Cr
↓ ₹48 Cr YTDRepaid
Debt / EBITDA
0.45x
↓ 0.1x QoQCovenant: <2.0x
DSCR
3.8x
StrongCovenant: >1.5x
Interest Coverage
17.8x
Well coveredMin: 3.0x
Debt Repayment Schedule
Principal + interest outflows · ₹ Crores quarterly
Capital Allocation — FY25
Capex · WC · Debt repay · Dividends · Strategic reserves
Capex Tracker — FY25
Budget vs actual · Project-level · ₹ Crores
Debt Covenant Monitor
Live covenant ratios vs thresholds
FX Hedging & Currency Risk
Forex exposure · Hedge coverage · MTM P&L · Currency sensitivity · VaR analysis
USD Payable Exposure
$48M
Vendor imports
Hedge Coverage
74%
Target: 80%
MTM Gain YTD
+₹4.2 Cr
Forward book
USD/INR Spot
83.42
↑ 1.8% YTD
FX Exposure vs Hedge Cover
Monthly exposure · covered · uncovered · ₹ Crores
MTM P&L — Forward Book
Mark-to-market gain/loss · ₹ Crores monthly
Active Hedge Positions
Forward contracts · Options · Maturity profile · MTM
Inventory Finance Analytics
Stock health · Dead stock · DOH · Holding cost · Capital locked · Aging
₹1,240 Cr
Capital Locked
↑ 8% QoQ
₹224 Cr
Dead Stock
Target <₹150 Cr
76 days
Avg Days on Hand
Target: 68 days
82%
In-Stock Rate
Target: 80%
₹48 Cr
Annual Hold Cost
3.9% of inv value
Inventory Trend — Monthly
Total stock · Dead stock · ₹ Crores
Days on Hand by Category
Current vs target · Risk flag
Stock Age Distribution
Aging buckets · ₹ Crores
Hold Cost by Category
Annual at 8.4% · ₹ Cr
ABC Classification
Value mix · A/B/C items
Warehouse Inventory Health
Capital · DOH · Dead stock · Holding cost per DC
Logistics Finance Intelligence
Freight cost · Modal split · OTIF · Last-mile · Returns finance
₹672 Cr
Total Freight
↑ 12% YoY
91.6%
OTIF
Target: 94%
₹28 Cr
Air Overrun
34% air-routed
₹48 Cr
Savings Opp.
Modal shift
Freight Cost by Mode
Air · Surface · Rail · ₹ Crores monthly
OTIF Trend — Regional
On-time in-full by region · Monthly %
Cost per km by Mode
₹/km comparison
Last-Mile Cost Breakdown
DEX · 3PL · COD · Hyperlocal
Return Logistics Cost
Reverse logistics · ₹ Crores
Warehouse Operations Finance
DC-level P&L · Throughput · Labor · Utilization · COGS
₹588 Cr
Total WH Cost
7% of net revenue
84.2%
Avg Utilization
3 DCs overcap
3,280/hr
Throughput
↑ 4.2% MoM
₹142 Cr
Labor Cost
↑ 8% YoY
WH Cost per Unit — Monthly
Handling + storage + labor · ₹/unit
Throughput by DC
Units/hr · Last 6 weeks
Warehouse KPI Scorecard
Financial health · Utilization · Labor · Shrinkage per DC
Procurement Finance Intelligence
Vendor performance · Spend analytics · Savings pipeline · Supplier risk matrix
₹186 Cr
Procurement Savings
8.8% of spend
₹2,100 Cr
Total Spend
25% of GMV
247
Active Vendors
18 high risk
42/100
Avg Supplier Risk
Target: <35
Supplier Risk Matrix
Spend vs risk · Quadrant analysis
🟢 Low Spend / Low Risk — Monitor
🔵 High Spend / Low Risk — Leverage
🟡 Low Spend / High Risk — Develop
🔴 High Spend / High Risk — Critical
Vendor OTIF Performance
On-time in-full · Top 8 suppliers
Vendor Scorecard
Comprehensive supplier performance · FY 2024–25
Operational Risk Intelligence
Supplier risk · Geopolitical · Concentration risk · Live disruption alerts · VaR
HIGH
Overall Risk Level
18 critical alerts
42/100
Supplier Risk Score
↑ 6pts QoQ
3
Active Disruptions
Live incidents
68%
Single-Source %
Concentration risk
Risk Heatmap
Category × Geography · 0–100
Risk Score Trend
Monthly index · Alert threshold 40
Active Risk Incidents
Real-time disruption monitoring
Scenario Simulation Engine
What-if analysis · Multi-variable impact · Monte Carlo · Financial projection
Fuel Cost Change (%)
0%
SLA Improvement (%)
+0%
Return Rate Reduction (%)
-0%
Inventory Reduction (%)
-0%
SIMULATION OUTPUT
Adjust sliders above and click Run Simulation to model financial impact.
Savings Opportunity Tracker
Identified vs realized · ₹ Crores
Scenario Impact Waterfall
Base vs optimized EBITDA bridge
Finance Intelligence & AI Insights
Analyst observations · ₹342 Cr pipeline · AI-powered anomaly detection · FY 2024–25
🤖
Pushpak Finance AI — Ask Anything
Claude-Powered
Supply Chain Finance Expert · Full data context
System
Welcome to Pushpak Finance AI. I have full context of your supply chain — P&L, inventory, logistics, working capital, treasury, procurement, risk, and hedging. Ask anything.Pushpak AI
📊 Key alert: CCC at 62 days (8 days above industry). Highest-leverage action: reduce DIO from 76→68 days to unlock ₹42 Cr. Want me to model the SKU-level intervention?AI is thinking...
Strategic Recommendations
Consulting-grade supply chain finance insights · FY 2024–25
Audit Intelligence Center
Duplicate payments · GST ITC · Vendor fraud · Returns fraud · Shrinkage · Compliance
Duplicate Payments
₹1.2 Cr
4 invoices flagged
Blocked GST ITC
₹4.6 Cr
Reconciliation pending
Freight Overbilling
₹10 Cr
MUM zone overrun
Fake Returns Est.
₹1.01 Cr
Pattern-flagged
Critical · Duplicate Invoice
Vendor: TechSource Pvt Ltd
4 duplicate invoices totalling ₹1.2 Cr in Q4. INV-8841, INV-8842 duplicated across two payment cycles. Payment hold applied pending verification.
Exposure: ₹1.2 Cr
High · Freight Overbilling
Air Freight — MUM Zone
Air freight spend ₹28 Cr vs budgeted ₹18 Cr. 34% of shipments air-routed despite 72-hr SLA tolerance. Surface re-routing saves ₹10 Cr.
Overrun: ₹10 Cr
Vendor Concentration Risk — Audit View
Single-source dependency · ₹ Crores at risk if vendor defaults
Route Optimization Intelligence
AI-driven delivery routing · Cost vs speed tradeoffs · Modal efficiency · Live dispatch
Route Cost Efficiency
₹/km by corridor · Top 10 routes
Dispatch Status — Live
Active · In-transit · Delayed routes
Cost per km by Mode
Modal Split Trend
Route P&L Summary
CFO Board Presentation
Q4 FY25 · Supply Chain Finance Summary · Board Review · Finance Intelligence Team
Board Pack · Supply Chain Finance
Flipkart Supply Chain
Finance Review — Q4 FY25
Finance Review — Q4 FY25
Prepared by CFO Office · Finance Intelligence Team · May 2025
Net Revenue
₹5,876 Cr
↑ 18.4% YoY
GMV
₹8,420 Cr
EBITDA
₹1,364 Cr
Net Margin
23.2%
CCC
62 days
SC Cost %
15.8%
01 · Business Performance
Revenue grew 18.4% YoY — EBITDA under margin pressure
GMV expanded to ₹8,420 Cr. EBITDA margin contracted 1.8pp QoQ due to freight overrun ₹48 Cr and return losses ₹94 Cr.
GMV ↑18.4%Margin ↓1.8pp
02 · Key Risks
₹1,240 Cr cash locked — CCC 8 days above industry
CCC at 62 days vs 54 days industry. Single-vendor 68% electronics concentration creates ₹86 Cr disruption exposure.
CCC: 62 daysRisk: ₹86 Cr
03 · Recommendations
₹342 Cr opportunity pipeline — actionable in 2 quarters
Freight modal shift ₹48 Cr, inventory reduction ₹76 Cr, DPO extension ₹28 Cr, South returns ₹34 Cr — board approval requested.
Opportunity: ₹342 Cr
Board-Level Strategic Recommendations
Ranked by financial impact · Cross-functional ownership
CFO CLOSING REMARKS
The supply chain finance position for Q4 FY25 reflects a business scaling effectively — but carrying working capital inefficiencies that must be addressed to sustain margin health into FY26. The ₹342 Cr opportunity pipeline is executable within two quarters with cross-functional commitment. The Board's approval for the task force is requested at this session.
Supply Chain Finance Intelligence · FY 2024–25 · Confidential