Best Buy Financial Model

• Total assets: Approximately $15 billion to $16 billion.
• Key asset categories: Merchandise Inventories (largest tangible asset), Operating Lease Right-of-Use Assets, and Property and Equipment.
• Goodwill & intangibles as % of total assets: Approximately 6% to 8%, primarily stemming from historical acquisitions including GreatCall (Best Buy Health).
• Working capital profile:
• Days Sales Outstanding (DSO): 6 to 10 days (mostly credit card receivables and vendor receivables).
• Days Inventory Outstanding (DIO): 55 to 65 days.
• Days Payable Outstanding (DPO): 70 to 80 days.
• Net working capital as % of revenue: Negative 3% to negative 5%.
• Working capital dynamic: Best Buy operates with negative working capital. Vendors finance the inventory (DPO exceeds DIO). This means the company generates cash when revenue grows but consumes cash when revenue shrinks.
• PP&E: Primarily store fixtures, supply chain facilities, and IT equipment. Useful lives range from 3 to 15 years for fixtures and up to 40 years for buildings.
• Right-of-use assets / operating leases: Highly material, representing approximately $2.5 billion to $3.0 billion, reflecting the massive leased store portfolio.

• Capex as % of revenue: 1.8% to 2.2% (historically $700 million to $850 million annually).
• Maintenance capex vs. growth capex: Approximately 60% maintenance (store upkeep, routine IT) and 40% growth (store remodels, supply chain automation, digital platform enhancements).
• Major capex programmes underway or planned: FY2027 guidance is approximately $750 million, focused on store refreshes, AI initiatives, and supply chain modernisation.
• Capitalised software / development costs: Material component of capex, reflecting ongoing investments in the digital marketplace and Best Buy Ads platform.
• M&A pattern: Bolt-on acquirer, primarily focused on healthcare technology (e.g., GreatCall, Current Health) to build out the Best Buy Health segment.
• Typical acquisition multiple paid: Not regularly disclosed, but historical health acquisitions were completed at premium software/services multiples, leading to recent goodwill impairments.

• Total debt: Approximately $1.1 billion in long-term debt, plus approximately $2.6 billion in operating lease liabilities. Net debt is typically negative (cash exceeds traditional debt).
• Debt/EBITDA ratio: Gross leverage is typically below 1.0x (excluding operating leases).
• Credit rating: Investment grade (Baa1/BBB+).
• Key debt instruments: Senior unsecured notes with staggered maturities.
• Maturity profile: Well-laddered, with significant maturities typically handled via refinancing or cash on hand.
• Interest rate profile: Primarily fixed-rate bonds.
• Covenants: Standard investment-grade covenants; no restrictive financial maintenance covenants that are currently at risk.
• Share repurchase programme: Highly active. The company repurchased $273 million in FY2026 and targets approximately $300 million for FY2027.
• Dividend policy: Strong dividend payer. The company has raised its dividend for 8 consecutive years, with a recent quarterly payout of $0.96 per share, yielding over 5% and representing a payout ratio of approximately 50% to 60%.

• Operating cash flow conversion: Consistently above 1.0x net income, driven by depreciation add-backs and deferred revenue from memberships.
• Free cash flow margin: 2.5% to 4.0% of revenue.
• Major non-cash items: Depreciation and amortisation, stock-based compensation, and periodic goodwill impairments (e.g., Best Buy Health).
• Working capital cash flow impact: Because working capital is negative, a decline in sales results in a cash outflow as payables shrink faster than inventory is liquidated.
• Capex intensity: Relatively low compared to historical retail standards, as the company limits new square footage and focuses on remodels and IT.
• Cash tax rate vs. GAAP effective tax rate: Cash taxes generally track the adjusted effective tax rate of approximately 25.5%, though GAAP rates fluctuate wildly due to non-deductible goodwill impairments.

1. Assumptions: Hardcoded inputs for macroeconomic drivers, segment comparable sales, margin profiles, tax rates, and capital allocation targets.
2. Revenue Build: Detailed forecast of Domestic and International segments. Domestic must be broken down by Computing and Mobile Phones, Consumer Electronics, Appliances, Entertainment, and Services.
3. Income Statement: Consolidated GAAP and Non-GAAP P&L. Must include specific lines for Restructuring Charges and Goodwill Impairments to bridge GAAP to Adjusted Operating Income.
4. Working Capital: Schedules for Accounts Receivable, Merchandise Inventories, Accounts Payable, and Deferred Revenue, driven by DSO, DIO, and DPO.
5. Depreciation & Capex: Waterfall schedules for PP&E and capitalised software, linking to the cash flow statement.
6. Lease Schedule: Right-of-use asset amortisation and operating lease liability reduction, crucial for retail models.
7. Debt & Interest: Schedule of senior notes, interest expense calculations, and interest income on cash balances.
8. Shareholders Equity: Retained earnings roll-forward, tracking dividend payments and share repurchases.
9. Cash Flow Statement: Indirect method starting from Net Income, adjusting for non-cash items, working capital changes, capex, and financing activities.
10. Balance Sheet: Standard presentation ensuring Total Assets equals Total Liabilities plus Equity.
11. DCF Valuation: Unlevered free cash flow calculation, WACC derivation, terminal value calculation, and implied share price.

1. Domestic Revenue = Prior Year Domestic Revenue x (1 + Domestic Comparable Sales Growth)
2. International Revenue = Prior Year International Revenue x (1 + International Comparable Sales Growth)
3. Total Revenue = Domestic Revenue + International Revenue
4. Domestic Gross Profit = Domestic Revenue x Domestic Gross Margin % (historically 22.5% to 23.6%)
5. International Gross Profit = International Revenue x International Gross Margin % (historically 21.0% to 22.5%)
6. Consolidated Gross Profit = Domestic Gross Profit + International Gross Profit
7. SG&A Expense = Total Revenue x SG&A Margin % (historically 19.0% to 20.0%)
8. Adjusted Operating Income = Consolidated Gross Profit - SG&A Expense
9. Merchandise Inventories = (COGS / 365) x DIO
10. Accounts Payable = (COGS / 365) x DPO
11. Deferred Revenue = Prior Period Deferred Revenue + New Memberships Sold - Services Revenue Recognised
12. Share Count = Prior Period Share Count - (Share Repurchase Amount / Average Share Price)
13. Total Dividends Paid = Share Count x Annual Dividend Per Share

The Assumptions sheet dictates the growth rates and margin profiles feeding the Revenue Build and Income Statement. The Income Statement generates Net Income, which flows to the top of the Cash Flow Statement and feeds Retained Earnings on the Balance Sheet. The Revenue Build and COGS from the Income Statement drive the Working Capital sheet. Changes in working capital flow directly to the Operating Cash Flow section of the Cash Flow Statement. The Cash Flow Statement determines the ending cash balance, which flows to the Balance Sheet and dictates interest income on the Debt & Interest sheet. A circular reference exists between interest income/expense, net income, cash balances, and debt paydown; this must be managed with a circuit breaker toggle on the Assumptions sheet.

• Revenues and sales figures are entered and displayed as positive numbers.
• Expenses (COGS, SG&A, Interest Expense, Taxes) are entered as positive numbers and subtracted in formulas.
• On the Cash Flow Statement, cash inflows are positive and cash outflows (including Capex, Dividends, and Share Repurchases) are negative.
• Balance Sheet contra-accounts (e.g., Accumulated Depreciation) are entered as positive numbers and subtracted from gross assets.

• Failing to adjust historical data for the 53-week fiscal year anomaly (FY2024 had an extra week adding approximately $735 million in revenue, distorting YoY growth rates for FY2025).
• Mismodelling the negative working capital dynamic. If the model projects a severe revenue decline, it must show a massive cash outflow from working capital as payables drain faster than inventory.
• Ignoring the impact of the Best Buy Health goodwill impairments. GAAP EPS will look artificially depressed in FY2025/FY2026; the model must focus on Adjusted Operating Income and Adjusted EPS for valuation.
• Overlooking the profit-sharing revenue from the co-branded credit card, which Best Buy records as a reduction to COGS rather than as revenue. This artificially inflates the gross margin percentage.
• Failing to account for deferred revenue dynamics related to the My Best Buy Total membership programme, which creates a timing mismatch between cash collection and revenue recognition.
• Treating operating leases as standard debt. The amortisation of the right-of-use asset runs through SG&A, not interest expense, which impacts EBITDA calculations.
• Using a statutory tax rate instead of the adjusted effective tax rate (historically around 25.5%), which accounts for specific retail and state tax structures.
• Assuming linear SG&A scaling. Store payroll and rent are highly fixed; a drop in comparable sales will cause severe operating margin deleverage.

• Consolidated Gross Margin should remain in the 22.5% to 23.8% range; flag if outside this band.
• Adjusted Operating Margin must align with management guidance of 4.3% to 4.4% for FY2027.
• Capex should equal approximately $750 million annually; flag if it exceeds 2.5% of revenue.
• DPO must remain higher than DIO + DSO to maintain the negative working capital advantage.
• The Balance Sheet must balance perfectly in every projected period (Total Assets = Total Liabilities + Equity).
• Free Cash Flow conversion (FCF / Net Income) should remain above 80% due to low capital intensity.
• The dividend payout ratio should remain between 45% and 65% based on the stated dividend policy.
• Share count must decrease year-over-year if the $300 million share repurchase assumption is active.

• Filings: SEC EDGAR database for Best Buy Co., Inc. (BBY) 10-K and 10-Q filings.
• Investor Relations: investors.bestbuy.com for earnings press releases, non-GAAP reconciliations, and earnings call transcripts.
• Key Peers: Target (TGT), Walmart (WMT), Amazon (AMZN), and specialized retailers like Williams-Sonoma (WSM) for margin benchmarking.
• Industry Data: Consumer Technology Association (CTA) for industry-wide consumer electronics sales forecasts and replacement cycle data.
• Alternative Data: SimilarWeb for bestbuy.com web traffic trends; credit card aggregation data for intra-quarter domestic sales pacing.

• Best Buy Co., Inc. Form 10-K for the fiscal year ended February 2026 (filed via SEC EDGAR).
• Best Buy Q4 FY2026 Earnings Press Release and Financial Supplement (March 3, 2026).
• Best Buy Q3 FY2025 and Q4 FY2025 Earnings Press Releases (historical context and segment margin data).
• Best Buy Investor Relations website (investors.bestbuy.com) for historical segment reporting structures and non-GAAP reconciliations.