Kroger Financial Model
Retail Company Financials Example (Free Excel Download)
The Kroger Co. operates supermarkets, multi-department stores, and fulfillment centres across the United States, manufacturing and processing a significant portion of the food sold in its stores.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the standalone equity valuation and cash flow generation profile of The Kroger Co. following the termination of its proposed merger with Albertsons, enabling an analyst to forecast capital returns through dividends and share repurchases.
The Kroger Co. operates supermarkets, multi-department stores, and fulfillment centres across the United States, manufacturing and processing a significant portion of the food sold in its stores. The business is split into two primary revenue streams: Supermarket sales without fuel (approximately 88-90% of revenue) and Fuel sales (approximately 10-12% of revenue). All operations and revenues are based entirely within the United States. Kroger operates an asset-heavy business model with an integrated supply chain, a massive real estate portfolio, and a highly profitable private label manufacturing division known as "Our Brands". It holds the position of the largest dedicated grocery supermarket chain in the US, competing fiercely with general merchandisers like Walmart and Target, warehouse clubs like Costco, and regional grocers. In late 2024, the company's proposed $25 billion mega-merger with Albertsons was blocked by a federal judge and officially terminated, forcing Kroger to pivot back to a standalone growth and capital return strategy. Additionally, Kroger sold its Specialty Pharmacy business in 2024 to improve overall margin mix.
The downloadable Kroger financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsKroger financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $137.89B | $148.26B | $150.04B | $147.12B | $147.64B |
| Depreciation and amortization | $2.82B | $2.96B | $3.13B | $3.25B | $3.33B |
| Operating income | $3.48B | $4.13B | $3.10B | $3.85B | $1.89B |
| Net income | $1.67B | $2.24B | $2.16B | $2.67B | $1.02B |
How to build a detailed financial model for Kroger
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Supermarket Sales (without fuel)
- Segment name: Supermarket sales without fuel
- Revenue driver formula: Prior Year Sales x (1 + Identical Sales Growth) + New Store Contributions
- Historical growth rate: 1.5% to 3.0% (FY2025 Identical Sales without fuel grew 2.9%)
- Key growth levers and headwinds: Growth is driven by digital sales expansion (over $16 billion in FY2025), penetration of "Our Brands", and retail media revenue. Headwinds include food price disinflation and intense promotional competition from Walmart.
- Pricing dynamics: Highly competitive spot pricing with heavy reliance on loyalty card promotions and personalised digital coupons.
- Revenue recognition notes: Recognised at the point of sale for in-store purchases and upon delivery or pickup for digital orders.
- Seasonality: The fourth quarter is typically the strongest due to the Thanksgiving and Christmas holiday shopping periods.
Fuel Sales
- Segment name: Fuel sales
- Revenue driver formula: Gallons Sold x Average Retail Price per Gallon
- Historical growth rate: Highly volatile, ranging from -15% to +20% depending entirely on global crude oil markets.
- Key growth levers and headwinds: Driven by the success of the Kroger fuel rewards programme which ties grocery loyalty to fuel discounts. Headwinds include the long-term transition to electric vehicles.
- Pricing dynamics: Spot pricing that closely tracks wholesale gasoline costs.
- Revenue recognition notes: Recognised at the pump at the point of sale.
- Seasonality: Volumes peak during the summer driving season in the second and third quarters.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Merchandise costs, inbound freight, shrink, and the LIFO (Last-In, First-Out) provision.
- Gross margin range: 22.1% to 23.5% (FY2025 reported gross margin was 22.9%).
- Key input costs and commodity exposures: Wholesale food costs, agricultural commodities, pharmacy procurement, and wholesale fuel prices.
- How COGS scales with revenue: Scales linearly with volume, but the LIFO accounting method causes significant swings in reported COGS during periods of high food inflation.
Operating Expenses
- R&D: Not applicable or material for this business.
- SG&A: Reported as Operating, General and Administrative (OG&A). This includes store associate wages, marketing, and corporate overhead. It typically runs at 16% to 18% of sales.
- Depreciation & Amortisation: Reported as a separate line item, typically representing 1.8% to 2.0% of total sales.
- Rent Expense: Reported separately from OG&A, representing the cost of the leased store portfolio.
- Restructuring / one-time charges: Frequent and sometimes massive. In FY2025, Kroger recorded a $2.5 billion impairment charge related to its automated fulfillment network.
Margin Profile
- Gross margin: 22.1% to 23.5%.
- EBITDA margin: 4.5% to 5.5%.
- Operating margin: 1.5% to 3.0% (FY2025 unadjusted operating margin was 2.58%, heavily impacted by impairments).
- Margin trend: Expanding slightly on an adjusted basis due to the growth of high-margin alternative profit businesses (retail media) and the divestiture of the lower-margin Specialty Pharmacy division.
Balance Sheet Structure
- Total assets: Approximately $50 billion.
- Key asset categories: Property, Plant and Equipment (stores, manufacturing plants, distribution centres), Inventory, and Operating lease right-of-use assets.
- Goodwill & intangibles: Represents roughly 10% to 15% of total assets, stemming from historical acquisitions like Harris Teeter and Fred Meyer.
- Working capital profile:
- Days Sales Outstanding (DSO): 3 to 5 days (primarily credit card receivables and third-party pharmacy payments).
- Days Inventory Outstanding (DIO): 25 to 30 days.
- Days Payable Outstanding (DPO): 30 to 35 days.
- Net working capital as % of revenue: Consistently negative.
- Kroger operates with a negative working capital advantage, meaning it collects cash from customers before it pays its suppliers, allowing it to fund growth organically.
- PP&E: Consists of owned real estate, store fixtures, and automated customer fulfillment centres. Useful lives range from 3 to 40 years.
- Right-of-use assets / operating leases: Highly material, representing a multi-billion dollar balance due to the extensive footprint of leased supermarket locations.
Capital Expenditure & Investment
- Capex as % of revenue: 2.3% to 2.6% (FY2026 guidance is $3.6 billion to $3.8 billion).
- Maintenance capex vs. growth capex: Approximately 60% maintenance and store remodels versus 40% growth and digital initiatives.
- Major capex programmes underway or planned: Store remodels, digital fulfillment infrastructure, and "deli of the future" concepts. The company recently scaled back investments in large automated fulfillment centres.
- Capitalised software / development costs: Present but generally bundled into broader digital capex figures.
- M&A pattern: Historically a bolt-on acquirer. The transformational Albertsons merger was blocked, returning the company to an organic growth and share repurchase focus.
- Typical acquisition multiple paid: Not applicable currently as the company is barred from large-scale grocery M&A by antitrust regulators.
Debt & Capital Structure
- Total debt: Approximately $12 billion to $14 billion.
- Debt/EBITDA ratio: Net total debt to adjusted EBITDA was 1.76x in FY2025. The target range is 2.30x to 2.50x.
- Credit rating: Investment grade (BBB / Baa1).
- Key debt instruments: Senior notes and a commercial paper programme for short-term liquidity.
- Maturity profile: Well-laddered with a mix of near-term commercial paper and long-term bonds extending beyond 10 years.
- Interest rate profile: Primarily fixed-rate senior notes with floating exposure on the commercial paper facility.
- Covenants: Standard investment-grade covenants including maximum leverage ratios.
- Share repurchase programme: Highly active. Kroger completed a $5 billion Accelerated Share Repurchase (ASR) in FY2025 and authorised a new $2 billion programme in December 2025.
- Dividend policy: Consistent annual growth. The payout ratio is typically 20% to 25% of net income, yielding approximately 2%.
Cash Flow Characteristics
- Operating cash flow conversion: Typically greater than 1.5x net income due to massive non-cash add-backs for D&A, LIFO charges, and asset impairments.
- Free cash flow margin: 1.5% to 2.0% of revenue (FY2026 guidance is $2.8 billion to $3.0 billion).
- Major non-cash items: Depreciation and amortisation, LIFO provision, stock-based compensation, and periodic impairment charges.
- Working capital cash flow impact: Acts as a source of cash during periods of revenue growth due to the negative working capital cycle.
- Capex intensity: Moderate, requiring constant reinvestment in store remodels to maintain foot traffic.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes closely track the GAAP effective tax rate of approximately 22%.
Sheet Structure
- Assumptions: Hardcoded inputs for identical sales growth, fuel prices, margins, capex, tax rate, and working capital days.
- Revenue_Build: Calculates Supermarket sales (driven by identical sales growth) and Fuel sales (driven by gallons and price per gallon).
- Income_Statement: Revenue, Merchandise Costs, LIFO Charge, Gross Profit, OG&A, Rent, D&A, Operating Profit, Interest Expense, Tax, and Net Income.
- Balance_Sheet: Cash, Receivables, Inventory, PP&E, ROU Assets, Goodwill, Accounts Payable, Accrued Liabilities, Short-term Debt, Long-term Debt, Lease Liabilities, and Equity.
- Cash_Flow_Statement: Net Income, D&A, LIFO adjustment, Impairments, NWC changes, Operating Cash Flow, Capex, Free Cash Flow, Debt issuance/repayment, Dividends, and Share Buybacks.
- Debt_Schedule: Tracks commercial paper, senior notes, interest expense calculation, and the Net Debt to Adjusted EBITDA ratio.
- Working_Capital: Schedules for DSO, DIO, and DPO to forecast receivables, inventory, and payables.
- DCF_Valuation: Unlevered free cash flow calculation, WACC assumptions, terminal value, and implied share price.
Key Financial Relationships
- "Supermarket Sales = Prior Year Supermarket Sales x (1 + Identical Sales Growth) + New Store Contribution"
- "Fuel Sales = Estimated Gallons Sold x Average Retail Price per Gallon"
- "Total Sales = Supermarket Sales + Fuel Sales"
- "FIFO Gross Profit = Total Sales - Merchandise Costs"
- "Reported Gross Profit = FIFO Gross Profit - LIFO Charge"
- "OG&A Expense = Total Sales x OG&A Margin Percentage"
- "Operating Profit = Reported Gross Profit - OG&A Expense - Rent Expense - Depreciation and Amortisation"
- "Ending Inventory = (Merchandise Costs / 365) x DIO"
- "Accounts Payable = (Merchandise Costs / 365) x DPO"
- "Net Debt = Short-Term Debt + Long-Term Debt - Cash and Cash Equivalents"
- "Adjusted EBITDA = Operating Profit + Depreciation and Amortisation + LIFO Charge + Impairment Charges"
- "Free Cash Flow = Operating Cash Flow - Capital Expenditures"
Cross-Sheet Dependencies
- The Assumptions sheet feeds drivers directly into the Revenue_Build, Income_Statement, and Working_Capital sheets.
- The Revenue_Build sheet feeds the top line of the Income_Statement.
- The Income_Statement generates Net Income, which feeds the top of the Cash_Flow_Statement and Retained Earnings on the Balance_Sheet.
- The Working_Capital sheet calculates changes in operating assets and liabilities, which feed into the Cash_Flow_Statement.
- The Debt_Schedule calculates Interest Expense which feeds the Income_Statement. To prevent circularity, interest expense should be calculated using the beginning balance of debt.
- The Cash_Flow_Statement generates the ending cash balance, which feeds the Balance_Sheet.
Sign Convention
- Revenue, Assets, and Equity: Positive.
- Expenses (Merchandise Costs, OG&A, Rent, D&A, Interest, Tax): Positive in their respective schedules, but subtracted in the Income Statement.
- Liabilities: Positive.
- Cash Flow: Inflows are positive. Outflows (Capital Expenditures, Dividends, Share Repurchases, Debt Repayment) are negative.
- LIFO Charge: Positive expense, subtracted from FIFO Gross Profit to arrive at Reported Gross Profit.
Things Most Likely to Go Wrong
- "LIFO accounting creates a wedge between FIFO gross margin and reported gross margin; the model must explicitly forecast the LIFO charge based on food inflation assumptions."
- "Fuel sales heavily distort overall margins because fuel has a very low gross margin percentage; margin analysis and OG&A ratios must be calculated on an ex-fuel basis."
- "The company records rent and D&A separately from Merchandise Costs and OG&A; do not lump them into a generic operating expense line."
- "Impairment charges heavily distort GAAP operating profit; the model needs an Adjusted EBITDA calculation to reflect underlying cash generation."
- "The 53rd week occurs every 5 to 6 years and distorts year-over-year growth rates; historical comparisons must adjust for this extra week."
- "Kroger operates with negative net working capital; growing sales will generate cash, which is counterintuitive for standard manufacturing models."
- "The sale of Kroger Specialty Pharmacy in 2024 removed approximately $2 billion in annual revenue but improved overall gross margin percentages; historical revenue must be adjusted to forecast future growth accurately."
- "Share repurchases are massive; failing to forecast the declining share count will severely understate Earnings Per Share."
Validation Checks
- "Total Gross Margin should be in the 22.0% to 23.5% range; flag if outside this band."
- "Net Debt to Adjusted EBITDA should remain between 1.7x and 2.5x; flag if leverage exceeds 2.5x per company target guidance."
- "Capex should be approximately $3.6 billion to $3.8 billion annually, or roughly 2.5% of sales."
- "Free Cash Flow should be between $2.8 billion and $3.0 billion annually based on management guidance."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Operating margin should be between 2.0% and 3.0% on an adjusted basis."
- "Effective tax rate should be approximately 22%."
- "Dividend payout ratio should remain around 20% to 25% of net income based on stated policy."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Supermarket Identical Sales Growth | 2.9 | % | FY2025 actual identical sales growth without fuel |
| Fuel Sales Growth | 0.0 | % | Assumes flat fuel prices and volumes for baseline forecast |
| FIFO Gross Margin (ex-fuel) | 23.5 | % | Reflects FY2025 margin expansion post-Specialty Pharmacy sale |
| LIFO Charge | 150 | $M | Normalised inflation expectation (FY2025 actual was $157M) |
| OG&A Margin (ex-fuel) | 17.0 | % | Historical average adjusted for recent wage investments |
| D&A % of Sales | 1.9 | % | Consistent historical run-rate |
| Capex | 3700 | $M | Midpoint of FY2026 guidance ($3.6B to $3.8B) |
| Effective Tax Rate | 22.0 | % | Management guidance for FY2026 |
| DSO | 4 | Days | Calculated from FY2025 receivables and total sales |
| DIO | 28 | Days | Calculated from FY2025 inventory and merchandise costs |
| DPO | 32 | Days | Calculated from FY2025 payables and merchandise costs |
| Share Repurchases | 2000 | $M | Authorised amount for FY2026 |
| Dividend per Share | 1.28 | $ | Annualised based on recent quarterly payouts |
| WACC | 7.5 | % | Standard cost of capital for mature grocery retail |
| Terminal Growth Rate | 1.5 | % | Aligns with long-term population and food inflation growth |
Data Sources & Benchmarks
- SEC EDGAR for Kroger 10-K and 8-K filings.
- Kroger Investor Relations page for quarterly earnings presentations, supplemental data, and guidance.
- Key peers for benchmarking: Walmart (WMT), Target (TGT), Albertsons (ACI), and Sprouts Farmers Market (SFM).
- Industry data sources: USDA food inflation data and EIA retail gasoline prices.
- Consensus estimates source: FactSet or Bloomberg for validation of model outputs.
Sources
Do more with the Kroger model
Frequently asked
What is Kroger's primary business model?+
Kroger operates as the largest dedicated grocery supermarket chain in the US, running supermarkets, multi-department stores, and fulfillment centers. It also manufactures and processes a significant portion of the food sold in its stores, leveraging an integrated supply chain and a profitable private label division.
How does Kroger generate its revenue?+
Kroger's revenue primarily comes from two streams: supermarket sales without fuel, which account for approximately 88-90% of its total revenue, and fuel sales, contributing the remaining 10-12%. All of Kroger's operations and revenues are generated entirely within the United States.
What is Kroger's capital expenditure strategy?+
Kroger's capital expenditure (capex) typically ranges from 2.3% to 2.6% of revenue, with FY2026 guidance at $3.6 billion to $3.8 billion. Approximately 60% of this capex is allocated to maintenance and store remodels, while the remaining 40% supports growth and digital initiatives like digital fulfillment infrastructure and "deli of the future" concepts.
How does Kroger's working capital profile impact its operations?+
Kroger consistently operates with a negative net working capital as a percentage of revenue, indicating a strong cash flow advantage. This means the company collects cash from customers quickly, typically within 3-5 days, before it pays its suppliers, allowing it to organically fund growth.
What is the purpose of a financial model for Kroger's equity valuation?+
A financial model for Kroger aims to evaluate the company's standalone equity valuation and its cash flow generation profile. This analysis helps an analyst forecast potential capital returns through dividends and share repurchases, especially after the termination of its proposed merger with Albertsons.
Can I download an Excel financial model for Kroger's valuation?+
No, an Excel financial model for Kroger's valuation is not available for download. The provided context indicates that a downloadable Excel model is not offered for this company.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Retail Company Financial Models
Browse another company in the same sector.
Best Buy
Best Buy is a leading multinational consumer electronics retailer providing technology products, services, and solutions.
Costco
Costco Wholesale Corporation operates an international chain of membership warehouses that offer high-quality, brand-name merchandise at substantially lower prices than are typically found at conventional wholesale or retail sources.
Dollar General
Dollar General is the largest discount retailer in the United States by store count, operating over 20,500 small-box stores primarily in rural and suburban markets.
Dollar Tree
Dollar Tree is a leading North American operator of discount variety stores, offering a wide range of everyday merchandise, seasonal goods, and party supplies across the United States and Canada.
Home Depot
The Home Depot is the world's largest home improvement retailer, selling building materials, home improvement products, lawn and garden products, and decor.
Lowe's
Lowe's is the second-largest home improvement retailer in the world, serving both DIY homeowners and professional customers with products for maintenance, repair, remodelling, and decorating.
Pool
Pool Corporation is the world's largest wholesale distributor of swimming pool supplies, equipment, and related leisure products.
Ross Stores
Ross Stores is the largest off-price apparel and home fashion chain in the United States, purchasing first-quality, in-season, name-brand, and designer merchandise at discounts and passing the savings to consumers through its Ross Dress for Less and dd's DISCOUNTS banners.
Explore more Consumer financial model templates.
