Definitive Analysis
Definitive Analysis
Financial Statements
Periods / Units
Fundamentals
Valuations
Miscellaneous
Analysis Mode
Full Access
See Pricing Start Trial

Target Corporation

Intrinsic Value Analysis (Discounted Cash Flow)Industry: Discount StoresSector: Consumer Defensive

Fair Value Summary

Current Price$97.67
5Y Range106.59 – 177.98
5Y Selected142.29
(-) Safety Margin83.39%
5Y Buy Price$23.63
Upside (to Buy Price)-75.80%
10Y Range119.40 – 191.37
10Y Selected155.38
(-) Safety Margin83.39%
10Y Buy Price$25.81
Upside (to Buy Price)-73.58%

Company Predictability & Safety

MetricValue
Revenue R2 (5Y)0.4818
Revenue R2 (10Y)0.8604
Net Income R2 (5Y)0.1222
Net Income R2 (10Y)0.1727
EBITDA R2 (5Y)0.0594
EBITDA R2 (10Y)0.2115
FCF R2 (5Y)0.1390
FCF R2 (10Y)0.0193
Safety Score0.1661

DA 10-Year Projection

Metric2026202720282029203020312032203320342035
% Growth7.69%7.28%6.87%6.46%6.05%5.64%5.23%4.82%4.41%4.00%
Revenue114,761.75123,117.20131,576.10140,076.59148,551.83156,930.67165,138.55173,098.51180,732.30187,961.60
EBITDA9,298.329,975.3010,660.6611,349.4012,036.0812,714.9613,379.9914,024.9214,643.4315,229.17
D&A-3,298.68-3,538.84-3,781.98-4,026.32-4,269.93-4,510.77-4,746.69-4,975.49-5,194.91-5,402.71
EBIT5,999.646,436.456,878.687,323.087,766.158,204.198,633.299,049.439,448.529,826.46
Pro forma Taxes-1,400.32-1,502.27-1,605.49-1,709.21-1,812.63-1,914.87-2,015.02-2,112.15-2,205.29-2,293.51
NOPAT4,599.324,934.185,273.195,613.865,953.536,289.336,618.276,937.297,243.237,532.96
Capital Expenditures-4,049.41-4,344.24-4,642.71-4,942.66-5,241.71-5,537.36-5,826.98-6,107.85-6,377.21-6,632.30
NWC Investment272.32277.63281.07282.45281.61278.41272.73264.49253.65240.21
(+) D&A3,298.683,538.843,781.984,026.324,269.934,510.774,746.694,975.495,194.915,402.71
Free Cash Flow4,120.914,406.424,693.534,979.985,263.365,541.145,810.726,069.426,314.596,543.58
Diluted Shares Outstanding456,550,000.00456,550,000.00456,550,000.00456,550,000.00456,550,000.00456,550,000.00456,550,000.00456,550,000.00456,550,000.00456,550,000.00

Discounting Periods

MetricFeb-26Feb-27Feb-28Feb-29Feb-30Feb-31Feb-32Feb-33Feb-34Feb-35
Period Start11/1/252/2/262/2/272/2/282/2/292/2/302/2/312/2/322/2/332/2/34
Period End2/1/262/1/272/1/282/1/292/1/302/1/312/1/322/1/332/1/342/1/35
Mid-Point12/17/258/3/268/3/278/2/288/3/298/3/308/3/318/2/328/3/338/3/34
Time (t)0.100.541.542.543.554.555.556.557.558.55
Valuation Date1/17/26

Base Case Projected Flows

WACC: 9.10%Terminal Growth: 2.43%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.990.950.870.800.730.670.620.570.520.47
PV UFCF4,085.184,204.024,104.513,991.843,863.793,728.493,583.823,431.213,272.113,108.01
Raw: 80,855.29
56,826.44
Raw: 100,521.98
45,710.83

Base Case Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value77,075.7783,083.80
(-) Net Debt15,777.7515,777.75
Equity Value61,298.0267,306.05
(/) Shares Out456.55456.55
Fair Value$134.26$147.42
(-) Safety Margin83.39%83.39%
Buy Price$22.30$24.49
Current Price$97.67$97.67
Upside (to Buy Price)-77.17%-74.93%

Conservative Projected Flows

WACC: 10.10%Terminal Growth: 1.93%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.990.950.860.780.710.650.590.530.480.44
PV UFCF4,081.454,183.364,047.243,900.393,740.643,576.873,406.863,232.153,054.292,874.76
Raw: 65,684.18
44,489.15
Raw: 81,660.75
34,190.82

Conservative Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value64,442.2270,288.82
(-) Net Debt15,777.7515,777.75
Equity Value48,664.4754,511.07
(/) Shares Out456.55456.55
Fair Value$106.59$119.40
(-) Safety Margin83.39%83.39%
Buy Price$17.70$19.83
Current Price$97.67$97.67
Upside (to Buy Price)-81.87%-79.69%

Aggressive Projected Flows

WACC: 8.10%Terminal Growth: 2.93%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.990.960.890.820.760.700.650.600.560.51
PV UFCF4,088.944,224.974,163.134,086.303,992.183,888.023,771.743,644.533,507.693,362.60
Raw: 104,833.50
76,478.36
Raw: 130,332.49
64,417.35

Aggressive Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value97,033.90103,147.47
(-) Net Debt15,777.7515,777.75
Equity Value81,256.1587,369.72
(/) Shares Out456.55456.55
Fair Value$177.98$191.37
(-) Safety Margin83.39%83.39%
Buy Price$29.56$31.79
Current Price$97.67$97.67
Upside (to Buy Price)-69.73%-67.46%

Reverse DCF: Market Implied Growth

Current Price$97.67
WACC Used9.1%
IMPLIED REVENUE GROWTH94.32%
Metric2027202820292030203120322033203420352036
Implied Revenue204,510.18397,411.81772,265.461,500,695.052,916,206.605,666,881.4511,012,095.4421,399,114.6541,583,557.8880,806,720.93
Constant Implied Growth94.32%94.32%94.32%94.32%94.32%94.32%94.32%94.32%94.32%94.32%
Implied Free Cash Flow20.4539.7477.23150.07291.62566.691,101.212,139.914,158.368,080.67
Discount Factor0.960.870.800.730.670.620.570.520.470.44
Present Value of Implied FCF19.7234.7561.90110.16196.22349.51622.541,108.871,975.103,518.01

Rolling Historical DCF (Backtest)

Valuation based on actual realized growth.
YearValuation DateActual PriceRealized Growth (5Y)Calculated Fair ValueValuation Delta
20202020-01-31$110.744.97%$120.769.05%
20192019-01-31$73.0010.74%$88.2720.92%
20182018-01-31$75.2213.60%$194.88159.08%
20172017-01-31$64.4812.55%$155.07140.49%
20162016-01-31$72.8310.22%$149.81105.70%
20152015-01-31$73.616.95%$68.45-7.01%
20142014-01-31$56.645.61%$74.0530.74%
20132013-01-31$60.413.86%$29.89-50.52%
20122012-01-31$50.811.96%$2.37-95.34%
20112011-01-31$54.832.91%$53.33-2.73%
20102010-01-31$51.094.99%$81.6959.89%
20092009-01-31$31.206.92%$-0.33-101.05%
20082008-01-31$55.427.30%$-23.27-142.00%
20072007-01-31$61.367.33%$11.69-80.95%
20062006-01-31$54.757.47%$15.73-71.27%
20052005-01-31$50.779.52%$-4.89-109.62%
20042004-01-31$37.9612.01%$-6.29-116.57%
20032003-01-31$28.2112.03%$-56.59-300.61%
20022002-01-31$44.419.41%$-31.13-170.09%
20012001-01-31$37.9811.03%$-23.42-161.66%
20002000-01-31$32.947.63%$2.43-92.63%
19991999-01-31$31.696.46%$-2.68-108.47%
19981998-01-31$17.985.89%$4.69-73.94%
19971997-01-31$9.413.72%$-2.27-124.10%
19961996-01-31$6.199.19%$-14.25-330.14%

Monte Carlo Simulation (1,000 Iterations)

Mean Fair Value
$152.07
Median
$146.95
10th Percentile
$117.55
90th Percentile
$193.65

Fair Value Distribution

$82.37 - $99.93
12
$99.93 - $117.49
87
$117.49 - $135.05
221
$135.05 - $152.61
265
$152.61 - $170.17
175
$170.17 - $187.73
111
$187.73 - $205.29
69
$205.29 - $222.85
31
$222.85 - $240.41
17
$240.41 - $257.97
6
$257.97 - $275.53
3
$275.53 - $293.09
2
$293.09 - $310.65
0
$310.65 - $328.21
0
$328.21 - $345.77
0
$345.77 - $363.33
0
$363.33 - $380.89
0
$380.89 - $398.45
0
$398.45 - $416.01
0
$416.01 - $433.57
0