Discounted Cash Flow Building - Target

Overview As of August 2024, Target Corporation was one of the largest U.S. retail chains, operating a broad network of stores and offering a diverse assortment of merchandise across categories including apparel, beauty, food and beverage, hardlines, home furnishings, and household essentials. Its combination of discretionary and everyday essentials made Target an interesting business to value, with performance influenced by consumer spending, merchandise mix, pricing, and operating efficiency. Target’s recent financial performance reflected the challenges facing general merchandise retailers. After benefiting from strong consumer demand during the pandemic, the company experienced pressure from changing consumer spending patterns, particularly in discretionary categories, as well as higher costs and inventory-related challenges. As these pressures normalized, Target’s ability to recover margins, grow sales, and manage operating expenses became important drivers of its future cash flow potential. For investors, valuing Target requires looking beyond near-term earnings to assess its ability to generate sustainable free cash flow. Revenue growth across merchandise categories, gross margin recovery, operating profitability, capital expenditures, and working capital requirements all influence the company’s long-term financial outlook. A Discounted Cash Flow analysis provides a framework for translating these operating assumptions into an estimate of intrinsic value. In this practice, you will build a DCF valuation of Target using publicly available financial information available as of August 1, 2024, along with explicit modeling assumptions. You will project revenue by merchandise category, forecast key operating and working capital metrics, calculate peer betas and the Weighted Average Cost of Capital, and use trading comparables to contextualize Target’s valuation. You will then estimate its implied share price using both the Exit Multiple and Perpetuity Growth methods and examine how changes in key assumptions affect the valuation. Learning Goals Develop an end-to-end understanding of how a retailer’s operating performance translates into long-term financial projections. Project revenue by merchandise category and forecast gross profit, margins, and operating net working capital. Calculate Unlevered Free Cash Flow by incorporating operating earnings, taxes, non-cash expenses, capital expenditures, and changes in working capital. Calculate peer unlevered betas and estimate Target’s Weighted Average Cost of Capital to discount projected cash flows. Use trading comparables to evaluate Target’s valuation relative to similar publicly traded companies. Estimate intrinsic value using two terminal value approaches: the Perpetuity Growth method and the Exit Multiple method. Analyze how assumptions about revenue growth, profitability, discount rates, and terminal value affect implied share price through sensitivity analysis. Key Concepts Revenue Growth: Projecting sales across Target’s merchandise categories based on historical performance and forward-looking assumptions. Gross Profit and Gross Margin: Understanding how merchandise sales and cost of goods sold drive profitability. EBITDA, EBIT, and NOPAT: Key operating profitability metrics used to derive free cash flow. Unlevered Free Cash Flow: Cash flow available to all capital providers before interest payments and financing decisions. Operating Net Working Capital: Modeling operating current assets and liabilities to capture the cash tied up in day-to-day operations. WACC and Beta: Using peer betas, capital structure, the cost of equity, and the after-tax cost of debt to estimate the appropriate discount rate. Trading Comparables: Calculating enterprise value multiples such as EV/Revenue and EV/EBITDA to benchmark Target against comparable retailers. Terminal Value (Perpetuity Growth) and Terminal Value (Exit Multiple): Applying two common methods to estimate the value of cash flows beyond the explicit forecast period. Enterprise Value vs. Equity Value: Understanding how discounted operating cash flows translate into equity value and an implied share price. Sensitivity Analysis: Evaluating how changes in key valuation assumptions, such as WACC and terminal multiples, affect the implied share price.

Practice Discounted Cash Flow Building - Target with interactive Excel modeling exercises in our DCF Modeling module.

This hands-on modeling exercise helps you master Discounted Cash Flow Building - Target through real-world Excel practice and financial modeling techniques.