All companies
Target logo
StaplesTGT

Target (TGT) Financial Forecast Calculator

Interactive 5-year forecast and DCF for Target. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from Target’s most recent SEC filings.

Revenue FY30
$159.95B
from $107.41B
FCF FY30
$8.43B
Margin 5.3%
Enterprise value
$120.36B
1.1× LTM revenue
Equity value
$106.65B
Net debt $13.71B
Revenue & free cash flow - history and 5-year forecast
Line (area)
Bars
Historicals from SEC EDGAR (grey). Forecast years (color) update live as you move the sliders.

Assumptions

Revenue growth (annual)
8.3%
-10.0%baseline 8.3%40.0%
Gross margin
28.1%
5.0%baseline 28.1%90.0%
Capex % of revenue
3.9%
0.0%baseline 3.9%30.0%
WACC (discount rate)
9.00%
4.0%baseline 9.0%18.0%
Terminal growth
2.50%
0.0%baseline 2.5%5.0%

Need this as an Excel model?

Keep iterating on the Target forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Frequently asked

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

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview