Lululemon Athletica Financial Model
Consumer Goods Company Financials Example (Free Excel Download)
Lululemon Athletica is a premium athletic apparel, footwear, and accessories company that designs and retails products for yoga, running, training, and other sweaty pursuits.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and scenario planning tool to assess whether Lululemon Athletica can sustain its premium valuation multiple while executing its "Power of Three x2" growth strategy in international markets and digital channels.
Lululemon Athletica is a premium athletic apparel, footwear, and accessories company that designs and retails products for yoga, running, training, and other sweaty pursuits.
The business operates through two primary reporting segments alongside an "Other" category. Company-Operated Stores account for approximately 46% of total revenue. The Direct to Consumer (DTC) segment, which comprises e-commerce sales, accounts for approximately 45% of revenue. The Other segment, which includes outlets, wholesale accounts, temporary locations, and license and supply arrangements, makes up the remaining 9%.
Geographically, the Americas region dominates with roughly 79% of revenue, while China Mainland contributes about 10%, and the Rest of World makes up the remaining 11%. The company employs an asset-light manufacturing model by outsourcing all production, but it maintains tight control over distribution through its vertically integrated direct-to-consumer retail model. Lululemon holds a dominant market position in premium athleisure, competing with global giants like Nike and Adidas, as well as fast-growing challengers like Alo Yoga and Vuori. A notable recent event was the acquisition of MIRROR in 2020, which subsequently underperformed, leading to significant impairment charges and a strategic pivot to a digital app partnership with Peloton in 2023.
The downloadable Lululemon Athletica 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 & AssumptionsLululemon Athletica financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $6.26B | $8.11B | $9.62B | $10.59B | $11.10B |
| Gross profit | $3.61B | $4.49B | $5.61B | $6.27B | $6.28B |
| Operating income | $1.33B | $1.33B | $2.13B | $2.51B | $2.21B |
| Net income | $975.3M | $854.8M | $1.55B | $1.81B | $1.58B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Lululemon Athletica
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Company-Operated Stores
- Segment name: Company-Operated Stores
- Revenue driver formula: Average Store Count x Average Revenue per Store (or driven by Comparable Store Sales Growth)
- Historical growth rate: 15-20% CAGR (rebounding strongly post-pandemic)
- Key growth levers and headwinds: Square footage expansion in international markets (especially China), store productivity improvements, and foot traffic trends.
- Pricing dynamics: Premium pricing with minimal discounting in mainline stores.
- Revenue recognition notes: Recognised at the point of sale when the customer takes possession.
- Seasonality: Highly seasonal. Q4 (holiday season) typically generates 30-35% of annual revenue and an even higher proportion of operating profit.
Direct to Consumer (DTC)
- Segment name: Direct to Consumer
- Revenue driver formula: Website Traffic x Conversion Rate x Average Order Value
- Historical growth rate: 20-25% CAGR (accelerated significantly during 2020-2021, now normalising)
- Key growth levers and headwinds: Digital marketing efficiency, mobile app adoption, and shipping costs.
- Pricing dynamics: Full-price strategy maintained online, with a dedicated "We Made Too Much" section for markdowns.
- Revenue recognition notes: Recognised upon shipment or delivery to the customer, depending on exact terms. Deferred revenue exists for unredeemed gift cards.
- Seasonality: Q4 is exceptionally strong due to digital holiday shopping events like Black Friday and Cyber Monday.
Other
- Segment name: Other
- Revenue driver formula: Outlet Store Count x Outlet Revenue per Store + Wholesale Revenue
- Historical growth rate: 10-15% CAGR
- Key growth levers and headwinds: Inventory clearance needs drive outlet performance.
- Pricing dynamics: Discounted pricing in outlets to clear seasonal or excess inventory.
Cost Structure
Variable Costs / COGS
- Cost of Goods Sold includes product costs (materials and labour from third-party manufacturers), inbound freight, duties, and warehousing costs.
- Gross margin range: 55% to 59% over the last 5 years.
- Key input costs include nylon, polyester, elastane, and global ocean/air freight rates.
- COGS scales linearly with volume, but gross margin fluctuates based on the mix of full-price versus markdown sales and the mix of air versus ocean freight.
Operating Expenses
- R&D: Not explicitly broken out as a separate line item. Product design and development costs are included in SG&A.
- SG&A: Selling, General and Administrative expenses typically run at 35% to 37% of revenue. This includes store payroll, rent (operating lease costs), marketing, and corporate overhead.
- Depreciation & Amortisation: Typically 3% to 4% of revenue, driven by store build-outs and technology investments.
- Stock-Based Compensation: Typically 0.5% to 1.0% of revenue.
- Restructuring / one-time charges: Infrequent, though the company recorded massive impairment charges related to the MIRROR acquisition in FY2022 and FY2023.
Margin Profile
- Gross margin: 55-59%.
- Operating margin: 21-23% (excluding MIRROR impairments).
- Net margin: 15-17%.
- Margin trend: Stable to slightly expanding, driven by a shift towards the higher-margin DTC channel, offset by investments in international expansion.
Balance Sheet Structure
- Total assets are approximately $7.5 billion to $8.5 billion.
- Key asset categories include Cash and Cash Equivalents, Inventories, Property and Equipment, and Right-of-Use (ROU) Lease Assets.
- Goodwill & intangibles represent less than 5% of total assets following the write-down of the MIRROR acquisition.
- Working capital profile:
- Days Sales Outstanding (DSO): 5-10 days (very low due to retail/credit card sales).
- Days Inventory Outstanding (DIO): 110-130 days (inventory is a major use of cash and requires careful management).
- Days Payable Outstanding (DPO): 40-50 days.
- Net working capital as % of revenue is typically 10% to 15%.
- Working capital is positive. The company must invest in inventory ahead of the peak Q4 selling season.
- PP&E consists primarily of leasehold improvements for stores, distribution centre equipment, and corporate offices.
- Right-of-use assets are highly material, representing over $1.2 billion due to the extensive leased store portfolio.
Capital Expenditure & Investment
- Capex as % of revenue ranges from 6% to 8%.
- Maintenance capex is roughly 30% of total capex, with growth capex making up the remaining 70%.
- Major capex programmes include new store openings (particularly in China and APAC), store renovations, and supply chain/technology infrastructure.
- Capitalised software costs are material as the company invests heavily in its e-commerce platform and digital capabilities.
- M&A pattern: Historically organic growers. The MIRROR acquisition was an exception and its failure makes future large-scale M&A unlikely in the near term.
Debt & Capital Structure
- Total traditional debt is negligible. Net debt is deeply negative due to a strong cash balance of over $1.5 billion.
- Debt/EBITDA ratio is near 0x (excluding operating leases).
- The company maintains an undrawn revolving credit facility for liquidity purposes.
- Interest rate profile is largely irrelevant for debt, but the company earns interest income on its cash balances.
- Share repurchase programme is highly active. The company frequently authorises $1 billion+ buyback programmes, repurchasing 1% to 3% of shares outstanding annually.
- Dividend policy: The company does not pay a dividend and reinvests cash into growth and share repurchases.
Cash Flow Characteristics
- Operating cash flow conversion (OCF / Net Income) typically ranges from 1.0x to 1.3x, though it can dip below 1.0x in years with heavy inventory build-ups.
- Free cash flow margin (FCF / Revenue) typically ranges from 10% to 14%.
- Major non-cash items include Depreciation and Amortisation, Stock-Based Compensation, and ROU asset amortisation.
- Working capital cash flow impact is highly seasonal. Cash is drained in Q2 and Q3 to build inventory and is generated massively in Q4.
- Capex intensity is moderate but essential for supporting the physical retail footprint.
- Cash tax rate closely tracks the GAAP effective tax rate of approximately 28% to 30%.
Sheet Structure
- Summary: Dashboard containing the key outputs, target price, DCF summary, and historical/projected charts.
- Assumptions: Hardcoded inputs for revenue drivers, margin profiles, working capital days, and valuation metrics.
- Store Roll-Forward: Detailed schedule of store openings, closures, and total square footage by geography (Americas, China Mainland, Rest of World).
- Revenue Build: Revenue projections split by Company-Operated Stores, DTC, and Other, driven by the Store Roll-Forward and digital traffic assumptions.
- Income Statement: Historical and projected P&L down to Net Income and EPS.
- Balance Sheet: Historical and projected assets, liabilities, and shareholders' equity.
- Cash Flow Statement: Indirect method cash flow statement linking Net Income to ending cash.
- Working Capital: Schedules for Accounts Receivable, Inventory, and Accounts Payable using days outstanding logic.
- Depreciation & Capex: PP&E roll-forward, capex assumptions, and depreciation calculations.
- Lease Schedule: Roll-forward of ROU assets and lease liabilities.
- Debt & Equity: Revolver schedule, share repurchase tracking, and basic shares outstanding calculations.
- DCF Valuation: Unlevered free cash flow calculation, WACC build, and terminal value calculation.
Key Financial Relationships
- Beginning Store Count + New Stores - Closed Stores = Ending Store Count
- Average Store Count = (Beginning Store Count + Ending Store Count) / 2
- Company-Operated Stores Revenue = Average Store Count x Average Revenue per Store
- DTC Revenue = Prior Year DTC Revenue x (1 + DTC Revenue Growth Rate)
- Total Revenue = Company-Operated Stores Revenue + DTC Revenue + Other Revenue
- Cost of Goods Sold = Total Revenue x (1 - Gross Margin Percentage)
- Gross Profit = Total Revenue - Cost of Goods Sold
- SG&A Expense = Total Revenue x SG&A Margin Percentage
- Operating Income = Gross Profit - SG&A Expense - D&A Expense (if D&A is excluded from SG&A)
- Ending Inventory = (Cost of Goods Sold / 365) x Days Inventory Outstanding
- Ending Accounts Payable = (Cost of Goods Sold / 365) x Days Payable Outstanding
- Free Cash Flow = Operating Cash Flow - Capital Expenditures
- Diluted Shares Outstanding = Prior Year Shares - (Share Repurchase Amount / Average Share Price)
Cross-Sheet Dependencies
The Assumptions sheet feeds directly into the Store Roll-Forward and Revenue Build. The outputs of the Revenue Build drive the top line of the 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 sheet uses Revenue and COGS from the Income Statement to calculate balance sheet items, and the year-over-year changes in these items flow into the Cash Flow Statement. The Cash Flow Statement determines the ending cash balance, which links back to the Balance Sheet. A circularity risk exists if interest income on cash balances is modelled dynamically, as interest income increases Net Income, which increases Cash, which in turn increases interest income. To resolve this, interest income should be calculated using the beginning cash balance.
Sign Convention
- Revenues, assets, and equity items are entered and displayed as positive numbers.
- Expenses (COGS, SG&A, D&A, Interest) are entered as positive numbers in the assumptions but subtracted in the Income Statement formulas.
- Liabilities are entered as positive numbers.
- On the Cash Flow Statement, cash inflows are positive and cash outflows (such as Capex, Share Repurchases, and Inventory increases) are negative.
Things Most Likely to Go Wrong
- Inventory levels are highly volatile. Failing to link inventory growth to COGS via DIO will result in inaccurate cash flow projections.
- The company experiences extreme Q4 seasonality. If building a quarterly model, applying a flat 25% revenue split per quarter will completely invalidate the margin and cash flow timing.
- Gross margin is highly sensitive to freight costs and markdown activity. Assuming a flat gross margin ignores the cyclicality of the apparel supply chain.
- The MIRROR impairment charges in historical years distort historical operating margins. The model must use adjusted operating margins for historical trend analysis.
- Foreign exchange translation significantly impacts reported revenue, especially given the rapid growth in China Mainland.
- Operating leases are a massive component of the balance sheet. Failing to properly model ROU asset amortisation and lease liability reduction will unbalance the balance sheet.
- Share repurchases are a primary use of cash. Forgetting to reduce the share count will result in understated EPS projections.
- DTC revenue growth is normalising post-pandemic. Extrapolating 2020-2021 growth rates will lead to wildly overstated out-year revenue.
Validation Checks
- Gross margin should remain within the 55% to 59% historical band. Flag if it exceeds 60%.
- Operating margin should stabilise around 21% to 23%.
- Days Inventory Outstanding (DIO) must remain between 100 and 140 days. A drop below 90 days implies unrealistic supply chain efficiency for this business model.
- Capex as a percentage of revenue should stay between 6% and 8%.
- The Balance Sheet must balance perfectly in every projected year (Total Assets = Total Liabilities + Shareholders' Equity).
- Free Cash Flow conversion (FCF / Net Income) should remain positive and generally above 70%.
- Total store count growth should align with management's "Power of Three x2" target of quadrupling international revenue.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Company-Operated Stores Rev Growth | 12.0 | % | Reflects continued store expansion in China and steady comparable sales. |
| DTC Revenue Growth | 15.0 | % | Normalised digital growth rate post-pandemic. |
| Other Revenue Growth | 10.0 | % | Steady growth in outlets to clear inventory. |
| Gross Margin | 58.3 | % | Based on FY23 actuals, reflecting normalised freight costs. |
| SG&A Margin | 36.1 | % | Based on FY23 actuals, reflecting ongoing investments in brand building. |
| Days Sales Outstanding (DSO) | 8 | Days | Retail business model with minimal receivables. |
| Days Inventory Outstanding (DIO) | 115 | Days | Historical average required to support global store network. |
| Days Payable Outstanding (DPO) | 45 | Days | Standard payment terms with third-party manufacturers. |
| Capex as % of Revenue | 7.0 | % | Midpoint of historical range for store build-outs and IT. |
| Effective Tax Rate | 29.0 | % | Blended statutory rates across North America and international jurisdictions. |
| Annual Share Repurchases | 750 | $ Millions | Consistent return of capital to shareholders. |
| Weighted Average Cost of Capital | 8.5 | % | Standard discount rate for a large-cap consumer discretionary stock. |
| Terminal Growth Rate | 3.0 | % | Long-term GDP growth plus premium brand pricing power. |
Data Sources & Benchmarks
- Filings: Lululemon Investor Relations website and SEC EDGAR database (10-K, 10-Q, 8-K).
- Peers for benchmarking: Nike (NKE), Deckers Outdoor (DECK), On Holding (ONON), and Gap Inc. (GPS) for Athleta comparisons.
- Industry data: NPD Group (now Circana) for activewear market share data.
- Consensus estimates: Bloomberg or FactSet for near-term revenue and EPS consensus.
- Alternative data: SimilarWeb for lululemon.com web traffic trends, and credit card panel data for North American consumer spending trends.
Sources
- Lululemon Athletica Inc. Form 10-K for the fiscal year ended January 28, 2024 (SEC EDGAR).
- Lululemon Athletica Inc. Q4 2023 Earnings Release and Supplemental Financial Information.
- Lululemon Investor Day 2022 Presentation ("Power of Three x2" strategy details).
- SEC EDGAR database (https://www.sec.gov/edgar).
- Lululemon Investor Relations (https://investor.lululemon.com/).
Do more with the Lululemon Athletica model
Frequently asked
What is Lululemon Athletica's core business model and product offering?+
Lululemon Athletica designs and retails premium athletic apparel, footwear, and accessories primarily for yoga, running, and training. The company operates through company-owned stores and a significant direct-to-consumer e-commerce segment, maintaining tight control over its distribution.
What are the primary revenue drivers for Lululemon Athletica?+
Lululemon's revenue is primarily driven by sales from its Company-Operated Stores and its growing Direct to Consumer (DTC) e-commerce segment. The company is focused on its "Power of Three x2" growth strategy, emphasizing expansion in international markets like China and further developing its digital channels.
What are Lululemon Athletica's capital expenditure priorities?+
Lululemon's capital expenditures, which range from 6% to 8% of revenue, are primarily allocated to growth initiatives. These include new store openings, particularly in China and the APAC region, along with store renovations and investments in supply chain and technology infrastructure to support its e-commerce platform.
How does Lululemon Athletica manage its working capital, particularly inventory?+
Lululemon maintains a positive net working capital profile, with inventory being a major use of cash, typically held for 110-130 days. The company must carefully manage its inventory investments, especially in anticipation of the peak Q4 selling season.
What is the purpose of the Lululemon Athletica financial model?+
The Lululemon Athletica financial model serves as a comprehensive equity valuation and scenario planning tool. Its primary purpose is to assess the company's ability to sustain its premium valuation multiple while executing its "Power of Three x2" growth strategy.
Is a financial model available for Lululemon Athletica, and what is its forecast horizon?+
Yes, a downloadable Excel financial model is available for Lululemon Athletica. This general corporate model provides a forecast horizon spanning from fiscal year 2026 through fiscal year 2030.
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.
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.
