Target Financial Model

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.

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

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

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

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

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.

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

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

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

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

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

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

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