Kimberly-Clark Financial Model
Consumer Goods Company Financials Example (Free Excel Download)
Kimberly-Clark is a global consumer packaged goods company that manufactures and markets personal care and consumer tissue products under iconic brands such as Huggies, Kleenex, Kotex, and Scott.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and M&A scenario analysis for Kimberly-Clark Corporation (KMB), enabling an analyst to forecast the core continuing operations (North America and International Personal Care) while layering in the pro-forma impacts of the pending Kenvue acquisition and the divestiture of the International Family Care and Professional (IFP) business.
- What the company does: Kimberly-Clark is a global consumer packaged goods company that manufactures and markets personal care and consumer tissue products under iconic brands such as Huggies, Kleenex, Kotex, and Scott.
- Business segments: Following the 2024 Transformation Initiative and the 2025 divestiture of the IFP business, continuing operations are split into two reportable segments: North America (NA) (~55% of continuing revenue) and International Personal Care (IPC) (~45% of continuing revenue).
- Key geographies: North America is the primary market, with the remainder spread across approximately 60 countries, including significant exposure to emerging markets like China, Indonesia, and Latin America.
- Business model type: Asset-heavy, fast-moving consumer goods (FMCG) manufacturer relying on high-volume production, brand equity, and extensive retail distribution networks.
- Competitive position: A top-tier global player in baby and child care, feminine care, and adult incontinence, competing directly with Procter & Gamble (P&G), Essity, and various private label manufacturers.
- Recent major events: The company is undergoing massive structural changes. In 2024, it launched the "Transformation Initiative" to streamline its supply chain. In mid-2025, it announced a joint venture with Suzano, selling a 51% stake in its IFP business for $1.7 billion (now treated as discontinued operations). Concurrently, KMB announced the transformational acquisition of Kenvue for approximately $6.7 billion in cash and 280 million shares.
The downloadable Kimberly-Clark 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 & AssumptionsKimberly-Clark financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Cost of products sold | $13.45B | $13.96B | $13.40B | $12.88B | $10.52B |
| Gross profit | $5.99B | $5.52B | $6.27B | $6.29B | $5.92B |
| Operating income | $2.56B | $2.31B | $1.93B | $2.70B | $2.35B |
| Net income | $1.81B | $1.93B | $1.76B | $2.54B | $2.02B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Kimberly-Clark
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
North America (NA)
- Revenue driver formula: `Prior Year NA Revenue x (1 + NA Volume Growth) x (1 + NA Net Price/Mix)`
- Historical growth rate: 1-3% organic CAGR.
- Key growth levers and headwinds: Driven by premiumisation in baby/child care and adult care. Headwinds include private label penetration, retailer destocking, and the recent exit of the US private label diaper business.
- Pricing dynamics: Highly competitive; relies on "price-to-value" tiering and promotional trade spend with major retailers like Walmart (which accounts for ~14% of total sales).
- Revenue recognition notes: Recognised at the point of shipment/delivery to retail customers, net of trade promotions and discounts.
- Seasonality: Relatively stable, though cold/flu season can slightly elevate tissue demand in Q1 and Q4.
International Personal Care (IPC)
- Revenue driver formula: `Prior Year IPC Revenue x (1 + IPC Volume Growth) x (1 + IPC Net Price/Mix) x (1 + FX Translation Impact)`
- Historical growth rate: 3-5% organic CAGR, though heavily distorted by FX.
- Key growth levers and headwinds: Volume growth in emerging markets (China, Indonesia, Brazil) is the primary lever. Severe headwinds from foreign currency translation, particularly in hyperinflationary markets like Argentina and Turkey.
- Pricing dynamics: Frequent pricing actions are required to offset local currency devaluation and imported raw material inflation.
- Revenue recognition notes: Standard FMCG point-of-sale recognition.
- Seasonality: Minimal seasonality; driven more by macroeconomic cycles in emerging markets.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Raw materials (pulp, superabsorbent polymers, non-woven materials), manufacturing labour, utilities, and inbound freight.
- Gross margin range: 35.0% to 37.5% (2025 adjusted gross margin was 37.3%).
- Key input costs and commodity exposures: Highly sensitive to global pulp prices, oil-derived polymers, and energy costs.
- How COGS scales with revenue: Generally linear, though the 2024 Transformation Initiative aims to generate $460 million in gross productivity savings through network optimisation and scalable automation.
Operating Expenses
- R&D: Typically 1.0-1.5% of revenue, focused on proprietary material science and product innovation.
- SG&A: Reported as "Marketing, research and general expenses". Marketing is a major component (advertising and consumer promotion).
- Depreciation & Amortisation: Approximately 4-5% of revenue, reflecting the asset-heavy manufacturing footprint.
- Restructuring / one-time charges: Highly material. The 2024 Transformation Initiative incurred hundreds of millions in charges through 2024 and 2025, significantly depressing GAAP operating margins.
Margin Profile
- Gross margin: ~36.0% GAAP, ~37.3% Adjusted.
- Operating margin: ~14.0% GAAP, ~15.0% Adjusted.
- Margin trend: Expanding on an adjusted basis due to productivity savings and pricing, but masked by restructuring charges and tariff impacts.
Balance Sheet Structure
- Total assets: Approximately $16-$18 billion (pre-Kenvue acquisition).
- Key asset categories: Property, Plant & Equipment (PP&E) is the largest tangible asset, alongside significant Goodwill and Intangible Assets from historical acquisitions.
- Goodwill & intangibles as % of total assets: Historically ~20-25%, but will increase massively post-Kenvue acquisition.
- Working capital profile:
- Days Sales Outstanding (DSO): ~30-35 days.
- Days Inventory Outstanding (DIO): ~45-55 days.
- Days Payable Outstanding (DPO): ~90-100 days (KMB aggressively manages payables).
- Net working capital as % of revenue: Negative.
- Is working capital positive or negative? KMB operates with a structural negative cash conversion cycle (approximately -9 days in 2024), meaning it funds growth through its suppliers.
- PP&E: Manufacturing facilities globally; useful lives range from 15-20 years for machinery.
- Right-of-use assets: Material operating leases for distribution centres and corporate offices.
Capital Expenditure & Investment
- Capex as % of revenue: 4.5% to 7.5% (stepped up to ~$1.1 billion in 2025 and projected at $1.3 billion in 2026).
- Maintenance capex vs. growth capex: Roughly 60% maintenance / 40% growth and supply chain transformation.
- Major capex programmes underway: Supply chain network optimisation and automation tied to the 2024 Transformation Initiative.
- M&A pattern: Historically bolt-on, but the pending Kenvue acquisition is highly transformational.
Debt & Capital Structure
- Total debt: $7.2 billion (continuing operations as of late 2025).
- Debt/EBITDA ratio: Historically ~2.0x, but will spike due to the $6.7 billion cash consideration for Kenvue funded via a new bridge loan facility.
- Credit rating: Single-A (management has stated a commitment to maintaining this rating).
- Key debt instruments: Senior unsecured notes, commercial paper programme, and a new bridge loan facility for M&A.
- Interest rate profile: Predominantly fixed-rate bonds, with commercial paper used for short-term liquidity.
- Share repurchase programme: Active but scaled back recently ($141 million in 2025) to preserve capital for the Kenvue deal.
- Dividend policy: High priority for management; paid $1.7 billion in dividends in 2025.
Cash Flow Characteristics
- Operating cash flow conversion: Very strong; OCF frequently exceeds Net Income due to high D&A and positive working capital dynamics. 2025 OCF was $2.8 billion.
- Free cash flow margin: Typically 10-14% of revenue.
- Major non-cash items: Depreciation, amortisation, stock-based compensation, and non-cash restructuring impairment charges.
- Working capital cash flow impact: Source of cash during growth phases due to the negative cash conversion cycle.
- Cash tax rate vs. GAAP effective tax rate: GAAP ETR is ~23-29% (29.2% in 2025 due to non-deductible M&A/restructuring costs). Cash taxes are slightly lower due to accelerated depreciation.
Sheet Structure
- Assumptions & Scenarios: Hardcoded drivers for NA and IPC segments, FX rates, commodity inflation, and a toggle for the Kenvue M&A integration.
- Income Statement: Revenue down to Net Income. Must explicitly separate "Continuing Operations" from "Discontinued Operations (IFP Business)".
- Revenue & Segment Build: Detailed build for NA and IPC. Rows for Volume Growth %, Price/Mix %, and FX Impact %.
- Operating Costs & Margins: Bridge from GAAP to Adjusted Gross Profit and Operating Profit, isolating the "2024 Transformation Initiative" charges.
- Balance Sheet: Standard assets, liabilities, and equity. Must include a pro-forma adjustment column for the Kenvue acquisition (adding new debt, goodwill, and equity issuance).
- Working Capital: Schedules for Accounts Receivable, Inventory, and Accounts Payable driven by DSO, DIO, and DPO to capture the negative cash conversion cycle.
- Debt & Interest: Tranche-by-tranche debt schedule, including the new bridge loan facility, calculating interest expense based on average balances.
- Cash Flow Statement: Indirect method starting from Net Income from Continuing Operations, adjusting for non-cash items and working capital changes.
- DCF Valuation: Unlevered free cash flow build, WACC calculation, and terminal value using the perpetuity growth method.
Key Financial Relationships
- `NA Segment Revenue = Prior Year NA Revenue * (1 + NA Volume Growth + NA Price/Mix)`
- `IPC Segment Revenue = Prior Year IPC Revenue * (1 + IPC Volume Growth + IPC Price/Mix + FX Impact)`
- `Consolidated Net Sales = NA Segment Revenue + IPC Segment Revenue`
- `Adjusted Gross Profit = Consolidated Net Sales * Adjusted Gross Margin %`
- `GAAP Gross Profit = Adjusted Gross Profit - Transformation Initiative Cost of Goods Sold Charges`
- `Adjusted Operating Profit = Adjusted Gross Profit - Marketing, Research and General Expenses`
- `GAAP Operating Profit = Adjusted Operating Profit - Transformation Initiative Opex Charges - M&A Transaction Costs`
- `Accounts Payable = (COGS / 365) * DPO` (Crucial for modelling the negative working capital)
- `Interest Expense = Average Total Debt * Weighted Average Interest Rate`
- `Pro-Forma Share Count = Base Share Count - Shares Repurchased + Kenvue Acquisition Shares Issued (280 million)`
Cross-Sheet Dependencies
- The Assumptions & Scenarios sheet dictates the organic growth and FX impacts on the Revenue & Segment Build.
- The Revenue & Segment Build feeds the top line of the Income Statement.
- The Operating Costs & Margins sheet calculates GAAP vs. Adjusted metrics, feeding operating profit on the Income Statement.
- Income Statement net income and D&A feed the top of the Cash Flow Statement.
- Working Capital changes (driven by revenue and COGS) feed the Cash Flow Statement.
- The Cash Flow Statement determines the ending cash balance and required revolver draw, feeding the Balance Sheet and Debt & Interest schedule.
- Debt & Interest feeds interest expense back to the Income Statement (creating a circular reference that must be managed with a circuit breaker).
Sign Convention
- Income Statement: Revenues are positive. All expenses (COGS, SG&A, Interest, Taxes) are negative.
- Balance Sheet: Assets are positive. Liabilities and Equity are positive.
- Cash Flow Statement: Net Income is positive. Non-cash add-backs (D&A) are positive. Increases in assets are negative (use of cash); increases in liabilities are positive (source of cash).
- Margin Percentages: Displayed as positive percentages.
Things Most Likely to Go Wrong
- Discontinued Operations Confusion: The IFP business was moved to discontinued operations in 2025. Historical financials must be recast; failing to exclude IFP from continuing revenue will overstate the core business by billions.
- GAAP vs. Non-GAAP Margins: The 2024 Transformation Initiative carries massive charges. Modelling GAAP margins without bridging to Adjusted margins will result in flawed, overly pessimistic steady-state forecasts.
- Negative Working Capital Dynamics: KMB funds operations through payables (DPO > 90 days). If the builder defaults to a standard positive working capital assumption, cash flow will be severely understated during growth periods.
- FX Translation in IPC: The IPC segment is heavily exposed to hyperinflationary economies. Ignoring FX impacts will result in unrealistic USD revenue growth projections.
- Kenvue Pro-Forma Share Dilution: The Kenvue deal requires issuing ~280 million shares. Failing to adjust the denominator for EPS and DCF per-share value will drastically overstate per-share metrics.
- Bridge Loan Interest: The $6.7 billion cash consideration for Kenvue is debt-funded. The model must include the interest burden of this new debt, which will drag on net income.
- Equity Income: KMB owns 47.9% of Kimberly-Clark de Mexico (KCM). This must be modelled as "Income from Equity Companies" below operating profit, not consolidated into revenue.
- Walmart Concentration: 14% of sales go to Walmart. Any modelled pricing increases in NA must be tempered by the reality of negotiating with a dominant retailer.
Validation Checks
- "Adjusted Gross Margin should be between 36.0% and 38.0%; flag if outside this band."
- "Cash Conversion Cycle must remain negative (historically around -9 days); flag if it turns positive."
- "Capex as a % of revenue should be between 6.0% and 8.0% during the Transformation Initiative phase (2025-2026)."
- "Total Assets must exactly equal Total Liabilities + Equity in every period."
- "Pro-forma share count must increase by 280 million in the period the Kenvue transaction closes."
- "Effective tax rate should be between 22.0% and 25.0% on an adjusted basis."
- "Dividend payout ratio should be checked against free cash flow to ensure the dividend is covered (FCF > Dividends Paid)."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| NA Volume Growth | 2.5 | % | Based on 2025 reported volume gains in North America. |
| NA Price/Mix | -0.5 | % | Reflects recent unfavourable pricing and promotional investments. |
| IPC Volume Growth | 2.0 | % | Steady emerging market volume growth. |
| IPC FX Impact | -2.0 | % | Ongoing currency headwinds in Latin America and Asia. |
| Adjusted Gross Margin | 37.3 | % | Actual 2025 adjusted gross margin. |
| Transformation Charges (COGS) | 1.0 | % of Rev | Temporary drag through 2026 based on 2025 run-rate. |
| Adjusted Operating Margin | 15.0 | % | Actual Q3/Q4 2025 run-rate. |
| Days Sales Outstanding (DSO) | 32 | Days | Historical average. |
| Days Inventory Outstanding (DIO) | 50 | Days | Historical average. |
| Days Payable Outstanding (DPO) | 95 | Days | Drives the negative cash conversion cycle. |
| Capex / Revenue | 7.5 | % | Elevated due to $1.3B planned spend in 2026 for supply chain automation. |
| Adjusted Effective Tax Rate | 23.0 | % | Management guidance for adjusted tax rate. |
| Kenvue Cash Consideration | 6,700 | $ Millions | Disclosed deal terms. |
| Kenvue Shares Issued | 280 | Millions | Disclosed deal terms. |
| WACC | 7.5 | % | Standard discount rate for a mature, single-A rated consumer staples company. |
| Terminal Growth Rate | 2.0 | % | Aligns with long-term global GDP and population growth. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, 8-K for Kenvue acquisition and IFP divestiture), Kimberly-Clark Investor Relations website.
- Key Peers: Procter & Gamble (PG), Colgate-Palmolive (CL), Church & Dwight (CHD), Essity (ESSITY-B.ST).
- Industry Data: NielsenIQ or Circana (formerly IRI) for scanner data and market share in US retail; RISI for global pulp commodity pricing.
- Consensus Estimates: FactSet or Bloomberg for forward-looking EPS and revenue estimates to benchmark the base case.
Sources
- Kimberly-Clark 2025 Annual Report on Form 10-K
- Kimberly-Clark Q3 and Q4 2025 Earnings Press Releases
- Kimberly-Clark Investor Relations: Segment Reporting Recast
- Kimberly-Clark 2024 Transformation Initiative Announcements
- PR Newswire / PublicNow SEC Filing Aggregators
- TradingView News: KIMBERLY CLARK CORP SEC 10-K Report
- StockTitan: KMB Financials and Margins
- InvestorRoom: KMB Earnings Pre-Recorded Management Discussion
Do more with the Kimberly-Clark model
Frequently asked
What does Kimberly-Clark (KMB) do and what are its main brands?+
Kimberly-Clark is a global consumer packaged goods company that manufactures and markets personal care and consumer tissue products. It operates under iconic brands such as Huggies, Kleenex, Kotex, and Scott. Following recent strategic initiatives, its continuing operations are focused on North America and International Personal Care segments.
What are the primary revenue drivers for Kimberly-Clark's continuing operations?+
Kimberly-Clark's revenue is primarily driven by its North America and International Personal Care segments, which constitute 100% of continuing revenue after divestitures. The company relies on high-volume production, strong brand equity, and extensive retail distribution networks across approximately 60 countries to drive sales.
What is Kimberly-Clark's capital expenditure strategy and what are its major programs?+
Kimberly-Clark's capital expenditure is projected to range from 4.5% to 7.5% of revenue, with specific forecasts of $1.1 billion in 2025 and $1.3 billion in 2026. Approximately 60% of this capex is for maintenance, while the remaining 40% is dedicated to growth and supply chain transformation, including network optimization and automation programs.
How does Kimberly-Clark manage its working capital and what is its cash conversion cycle?+
Kimberly-Clark operates with a structural negative cash conversion cycle, estimated at approximately -9 days in 2024, indicating it funds growth through its suppliers. This is supported by aggressively managing payables, with Days Payable Outstanding (DPO) typically ranging from 90-100 days.
What is the purpose of the financial model available for Kimberly-Clark (KMB)?+
The financial model for Kimberly-Clark provides a comprehensive equity valuation and M&A scenario analysis. It allows analysts to forecast the core continuing operations while integrating the pro-forma impacts of the pending Kenvue acquisition and the divestiture of the International Family Care and Professional business.
Is there a downloadable Excel financial model available for Kimberly-Clark (KMB)?+
Yes, a downloadable Excel financial model is available for Kimberly-Clark (KMB). This model provides financial forecasts for the period FY2026 through FY2030, incorporating key assumptions such as revenue growth and various expense percentages.
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 Consumer Goods Company Financial Models
Browse another company in the same sector.
Church & Dwight
Church & Dwight Co., Inc.
Colgate-Palmolive
Colgate-Palmolive is a leading global consumer products company focused on the production, distribution, and provision of household, health care, personal care, and veterinary products.
Clorox
The Clorox Company is a leading multinational manufacturer and marketer of consumer and professional products.
Deckers Brands
Deckers Brands is a global footwear, apparel, and accessories designer and distributor, best known for its powerhouse brands UGG and HOKA.
Estée Lauder Companies
The Estée Lauder Companies Inc.
Kenvue
Kenvue is the world's largest pure-play consumer health company by revenue, manufacturing and marketing a portfolio of iconic, science-backed brands including Tylenol, Neutrogena, Listerine, and Band-Aid.
Lululemon Athletica
Lululemon Athletica is a premium athletic apparel, footwear, and accessories company that designs and retails products for yoga, running, training, and other sweaty pursuits.
Altria
Altria is the leading manufacturer and seller of tobacco products in the United States, spanning smokeable products, oral tobacco products, and e-vapor products.
Explore more Consumer financial model templates.
