Costco Financial Model

• 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.

• 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.

• 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).

• 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%.

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.

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

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.

• 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.

• 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.

• 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.

• 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.

• 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.