Pool Financial Model
Retail Company Financials Example (Free Excel Download)
Pool Corporation is the world's largest wholesale distributor of swimming pool supplies, equipment, and related leisure products.
professionals from Deloitte
Used by professionals from
About this model
This financial model provides a comprehensive equity valuation and scenario analysis tool for Pool Corporation (POOL), allowing an analyst to forecast earnings and cash flow based on the critical mix shift between stable, non-discretionary pool maintenance revenues and highly cyclical new pool construction volumes.
Pool Corporation is the world's largest wholesale distributor of swimming pool supplies, equipment, and related leisure products. The company operates a vast network of sales centres, serving pool builders, retail stores, and service companies.
While the company operates as a single reportable segment, its revenue is driven by three distinct end-market activities:
- Maintenance and Minor Repair (approximately 64% of revenue): Non-discretionary recurring revenue.
- Renovation and Remodel (approximately 22% of revenue): Partially discretionary upgrades to existing pools.
- New Pool Construction (approximately 14% of revenue): Highly discretionary and tied to housing starts and interest rates.
Geographically, the business is highly concentrated in North America (96% of sales), with the four largest sunbelt states (Florida, California, Texas, and Arizona) accounting for 54% of total revenue. The business model is an asset-light wholesale distribution network that benefits from immense scale, purchasing power, and high route density. Pool Corporation holds a dominant competitive position, acting as the undisputed industry leader with significant market share over fragmented regional distributors. Recent major events include the normalisation of demand following a pandemic-era surge in pool construction, alongside strategic investments in the POOL360 digital ecosystem and the expansion of the Pinch A Penny franchise network.
The downloadable Pool 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 & AssumptionsPool financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $5.30B | $6.18B | $5.54B | $5.31B | $5.29B |
| Gross profit | $1.62B | $1.93B | $1.66B | $1.58B | $1.57B |
| Operating income | $832.8M | $1.03B | $746.6M | $617.2M | $580.2M |
| Net income | $650.6M | $748.5M | $523.2M | $434.3M | $406.4M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Pool
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Maintenance and Minor Repair
- Segment name: Maintenance and Minor Repair
- Revenue driver formula: Installed Base of Pools x Average Maintenance Spend per Pool x Inflation/Pricing Factor
- Historical growth rate: 5% to 8% CAGR historically, though flat in recent normalisation periods.
- Key growth levers and headwinds: Driven by the cumulative number of pools built in prior years (the installed base). Headwinds include extreme weather events (unseasonably cold or wet weather) which delay pool openings.
- Pricing dynamics: High pricing power. Chemical prices (representing 14% to 15% of total sales) can fluctuate with commodity costs, but POOL generally passes these on to consumers.
- Revenue recognition notes: Recognised at the point of sale when the customer takes control of the product.
- Seasonality: Highly seasonal. The second and third quarters account for the vast majority of sales and profitability due to the North American summer pool season.
Renovation and Remodel
- Segment name: Renovation and Remodel
- Revenue driver formula: Aging Pool Base x Upgrade Propensity x Average Ticket Size
- Historical growth rate: 2% to 5% CAGR, highly dependent on consumer confidence.
- Key growth levers and headwinds: Driven by technological upgrades (variable speed pumps, smart pool automation, energy-efficient heaters). Headwinds include tightening consumer credit and lower home equity withdrawal rates.
- Pricing dynamics: Competitive but supported by vendor rebates and private label penetration.
- Revenue recognition notes: Point of sale.
- Seasonality: Peaks in spring (Q2) as homeowners prepare for the summer season.
New Pool Construction
- Segment name: New Pool Construction
- Revenue driver formula: Total US New Pool Permits x POOL Market Share x Revenue per New Pool
- Historical growth rate: Highly volatile. Surged during 2020 to 2022, but declined significantly (down 15% to 20% year-over-year) in 2024 and 2025 due to high interest rates.
- Key growth levers and headwinds: Directly tied to macroeconomic factors, specifically mortgage rates, housing turnover, and consumer confidence.
- Pricing dynamics: Spot pricing based on contractor demand and equipment availability.
- Revenue recognition notes: Point of sale.
- Seasonality: Construction occurs year-round in sunbelt states but is heavily weighted towards Q1 and Q2 in seasonal markets.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Product purchase costs, freight-in, and inventory shrinkage, net of vendor rebates and purchase incentives.
- Gross margin range: 29.0% to 31.3% over the last 5 years (29.7% in 2024 and 2025).
- Key input costs and commodity exposures: PVC, steel, and chemical commodities (chlorine).
- How COGS scales with revenue: Linear, though gross margins expand slightly during periods of high inflation due to inventory holding gains and vendor volume rebates.
Operating Expenses
- R&D: Not material. The company is a distributor, not a manufacturer.
- SG&A: Reported as "Selling and administrative expenses". This includes sales centre facility costs (rent, utilities), wages, insurance, and technology investments (POOL360). Runs at 16.5% to 18.0% of revenue.
- Depreciation & Amortisation: Relatively low, typically 0.5% to 1.0% of revenue, reflecting the asset-light leased branch network.
- Stock-Based Compensation: Modest, but creates volatility in the effective tax rate due to ASU 2016-09 benefits.
- Restructuring / one-time charges: Rare.
Margin Profile
- Gross margin: 29.0% to 31.3%.
- EBITDA margin: 12.5% to 15.0%.
- Operating margin: 11.0% to 13.5% (11.6% in 2024, 11.1% in 2025).
- Net margin: 7.5% to 9.5%.
- Margin trend: Compressing slightly from pandemic peaks due to negative operating leverage as new pool construction volumes decline, offset partially by pricing optimisation and private label growth.
Balance Sheet Structure
- Total assets: Approximately $3.5 billion to $4.0 billion.
- Key asset categories: Inventory is the largest asset ($1.3 billion to $1.5 billion), followed by Receivables.
- Goodwill & intangibles: Approximately 15% to 20% of total assets, stemming from historical bolt-on acquisitions and the Pinch A Penny acquisition.
- Working capital profile:
- Days Sales Outstanding (DSO): 26 to 28 days.
- Days Inventory Outstanding (DIO): 110 to 130 days (inventory is built up heavily in Q1/Q4 ahead of the season).
- Days Payable Outstanding (DPO): 35 to 45 days.
- Net working capital as % of revenue: 20% to 25%.
- Working capital dynamic: Positive working capital. The company consumes significant cash to build inventory in the winter and spring, and generates massive cash flow in the summer and autumn as receivables are collected and inventory is drawn down.
- PP&E: Minimal. Mostly leasehold improvements, warehouse equipment, and delivery vehicles.
- Right-of-use assets: Material, as the company leases almost all of its 450+ sales centres.
Capital Expenditure & Investment
- Capex as % of revenue: 1.0% to 1.5%.
- Maintenance capex vs. growth capex: Roughly 40% maintenance (fleet, warehouse upkeep) and 60% growth (new greenfield locations, technology investments).
- Major capex programmes: Expansion of the POOL360 digital ecosystem and opening 10 to 15 new greenfield sales centres annually.
- Capitalised software: Modest but growing due to digital initiatives.
- M&A pattern: Serial bolt-on acquirer of independent regional distributors and franchise networks.
Debt & Capital Structure
- Total debt: $950 million to $1.2 billion.
- Debt/EBITDA ratio: 1.2x to 1.8x (conservative leverage profile).
- Credit rating: Investment grade profile, though often relies on bank facilities rather than rated public bonds.
- Key debt instruments: Unsecured revolving credit facility and term loans.
- Maturity profile: Generally staggered 3 to 5 year bank facilities.
- Interest rate profile: Predominantly floating rate, subject to interest rate swaps.
- Covenants: Standard leverage and interest coverage ratios; the company operates with massive headroom.
- Share repurchase programme: Highly active. The company repurchased $341 million in 2025 and uses excess free cash flow consistently for buybacks.
- Dividend policy: Consistent dividend grower. Payout ratio is typically 35% to 45%, with a yield around 1.5% to 2.0%.
Cash Flow Characteristics
- Operating cash flow conversion: Exceptional. OCF / Net Income frequently exceeds 120% (was 152% in 2024) due to non-cash charges and working capital harvesting during revenue plateaus.
- Free cash flow margin: 8.0% to 10.0%.
- Major non-cash items: Depreciation, amortisation, stock-based compensation, and deferred taxes.
- Working capital cash flow impact: Highly counter-cyclical. When revenue shrinks, the company liquidates inventory and generates massive cash flow. When revenue grows rapidly, working capital is a major use of cash.
- Capex intensity: Very low, driving high free cash flow conversion.
- Cash tax rate vs. GAAP effective tax rate: GAAP tax rate is around 25%, but is frequently lowered by ASU 2016-09 tax benefits related to stock-based compensation (which added $0.23 to EPS in 2024 and $0.12 in 2025).
Sheet Structure
- Assumptions: Hardcoded inputs for macroeconomic drivers, segment growth rates, margin profiles, and working capital days.
- Revenue Build: Forecasts revenue by the three end-market drivers (Maintenance, Remodel, New Construction) using volume and price assumptions.
- Income Statement: Consolidated P&L mirroring the 10-K, including Net Sales, Cost of Sales, Gross Profit, Selling and Administrative Expenses, Operating Income, Interest Expense, and Net Income.
- Working Capital: Schedules for Accounts Receivable, Inventory, and Accounts Payable based on DSO, DIO, and DPO.
- Depreciation & Capex: Waterfall schedule for PP&E and capitalised software.
- Debt Schedule: Tranches of the revolving credit facility and term loans, calculating interest expense based on average balances.
- Balance Sheet: Standard balancing statement linking assets, liabilities, and equity.
- Cash Flow Statement: Indirect method starting from Net Income, adjusting for working capital changes, capex, debt paydown, dividends, and share repurchases.
- Valuation: DCF model using unlevered free cash flow, WACC, and terminal multiple, plus an EPS/PE multiple valuation check.
Key Financial Relationships
- `Total Net Sales = Maintenance Revenue + Remodel Revenue + New Construction Revenue`
- `Maintenance Revenue = Prior Year Maintenance Revenue * (1 + Installed Base Growth + Maintenance Price/Mix)`
- `New Construction Revenue = Prior Year New Construction Revenue * (1 + New Pool Volume Growth + Equipment Price Growth)`
- `Cost of Sales = Total Net Sales * (1 - Blended Gross Margin %)`
- `Selling and Administrative Expenses = Fixed SG&A + (Total Net Sales * Variable SG&A %)`
- `Operating Income = Total Net Sales - Cost of Sales - Selling and Administrative Expenses`
- `Accounts Receivable = (Total Net Sales / 365) * DSO`
- `Inventory = (Cost of Sales / 365) * DIO`
- `Accounts Payable = (Cost of Sales / 365) * DPO`
- `Interest Expense = Average Total Debt * Weighted Average Interest Rate`
- `Effective Tax Rate = Base Statutory Rate - (ASU 2016-09 Benefit / Pre-Tax Income)`
- `Share Count = Prior Year Share Count - (Share Repurchase Amount / Average Share Price)`
- `Dividends Paid = Share Count * Annual Dividend Per Share`
- `Free Cash Flow = Cash from Operations - Capital Expenditures`
Cross-Sheet Dependencies
- The Assumptions sheet dictates the growth rates in the Revenue Build.
- The Revenue Build feeds the top line of the Income Statement and drives Accounts Receivable in the Working Capital sheet.
- Cost of Sales from the Income Statement drives Inventory and Accounts Payable in the Working Capital sheet.
- The Working Capital changes feed the Cash Flow Statement.
- The Cash Flow Statement determines the ending cash balance or required revolver draw in the Debt Schedule.
- The Debt Schedule calculates Interest Expense, which loops back to the Income Statement (potential circularity requiring an iterative calculation or a switch to break the loop).
- Net Income from the Income Statement feeds Retained Earnings on the Balance Sheet.
Sign Convention
- Income Statement: Revenue is positive. Expenses (COGS, SG&A, Interest, Taxes) are negative.
- Balance Sheet: Assets are positive. Liabilities and Equity are positive.
- Cash Flow Statement: Cash inflows (Net Income, depreciation, increases in payables, debt issuance) are positive. Cash outflows (increases in inventory/receivables, capex, dividends, share repurchases, debt repayment) are negative.
Things Most Likely to Go Wrong
- Failing to model the counter-cyclical nature of cash flows. The model must show working capital as a source of cash when revenue declines, and a use of cash when revenue grows.
- Ignoring the ASU 2016-09 tax benefit. This stock-based compensation tax benefit artificially lowers the effective tax rate and boosts EPS. The model should separate the core tax rate (around 25%) from this benefit.
- Overestimating operating leverage. Because POOL operates a physical branch network, SG&A has a high fixed component. Margin compresses quickly if revenue falls.
- Misunderstanding the revenue mix. Applying a blanket growth rate to total revenue ignores the fact that 64% of the business (Maintenance) is highly stable, while 14% (New Construction) is highly volatile.
- Assuming linear inventory days. Inventory builds heavily in Q1 and Q4. If building a quarterly model, flat DIO will break the cash flow phasing.
- Forgetting vendor rebates. These are a material reduction to COGS and are tied to volume targets. If volumes drop significantly, gross margins will compress faster than expected as rebate tiers are missed.
- Double-counting tariff impacts. 2024 gross margin included a 20 basis point benefit from a $12.6 million import tax reversal. This must be excluded from the go-forward run rate.
- Underestimating the impact of share repurchases on EPS. POOL consistently buys back stock, which provides a floor to EPS growth even in flat revenue environments.
Validation Checks
- Gross margin should remain tightly bound between 29.0% and 30.5%. Flag if it exceeds 31.0%.
- Operating margin should remain between 11.0% and 13.0%. Flag if it drops below 10.0%.
- OCF/Net Income conversion should be >1.0x in most years.
- Debt/EBITDA should remain below 2.0x based on the company's conservative financial policy.
- Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period.
- Maintenance revenue growth should not be negative unless there is a severe deflationary environment.
- Capex as a % of revenue should not exceed 2.0%.
- The effective tax rate (excluding ASU benefits) should be approximately 25.0%.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Maintenance Revenue Growth | 3.0 | % | Reflects steady installed base growth and modest pricing power. |
| Remodel Revenue Growth | 1.0 | % | Assumes sluggish consumer discretionary spending environment. |
| New Construction Revenue Growth | -5.0 | % | Reflects continued pressure from high interest rates and housing turnover. |
| Gross Margin | 29.7 | % | Matches actual 2024 and 2025 reported gross margin. |
| SG&A as % of Revenue | 18.0 | % | Matches 2024 actuals, reflecting network expansion costs. |
| Days Sales Outstanding (DSO) | 26.5 | Days | Based on 2024 trailing four-quarter average. |
| Days Inventory Outstanding (DIO) | 120.0 | Days | Reflects heavy inventory requirements for distribution network. |
| Days Payable Outstanding (DPO) | 40.0 | Days | Historical average for vendor payment terms. |
| Capex as % of Revenue | 1.2 | % | Historical average for maintenance and greenfield expansion. |
| Effective Tax Rate (Base) | 25.0 | % | Stated core tax rate excluding ASU 2016-09 benefits. |
| Average Interest Rate on Debt | 5.5 | % | Reflects current floating rate environment on bank facilities. |
| Annual Share Repurchases | 300.0 | $M | Consistent with 2024/2025 capital return policy. |
| Dividend Payout Ratio | 40.0 | % | Aligns with management's target to return cash to shareholders. |
| WACC | 8.5 | % | Standard discount rate for a stable, US-centric distributor. |
| Terminal Growth Rate | 2.5 | % | Aligns with long-term GDP and installed pool base growth. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the POOLCORP Investor Relations website.
- Key Peers: Watsco (WSO - HVAC distribution), SiteOne Landscape Supply (SITE - landscaping distribution), Beacon Roofing Supply (BECN - roofing distribution).
- Industry Data: Pkdata (swimming pool industry statistics), US Census Bureau (housing starts and pool permits).
- Consensus Estimates: FactSet or Bloomberg for forward-looking EPS and revenue estimates.
Sources
Do more with the Pool model
Frequently asked
What does Pool Corporation (POOL) do?+
Pool Corporation is the world's largest wholesale distributor of swimming pool supplies, equipment, and related leisure products. The company operates a vast network of sales centers, serving pool builders, retail stores, and service companies primarily across North America.
What are the primary revenue drivers for Pool Corporation?+
Pool Corporation's revenue is driven by three distinct end-market activities: maintenance and minor repair (approximately 64%), renovation and remodel (approximately 22%), and new pool construction (approximately 14%). New pool construction is highly discretionary and tied to housing starts and interest rates, while maintenance is non-discretionary.
What is Pool Corporation's typical capital expenditure as a percentage of revenue?+
Pool Corporation's capital expenditure typically ranges from 1.0% to 1.5% of revenue. This capex is roughly 40% for maintenance, covering fleet and warehouse upkeep, and 60% for growth, including new greenfield locations and technology investments.
How does Pool Corporation's working capital profile affect its cash flow?+
Pool Corporation exhibits a positive working capital dynamic, consuming significant cash to build inventory in the winter and spring ahead of the peak season. Conversely, the company generates substantial cash flow in the summer and autumn as receivables are collected and inventory levels are drawn down.
Can I download a financial model for Pool Corporation (POOL)?+
Yes, a comprehensive equity valuation and scenario analysis Excel model for Pool Corporation (POOL) is available for download. This model allows analysts to forecast earnings and cash flow based on the critical mix shift between stable maintenance revenues and highly cyclical new pool construction volumes.
What are the key asset categories on Pool Corporation's balance sheet?+
Inventory is the largest asset category for Pool Corporation, typically ranging from $1.3 billion to $1.5 billion, followed by receivables. Goodwill and intangibles also represent a material portion, making up approximately 15% to 20% of total assets.
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.
Lowe's
Lowe's is the second-largest home improvement retailer in the world, serving both DIY homeowners and professional customers with products for maintenance, repair, remodelling, and decorating.
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.
