# Best Buy (BBY) Financial Model Free Excel 3-statement financial model and company analysis for Best Buy. - Canonical: https://finamodel.com/companies/best-buy - Industry: Retail - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/BBY.xlsx ## Model Purpose This model provides a comprehensive three-statement forecast and discounted cash flow valuation to determine Best Buy Co., Inc.'s intrinsic equity value, enabling an equity research analyst to assess whether the stock is mispriced relative to its fundamental cash generation capacity and capital return programme. ## Company Overview Best Buy is a leading multinational consumer electronics retailer providing technology products, services, and solutions. The company operates through two primary business segments: Domestic (approximately 92% of total revenue) and International (approximately 8% of total revenue, primarily in Canada). The business model is an omnichannel retail operation, blending a massive physical store footprint with a robust digital platform where online sales account for over 30% of domestic revenue. Best Buy holds a dominant competitive position as the last remaining national dedicated consumer electronics big-box retailer in the United States, competing primarily against mass merchants like Walmart and Target, as well as e-commerce giants like Amazon. Recent major events include the scaling of the Best Buy Health initiative, store footprint optimisation, and the launch of Best Buy Express locations in Canada, alongside restructuring efforts that included significant goodwill impairments related to the health business. ## Revenue Deep Dive ### Domestic Segment - **Segment name:** Domestic - **Revenue driver formula:** (Prior Year Revenue x (1 + Comparable Sales Growth)) + (Net New Stores x Average Store Volume) + Digital Marketplace Revenue - **Historical growth rate:** -5% to +1% over the last 3 years (impacted by post-pandemic normalisation and macroeconomic pressures) - **Key growth levers and headwinds:** Growth is driven by replacement cycles in computing and mobile phones, expansion of the paid membership programme (My Best Buy Total), and growth in Best Buy Ads. Headwinds include a pressured consumer electronics environment, housing market stagnation impacting appliance sales, and intense promotional environments. - **Pricing dynamics:** Highly competitive and promotional, with price-matching guarantees to defend market share against online pure-plays. - **Revenue recognition notes:** Product revenue is recognised at the point of sale or upon delivery. Services revenue (including memberships) is deferred and recognised over the contract period. - **Seasonality:** Highly seasonal, with the fourth fiscal quarter (holiday season) historically accounting for approximately 33% of annual revenue and an outsized portion of operating profit. ### International Segment - **Segment name:** International - **Revenue driver formula:** Prior Year Revenue x (1 + Comparable Sales Growth) x Foreign Exchange Translation Factor - **Historical growth rate:** -3% to +4% over the last 3 years - **Key growth levers and headwinds:** Driven by the rollout of smaller-format Best Buy Express stores in Canada and mobile phone replacement cycles. Headwinds include foreign currency fluctuations (Canadian Dollar) and local macroeconomic pressures. - **Pricing dynamics:** Similar to the Domestic segment, driven by local competitive dynamics and vendor pricing policies. - **Revenue recognition notes:** Standard point-of-sale recognition, consistent with the Domestic segment. - **Seasonality:** Mirrors the Domestic segment with a heavy skew towards the fiscal fourth quarter. ## Cost Structure ### Variable Costs / COGS - **Line-by-line breakdown:** Product costs, inbound freight, supply chain costs, delivery costs, and physical store inventory shrinkage. Profit-sharing revenue from the private label credit card is recorded as a reduction to COGS. - **Gross margin range:** 22.0% to 23.6% over the last 5 years. - **Key input costs and commodity exposures:** Fuel costs for delivery, ocean freight rates, and vendor promotional support. - **How COGS scales with revenue:** Largely linear with product sales, though services and membership revenues carry significantly higher gross margins, providing operating leverage as the mix shifts towards services. ### Operating Expenses - **R&D:** Not material or separately disclosed; technology investments are embedded in SG&A. - **SG&A:** Includes store payroll, advertising, depreciation, corporate overhead, and Best Buy Health operating expenses. SG&A typically runs at 19.0% to 20.0% of revenue. - **Depreciation & Amortisation:** Typically 1.8% to 2.2% of revenue, primarily related to store fixtures, supply chain infrastructure, and capitalised software. - **Stock-Based Compensation:** Approximately 0.3% to 0.5% of revenue, relatively low compared to technology companies. - **Restructuring / one-time charges:** Frequent in recent years, including a $190 million charge in FY2026 for labour and store optimisation, and a $171 million impairment related to Best Buy Health. ### Margin Profile - **Gross margin:** 22.0% to 23.6% (expanding recently due to services mix and advertising revenue). - **EBITDA margin:** 5.5% to 6.5%. - **Operating margin:** 3.5% to 4.5% (Adjusted operating margin guided to 4.3% to 4.4% for FY2027). - **Net margin:** 2.5% to 3.5%. - **Margin trend:** Stable to slightly expanding on an adjusted basis, as cost reduction initiatives and higher-margin services offset product margin pressure and flat-to-declining comparable sales. ## Balance Sheet Structure - **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. ## Capital Expenditure & Investment - **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. ## Debt & Capital Structure - **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%. ## Cash Flow Characteristics - **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. ## Sheet Structure 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. ## Key Financial Relationships 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 ## Cross-Sheet Dependencies 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. ## Sign Convention - 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. ## Things Most Likely to Go Wrong - 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. ## Validation Checks - 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. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Domestic Comparable Sales Growth | 0.5 | % | Midpoint of FY2027 guidance (-1.0% to +1.0%) | | International Comparable Sales Growth | 1.0 | % | Assumes slight outperformance driven by Canadian Express store rollout | | Domestic Gross Margin | 23.4 | % | Aligns with recent FY2026 actuals, supported by services mix | | International Gross Margin | 21.8 | % | Aligns with recent FY2026 actuals | | SG&A as % of Revenue | 19.3 | % | Based on FY2026 actuals and cost control initiatives | | Days Inventory Outstanding (DIO) | 60 | Days | Historical average reflecting supply chain normalisation | | Days Payable Outstanding (DPO) | 75 | Days | Historical average reflecting strong vendor financing terms | | Days Sales Outstanding (DSO) | 8 | Days | Historical average (primarily credit card receivables) | | Capital Expenditures | 750 | $ Millions | Exact match to management's FY2027 guidance | | Adjusted Effective Tax Rate | 25.5 | % | Exact match to management's FY2027 guidance | | Annual Share Repurchases | 300 | $ Millions | Exact match to management's FY2027 target | | Annual Dividend Per Share | 3.84 | $ | Based on the recent quarterly raise to $0.96 per share | | Weighted Average Cost of Capital | 8.5 | % | Standard assumption for a mature, investment-grade retailer | | Terminal Growth Rate | 1.5 | % | Reflects mature industry growth slightly below long-term GDP | ## Data Sources & Benchmarks - **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. ## Sources - 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. --- ## Frequently asked questions ### What is Best Buy's primary business model? Best Buy operates as a multinational consumer electronics retailer, offering technology products, services, and solutions through an omnichannel approach. This model combines a large physical store presence with a robust digital platform, where online sales contribute significantly to domestic revenue. ### How does Best Buy generate its revenue? Best Buy generates revenue primarily through its Domestic and International business segments, selling consumer electronics and related services. Online sales account for over 30% of domestic revenue, complementing its extensive physical store footprint. ### What is Best Buy's typical capital expenditure as a percentage of revenue? Best Buy's capital expenditure historically ranges from 1.8% to 2.2% of revenue, equating to approximately $700 million to $850 million annually. This investment is split between maintenance (60%) for store upkeep and IT, and growth (40%) for remodels, supply chain automation, and digital platform enhancements. ### What is the purpose of the Best Buy financial model? The Best Buy financial model provides a comprehensive three-statement forecast and discounted cash flow valuation. Its purpose is to determine the company's intrinsic equity value, allowing analysts to assess if the stock is mispriced relative to its fundamental cash generation and capital return programs. ### Can I download an Excel financial model for Best Buy (BBY)? Yes, a downloadable Excel financial model for Best Buy (BBY) is available. This general corporate model provides a forecast horizon from FY2027 to FY2031 for detailed analysis. ### How does Best Buy's working capital profile impact its cash flow? Best Buy operates with a negative working capital profile, meaning vendors primarily finance its inventory as Days Payable Outstanding exceeds Days Inventory Outstanding. This dynamic results in the company generating cash when revenue grows but consuming cash when revenue shrinks. [Interactive forecast calculator](https://finamodel.com/companies/best-buy/forecast)