Looks like there`s been an error while trying to load this page.
Our team has been notified but please contact us using the email support widget if the problem persists.
Metrics | Range | Conclusion |
---|---|---|
Selected LTM P/E Multiple | 28.9x - 32.0x | 30.4x |
Selected Fwd P/E Multiple | 25.3x - 28.0x | 26.6x |
Fair Value | €60.42 - €66.78 | €63.60 |
Upside | -27.8% - -20.2% | -24.0% |
Benchmarks | - | Full Ticker |
Target Corporation | - | NYSE:TGT |
Natural Grocers by Vitamin Cottage, Inc. | - | NYSE:NGVC |
PriceSmart, Inc. | - | NasdaqGS:PSMT |
Costco Wholesale Corporation | - | NasdaqGS:COST |
SpartanNash Company | - | NasdaqGS:SPTN |
Walmart Inc. | - | DB:WMT |
- | - | - |
Select Price / LTM EPS Ratio | ||||||||
Benchmark Companies | ||||||||
TGT | NGVC | PSMT | COST | SPTN | WMT | |||
NYSE:TGT | NYSE:NGVC | NasdaqGS:PSMT | NasdaqGS:COST | NasdaqGS:SPTN | DB:WMT | |||
Historical Net Income Growth | ||||||||
5Y CAGR | 4.6% | 29.2% | 13.6% | 15.0% | -45.0% | 5.5% | ||
3Y CAGR | -16.2% | 18.1% | 12.4% | 13.7% | -84.1% | 12.4% | ||
Latest Twelve Months | 1.3% | 43.9% | 16.6% | 9.3% | -119.6% | -0.6% | ||
Historical Net Income Profit Margin | ||||||||
5 Year Average Margin | 4.3% | 2.2% | 2.6% | 2.7% | 0.5% | 2.4% | ||
Prior Fiscal Year | 3.9% | 2.0% | 2.4% | 2.6% | 0.5% | 2.4% | ||
Latest Fiscal Year | 3.8% | 2.7% | 2.8% | 2.9% | 0.0% | 2.9% | ||
Latest Twelve Months | 4.0% | 3.2% | 2.8% | 2.9% | -0.1% | 2.7% | ||
Current Trading Multiples | ||||||||
EV / LTM EBITDA | 7.1x | 13.6x | 10.3x | 34.7x | 8.8x | 19.9x | ||
Price / LTM Sales | 0.4x | 0.7x | 0.6x | 1.6x | 0.1x | 1.1x | ||
LTM P/E Ratio | 11.3x | 22.3x | 22.7x | 55.8x | -85.6x | 41.7x | ||
Low | Mid | High | ||||||
Benchmark LTM P/E Ratio | -85.6x | 22.3x | 55.8x | |||||
Historical LTM P/E Ratio | 20.1x | 40.1x | 48.4x | |||||
Selected P/E Multiple | 28.9x | 30.4x | 32.0x | |||||
(x) LTM Net Income | 18,819 | 18,819 | 18,819 | |||||
(=) Equity Value | 544,244 | 572,888 | 601,533 | |||||
(/) Shares Outstanding | 7,980.4 | 7,980.4 | 7,980.4 | |||||
Implied Value Range | 68.20 | 71.79 | 75.38 | |||||
FX Rate: USD/EUR | 1.2 | 1.2 | 1.2 | Market Price | ||||
Implied Value Range (Trading Cur) | 57.89 | 60.93 | 63.98 | 83.70 | ||||
Upside / (Downside) | -30.8% | -27.2% | -23.6% |
Equity Value | |||||||
Benchmark Companies | |||||||
(in millions) | TGT | NGVC | PSMT | COST | SPTN | WMT | |
Value of Common Equity | 47,281 | 920 | 3,197 | 437,721 | 900 | 786,947 | |
(/) Shares Outstanding | 454.4 | 23.0 | 30.0 | 443.5 | 33.8 | 7,980.4 | |
Implied Stock Price | 104.06 | 40.09 | 106.61 | 987.02 | 26.60 | 98.61 | |
FX Conversion Rate to Trading Currency | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.18 | |
Implied Stock Price (Trading Cur) | 104.06 | 40.09 | 106.61 | 987.02 | 26.60 | 83.70 | |
Trading Currency | USD | USD | USD | USD | USD | EUR | |
FX Rate to Reporting Currency | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.18 |