All companies
Costco logo
StaplesCOST

Costco (COST) Financial Forecast Calculator

Interactive 5-year forecast and DCF for Costco. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from Costco’s most recent SEC filings.

Revenue FY30
$431.46B
from $242.29B
FCF FY30
$7.22B
Margin 1.7%
Enterprise value
$97.25B
0.4× LTM revenue
Equity value
$101.26B
Net debt -$4.01B
Revenue & free cash flow - history and 5-year forecast
Line (area)
Bars
Historicals from SEC EDGAR (grey). Forecast years (color) update live as you move the sliders.

Assumptions

Revenue growth (annual)
12.2%
-10.0%baseline 12.2%40.0%
Gross margin
12.7%
5.0%baseline 12.7%90.0%
Capex % of revenue
1.8%
0.0%baseline 1.8%30.0%
WACC (discount rate)
9.00%
4.0%baseline 9.0%18.0%
Terminal growth
2.50%
0.0%baseline 2.5%5.0%

Need this as an Excel model?

Keep iterating on the Costco forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Frequently asked

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.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview