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 Ps Multiple | 0.1x - 0.2x | 0.2x |
Selected Fwd Ps Multiple | 0.1x - 0.2x | 0.1x |
Fair Value | €17.67 - €19.53 | €18.60 |
Upside | -7.5% - 2.2% | -2.6% |
Benchmarks | Ticker | Full Ticker |
---|---|---|
The Kroger Co. | - | NYSE:KR |
Target Corporation | - | NYSE:TGT |
Costco Wholesale Corporation | - | NasdaqGS:COST |
Walmart Inc. | - | NYSE:WMT |
Koninklijke Ahold Delhaize N.V. | - | OTCPK:AHOD.F |
Albertsons Companies, Inc. | - | DB:27S |
Select Price / LTM Sales Ratio | ||||||||
Benchmark Companies | ||||||||
KR | TGT | COST | WMT | AHOD.F | 27S | |||
NYSE:KR | NYSE:TGT | NasdaqGS:COST | NYSE:WMT | OTCPK:AHOD.F | DB:27S | |||
Historical Sales Growth | ||||||||
5Y CAGR | 3.8% | 6.4% | 10.8% | 5.4% | 6.2% | 5.2% | ||
3Y CAGR | 2.2% | 0.2% | 9.1% | 5.9% | 5.7% | 3.8% | ||
Latest Twelve Months | -1.9% | -0.8% | 6.1% | 4.2% | 2.3% | 1.5% | ||
Historical Net Income Profit Margin | ||||||||
5 Year Average Margin | 1.5% | 4.3% | 2.6% | 2.4% | 2.4% | 1.6% | ||
Prior Fiscal Year | 1.4% | 3.9% | 2.6% | 2.4% | 2.1% | 1.6% | ||
Latest Fiscal Year | 1.8% | 3.8% | 2.9% | 2.9% | 2.0% | 1.2% | ||
Latest Twelve Months | 1.8% | 3.8% | 2.9% | 2.7% | 2.0% | 1.2% | ||
Current Trading Multiples | ||||||||
EV / LTM EBITDA | 8.5x | 6.6x | 37.4x | 19.6x | 9.6x | 7.1x | ||
Price / LTM Sales | 0.3x | 0.4x | 1.7x | 1.1x | 0.4x | 0.2x | ||
LTM P/E Ratio | 17.3x | 10.3x | 59.9x | 40.9x | 19.1x | 13.3x | ||
Low | Mid | High | ||||||
Benchmark LTM P/S Ratio | 0.3x | 0.4x | 1.7x | |||||
Historical LTM P/S Ratio | 0.1x | 0.1x | 0.2x | |||||
Selected Price / Sales Multiple | 0.1x | 0.2x | 0.2x | |||||
(x) LTM Sales | 80,391 | 80,391 | 80,391 | |||||
(=) Equity Value | 11,468 | 12,072 | 12,675 | |||||
(/) Shares Outstanding | 575.7 | 575.7 | 575.7 | |||||
Implied Value Range | 19.92 | 20.97 | 22.02 | |||||
FX Rate: USD/EUR | 1.1 | 1.1 | 1.1 | Market Price | ||||
Implied Value Range (Trading Cur) | 17.57 | 18.49 | 19.42 | 19.10 | ||||
Upside / (Downside) | -8.0% | -3.2% | 1.7% |
Equity Value | |||||||
Benchmark Companies | |||||||
(in millions) | KR | TGT | COST | WMT | AHOD.F | 27S | |
Value of Common Equity | 46,277 | 44,582 | 460,020 | 782,487 | 32,151 | 12,468 | |
(/) Shares Outstanding | 665.9 | 454.4 | 443.7 | 8,000.9 | 913.6 | 575.7 | |
Implied Stock Price | 69.50 | 98.12 | 1,036.82 | 97.80 | 35.19 | 21.66 | |
FX Conversion Rate to Trading Currency | 1.00 | 1.00 | 1.00 | 1.00 | 0.88 | 1.13 | |
Implied Stock Price (Trading Cur) | 69.50 | 98.12 | 1,036.82 | 97.80 | 39.90 | 19.10 | |
Trading Currency | USD | USD | USD | USD | USD | EUR | |
FX Rate to Reporting Currency | 1.00 | 1.00 | 1.00 | 1.00 | 0.88 | 1.13 |