Lowe's Financial Model
Retail Company Financials Example (Free Excel Download)
Lowe's Companies, Inc. is the second-largest home improvement retailer in the world, operating over 1,700 stores across the United States.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and scenario planning tool to assess how Lowe's strategic shift towards Pro customers, supply chain investments, and recent acquisitions (Foundation Building Materials and Artisan Design Group) will impact long-term earnings and free cash flow generation.
Lowe's Companies, Inc. is the second-largest home improvement retailer in the world, operating over 1,700 stores across the United States. The company serves both Do-It-Yourself (DIY) homeowners and Professional (Pro) customers, offering products for maintenance, repair, remodelling, and decorating.
Lowe's operates as a single reportable segment but tracks revenue across three primary product categories: Building & Maintenance (approx. 30-35%), Décor (approx. 35%), and Hardlines (approx. 30%). Following the divestiture of its Canadian retail business in early 2023, the company is entirely focused on the US market. The business model is asset-heavy, relying on an extensive physical store footprint and a massive distribution network, though it is increasingly supported by an omnichannel digital platform. Lowe's holds a strong #2 market position behind The Home Depot. Recently, the company has focused heavily on its "Total Home Strategy" to drive Pro penetration (currently around 30% of sales) and executed the acquisitions of Foundation Building Materials (FBM) and Artisan Design Group (ADG) in late fiscal 2025 to accelerate this growth.
The downloadable Lowe's 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 & AssumptionsLowe's financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $96.25B | $97.06B | $86.38B | $83.67B | $86.29B |
| Gross profit | $32.06B | $32.26B | $28.84B | $27.88B | $28.89B |
| Operating income | $12.09B | $10.16B | $11.56B | $10.47B | $10.15B |
| Net income | $8.44B | $6.44B | $7.73B | $6.96B | $6.65B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Lowe's
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Building & Maintenance
- Revenue driver formula: Total US Stores x Average Sales per Store x Category Mix %
- Historical growth rate: Low single-digit CAGR (highly dependent on macro housing turnover and Pro demand).
- Key growth levers and headwinds: Driven by lumber prices, building materials demand, and the success of the Pro loyalty programme. Headwinds include high mortgage rates locking in homeowners and reducing large-scale renovations.
- Pricing dynamics: Highly sensitive to commodity deflation/inflation (especially lumber and copper).
- Revenue recognition notes: Recognised at the point of sale; delivery fees are recognised when the service is provided.
- Seasonality: Steady throughout the year, but spikes slightly in Q2 and Q3 during peak construction months.
Décor
- Revenue driver formula: Total US Stores x Average Sales per Store x Category Mix %
- Historical growth rate: Flat to low single-digit CAGR.
- Key growth levers and headwinds: Driven by DIY discretionary spending, appliance upgrades, and interior remodelling. Pressured recently by a pullback in big-ticket discretionary purchases.
- Pricing dynamics: Competitive retail pricing, heavily promotional during holiday weekends (Memorial Day, Black Friday).
- Revenue recognition notes: Point of sale. Extended protection plans are deferred and recognised over the life of the contract.
- Seasonality: Strongest in Q4 due to holiday promotions and appliance sales.
Hardlines
- Revenue driver formula: Total US Stores x Average Sales per Store x Category Mix %
- Historical growth rate: Low single-digit CAGR.
- Key growth levers and headwinds: Includes lawn and garden, hardware, and tools. Highly weather-dependent.
- Pricing dynamics: Standard retail markup, competitive with local hardware stores and online marketplaces.
- Revenue recognition notes: Point of sale.
- Seasonality: Massive peak in Q1 and Q2 (spring and early summer) driven by outdoor and garden projects.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Inventory acquisition costs, inbound freight, distribution network costs, and inventory shrinkage.
- Gross margin range: 32.5% to 33.5% over the last 5 years (FY24 was 32.9%).
- Key input costs and commodity exposures: Lumber, copper, and petroleum (for freight).
- How COGS scales with revenue: Largely linear, though supply chain investments and Perpetual Productivity Improvement (PPI) initiatives provide slight operating leverage.
Operating Expenses
- R&D: Not material; technology investments are capitalised or sit in SG&A.
- SG&A: Store payroll, employee benefits, advertising, and corporate overhead. Heavily headcount-driven. Deleveraged recently due to wage inflation and bonus payouts.
- Depreciation & Amortisation: Approximately 2.0% to 2.2% of sales (roughly $1.8 billion annually), primarily related to store fixtures, buildings, and supply chain infrastructure.
- Stock-Based Compensation: Relatively small compared to tech, typically around 0.2% to 0.3% of sales.
- Restructuring / one-time charges: Occasional charges related to store closures or M&A integration (e.g., $149 million pre-tax expense in Q4 2025 for FBM and ADG acquisitions).
Margin Profile
- Gross margin: 32.5% to 33.5%.
- EBITDA margin: 14.0% to 15.0%.
- Operating margin: 11.5% to 12.5% (FY24 adjusted operating margin was 12.3%; FY26 guidance is 11.2% to 11.8% due to M&A integration).
- Net margin: 8.0% to 9.0%.
- Margin trend: Compressing slightly in the near term due to M&A integration and DIY spending pressure, but long-term expansion is expected via $1 billion in targeted PPI cost savings.
Balance Sheet Structure
- Total assets: Approximately $40 billion to $45 billion.
- Key asset categories: Merchandise Inventory (largest current asset), Operating Lease Right-of-Use Assets, and Property, Plant & Equipment.
- Goodwill & intangibles: Historically low, but increasing materially in FY26 due to the FBM and ADG acquisitions.
- Working capital profile:
- Days Sales Outstanding (DSO): Very low (3 to 5 days), as most sales are consumer credit or cash.
- Days Inventory Outstanding (DIO): 90 to 105 days (inventory builds ahead of spring).
- Days Payable Outstanding (DPO): 55 to 65 days.
- Net working capital as % of revenue: Typically negative or near zero.
- Is working capital positive or negative? Lowe's operates with negative to neutral working capital, using vendor financing (accounts payable) to fund inventory.
- PP&E: Land, buildings, store equipment, and distribution centres. Useful lives range from 5 to 15 years for equipment and up to 40 years for buildings.
- Right-of-use assets / operating leases: Highly material, typically representing $3.5 billion to $4.5 billion on the balance sheet due to leased store locations.
Capital Expenditure & Investment
- Capex as % of revenue: 2.5% to 3.0% (approximately $2.0 billion to $2.5 billion annually).
- Maintenance capex vs. growth capex: Roughly 60% maintenance (store refreshes, IT upkeep) and 40% growth (supply chain expansion, omnichannel technology, new store formats).
- Major capex programmes underway or planned: Total Home Strategy investments, supply chain modernisation, and Pro fulfilment centres.
- Capitalised software / development costs: Material component of growth capex as the company builds its online marketplace and Pro loyalty ecosystem.
- M&A pattern: Historically organic, but recently shifted to transformational bolt-ons with the FBM and ADG acquisitions to capture the complex Pro market.
Debt & Capital Structure
- Total debt: Approximately $35 billion to $38 billion (including operating lease liabilities).
- Debt/EBITDA ratio: Target Adjusted Debt to EBITDAR is 2.75x to 3.00x (ended FY24 at 3.01x).
- Credit rating: BBB+ (S&P) / Baa1 (Moody's).
- Key debt instruments: Unsecured senior notes, commercial paper programme, and a revolving credit facility.
- Maturity profile: Well-laddered, with average maturity exceeding 10 years.
- Interest rate profile: Predominantly fixed-rate bonds; net interest expense runs approximately $1.3 billion to $1.6 billion annually.
- Covenants: Standard leverage and interest coverage covenants on the revolver; currently well within limits.
- Share repurchase programme: Highly active. The company returned $6.5 billion to shareholders via buybacks and dividends in FY24.
- Dividend policy: Consistent dividend grower with a target payout ratio of approximately 35% of net earnings.
Cash Flow Characteristics
- Operating cash flow conversion: Consistently >1.0x net income due to high D&A and stable working capital.
- Free cash flow margin: 8.0% to 10.0% (generated $7.7 billion in FCF in FY24).
- Major non-cash items: Depreciation and amortisation, stock-based compensation, and deferred income taxes.
- Working capital cash flow impact: Seasonal use of cash in Q1 (inventory build) and source of cash in Q2/Q3.
- Capex intensity: Moderate (2.5% to 3.0% of sales).
- Cash tax rate vs. GAAP effective tax rate: Effective tax rate is approximately 24.5%. Cash taxes closely mirror the GAAP rate, with minor timing differences from accelerated depreciation.
Sheet Structure
- Assumptions: Hardcoded drivers for macro housing metrics, store counts, comparable sales, margins, and capital allocation.
- Scenarios: Base, Bull, and Bear cases toggling Pro penetration rates, DIY macro recovery, and M&A synergy realisation.
- Revenue & Comps Build: Calculates beginning stores, new store openings, closures, comparable store sales growth, and splits revenue by Building & Maintenance, Décor, and Hardlines.
- Income Statement: Consolidated P&L from Net Sales down to Net Earnings and EPS.
- Working Capital Schedule: Projects Accounts Receivable, Inventory, Accounts Payable, and Deferred Revenue based on days outstanding metrics.
- PP&E & Capex Schedule: Rolls forward gross PP&E, accumulated depreciation, and calculates D&A expense.
- Lease Schedule: Rolls forward Right-of-Use assets and lease liabilities.
- Debt & Interest Schedule: Tracks commercial paper, senior notes, interest expense, and calculates the Adjusted Debt to EBITDAR metric.
- Shareholders' Equity: Rolls forward retained earnings, tracks share repurchases, dividend payouts, and calculates ending basic and diluted share counts.
- Balance Sheet: Consolidated view ensuring Total Assets equals Total Liabilities plus Equity.
- Cash Flow Statement: Indirect method starting from Net Earnings, adjusting for non-cash items and working capital changes to arrive at Free Cash Flow.
- DCF Valuation: Unlevered free cash flow projection, WACC calculation, terminal value, and implied share price.
Key Financial Relationships
- `Total Stores = Prior Period Stores + New Stores Opened - Stores Closed`
- `Comparable Sales = Prior Period Sales x Comparable Sales Growth %`
- `Total Net Sales = Comparable Sales + Non-Comparable Sales (New Stores + M&A Contribution)`
- `Building & Maintenance Revenue = Total Net Sales x Building & Maintenance Mix %`
- `Pro Sales = Total Net Sales x Pro Penetration %`
- `Gross Profit = Total Net Sales x Gross Margin %`
- `SG&A Expense = Total Net Sales x SG&A % of Sales`
- `EBIT = Gross Profit - SG&A Expense - Depreciation & Amortisation`
- `Ending Inventory = (COGS / 365) x Days Inventory Outstanding`
- `Ending Accounts Payable = (COGS / 365) x Days Payable Outstanding`
- `Interest Expense = Average Debt Balance x Weighted Average Interest Rate`
- `Adjusted Debt to EBITDAR = (Total Debt + Capitalised Operating Leases) / (EBITDA + Rent Expense)`
- `Diluted Shares Outstanding = Prior Period Shares - (Share Repurchases / Average Share Price) + Options Dilution`
- `Dividends Paid = Diluted Shares Outstanding x Dividend Per Share`
Cross-Sheet Dependencies
- The Assumptions sheet dictates the inputs for the Revenue & Comps Build, Working Capital Schedule, and PP&E & Capex Schedule.
- The Revenue & Comps Build feeds the top line of the Income Statement.
- The Income Statement generates Net Earnings, which feeds the top of the Cash Flow Statement and Retained Earnings on the Shareholders' Equity sheet.
- The Working Capital Schedule calculates changes in operating assets and liabilities, feeding the operating section of the Cash Flow Statement.
- The PP&E & Capex Schedule feeds D&A to the Income Statement and Capex to the Cash Flow Statement.
- The Debt & Interest Schedule creates a circular reference: Interest Expense reduces Net Earnings, which reduces Cash, which dictates the need for revolver borrowing, which in turn changes Interest Expense. A circularity breaker (toggle) must be included.
- The Cash Flow Statement outputs the ending cash balance, which links to the Balance Sheet.
Sign Convention
- Income Statement: Revenues are positive. Expenses (COGS, SG&A, D&A, Interest, Taxes) are positive in their specific build schedules but must be subtracted from revenue to calculate profit subtotals.
- Balance Sheet: All assets, liabilities, and equity balances are positive.
- Cash Flow Statement: Net Income and non-cash add-backs are positive. Cash inflows (e.g., issuing debt) are positive. Cash outflows (e.g., Capex, dividends, share repurchases, debt repayment) are negative.
- Working Capital: An increase in an asset (e.g., Inventory) is a negative adjustment to cash flow. An increase in a liability (e.g., Accounts Payable) is a positive adjustment to cash flow.
Things Most Likely to Go Wrong
- 52/53-Week Fiscal Year: Lowe's fiscal year ends on the Friday nearest to January 31. Fiscal 2023 had 53 weeks, which skews historical comparable sales bases. The model must normalise for 52-week periods.
- Canadian Divestiture: Historical financials prior to Q1 2023 include the Canadian retail business. Using pre-2023 data to project future US-only store economics will severely understate average store productivity and overstate store counts.
- M&A Integration: The FY26 guidance includes the FBM and ADG acquisitions, which add significant revenue but carry lower initial operating margins due to integration costs. Applying historical standalone Lowe's margins to FY26 will overstate EBIT.
- Inventory Seasonality: If building a quarterly model, straight-lining inventory will break the cash flow statement. Inventory must peak in Q1 ahead of the spring selling season.
- Pro vs. DIY Mix: Pro sales carry different margin profiles and ticket sizes than DIY. Failing to model the mix shift (as Pro penetration moves from 30% towards 40%) will result in inaccurate gross margin forecasts.
- Share Repurchase Impact: Lowe's aggressively buys back stock. Failing to dynamically reduce the share count will severely understate EPS and overstate the total dividend cash burden.
- Lumber Deflation/Inflation: Commodity price swings can artificially inflate or deflate top-line revenue without corresponding volume changes. The model should note that comp sales include commodity impacts.
- Lease Accounting: Operating leases must be capitalised when calculating the Adjusted Debt to EBITDAR ratio to match rating agency and management methodologies.
Validation Checks
- "Gross margin should remain tightly bound between 32.5% and 33.5%; flag if the model projects outside this range."
- "Adjusted Operating Margin should not exceed 12.5% in the near term due to M&A integration headwinds."
- "Capex as a percentage of sales must remain between 2.5% and 3.0%."
- "Adjusted Debt to EBITDAR must remain near the 3.0x target; flag if leverage exceeds 3.2x or drops below 2.7x."
- "The Balance Sheet must balance perfectly in every period: Total Assets = Total Liabilities + Shareholders' Equity."
- "Free Cash Flow conversion (FCF / Net Income) should remain near or above 1.0x."
- "Effective tax rate should remain stable at approximately 24.5%."
- "Dividend payout ratio should track towards management's stated target of 35% of net earnings."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| FY26 Total Sales Growth | 8.0 | % | Midpoint of management guidance (7% to 9%) driven by FBM/ADG acquisitions. |
| Long-Term Comp Sales Growth | 2.0 | % | Historical average reflecting stable housing turnover and inflation. |
| Pro Penetration Target | 35.0 | % | Strategic goal to increase Pro mix from current ~30% base. |
| Gross Margin | 33.0 | % | Historical average, balancing supply chain investments with PPI savings. |
| SG&A % of Sales | 18.5 | % | Reflects recent wage inflation and M&A integration costs. |
| D&A Expense | 1.8 | $ Billions | Based on FY24 actuals and historical run-rate. |
| Effective Tax Rate | 24.5 | % | Management guidance for FY25/FY26. |
| Days Inventory Outstanding (DIO) | 95 | Days | Historical average required to support in-stock levels for Pro and DIY. |
| Days Payable Outstanding (DPO) | 60 | Days | Historical average reflecting strong vendor financing terms. |
| Capex | 2.5 | $ Billions | Management guidance for FY25/FY26. |
| Annual Share Repurchases | 4.5 | $ Billions | Normalised run-rate, slightly below FY24 peak to fund recent M&A. |
| Dividend Payout Ratio | 35.0 | % | Management's stated capital allocation target. |
| Cost of Debt | 4.5 | % | Weighted average interest rate on existing senior notes. |
| WACC | 8.5 | % | Standard discount rate for large-cap US retail. |
| Terminal Growth Rate | 2.0 | % | Aligned with long-term US GDP and inflation expectations. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the Lowe's Investor Relations website (ir.lowes.com).
- Key Peers for Benchmarking: The Home Depot (HD), Tractor Supply Company (TSCO), Floor & Decor (FND), and Builders FirstSource (BLDR) for the new Pro segments.
- Industry Data Sources: US Census Bureau (Monthly Retail Trade Report for Building Materials), National Association of Realtors (Existing Home Sales), and the Harvard Joint Center for Housing Studies (LIRA - Leading Indicator of Remodeling Activity).
- Consensus Estimates: FactSet or Bloomberg for forward-looking analyst estimates on comp sales and EPS.
Sources
- Lowe's Companies, Inc. Form 10-K for the Fiscal Year Ended February 2, 2024 (Filed March 2024).
- Lowe's Q4 2024 Earnings Release and Conference Call Transcript (February 26, 2025).
- Lowe's Q4 2025 Earnings Release and FY26 Guidance (February 25, 2026).
- Lowe's 2025 Total Home Strategy Investor Update (December 11, 2024).
Do more with the Lowe's model
Frequently asked
What is Lowe's core business and customer focus?+
Lowe's is the second-largest home improvement retailer globally, operating over 1,700 stores in the United States. It serves both Do-It-Yourself homeowners and Professional customers, offering products for maintenance, repair, remodelling, and decorating.
How does Lowe's generate revenue, and what are its key growth strategies?+
Lowe's generates revenue through sales across three primary product categories: Building & Maintenance, Décor, and Hardlines. The company is heavily focused on its "Total Home Strategy" to drive Pro customer penetration and has made recent acquisitions like Foundation Building Materials and Artisan Design Group to accelerate this growth.
What is Lowe's typical capital expenditure as a percentage of revenue, and what does it fund?+
Lowe's typically allocates 2.5% to 3.0% of its revenue towards capital expenditures, amounting to approximately $2.0 billion to $2.5 billion annually. These investments are split between maintenance (store refreshes, IT upkeep) and growth initiatives like supply chain expansion, omnichannel technology, and new store formats.
What is the purpose of the Lowe's financial model, and what key areas does it assess?+
The Lowe's financial model serves as a comprehensive equity valuation and scenario planning tool. It assesses how the company's strategic shift towards Pro customers, supply chain investments, and recent acquisitions will impact long-term earnings and free cash flow generation.
Can I download an Excel model for Lowe's, and what forecast horizon does it cover?+
Yes, an Excel model for Lowe's is available for download. This model provides a forecast horizon covering fiscal years 2026 through 2030, allowing for detailed analysis of future performance.
What is Lowe's working capital profile, and is it typically positive or negative?+
Lowe's operates with a negative to neutral net working capital profile, primarily due to its efficient use of vendor financing. The company funds its inventory through accounts payable, resulting in very low Days Sales Outstanding and Days Payable Outstanding.
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.
Kroger
Kroger 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.
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.
