Edition:
United Kingdom

Don Quijote Holdings Co Ltd (7532.T)

7532.T on Tokyo Stock Exchange

5,050JPY
22 Nov 2017
Change (% chg)

¥20 (+0.40%)
Prev Close
¥5,030
Open
¥5,080
Day's High
¥5,080
Day's Low
¥5,010
Volume
476,600
Avg. Vol
697,902
52-wk High
¥5,130
52-wk Low
¥3,715

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2018 Sep 223,433.00 53.464
FY 2017 Jun '17 208,811.00 38.536
Mar '17 202,293.00 66.478
Dec 216,367.00 52.677
Sep 201,327.00 51.373
FY 2016 Jun '16 190,045.00 32.841
Mar '16 185,102.00 34.785
Dec 197,803.00 48.988
Sep 186,642.00 40.982
FY 2015 Jun '15 174,061.00 19.384
Mar '15 167,696.00 40.429
Dec 178,363.00 47.866
Sep 163,861.00 38.991
 
*Note: Units in Millions ofYen
**Note: Units in Yen

Consensus Estimates Analysis

  # of Estimates Mean High Low 1 Year Ago
SALES (in millions)
Quarter Ending Jun-17 4 207,010.00 208,013.00 204,013.00 --
Quarter Ending Mar-18 2 224,750.00 230,000.00 219,500.00 --
Year Ending Jun-17 14 830,011.00 842,450.00 824,000.00 --
Year Ending Jun-18 13 909,464.00 922,000.00 892,500.00 902,184.00
Year Ending Jun-19 13 994,913.00 1,023,000.00 962,100.00 978,260.00
Earnings (per share)
Quarter Ending Jun-17 1 31.77 31.77 31.77 --
Quarter Ending Mar-18 1 40.46 40.46 40.46 --
Year Ending Jun-17 14 197.84 206.10 175.06 --
Year Ending Jun-18 13 203.94 227.60 191.60 197.66
Year Ending Jun-19 13 230.83 261.10 204.80 218.27
LT Growth Rate (%) 1 3.20 3.20 3.20 9.80
Sales and Profit Figures in Japanese Yen (JPY);

Valuation Ratios

  Company industry sector
P/E Ratio (TTM) 20.64 24.84 19.08
P/E High - Last 5 Yrs. 35.53 34.32 32.94
P/E Low - Last 5 Yrs. 17.72 19.71 12.89
Beta 0.84 0.85 1.28
Price to Sales (TTM) 0.82 1.25 4,112.74
Price to Book (MRQ) 2.63 4.98 2.27
Price to Tangible Book (MRQ) 2.81 7.28 2.78
Price to Cash Flow (TTM) 12.42 17.55 460,052.21
% Owned Institutions -- 4.12 0.21

Dividends

  Company industry sector
Dividend Yield 0.60 1.61 2.13
Dividend Yield - 5 Year Avg 0.55 1.60 2.25
Dividend 5 Year Growth Rate 10.90 16.43 8.18
Payout Ratio(TTM) 12.43 59.78 42.90

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago 9.87 8.40 6.55
Sales (TTM) vs TTM 1 Yr. Ago 9.11 7.90 4.61
Sales - 5 Yr. Growth Rate 8.94 8.42 4.02
EPS (MRQ) vs Qtr. 1 Yr. Ago 17.34 24.25 30.93
EPS (TTM) vs TTM 1 Yr. Ago 32.66 -- --
EPS - 5 Yr. Growth Rate 10.23 9.40 1.74
Capital Spending - 5 Yr. Growth Rate 14.93 7.68 1.18

Financial Strength

  Company industry sector
Quick Ratio (MRQ) 0.63 0.61 1.12
Current Ratio (MRQ) 1.38 1.27 1.37
LT Debt to Equity (MRQ) 69.03 36.58 34.60
Total Debt to Equity (MRQ) 81.45 48.82 70.67
Interest Coverage (TTM) 144.24 316.29 5.20

Profitability Ratios

  Company industry sector
Gross Margin (TTM) 26.37 25.98 23.39
Gross Margin - 5 Yr. Avg. 26.44 25.31 22.61
EBITD Margin (TTM) 7.50 -- --
EBITD - 5 Yr. Avg 7.58 8.51 36.53
Operating Margin (TTM) 5.65 6.27 14.04
Operating Margin - 5 Yr. Avg. 5.46 6.46 40.66
Pre-Tax Margin (TTM) 6.68 6.66 16.28
Pre-Tax Margin - 5 Yr. Avg. 5.91 6.56 43.18
Net Profit Margin (TTM) 4.72 4.66 13.79
Net Profit Margin - 5 Yr. Avg. 4.10 4.60 39.94
Effective Tax Rate (TTM) 29.33 28.16 21.05
Effective Tax Rate - 5 Yr. Avg. 30.61 29.31 22.25

Efficiency

  Company industry sector
Revenue/Employee (TTM) 123,553,696 82,256,756 761,403,902
Net Income/Employee (TTM) 5,828,414 4,760,041 85,150,142
Receivable Turnover (TTM) 99.84 321.71 13.15
Inventory Turnover (TTM) 5.06 7.14 10.47
Asset Turnover (TTM) 1.38 1.93 0.70

Management Effectiveness

  Company industry sector
Return on Assets (TTM) 6.50 9.69 6.26
Return on Assets - 5 Yr. Avg. 5.93 8.51 7.76
Return on Investment (TTM) 9.13 15.52 10.55
Return on Investment - 5 Yr. Avg. 8.47 13.48 12.59
Return on Equity (TTM) 13.48 25.58 12.64
Return on Equity - 5 Yr. Avg. 12.39 17.36 16.57
  1 Year 3 Year 5 Year
Sales % 9.11 10.61 8.94
EPS (TTM) % 32.60 15.25 10.23
Dividend % 18.18 13.04 10.90
Note: Units in Millions of US Dollars

Performance for Don Quijote Holdings Co Ltd

Period %
Actual
% vs.
S&P 500
Rank In
Industry
Industry
Rank
4 Week 0.70 -4.89 99 26
13 Week 5.50 0.49 99 52
26 Week 10.64 -2.30 99 45
52 Week 10.22 -11.55 99 31
YTD -0.23 -10.20 99 34
Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best.

Institutional Holders

% Shares Owned: 42.59%
# of Holders: 218
Total Shares Held: 67,366,931
3 Mo. Net Change: -6,737,319
# New Positions: 4
# Closed Positions: 9
# Increased Positions: 51
# Reduced Positions: 46
# Net Buyers: 5
NYSE and AMEX quotes delayed by at least 20 minutes. NASDAQ delayed by at least 15 minutes. For a complete list of exchanges and delays, please click here.