# Target (TGT) Financial Model Free Excel 3-statement financial model and company analysis for Target. - Canonical: https://finamodel.com/companies/target - Industry: Retail - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/TGT.xlsx ## Model Purpose This model provides a comprehensive equity valuation and scenario planning tool to forecast Target Corporation's comparable sales growth, operating margin recovery, and free cash flow generation to determine its intrinsic share price. ## Company Overview Target Corporation operates as a general merchandise retailer in the United States, offering everyday essentials and differentiated merchandise at discounted prices. The company operates a single business segment but tracks revenue across five core merchandise categories: Beauty & Household Essentials (approximately 28% of sales), Food & Beverage (22%), Home Furnishings & Décor (18%), Hardlines (17%), and Apparel & Accessories (15%). Target operates exclusively in the United States with a highly integrated omnichannel business model, leveraging its network of over 1,950 stores to fulfil more than 95% of total sales, including digital orders via Drive Up, Order Pickup, and Shipt. The company holds a strong competitive position in the US retail market, competing directly with Walmart, Amazon, and Costco, differentiating itself through owned brands, exclusive partnerships, and a premium discount store experience. Recent major events include significant supply chain investments, the expansion of its sortation centre network, and the rebranding of its loyalty programme to Target Circle. ## Revenue Deep Dive Target operates as a single reportable segment, but revenue modelling requires breaking down sales by channel and merchandise category. **Store Originated Sales** - Revenue driver formula: "Beginning Store Count + Net New Stores" x "Sales per Store" OR "Comparable Store Sales Growth" applied to the prior year base. - Historical growth rate: 1% to 5% CAGR, highly dependent on macroeconomic cycles. - Key growth levers and headwinds: Foot traffic, store remodels, inflation impacting discretionary spending, and shrink (theft and loss). - Pricing dynamics: Highly competitive, promotional pricing environment. - Seasonality: Q4 is historically the strongest quarter by a significant margin due to the holiday shopping season, generating outsized revenue and operating profit. **Digitally Originated Sales** - Revenue driver formula: "Digital Traffic" x "Conversion Rate" x "Average Order Value". - Historical growth rate: 5% to 15% CAGR, normalising after a massive pandemic-era surge. - Key growth levers and headwinds: Adoption of Drive Up, Shipt delivery volume, and digital advertising revenue (Roundel). - Revenue recognition notes: Recognised upon delivery to the guest or pickup at the store. **Other Revenue** - Consists primarily of credit card profit-sharing (Target Circle Card) and advertising revenue from Roundel. - Revenue driver formula: "Total Sales" x "Other Revenue % Margin". - Historical growth rate: 8% to 12% CAGR, growing faster than retail sales due to the high-margin retail media network expansion. ## Cost Structure ### Variable Costs / COGS - Cost of Sales includes inventory valuation, freight, distribution costs, and inventory shrinkage. - Gross margin range: 26.0% to 28.5% over the last 5 years. - Key input costs and commodity exposures: Ocean freight rates, domestic trucking costs, raw material costs for owned brands, and wage rates in distribution centres. - How COGS scales with revenue: Largely linear, but highly sensitive to markdown activity when inventory levels exceed consumer demand. ### Operating Expenses - SG&A: Includes store payroll, benefits, advertising, and corporate overhead. Typically runs at 19.5% to 21.0% of total revenue. It is heavily driven by store headcount and hourly wage rates. - Depreciation & Amortisation: Typically 2.4% to 2.6% of total revenue, driven by the capital-intensive nature of store remodels and supply chain investments. - Stock-Based Compensation: Relatively small for a traditional retailer, typically under 0.2% of revenue. - Restructuring / one-time charges: Infrequent, usually related to specific strategic shifts or store closures. ### Margin Profile - Gross margin: 26.0% to 28.5%. - EBITDA margin: 7.5% to 9.5%. - Operating margin (EBIT): 5.0% to 6.5% (management's stated long-term goal is to maintain a 6% operating margin). - Net margin: 3.5% to 4.5%. - Margin trend: Recovering and stabilising after severe compression in 2022 caused by excess inventory markdowns and elevated freight costs. ## Balance Sheet Structure - Total assets: Approximately $53 billion to $55 billion. - Key asset categories: Property and Equipment (PP&E) makes up nearly 60% of total assets, followed by Inventory (20% to 25%). - Goodwill & intangibles as % of total assets: Less than 3%, reflecting a strategy focused on organic growth rather than large-scale M&A. - Working capital profile: - Days Sales Outstanding (DSO): 4 to 6 days (Target sold its credit card portfolio, so receivables are minimal and mostly represent vendor allowances and third-party credit card settlements). - Days Inventory Outstanding (DIO): 55 to 65 days. - Days Payable Outstanding (DPO): 60 to 70 days. - Net working capital as % of revenue: Typically negative. - Target operates with negative working capital, meaning it sells inventory to consumers before it has to pay its vendors, generating cash as it grows. - PP&E: Consists of land, buildings, and fixtures. Useful lives range from 10 to 39 years for buildings and 3 to 15 years for fixtures and equipment. - Right-of-use assets / operating leases: Material, representing approximately $2.5 billion to $3.0 billion, as Target leases a portion of its store real estate. ## Capital Expenditure & Investment - Capex as % of revenue: 3.0% to 4.5% (historically $3 billion to $5 billion annually). - Maintenance capex vs. growth capex: Approximately 40% maintenance (IT, basic store upkeep) and 60% growth (full store remodels, new store openings, supply chain sortation centres). - Major capex programmes underway: Expanding the sortation centre network to reduce last-mile delivery costs and ongoing store remodels to support omnichannel fulfilment. - Capitalised software / development costs: Material component of IT capital expenditures, amortised over 3 to 7 years. - M&A pattern: Infrequent, bolt-on acquisitions (for example, Shipt in 2017 for $550 million, Grand Junction, Deliv). ## Debt & Capital Structure - Total debt: Approximately $14 billion to $16 billion, plus operating lease liabilities. - Debt/EBITDA ratio: Target range is 2.0x to 2.5x. - Credit rating: Investment grade (A2 by Moody's, A by S&P). - Key debt instruments: Unsecured fixed-rate notes and bonds. The company maintains a $3 billion revolving credit facility. - Maturity profile: Well-laddered, with a weighted average maturity exceeding 10 years. - Interest rate profile: Predominantly fixed-rate debt, with a weighted average interest rate of approximately 3.5% to 4.5%. - Covenants: Standard investment-grade covenants, primarily a limitation on secured debt. - Share repurchase programme: Highly active. Target frequently returns excess cash to shareholders via buybacks, typically 1% to 3% of market capitalisation annually depending on free cash flow. - Dividend policy: Dividend Aristocrat with over 50 consecutive years of increases. Payout ratio targets 40% to 50% of adjusted earnings per share. ## Cash Flow Characteristics - Operating cash flow conversion: OCF / Net Income typically ranges from 1.5x to 2.0x due to high depreciation and positive cash flow from negative working capital dynamics. - Free cash flow margin: 3.0% to 5.0% of total revenue. - Major non-cash items: Depreciation and amortisation, share-based compensation, and deferred income taxes. - Working capital cash flow impact: Inventory builds in Q3 ahead of the holidays are a major use of cash, which reverses in Q4 as inventory is sold and payables increase. - Capex intensity: Moderate to high for a retailer, requiring consistent reinvestment to maintain store relevance and supply chain efficiency. - Cash tax rate vs. GAAP effective tax rate: Cash taxes closely track the GAAP effective tax rate of approximately 21% to 23%. ## Sheet Structure 1. **Assumptions**: Contains all hardcoded inputs, historical growth rates, margin targets, working capital days, and macroeconomic drivers. 2. **Revenue & Comps**: Builds total sales from store count, square footage, comparable sales growth (traffic and ticket), digital sales penetration, and other revenue. 3. **Income Statement**: Standard P&L from Total Revenue down to Net Income and EPS, mirroring Target's reported consolidated statement of operations. 4. **Balance Sheet**: Assets, Liabilities, and Shareholders' Equity. Must explicitly break out Merchandise Inventories, Accounts Payable, and Accrued Liabilities. 5. **Cash Flow Statement**: Indirect method starting with Net Income, adjusting for D&A, working capital changes, capex, debt issuance/repayment, dividends, and share repurchases. 6. **Working Capital Schedule**: Calculates Accounts Receivable, Inventory, Accounts Payable, and Accrued Liabilities based on DSO, DIO, DPO, and historical ratios. 7. **PP&E & Depreciation**: Tracks capital expenditures, capitalised software, and calculates depreciation and amortisation using a waterfall or percentage-of-revenue approach. 8. **Debt Schedule**: Tracks existing bond tranches, revolving credit facility drawdowns, interest expense, and mandatory repayments. 9. **DCF Valuation**: Calculates Unlevered Free Cash Flow, applies WACC, calculates terminal value via perpetuity growth and exit multiple methods, and bridges enterprise value to equity value per share. ## Key Financial Relationships 1. Total Revenue = Sales + Other Revenue 2. Sales = Prior Year Sales x (1 + Comparable Sales Growth) + Non-Comparable Sales (from new stores) 3. Comparable Sales Growth = Comparable Traffic Growth + Comparable Average Ticket Growth 4. Gross Margin = (Sales - Cost of Sales) / Sales 5. Operating Income (EBIT) = Total Revenue - Cost of Sales - SG&A - D&A 6. Ending Inventory = Beginning Inventory + Purchases - Cost of Sales 7. Accounts Payable = (Cost of Sales / 365) x DPO 8. Merchandise Inventories = (Cost of Sales / 365) x DIO 9. Interest Expense = Average Debt Balance x Weighted Average Interest Rate 10. Basic Shares Outstanding = Prior Period Shares - (Share Repurchases / Average Share Price) 11. Dividends Paid = Dividend Per Share x Basic Shares Outstanding 12. Unlevered Free Cash Flow = EBIT x (1 - Tax Rate) + D&A - Capital Expenditures - Change in Net Working Capital ## Cross-Sheet Dependencies - The **Assumptions** sheet feeds all forward-looking calculations across the model. - **Revenue & Comps** feeds Total Revenue and Sales into the **Income Statement**. - Cost of Sales from the **Income Statement** feeds the **Working Capital Schedule** to calculate Inventory and Accounts Payable. - The **Working Capital Schedule** feeds the Change in Net Working Capital line on the **Cash Flow Statement** and the current asset/liability lines on the **Balance Sheet**. - Capital Expenditures from the **Assumptions** sheet feed the **PP&E & Depreciation** schedule, which in turn feeds D&A to the **Income Statement** and **Cash Flow Statement**, and ending PP&E to the **Balance Sheet**. - The **Cash Flow Statement** determines the ending cash balance, which feeds the **Balance Sheet**. If cash falls below the minimum operating threshold, it triggers a draw on the revolver in the **Debt Schedule**, creating a circular reference with Interest Expense on the **Income Statement**. ## Sign Convention - Revenues and expenses on the Income Statement are entered as positive numbers. Subtotals (Gross Profit, Operating Income) are calculated via subtraction. - Assets, Liabilities, and Equity on the Balance Sheet are positive numbers. - On the Cash Flow Statement, cash inflows are positive and cash outflows (including capital expenditures, dividends, and share repurchases) are negative. - In the Working Capital Schedule, an increase in an asset is a negative cash flow, and an increase in a liability is a positive cash flow. ## Things Most Likely to Go Wrong - Shrink (theft and inventory loss) is a major variable for Target. Failing to model gross margin sensitivity to shrink will result in inaccurate operating profit forecasts. - Target's working capital is highly seasonal. Using annual averages for quarterly modelling will break the cash flow statement. The model must account for the Q3 inventory build and Q4 cash generation. - The company includes freight and distribution costs in Cost of Sales, whereas some retailers split this. Ensure gross margin comparisons with peers account for this accounting treatment. - Other Revenue is almost entirely pure profit (credit card sharing and advertising). Modelling it with the same margin profile as merchandise sales will severely understate operating income. - Target frequently uses debt to fund share repurchases when free cash flow is insufficient. The debt schedule must dynamically link to the share repurchase assumptions to balance the balance sheet. - Supply chain investments are capital intensive. Underestimating capex requirements will artificially inflate Unlevered Free Cash Flow in the DCF. - The company operates with negative net working capital. A common builder error is treating working capital growth as a use of cash, whereas for Target, revenue growth typically generates working capital cash inflows. - Operating lease liabilities must be treated as debt in the enterprise value bridge to ensure an accurate valuation. ## Validation Checks - Gross margin should remain strictly within the 26.0% to 28.5% range based on historical performance. Flag any periods outside this band. - Operating margin (EBIT margin) should trend towards management's stated goal of 6.0%. - Capex as a percentage of total revenue should run between 3.0% and 4.5%. - The Balance Sheet must balance perfectly in every period: Total Assets = Total Liabilities + Shareholders' Equity. - Debt/EBITDA should remain below 2.5x to maintain the company's current investment-grade credit rating. - OCF/Net Income conversion should consistently be greater than 1.2x. - Effective tax rate should remain between 21.0% and 23.0% absent statutory corporate tax rate changes. - Dividend payout ratio should remain between 40% and 50% of Net Income. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Comparable Sales Growth | 1.5 | % | Assumes moderate recovery in discretionary spending and stable foot traffic. | | Digital Sales Penetration | 18.5 | % | Reflects stabilisation of digital channel mix post-pandemic. | | Other Revenue Growth | 8.0 | % | Driven by continued expansion of the Roundel retail media network. | | Gross Margin | 27.5 | % | Normalised margin assuming freight and shrink headwinds subside. | | SG&A as % of Total Revenue | 20.5 | % | Reflects ongoing wage investments and store payroll inflation. | | D&A as % of Total Revenue | 2.5 | % | Consistent with historical depreciation of store remodels and supply chain assets. | | Days Inventory Outstanding (DIO) | 60 | Days | Based on historical average inventory turnover rates. | | Days Payable Outstanding (DPO) | 65 | Days | Reflects standard vendor payment terms and negative working capital model. | | Days Sales Outstanding (DSO) | 5 | Days | Minimal receivables due to the sale of the credit card portfolio. | | Capex as % of Total Revenue | 3.5 | % | Aligns with management guidance of $3 billion to $4 billion annual spend. | | Effective Tax Rate | 22.0 | % | Based on recent historical GAAP tax rates. | | Dividend Growth Rate | 4.0 | % | Consistent with Target's history as a Dividend Aristocrat. | | Share Repurchases | 1,500 | $ Millions | Assumes return to historical buyback levels as margins recover. | | Weighted Average Interest Rate | 4.2 | % | Based on the current blended rate of outstanding fixed-rate notes. | | WACC | 7.5 | % | Standard discount rate for a mature, large-cap consumer staples/discretionary retailer. | | Terminal Growth Rate | 2.0 | % | Aligns with long-term US GDP and inflation expectations. | ## Data Sources & Benchmarks - SEC EDGAR: Target Corporation (TGT) 10-K and 10-Q filings. - Target Investor Relations website for earnings call transcripts, presentation decks, and financial supplements. - Key peers for benchmarking: Walmart Inc. (WMT), Costco Wholesale Corporation (COST), Amazon.com Inc. (AMZN), and Dollar General Corporation (DG). - Industry data sources: US Census Bureau (Retail Sales Data), National Retail Federation (NRF) holiday spending forecasts. - Consensus estimates: Bloomberg or FactSet for forward-looking analyst estimates on comparable sales and EPS. ## Sources - Target Corporation Annual Report on Form 10-K (SEC EDGAR). - Target Corporation Quarterly Reports on Form 10-Q (SEC EDGAR). - Target Investor Relations Financial History and Operating Metrics (investors.target.com). - Management commentary from recent quarterly earnings calls regarding the 6% operating margin target and capital allocation framework. --- ## Frequently asked questions ### What is Target Corporation's primary business model and how does it differentiate itself in the retail market? Target operates as a general merchandise retailer in the United States, offering everyday essentials and differentiated merchandise at discounted prices. It differentiates itself through owned brands, exclusive partnerships, and a premium discount store experience, competing with major retailers like Walmart, Amazon, and Costco. ### How does Target generate its revenue, and what are its main sales channels? Target generates revenue through both store-originated and digitally-originated sales. Store sales are driven by store count and sales per store or comparable store sales growth, while digital sales depend on digital traffic, conversion rate, and average order value. The company leverages its extensive store network to fulfill over 95% of total sales, including digital orders. ### What are Target's key capital expenditure priorities, and what percentage of revenue is typically allocated to Capex? Target typically allocates 3.0% to 4.5% of its revenue to capital expenditures annually, historically ranging from $3 billion to $5 billion. Major capex programs include expanding its sortation center network to reduce last-mile delivery costs and ongoing store remodels to support omnichannel fulfillment. Approximately 60% of this capex is for growth initiatives. ### What is the purpose of the Target Corporation financial model, and what key metrics does it aim to forecast? The financial model provides a comprehensive equity valuation and scenario planning tool for Target Corporation. It aims to forecast comparable sales growth, operating margin recovery, and free cash flow generation to determine the company's intrinsic share price. ### Is a downloadable Excel financial model available for Target Corporation, and what is its forecast horizon? Yes, a downloadable Excel financial model is available for Target Corporation. This model provides a forecast horizon covering fiscal years FY2026 through FY2030. ### How does Target Corporation manage its working capital, and what is its typical net working capital profile? Target Corporation typically operates with negative net working capital as a percentage of revenue, meaning it sells inventory to consumers before paying vendors. This profile allows the company to generate cash as it grows. Key balance sheet components include Property and Equipment, which makes up nearly 60% of total assets, and Inventory, at 20% to 25%. [Interactive forecast calculator](https://finamodel.com/companies/target/forecast)