# Costco (COST) Financial Model Free Excel 3-statement financial model and company analysis for Costco. - Canonical: https://finamodel.com/companies/costco - Industry: Retail - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/COST.xlsx ## Model Purpose This model provides a comprehensive equity valuation and operational forecast to determine if Costco's premium valuation multiple is justified by its membership fee growth, warehouse expansion pipeline, and high return on invested capital. ## Company Overview 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. The company generates revenue through two primary streams: high-volume merchandise sales at extremely low margins and high-margin membership fees. Business segments include: * Net Sales (approximately 98% of total revenue) * Membership Fees (approximately 2% of total revenue, but generating the vast majority of operating profit) Key geographies by revenue contribution are the United States (73%), Canada (14%), and Other International (13%). The business model is asset-heavy, as Costco owns the land and buildings for the majority of its warehouses. Its competitive position is dominant in the warehouse club industry, ranking as the third-largest retailer in the world, with key competitors including Walmart (Sam's Club), BJ's Wholesale Club, and Amazon. Recent major events include a highly anticipated membership fee increase implemented in September 2024 and a massive $15 per share special dividend paid in January 2024. ## Revenue Deep Dive ### Net Sales * **Segment name**: Net Sales (further broken down into Food and Sundries, Non-Food, Fresh Foods, and Warehouse Ancillary and Other). * **Revenue driver formula**: Total Warehouses x Average Sales per Warehouse, or alternatively modelled as Comparable Sales Growth (Traffic + Ticket) + Sales from New Warehouses. * **Historical growth rate**: 5% to 9% CAGR over the last 5 years. * **Key growth levers and headwinds**: Inflationary pressures on consumer spending, petrol price volatility (which heavily impacts the Ancillary segment top line), and the pace of new warehouse openings globally. * **Pricing dynamics**: Highly competitive. Costco caps its gross margins on merchandise (historically around 14% for private label Kirkland Signature and 11% for branded goods) to drive volume. * **Revenue recognition notes**: Recognised at the point of sale. E-commerce sales are recognised upon delivery. * **Seasonality**: The fiscal first quarter (ending late November) and second quarter (ending late February) benefit from the holiday shopping season. ### Membership Fees * **Segment name**: Membership Fees. * **Revenue driver formula**: Total Paid Cardholders x Average Fee per Cardholder. * **Historical growth rate**: 6% to 8% CAGR. * **Key growth levers and headwinds**: Executive member upgrades (who pay double the base fee and represent over 45% of members but over 70% of sales), international expansion, and periodic fee increases (typically every 5 to 6 years). * **Pricing dynamics**: Contractual and highly sticky. The US and Canada renewal rate consistently sits around 93%. * **Revenue recognition notes**: Recognised straight-line over the one-year term of the membership. This creates a large deferred revenue balance on the balance sheet. * **Seasonality**: Relatively smooth, though cash collection spikes slightly around major sign-up cohorts. ## Cost Structure ### Variable Costs / COGS * **Line-by-line breakdown**: Merchandise costs, inbound freight, and warehouse handling costs. * **Gross margin range**: 10.4% to 11.0% over the last 5 years. * **Key input costs and commodity exposures**: Food commodities, petrol prices (for gas stations), and global shipping rates. * **How COGS scales with revenue**: Almost perfectly linear. Costco passes savings directly to consumers, keeping gross margins structurally flat. ### Operating Expenses * **R&D**: Zero. Costco does not report R&D. * **SG&A**: Approximately 8.8% to 9.2% of revenue. This includes warehouse operating costs, payroll, benefits, utilities, and central administrative costs. It is heavily headcount-driven. * **Depreciation & Amortisation**: Approximately 0.8% of revenue. Almost entirely tangible depreciation related to warehouses and equipment. * **Stock-Based Compensation**: Approximately 0.3% of revenue. Relatively low compared to tech peers but material to cash flow adjustments. * **Restructuring / one-time charges**: Extremely rare. ### Margin Profile * **Gross margin**: 10.4% to 11.0%. * **EBITDA margin**: 4.0% to 4.3%. * **Operating margin**: 3.3% to 3.5%. * **Net margin**: 2.5% to 2.8%. * **Margin trend**: Highly stable. The company deliberately reinvests potential margin expansion into lower prices to drive volume and membership loyalty. ## Balance Sheet Structure * **Total assets**: Approximately $72 billion. * **Key asset categories**: Cash and cash equivalents, Merchandise Inventories, and Property and Equipment (PP&E). * **Goodwill & intangibles as % of total assets**: Less than 2%. Costco relies on organic growth rather than acquisitions. * **Working capital profile**: * **Days Sales Outstanding (DSO)**: 4 to 6 days (mostly credit card receivables). * **Days Inventory Outstanding (DIO)**: 28 to 32 days (extremely fast inventory turnover of 11x to 12x per year). * **Days Payable Outstanding (DPO)**: 38 to 42 days. * **Net working capital as % of revenue**: Negative 3% to negative 5%. * **Is working capital positive or negative?**: Negative. Costco sells its inventory before it has to pay its suppliers, meaning growth generates free cash flow from working capital. * **PP&E**: Represents over 40% of total assets. Consists of land, buildings, and equipment. Costco owns roughly 80% of its warehouses outright. * **Right-of-use assets / operating leases**: Material but manageable, representing approximately $3.5 billion, as the company prefers to own rather than lease. ## Capital Expenditure & Investment * **Capex as % of revenue**: 1.5% to 2.0% (approximately $4.0 billion to $4.5 billion annually). * **Maintenance capex vs. growth capex**: Roughly 30% maintenance and 70% growth (new warehouses, logistics networks, and e-commerce infrastructure). * **Major capex programmes underway or planned**: Expanding the international footprint, particularly in China and Europe, and expanding the Costco Logistics network for big-and-bulky home delivery. * **Capitalised software / development costs**: Immaterial. * **M&A pattern**: Exclusively organic grower. The only notable recent acquisition was Innovel Solutions in 2020 for $1 billion to bolster logistics. * **Typical acquisition multiple paid**: Not applicable. ## Debt & Capital Structure * **Total debt**: Approximately $5 billion to $7 billion in long-term debt. * **Net debt**: Deeply negative. Costco typically holds $10 billion to $15 billion in cash, making it net cash positive. * **Debt/EBITDA ratio**: Less than 0.5x. * **Credit rating**: A+ (S&P) / A1 (Moody's). * **Key debt instruments**: Senior unsecured notes. * **Maturity profile**: Well-laddered with average maturities exceeding 5 years. * **Interest rate profile**: Almost entirely fixed-rate bonds. * **Covenants**: Standard investment-grade covenants; no restrictive financial maintenance covenants. * **Share repurchase programme**: Active but modest, typically offsetting dilution. Historically $500 million to $1 billion annually. * **Dividend policy**: Regular quarterly dividend yielding around 0.5%, supplemented by massive special dividends every 3 to 4 years (e.g., $15 per share in early 2024, $10 per share in 2020). ## Cash Flow Characteristics * **Operating cash flow conversion**: 130% to 150% of Net Income. * **Free cash flow margin**: 2.5% to 3.5% of Revenue. * **Major non-cash items**: Depreciation and amortisation, stock-based compensation, and changes in deferred membership fees. * **Working capital cash flow impact**: Significant source of cash. As the company grows, the negative working capital cycle provides a float that funds operations. * **Capex intensity**: Low relative to revenue, but high in absolute dollar terms. * **Cash tax rate vs. GAAP effective tax rate**: Closely aligned, typically around 24% to 26%. ## Sheet Structure 1. **Assumptions**: Hardcoded inputs for macroeconomic drivers, warehouse growth, comparable sales, margins, and capital allocation. 2. **Scenarios**: Base, Bull, and Bear cases toggling key drivers like membership fee increases and warehouse opening velocity. 3. **Revenue & Membership Build**: Detailed schedule projecting beginning warehouses, openings, closings, ending warehouses, comparable sales growth, paid cardholders, and average membership fee. 4. **Income Statement**: Consolidated statement of earnings mirroring the 10-K (Net Sales, Membership Fees, Merchandise Costs, SG&A, Pre-opening Expenses, Operating Income, Interest Expense, Interest Income, Taxes, Net Income). 5. **Balance Sheet**: Standard assets, liabilities, and equity. Must explicitly break out Deferred Membership Fees and Merchandise Inventories. 6. **Working Capital**: Schedules for accounts receivable, inventory, accounts payable, and deferred revenue based on days outstanding metrics. 7. **PP&E & Capex**: Roll-forward of land, buildings, and equipment, calculating depreciation based on useful life and linking to the cash flow statement. 8. **Debt & Interest**: Debt schedule detailing senior notes, interest expense calculations, and interest income on the substantial cash balance. 9. **Cash Flow**: Indirect method starting with Net Income, adjusting for D&A, SBC, deferred revenue, and working capital changes, followed by investing (capex) and financing (dividends, buybacks, debt paydown). 10. **DCF Valuation**: Unlevered free cash flow calculation, WACC build, terminal value using the perpetuity growth method, and implied share price calculation. ## Key Financial Relationships 1. Ending Warehouses = Beginning Warehouses + New Openings - Closings 2. Net Sales = Prior Year Net Sales x (1 + Comparable Sales Growth) + (New Warehouses x Average First-Year Sales per Warehouse) 3. Total Paid Cardholders = Prior Year Cardholders x (1 + Cardholder Growth Rate) 4. Membership Fees = Total Paid Cardholders x Average Fee per Cardholder 5. Total Revenue = Net Sales + Membership Fees 6. Merchandise Costs = Net Sales x (1 - Gross Margin Percentage) 7. SG&A Expense = Total Revenue x SG&A Margin Percentage 8. Deferred Membership Fees (Balance Sheet) = Membership Fees x Deferred Recognition Factor (historically around 50% of annual fees) 9. Inventory Balance = (Merchandise Costs / 365) x Days Inventory Outstanding 10. Accounts Payable = (Merchandise Costs / 365) x Days Payable Outstanding 11. Interest Income = Average Cash Balance x Yield on Cash 12. Free Cash Flow = Cash from Operations - Capital Expenditures ## Cross-Sheet Dependencies The **Assumptions** and **Scenarios** sheets feed directly into the **Revenue & Membership Build**. The outputs of the revenue build (Net Sales and Membership Fees) drive the top line of the **Income Statement**. Net Sales and Merchandise Costs from the Income Statement feed the **Working Capital** sheet to calculate Receivables, Inventory, and Payables. These working capital balances flow to the **Balance Sheet** and their period-over-period changes flow to the **Cash Flow** sheet. The **Debt & Interest** sheet creates a circularity: interest income depends on the cash balance, which depends on net income, which depends on interest income. A circularity breaker (toggle switch) must be included to allow the model to calculate without crashing. Finally, the Cash Flow and Income Statement outputs feed the **DCF Valuation**. ## Sign Convention * Revenues, assets, and equity are entered and displayed as positive numbers. * Expenses on the Income Statement (Merchandise Costs, SG&A, Interest Expense) are entered as positive numbers and subtracted in subtotals. * Liabilities are entered as positive numbers. * On the Cash Flow statement, cash inflows are positive and cash outflows (such as capital expenditures, dividends, and debt repayments) are negative. * Working capital changes on the Cash Flow statement must follow standard accounting logic: an increase in an asset is a negative cash flow, while an increase in a liability is a positive cash flow. ## Things Most Likely to Go Wrong * Failing to separate Net Sales from Membership Fees will ruin the margin analysis, as membership fees have nearly a 100% gross margin and drive operating profit. * Mismodelling the negative working capital dynamic. If DPO falls below DIO, the model will incorrectly show working capital as a drain on cash during growth periods. * Ignoring the deferred membership fee liability. Cash is collected upfront but recognised over 12 months, creating a permanent deferred revenue balance that grows with the membership base. * Overestimating gross margin expansion. Costco structurally caps its gross margins. Any model showing gross margins climbing to 13% or 14% fundamentally misunderstands the business model. * Forgetting to model interest income. Costco holds massive cash balances, and in a higher interest rate environment, interest income is a material contributor to pre-tax income. * Mishandling special dividends. The historical cash flow statement will show massive financing outflows in specific years (like FY2024). The forecast must either normalise this or explicitly model future special dividends. * Petrol price volatility can swing Net Sales growth by 200 to 300 basis points year-over-year but has almost zero impact on absolute gross profit dollars. * Pre-opening expenses are reported separately from SG&A on the income statement and must be modelled as a function of new warehouse openings. ## Validation Checks * Gross margin on Net Sales must remain tightly bound between 10.4% and 11.0%. Flag if outside this band. * Operating margin should not exceed 4.0%. The company reinvests excess profit into price cuts. * Days Payable Outstanding (DPO) must be greater than Days Inventory Outstanding (DIO) to maintain the negative working capital advantage. * Membership renewal rates should be hardcoded or checked to remain above 88% globally and 92% in the US/Canada. * Capex as a percentage of total revenue should run between 1.5% and 2.0%. * The balance sheet must balance: Total Assets = Total Liabilities + Shareholders' Equity in every forecasted period. * Operating Cash Flow must exceed Net Income in every forecasted year due to the working capital float and deferred revenue. * Effective tax rate should remain between 24% and 26% absent major statutory changes. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Net Sales Growth (Base Case) | 6.5 | % | Blended average of historical traffic and ticket growth plus new store contributions. | | New Warehouse Openings | 28 | Count | Management guidance for annual global expansion pace. | | Membership Fee Growth | 7.0 | % | Reflects organic member growth plus the impact of the September 2024 fee increase. | | Gross Margin (on Net Sales) | 10.6 | % | Historical 5-year average; reflects commitment to low prices. | | SG&A Margin | 8.9 | % | Historical average; demonstrates strong cost control and operating leverage. | | Pre-opening Expenses per New Store | 3.5 | $ Millions | Historical average cost to launch a new warehouse. | | Days Sales Outstanding (DSO) | 5 | Days | Primarily credit card processing times. | | Days Inventory Outstanding (DIO) | 30 | Days | Reflects rapid inventory turnover of roughly 12x per year. | | Days Payable Outstanding (DPO) | 40 | Days | Reflects strong supplier negotiating power. | | Capex as % of Revenue | 1.7 | % | Aligns with management guidance of $4.0B to $4.5B annual spend. | | Effective Tax Rate | 25.5 | % | Based on recent historical GAAP tax rates. | | Regular Dividend Payout Ratio | 20.0 | % | Excludes special dividends; reflects the steady quarterly dividend policy. | | Yield on Cash | 4.0 | % | Assumed average yield on short-term investments and cash equivalents. | | WACC | 7.5 | % | Low cost of capital reflecting stable cash flows, low beta, and strong balance sheet. | | Terminal Growth Rate | 2.5 | % | Reflects long-term GDP growth and inflation pricing power. | ## Data Sources & Benchmarks * **Filings**: SEC EDGAR database for Costco Wholesale Corporation (COST) 10-K and 10-Q filings. Costco Investor Relations website for monthly sales reports and earnings call transcripts. * **Key Peers**: Walmart Inc. (WMT) specifically the Sam's Club division, BJ's Wholesale Club Holdings (BJ), and Target Corporation (TGT) for broader retail benchmarking. * **Industry Data**: US Census Bureau Retail Sales data (specifically warehouse clubs and supercentres), and petrol price indices (EIA) to model the ancillary segment. * **Consensus Estimates**: Bloomberg or FactSet for sell-side consensus on comparable sales growth and warehouse opening schedules. ## Sources * Costco Wholesale Corporation Form 10-K for the fiscal year ended September 1, 2024 (SEC EDGAR). * Costco Wholesale Corporation Form 10-Q filings for recent quarterly results. * Costco Investor Relations (investor.costco.com) for monthly sales metrics and historical dividend announcements. * Earnings call transcripts (Q4 2024 and Q1 2025) detailing the September 2024 membership fee increase and capital expenditure guidance. --- ## Frequently asked questions ### What is Costco's business model? Costco operates an international chain of membership warehouses that offer high-quality, brand-name merchandise at substantially lower prices. The company generates revenue through high-volume merchandise sales at low margins and high-margin membership fees. ### How does Costco generate its revenue? Costco's revenue primarily comes from net merchandise sales, which account for approximately 98% of its total revenue. The remaining 2% is generated by membership fees, which contribute the vast majority of its operating profit. ### What are the key capital expenditure assumptions in Costco's financial model? The financial model assumes Costco's capital expenditure as a percentage of revenue to be approximately 1.8%. This annual spend, estimated at $4.0 billion to $4.5 billion, is largely dedicated to growth initiatives such as new warehouses and expanding logistics networks. ### What is the purpose of the Costco financial model? The Costco financial model provides a comprehensive equity valuation and operational forecast. Its primary purpose is to determine if the company's premium valuation multiple is justified by factors like membership fee growth, warehouse expansion, and high return on invested capital. ### Can I download an Excel financial model for Costco? Yes, a downloadable Excel financial model for Costco is available. This model offers an operational forecast for the company from FY2026 through FY2030. ### Does Costco have positive or negative net working capital? Costco typically operates with negative net working capital, ranging from negative 3% to negative 5% of revenue. This structure means the company sells its inventory and collects cash before paying suppliers, allowing growth to generate free cash flow from working capital. [Interactive forecast calculator](https://finamodel.com/companies/costco/forecast)