Ralph Lauren Financial Model
Consumer Goods Company Financials Example (Free Excel Download)
Ralph Lauren Corporation is a global leader in the design, marketing, and distribution of premium lifestyle products, including apparel, footwear, accessories, home furnishings, and fragrances.
professionals from Deloitte
Used by professionals from
About this model
This financial model provides a comprehensive 3-statement forecast and discounted cash flow (DCF) valuation for Ralph Lauren Corporation (NYSE: RL) to help equity analysts determine the intrinsic value of the company based on its direct-to-consumer (DTC) transition, international expansion (particularly in Asia), and ongoing margin expansion initiatives.
- Ralph Lauren Corporation is a global leader in the design, marketing, and distribution of premium lifestyle products, including apparel, footwear, accessories, home furnishings, and fragrances.
- Business Segments: North America (~43% of revenue), Europe (~28% of revenue), Asia (~27% of revenue), and Other Non-Reportable/Licensing (~2% of revenue).
- Key Geographies: Approximately 57% of FY25 net revenues were generated outside of the United States.
- Business Model Type: Omnichannel brand operator transitioning towards an asset-lighter, direct-to-consumer (DTC) model. The company operates retail stores, concessions, and digital commerce sites, alongside a traditional wholesale business selling to department and specialty stores.
- Competitive Position: A highly recognised global luxury lifestyle brand, competing with PVH Corp (Tommy Hilfiger, Calvin Klein), Capri Holdings, Tapestry, and European luxury houses.
- Recent Major Events: The company has executed a multi-year "Next Great Chapter: Accelerate" strategy, significantly reducing its reliance on North American off-price wholesale, elevating the brand through Average Unit Retail (AUR) growth, and driving operating margin expansion to over 13% in FY25.
The downloadable Ralph Lauren 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 & AssumptionsRalph Lauren financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2022 | FY2023 | FY2024 | FY2025 | FY2026 |
|---|---|---|---|---|---|
| Revenue | $6.22B | $6.44B | $6.63B | $7.08B | $8.11B |
| Gross profit | $4.15B | $4.17B | $4.43B | $4.85B | $5.67B |
| Operating income | $798.4M | $704.2M | $756.4M | $932.1M | $1.18B |
| Net income | $600.1M | $522.7M | $646.3M | $742.9M | $941.1M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Ralph Lauren
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
North America
- Segment Name: North America (Retail and Wholesale)
- Revenue Driver Formula: (Retail Store Count x Revenue per Store x Comparable Store Sales Growth) + (Digital Commerce Traffic x Conversion x AUR) + Wholesale Sell-In Volume
- Historical Growth Rate: Flat to low-single-digit growth (FY25 revenue was approximately $3.1 billion, up 3% YoY).
- Key Growth Levers and Headwinds: Growth is driven by DTC expansion and AUR increases, offset by deliberate reductions in lower-tier wholesale accounts to protect brand equity.
- Pricing Dynamics: High pricing power demonstrated by consecutive quarters of high single-digit AUR growth.
- Seasonality: Strongest in the fiscal third quarter (ending late December) due to the holiday shopping season.
Europe
- Segment Name: Europe (Retail and Wholesale)
- Revenue Driver Formula: Retail Revenue (Stores + Digital) + Wholesale Revenue
- Historical Growth Rate: Mid-single-digit constant currency growth.
- Key Growth Levers and Headwinds: Expansion of digital ecosystem and physical retail footprint, offset by macroeconomic softness in certain Western European markets and foreign exchange volatility.
- Pricing Dynamics: Premium positioning with strong AUR growth offsetting inflationary pressures.
Asia
- Segment Name: Asia (Retail and Wholesale)
- Revenue Driver Formula: Retail Revenue (Stores + Digital) + Wholesale Revenue
- Historical Growth Rate: High-single to low-double-digit growth (the fastest-growing segment).
- Key Growth Levers and Headwinds: Store expansion in China and Japan, rising middle-class luxury consumption. Headwinds include regional currency depreciation (e.g., Japanese Yen, Chinese Yuan).
- Pricing Dynamics: Highest operating margin region (adjusted operating margin over 27% in Q1 FY25), driven by a highly profitable DTC mix.
Other Non-Reportable (Licensing)
- Segment Name: Other Non-Reportable
- Revenue Driver Formula: Licensee Wholesale Revenue x Royalty Rate
- Historical Growth Rate: Stable, low-single-digit growth.
- Key Growth Levers and Headwinds: Driven by Ralph Lauren and Chaps branded royalty revenues earned through global licensing alliances.
Cost Structure
Variable Costs / COGS
- Line items: Product costs (raw materials, labour), inbound freight, duties, and inventory shrinkage.
- Gross Margin Range: 65.0% to 69.0% (FY24 was 66.8%; FY25 expanded to 68.6%).
- Key Input Costs: Cotton is a major commodity exposure. Freight costs (e.g., Red Sea disruptions) also impact COGS.
- Scaling: Scales linearly with revenue, but gross margin percentage improves as the channel mix shifts from wholesale to DTC and as AUR increases.
Operating Expenses
- SG&A Breakdown: Reported as a single "Operating Expenses" line item, which includes selling, general, administrative, and marketing expenses.
- Marketing: Typically runs at approximately 6% of sales.
- Depreciation & Amortisation: Embedded within operating expenses; primarily related to retail store build-outs and digital infrastructure.
- Restructuring / One-time charges: The company frequently reports restructuring charges (e.g., $75 million in FY24, $58 million in FY25) related to corporate real estate and headcount optimisation.
Margin Profile
- Gross Margin: 66.8% (FY24) to 68.6% (FY25).
- Operating Margin: 11.4% (FY24) to 13.2% (FY25 on a reported basis; 14.0% adjusted).
- Margin Trend: Expanding, driven by AUR growth, lower freight costs, and a favourable geographic/channel mix shift towards Asia and DTC.
Balance Sheet Structure
- Total Assets: Approximately $7.8 billion.
- Key Asset Categories: Cash and short-term investments, Inventory, Property & Equipment (retail stores), and Operating Lease Right-of-Use Assets.
- Working Capital Profile:
- Days Sales Outstanding (DSO): ~30-40 days (wholesale receivables).
- Days Inventory Outstanding (DIO): ~130-150 days. Inventory management is a critical focus; FY25 ending inventory was $950 million.
- Days Payable Outstanding (DPO): ~60-75 days.
- Net Working Capital: Generally positive, requiring seasonal investment ahead of the holiday quarter.
- PP&E: Primarily leasehold improvements for retail stores, fixtures, and IT infrastructure.
- Right-of-Use Assets: Highly material due to the extensive global retail store and concession footprint.
Capital Expenditure & Investment
- Capex as % of Revenue: Typically 3.0% to 4.5% (FY25 Capex was $216 million on $7.08 billion revenue, ~3.0%).
- Maintenance vs. Growth: Heavily skewed towards growth and digital. Investments focus on new store openings, store renovations, digital enhancements, and technology infrastructure.
- M&A Pattern: Organic grower. Ralph Lauren rarely makes material acquisitions, focusing instead on internal brand elevation and direct retail expansion.
Debt & Capital Structure
- Total Debt: $1.1 billion (end of FY25).
- Cash Balance: $2.1 billion in cash and short-term investments (end of FY25), resulting in a net cash position of approximately $1.0 billion.
- Key Debt Instruments: Primarily fixed-rate senior notes. Key maturities include $400 million (3.75% rate) due in 2025 and $700 million (3.00% rate) due in 2030.
- Share Repurchase Programme: Highly active. The company returned $625 million to shareholders via dividends and buybacks in FY25, and the Board recently approved a $1.5 billion expansion of the share repurchase programme.
- Dividend Policy: The company pays a regular quarterly dividend, which was increased by 10% in FY25.
Cash Flow Characteristics
- Operating Cash Flow Conversion: Very strong. OCF consistently exceeds net income due to high depreciation and effective working capital management.
- Free Cash Flow Margin: Approximately 10% to 14% of revenue (FY25 FCF was over $1.0 billion).
- Major Non-Cash Items: Depreciation and amortisation, stock-based compensation, and operating lease amortisation.
- Working Capital Impact: Inventory swings dictate quarterly cash flow, with heavy cash generation in Q3 (holiday sell-through) and Q4 (spring wholesale collections).
- Tax Rate: The effective tax rate was 22% in FY25, up from 17% in FY24 due to the absence of prior-year discrete tax benefits.
Sheet Structure
- Assumptions: Hardcoded inputs for macroeconomic drivers, segment growth rates, AUR growth, margin targets, working capital days, and tax rates.
- Revenue Build: Segment-level revenue forecasting for North America, Europe, Asia, and Other Non-Reportable. Splits retail and wholesale where applicable.
- Income Statement: Consolidated P&L from Net Revenues down to Net Income and EPS. Includes adjustments for restructuring charges to show both GAAP and Non-GAAP (Adjusted) figures.
- Balance Sheet: Assets, Liabilities, and Shareholders' Equity. Must include specific lines for Inventories and Operating Lease Liabilities.
- Cash Flow Statement: Operating, Investing, and Financing cash flows. Links to the Balance Sheet to capture working capital changes.
- Debt & Interest Schedule: Tranches of debt (2025 notes, 2030 notes), interest expense calculations, and cash interest income.
- Working Capital Schedule: Calculation of Accounts Receivable, Inventory, and Accounts Payable based on DSO, DIO, and DPO.
- PP&E & Intangibles Schedule: Capex, depreciation, and right-of-use asset amortisation.
- Shareholders' Equity: Retained earnings, dividend payouts, and share repurchases tracking.
- DCF Valuation: Unlevered free cash flow calculation, WACC assumptions, terminal value, and implied share price.
Key Financial Relationships
- `North America Revenue = North America Prior Year Revenue x (1 + North America Growth Rate)`
- `Europe Revenue = Europe Prior Year Revenue x (1 + Europe Growth Rate)`
- `Asia Revenue = Asia Prior Year Revenue x (1 + Asia Growth Rate)`
- `Total Net Revenues = North America Revenue + Europe Revenue + Asia Revenue + Other Non-Reportable Revenue`
- `Gross Profit = Total Net Revenues x Gross Margin %` (Targeting ~68.6% based on FY25)
- `Operating Expenses = Total Net Revenues x Operating Expense %` (Targeting ~54.6% adjusted)
- `Operating Income = Gross Profit - Operating Expenses - Restructuring Charges`
- `Interest Expense = (Prior Period Debt x Interest Rate)` (Blended rate ~3.3% based on 2025 and 2030 notes)
- `Income Tax Expense = Pre-Tax Income x Effective Tax Rate` (Targeting 22%)
- `Ending Inventory = (COGS / 365) x DIO`
- `Share Repurchases = Free Cash Flow x Target Buyback Payout %`
- `Ending Basic Shares = Prior Period Shares - (Share Repurchases / Average Share Price)`
Cross-Sheet Dependencies
- The Assumptions sheet dictates the growth and margin profiles on the Revenue Build and Income Statement.
- The Income Statement generates Net Income, which flows to the top of the Cash Flow Statement and into Retained Earnings on the Balance Sheet.
- The Working Capital Schedule uses Revenue and COGS from the Income Statement to calculate balance sheet items (Receivables, Inventory, Payables), the changes in which flow to the Cash Flow Statement.
- The Debt & Interest Schedule calculates interest expense for the Income Statement and ending debt balances for the Balance Sheet. *Circularity risk:* Interest income depends on cash balances, which depend on net income, which depends on interest income. Use a circularity breaker or base interest on beginning balances.
- The Cash Flow Statement determines the ending cash balance, which flows to the Balance Sheet to ensure Total Assets = Total Liabilities + Equity.
Sign Convention
- Revenues and Assets: Positive.
- Expenses and Liabilities: Positive on their specific schedules, but subtracted in aggregation formulas (e.g., Gross Profit = Revenue - COGS).
- Cash Flow Statement: Cash inflows are positive; cash outflows (e.g., Capex, Share Repurchases, Dividends) are negative.
- Contra-Equity (Treasury Stock): Negative on the Balance Sheet.
Things Most Likely to Go Wrong
- Foreign Exchange Volatility: RL generates 57% of revenue internationally. The model must account for constant currency vs. reported growth; failing to adjust for FX can severely skew historical run-rates.
- Inventory Swings: Retail inventory is highly seasonal. Using an annual average for DIO will fail to capture the massive Q3 inventory build and subsequent Q4 release.
- Adjusted vs. GAAP Metrics: RL frequently reports "Adjusted Operating Margin" excluding restructuring charges (e.g., 14.0% adjusted vs 13.2% reported in FY25). The model must clearly separate one-time charges to prevent them from being projected in perpetuity.
- Marketing Expense Rigidity: RL strictly manages marketing at ~6% of sales. If the model allows operating expenses to scale linearly without protecting the marketing spend ratio, brand equity assumptions will be flawed.
- Share Count Dilution vs. Buybacks: RL aggressively buys back stock ($1.5B authorisation). Failing to model the reduction in share count will artificially depress EPS forecasts.
- Lease Accounting: Right-of-use assets and lease liabilities are massive for RL. The builder must ensure lease amortisation is correctly handled in the cash flow statement to avoid double-counting rent expense.
- Cotton Price Lag: COGS improvements from falling cotton prices take 6-9 months to flow through the P&L due to inventory turns. Immediate margin expansion based on spot cotton prices is a common modelling error.
- Licensing Margin Distortion: The "Other Non-Reportable" segment is almost entirely high-margin royalty revenue. If this segment's growth outpaces the core business, consolidated margins will expand mathematically without any underlying operational improvement.
Validation Checks
- "Gross margin should be in the 66.0% - 69.0% range; flag if outside this band."
- "Operating margin should be between 12.0% and 15.0% based on management's 'Next Great Chapter' targets."
- "Capex as a % of revenue should run between 3.0% and 4.0%."
- "Net Debt should remain negative (Cash > Debt); flag if the company enters a net debt position."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Effective tax rate should be approximately 21% - 23%."
- "Marketing expense should equal approximately 6.0% of Total Net Revenues."
- "Inventory balance should not exceed 18% of forward 12-month COGS."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| North America Revenue Growth | 3.0 | % | Based on FY25 reported growth and DTC expansion. |
| Europe Revenue Growth | 4.0 | % | Mid-single-digit historical trend and management guidance. |
| Asia Revenue Growth | 9.0 | % | Fastest growing segment, driven by China and Japan expansion. |
| Other (Licensing) Growth | 2.0 | % | Stable, mature royalty stream. |
| Gross Margin | 68.6 | % | Actual reported FY25 gross margin. |
| Operating Expense % (Adjusted) | 54.6 | % | Actual reported FY25 adjusted operating expense rate. |
| Effective Tax Rate | 22.0 | % | Actual reported FY25 tax rate. |
| Capex as % of Revenue | 3.0 | % | Based on FY25 Capex of $216M on $7.08B revenue. |
| Days Sales Outstanding (DSO) | 35 | Days | Historical average for wholesale receivables. |
| Days Inventory Outstanding (DIO) | 140 | Days | Based on FY25 ending inventory of $950M. |
| Days Payable Outstanding (DPO) | 65 | Days | Historical average. |
| Interest Rate on Debt | 3.3 | % | Blended rate of 2025 (3.75%) and 2030 (3.00%) senior notes. |
| Share Repurchase Annual Spend | 400 | $M | Based on recent run-rate and new $1.5B authorisation. |
| Dividend per Share (Annual) | 3.30 | $ | Based on $0.825 quarterly dividend run-rate. |
| WACC | 8.5 | % | Standard consumer discretionary discount rate. |
| Terminal Growth Rate | 2.0 | % | Long-term GDP and inflation alignment. |
Data Sources & Benchmarks
- SEC Filings: Ralph Lauren Investor Relations (investor.ralphlauren.com) for 10-K, 10-Q, and 8-K earnings releases.
- Key Peers for Benchmarking: PVH Corp (PVH), Capri Holdings (CPRI), Tapestry (TPR), Levi Strauss & Co. (LEVI).
- Industry Data Sources: National Retail Federation (NRF) for US retail sales data, Bain & Company Luxury Goods Worldwide Market Study for global luxury trends.
- Consensus Estimates: FactSet or Bloomberg for forward EPS and revenue consensus.
- Proprietary Data: SimilarWeb for digital commerce traffic trends on RalphLauren.com; credit card panel data for US retail comparable sales tracking.
Sources
- Ralph Lauren Corporation FY25 Q4 and Full Year Earnings Release (May 22, 2025)
- Ralph Lauren Corporation FY24 Q4 and Full Year Earnings Release (May 23, 2024)
- Ralph Lauren Corporation FY25 Q1 Earnings Release
- Ralph Lauren Corporation FY25 Q2 10-Q (November 7, 2024)
- Monexa AI: Ralph Lauren Corporation FY25 Financial Turnaround & Growth Analysis
- Seeking Alpha: Ralph Lauren's Strategy And Execution Are Great
- Investing.com: Ralph Lauren exceeds Q4 expectations
- StockInsights.ai: Ralph Lauren Corp Segment Data
Do more with the Ralph Lauren model
Frequently asked
What does Ralph Lauren Corporation do?+
Ralph Lauren Corporation designs, markets, and distributes premium lifestyle products globally, including apparel, footwear, accessories, home furnishings, and fragrances. It operates as an omnichannel brand, transitioning towards a direct-to-consumer (DTC) model with retail stores, digital commerce, and a wholesale business.
What are the primary revenue drivers for Ralph Lauren?+
Ralph Lauren's revenue is primarily driven by its direct-to-consumer (DTC) transition, international expansion, particularly in Asia, and ongoing brand elevation through Average Unit Retail (AUR) growth. Approximately 57% of FY25 net revenues were generated outside of the United States, highlighting the importance of global markets.
What are Ralph Lauren's typical capital expenditure levels?+
Ralph Lauren's capital expenditure typically ranges from 3.0% to 4.5% of revenue, with FY25 Capex being approximately 3.0% of its $7.08 billion revenue. These investments are heavily skewed towards growth, focusing on new store openings, store renovations, and digital enhancements.
How does the financial model for Ralph Lauren determine its intrinsic value?+
The financial model for Ralph Lauren provides a comprehensive 3-statement forecast and discounted cash flow (DCF) valuation. It helps equity analysts determine the intrinsic value of the company based on its strategic initiatives like the DTC transition, international expansion, and margin expansion.
Can I download an Excel financial model for Ralph Lauren?+
Yes, a downloadable Excel financial model for Ralph Lauren Corporation (RL) is available. This general corporate model provides a forecast horizon from FY2026 to FY2030, offering detailed assumptions for analysis.
What is Ralph Lauren's strategy for growth and profitability?+
Ralph Lauren's strategy, "Next Great Chapter: Accelerate," focuses on reducing reliance on North American off-price wholesale and elevating the brand through Average Unit Retail (AUR) growth. This strategy also drives margin expansion and emphasizes an asset-lighter, direct-to-consumer (DTC) model and international expansion, especially in Asia.
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.
Kimberly-Clark
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.
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.
Explore more Consumer financial model templates.
