Loading...

Ace Hardware Indonesia

DB:4AH1
Snowflake Description

Flawless balance sheet with reasonable growth potential.

The Snowflake is generated from 30 checks in 5 different areas, read more below.
4AH1
DB
IDR30,811B
Market Cap
  1. Home
  2. DE
  3. Retail
Company description

PT Ace Hardware Indonesia Tbk engages in the retail of household appliances and lifestyle products in Indonesia. The last earnings update was 56 days ago. More info.


Add to Portfolio Compare Print
4AH1 Share Price and Events
7 Day Returns
3%
DB:4AH1
-0.4%
DE Specialty Retail
1.6%
DE Market
1 Year Returns
45.3%
DB:4AH1
-20.8%
DE Specialty Retail
-7.4%
DE Market
4AH1 Shareholder Return
  7 Day 30 Day 90 Day 1 Year 3 Year 5 Year
Ace Hardware Indonesia (4AH1) 3% 11.3% 0.6% 45.3% 109.2% 127.4%
DE Specialty Retail -0.4% 1% 5.9% -20.8% -49.7% -55.4%
DE Market 1.6% 1.5% 3% -7.4% 14.7% 9.4%
1 Year Return vs Industry and Market
  • 4AH1 outperformed the Specialty Retail industry which returned -20.8% over the past year.
  • 4AH1 outperformed the Market in Germany which returned -7.4% over the past year.
Price Volatility
4AH1
Industry
5yr Volatility vs Market
Related Companies

Sorry, no analysis for Ace Hardware Indonesia's competitors could be found in our database.

Value

 Is Ace Hardware Indonesia undervalued based on future cash flows and its price relative to the stock market?

Value is all about what a company is worth versus what price it is available for. If you went into a grocery store and all the bananas were on sale at half price, they could be considered undervalued.
INTRINSIC VALUE BASED ON FUTURE CASH FLOWS
Here we compare the current share price of Ace Hardware Indonesia to its discounted cash flow analysis.value.

The discounted cash flow value is simply looking at what the company is worth today, based on estimates of how much money it is expected to make in the future.
Raw Data

Below are the data sources, inputs and calculation used to determine the intrinsic value for Ace Hardware Indonesia.

DB:4AH1 Discounted Cash Flow Data Sources
Data Point Source Value
Valuation Model 2 Stage Free Cash Flow to Equity
Levered Free Cash Flow Average of 12 Analyst Estimates (S&P Global) See below
Discount Rate (Cost of Equity) See below 5.7%
Perpetual Growth Rate 10-Year DE Government Bond Rate 0.2%

An important part of a discounted cash flow is the discount rate, below we explain how it has been calculated.

Calculation of Discount Rate/ Cost of Equity for DB:4AH1
Data Point Calculation/ Source Result
Risk-Free Rate 10-Year DE Govt Bond Rate 0.2%
Equity Risk Premium S&P Global 6%
Specialty Retail Unlevered Beta Simply Wall St/ S&P Global 0.87
Re-levered Beta = Unlevered beta (1 + (1- tax rate) (Debt/Equity))
= 0.871 (1 + (1- 25%) (0.04%))
0.914
Levered Beta Levered Beta limited to 0.8 to 2.0
(practical range for a stable firm)
0.91
Discount Rate/ Cost of Equity = Cost of Equity = Risk Free Rate + (Levered Beta * Equity Risk Premium)
= 0.23% + (0.914 * 5.96%)
5.68%

Discounted Cash Flow Calculation for DB:4AH1 using 2 Stage Free Cash Flow to Equity Model

The calculations below outline how an intrinsic value for Ace Hardware Indonesia is arrived at by discounting future cash flows to their present value using the 2 stage method. We try to start with analysts estimates of free cash flow, however if these are not available we use the most recent financial results. In the 1st stage we continue to grow the free cash flow over a 10 year period, with the growth rate trending towards the perpetual growth rate used in the 2nd stage. The 2nd stage assumes the company grows at a stable rate into perpetuity.

DB:4AH1 DCF 1st Stage: Next 10 year cash flow forecast
Levered FCF (IDR, Millions) Source Present Value
Discounted (@ 5.68%)
2019 739,966.67 Analyst x3 700,225.65
2020 763,683.33 Analyst x6 683,856.58
2021 863,600.00 Analyst x5 731,796.30
2022 938,476.12 Est @ 8.67% 752,534.92
2023 996,075.67 Est @ 6.14% 755,825.65
2024 1,039,551.32 Est @ 4.36% 746,450.62
2025 1,072,023.63 Est @ 3.12% 728,425.88
2026 1,096,197.55 Est @ 2.25% 704,848.36
2027 1,114,250.67 Est @ 1.65% 677,978.04
2028 1,127,858.12 Est @ 1.22% 649,401.15
Present value of next 10 years cash flows IDR7,131,343.14
DB:4AH1 DCF 2nd Stage: Terminal Value
Calculation Result
Terminal Value = FCF2028 × (1 + g) ÷ (Discount Rate – g)
= IDR1,127,858.12 × (1 + 0.23%) ÷ (5.68% – 0.23%)
IDR20,751,504.40
Present Value of Terminal Value = Terminal Value ÷ (1 + r)10
= IDR20,751,504.40 ÷ (1 + 5.68%)10
IDR11,948,356.42
DB:4AH1 Total Equity Value
Calculation Result
Total Equity Value = Present value of next 10 years cash flows + Terminal Value
= IDR7,131,343.14 + IDR11,948,356.42
IDR19,079,699.57
Equity Value per Share
(IDR)
= Total value / Shares Outstanding
= IDR19,079,699.57 / 17,117.25
IDR1114.65
DB:4AH1 Discount to Share Price
Calculation Result
Non-primary Listing Adjustment Factor 1 share in DB:4AH1 represents 6.0E-5x of IDX:ACES
(This could be a different class, a depositary receipt, a different currency, or all of these things.)
6.0E-5x
Value per Share
(Listing Adjusted, EUR)
= Value per Share (IDR) x Listing Adjustment Factor
= IDR 1,114.65 x 6.0E-5
€0.06
Value per share (EUR) From above. €0.06
Current discount Discount to share price of €0.10
= -1 x (€0.10 - €0.06) / €0.06
-61.5%

Learn more about our DCF calculations in Simply Wall St’s analysis model .

  • The current share price of Ace Hardware Indonesia is above its future cash flow value.
Often investors are willing to pay a premium for a company that has a high dividend or the potential for future growth.
PRICE RELATIVE TO MARKET
We can also value a company based on what the stock market is willing to pay for it. This is similar to the price of fruit (e.g. Mangoes or Avocados) increasing when they are out of season, or how much your home is worth.

The amount the stock market is willing to pay for Ace Hardware Indonesia's earnings, growth and assets is considered below, and whether this is a fair price.
Price based on past earnings
Are Ace Hardware Indonesia's earnings available for a low price, and how does this compare to other companies in the same industry?
Raw Data
DB:4AH1 PE (Price to Earnings) Ratio Data Sources
Data Point Source Value
Earnings Per Share * Company Filings (2019-03-31) in IDR IDR58.10
IDX:ACES Share Price ** IDX (2019-06-24) in IDR IDR1800
Germany Specialty Retail Industry PE Ratio Median Figure of 6 Publicly-Listed Specialty Retail Companies 14.47x
Germany Market PE Ratio Median Figure of 425 Publicly-Listed Companies 20.07x

* Trailing twelve months (TTM) annual GAAP earnings per share excluding extraordinary items.

** Primary Listing of Ace Hardware Indonesia.

DB:4AH1 PE (Price to Earnings) Ratio Calculation
Calculation Outcome
PE Ratio

= IDX:ACES Share Price ÷ EPS (both in IDR)

= 1800 ÷ 58.10

30.98x

Learn more about our ratios and growth rates in Simply Wall St’s analysis model >

  • Ace Hardware Indonesia is overvalued based on earnings compared to the DE Specialty Retail industry average.
  • Ace Hardware Indonesia is overvalued based on earnings compared to the Germany market.
Price based on expected Growth
Does Ace Hardware Indonesia's expected growth come at a high price?
Raw Data
DB:4AH1 PEG (Price to Earnings to Growth) Ratio Data Sources
Data Point Source Value
PE Ratio See PE Ratio Section 30.98x
Net Income Annual Growth Rate See Future Growth Section.
Line of Best Fit* through Consensus Estimate Earnings of 12 Analysts
13.6%per year
Germany Specialty Retail Industry PEG Ratio Median Figure of 6 Publicly-Listed Specialty Retail Companies 0.86x
Germany Market PEG Ratio Median Figure of 272 Publicly-Listed Companies 1.46x

*Line of best fit is calculated by linear regression .

DB:4AH1 PEG (Price to Earnings to Growth) Ratio Calculation
Calculation Outcome
PEG Ratio

= PE Ratio ÷ Net Income Annual Growth Rate

= 30.98x ÷ 13.6%

2.27x

Learn more about our ratios and growth rates in Simply Wall St’s analysis model >

  • Ace Hardware Indonesia is poor value based on expected growth next year.
Price based on value of assets
What value do investors place on Ace Hardware Indonesia's assets?
Raw Data
DB:4AH1 PB (Price to Book) Ratio Data Sources
Data Point Source Value
Book Value per Share Company Filings (2019-03-31) in IDR IDR260.69
IDX:ACES Share Price * IDX (2019-06-24) in IDR IDR1800
Germany Specialty Retail Industry PB Ratio Median Figure of 6 Publicly-Listed Specialty Retail Companies 0.91x
Germany Market PB Ratio Median Figure of 574 Publicly-Listed Companies 1.8x
DB:4AH1 PB (Price to Book) Ratio Calculation
Calculation Outcome
PB Ratio

= IDX:ACES Share Price ÷ Book Value per Share (both in IDR)

= 1800 ÷ 260.69

6.9x

* Primary Listing of Ace Hardware Indonesia.

Learn more about our ratios and growth rates in Simply Wall St’s analysis model >

  • Ace Hardware Indonesia is overvalued based on assets compared to the DE Specialty Retail industry average.
X
Value checks
We assess Ace Hardware Indonesia's value by looking at:
  1. Is the discounted cash flow value less than 20%, or 40% of the share price? (2 checks) ( Click here or on bar chart for details of DCF calculation. )
  2. Is the PE ratio less than the market average, and/ or less than the Specialty Retail industry average (and greater than 0)? (2 checks)
  3. Is the PEG ratio within a reasonable range (0 to 1)? (1 check)
  4. Is the PB ratio less than the Specialty Retail industry average (and greater than 0)? (1 check)
  5. Ace Hardware Indonesia has a total score of 0/6, see the detailed checks below.

    Note: We use GAAP Earnings per Share in all our calculations including PE and PEG Ratio.

    Full details on the Value part of the Simply Wall St company analysis model.

Future Performance

 How is Ace Hardware Indonesia expected to perform in the next 1 to 3 years based on estimates from 12 analysts?

The future performance of a company is measured in the same way as past performance, by looking at estimated growth and how much profit it is expected to make.

Future estimates come from professional analysts. Just like forecasting the weather, they don’t always get it right!
Annual Growth Rate
13.6%
Expected annual growth in earnings.
Earnings growth vs Low Risk Savings
Is Ace Hardware Indonesia expected to grow at an attractive rate?
  • Ace Hardware Indonesia's earnings growth is expected to exceed the low risk savings rate of 0.2%.
Growth vs Market Checks
  • Ace Hardware Indonesia's earnings growth is expected to exceed the Germany market average.
  • Ace Hardware Indonesia's revenue growth is expected to exceed the Germany market average.
Annual Growth Rates Comparison
Raw Data
DB:4AH1 Future Growth Rates Data Sources
Data Point Source Value (per year)
DB:4AH1 Future Earnings Growth Rate Line of Best Fit* through Consensus Estimate Earnings of 12 Analysts 13.6%
DB:4AH1 Future Revenue Growth Rate Line of Best Fit* through Consensus Estimate Revenue of 12 Analysts 13.1%
Germany Specialty Retail Industry Earnings Growth Rate Market Cap Weighted Average 18.3%
Germany Specialty Retail Industry Revenue Growth Rate Market Cap Weighted Average 3.9%
Germany Market Earnings Growth Rate Market Cap Weighted Average 12.4%
Germany Market Revenue Growth Rate Market Cap Weighted Average 5.1%

*Line of best fit is calculated by linear regression .

Industry and Market average data is calculated daily.

Learn more about our growth rate calculations in Simply Wall St’s analysis model.

Analysts growth expectations
Raw Data
DB:4AH1 Analysts Growth Expectations Data Sources
Data Point Source Value
Past Financials Company Filings (2 months ago) See Below
Future Estimates Average of up to 12 Analyst Estimates (S&P Global) See Below
All numbers in IDR Millions and using Trailing twelve months (TTM) annual period rather than quarterly.
DB:4AH1 Future Estimates Data
Date (Data in IDR Millions) Revenue Cash Flow Net Income * Avg. No. Analysts
2021-12-31 10,973,860 1,169,333 1,474,386 7
2020-12-31 9,794,654 985,130 1,317,229 10
2019-12-31 8,577,898 887,933 1,144,170 7
DB:4AH1 Past Financials Data
Date (Data in IDR Millions) Revenue Cash Flow Net Income *
2019-03-31 7,547,824 278,471 992,540
2018-12-31 7,239,754 280,550 964,554
2018-09-30 6,879,126 282,057 948,630
2018-06-30 6,563,452 518,329 875,643
2018-03-31 6,217,520 571,234 832,507
2017-12-31 5,938,576 690,356 777,727
2017-09-30 5,607,728 744,140 760,843
2017-06-30 5,357,798 1,014,262 800,309
2017-03-31 5,069,509 505,244 724,889
2016-12-31 4,935,903 491,972 710,580
2016-09-30 4,838,005 744,298 671,270
2016-06-30 4,859,922 665,765 578,278

*GAAP earnings excluding extraordinary items.

Super high growth metrics
High Growth Checks
  • Ace Hardware Indonesia's earnings are expected to grow by 13.6% yearly, however this is not considered high growth (20% yearly).
  • Ace Hardware Indonesia's revenue is expected to grow by 13.1% yearly, however this is not considered high growth (20% yearly).
Past and Future Earnings per Share
The accuracy of the analysts who estimate the future performance data can be gauged below. We look back 3 years and see if they were any good at predicting what actually occurred. We also show the highest and lowest estimates looking forward to see if there is a wide range.
Raw Data
DB:4AH1 Past and Future Earnings per Share
Data Point Source Value
Past Financials Company Filings (2 months ago) See Below
Future Estimates Average of up to 12 Analyst Estimates (S&P Global) See Below

All data from Ace Hardware Indonesia Company Filings, last reported 2 months ago, and in Trailing twelve months (TTM) annual period rather than quarterly.

DB:4AH1 Future Estimates Data
Date (Data in IDR Millions) EPS * EPS High Estimate EPS Low Estimate Avg. No. Analysts
2021-12-31 86.09 92.99 80.00 7.00
2020-12-31 76.94 80.90 73.00 9.00
2019-12-31 66.86 67.83 65.30 5.00
DB:4AH1 Past Financials Data
Date (Data in IDR Millions) EPS *
2019-03-31 58.10
2018-12-31 56.49
2018-09-30 55.65
2018-06-30 51.37
2018-03-31 48.84
2017-12-31 45.62
2017-09-30 44.68
2017-06-30 46.98
2017-03-31 42.54
2016-12-31 41.69
2016-09-30 39.40
2016-06-30 33.96

*GAAP earnings excluding extraordinary items.

Performance in 3 years
In the same way as past performance we look at the future estimated return (profit) compared to the available funds. We do this looking forward 3 years.
  • Ace Hardware Indonesia is expected to efficiently use shareholders’ funds in the future (Return on Equity greater than 20%).
X
Future performance checks
We assess Ace Hardware Indonesia's future performance by looking at:
  1. Is the annual earnings growth rate expected to beat the low risk savings rate, plus a premium to keep pace with inflation?
  2. Is the annual earnings growth rate expected to beat the average growth rate in earnings of the Germany market? (1 check)
  3. Is the annual revenue growth rate expected to beat the average growth rate in revenue of the Germany market? (1 check)
  4. Is the annual earnings growth rate expected to be above 20%? (1 check)
  5. Is the annual revenue growth rate expected to be above 20%? (1 check)
  6. Is the Return on Equity in 3 years expected to be over 20%? (1 check)
Some of the above checks will fail if the company is expected to be loss making in the relevant year.
Ace Hardware Indonesia has a total score of 4/6, see the detailed checks below.

Note 1: We use GAAP Net Income Excluding Exceptional Items for our Earnings in all our calculations.

Full details on the Future part of the Simply Wall St company analysis model.

Past Performance

  How has Ace Hardware Indonesia performed over the past 5 years?

The past performance of a company can be measured by how much growth it has experienced and how much profit it makes relative to the funds and assets it has available.
Past earnings growth
Below we compare Ace Hardware Indonesia's growth in the last year to its industry (Specialty Retail).
Past Earnings growth analysis
We also check if the company has grown in the past 5 years, and whether it has maintained that growth in the year.
  • Ace Hardware Indonesia's year on year earnings growth rate has been positive over the past 5 years.
  • Ace Hardware Indonesia's 1-year earnings growth exceeds its 5-year average (19.2% vs 13.1%)
  • Ace Hardware Indonesia's earnings growth has not exceeded the DE Specialty Retail industry average in the past year (19.2% vs 32.5%).
Earnings and Revenue History
Ace Hardware Indonesia's revenue and profit over the past 5 years is shown below, any years where they have experienced a loss will show up in red.
Raw Data

All data from Ace Hardware Indonesia Company Filings, last reported 2 months ago, and in Trailing twelve months (TTM) annual period rather than quarterly.

DB:4AH1 Past Revenue, Cash Flow and Net Income Data
Date (Data in IDR Millions) Revenue Net Income * G+A Expenses R&D Expenses
2019-03-31 7,547,824.28 992,540.45 2,268,136.30
2018-12-31 7,239,754.27 964,554.03 2,177,652.39
2018-09-30 6,879,126.08 948,630.44 2,059,647.62
2018-06-30 6,563,452.44 875,642.85 1,989,944.20
2018-03-31 6,217,520.35 832,506.64 1,883,523.18
2017-12-31 5,938,576.23 777,727.07 1,807,068.07
2017-09-30 5,607,727.60 760,842.93 1,652,278.70
2017-06-30 5,357,798.35 800,309.07 1,566,314.87
2017-03-31 5,069,508.77 724,889.03 1,513,951.47
2016-12-31 4,935,902.89 710,580.26 1,482,448.19
2016-09-30 4,838,004.99 671,269.97 1,491,448.67
2016-06-30 4,859,921.51 578,277.56 1,520,590.70
2016-03-31 4,795,804.16 602,050.43 1,460,360.24
2015-12-31 4,742,525.93 588,324.83 1,451,008.40
2015-09-30 4,643,906.52 579,912.17 1,432,217.75
2015-06-30 4,589,318.37 565,127.44 1,425,055.58
2015-03-31 4,574,713.17 551,697.58 1,432,338.14
2014-12-31 4,541,473.97 562,324.44 1,422,045.67
2014-09-30 4,460,059.76 566,295.21 1,440,336.46
2014-06-30 4,280,835.08 569,229.40 1,392,461.93
2014-03-31 4,082,992.76 552,917.00 1,329,506.47
2013-12-31 3,895,446.38 508,872.99 1,281,438.34
2013-09-30 3,733,750.54 474,860.63 1,189,879.63
2013-06-30 3,572,172.16 440,342.32 1,121,545.12
2013-03-31 3,393,658.10 434,918.38 1,053,103.39
2012-12-31 3,223,291.02 437,142.98 974,606.19
2012-09-30 2,978,534.85 385,427.12 906,831.51
2012-06-30 2,784,645.34 356,551.46 837,060.84

*GAAP earnings excluding extraordinary items.

Performance last year
We want to ensure a company is making the most of what it has available. This is done by comparing the return (profit) to a company's available funds, assets and capital.
  • Ace Hardware Indonesia has efficiently used shareholders’ funds last year (Return on Equity greater than 20%).
  • Ace Hardware Indonesia used its assets more efficiently than the DE Specialty Retail industry average last year based on Return on Assets.
  • Ace Hardware Indonesia's use of capital has not improved over the past 3 years (Return on Capital Employed).
X
Past performance checks
We assess Ace Hardware Indonesia's performance over the past 5 years by checking for:
  1. Has earnings increased in past 5 years? (1 check)
  2. Has the earnings growth in the last year exceeded that of the Specialty Retail industry? (1 check)
  3. Is the recent earnings growth over the last year higher than the average annual growth over the past 5 years? (1 check)
  4. Is the Return on Equity (ROE) higher than 20%? (1 check)
  5. Is the Return on Assets (ROA) above industry average? (1 check)
  6. Has the Return on Capital Employed (ROCE) increased from 3 years ago? (1 check)
The above checks will fail if the company has reported a loss in the most recent earnings report. Some checks require at least 3 or 5 years worth of data.
Ace Hardware Indonesia has a total score of 4/6, see the detailed checks below.

Note: We use GAAP Net Income excluding extraordinary items in all our calculations.

Full details on the Past part of the Simply Wall St company analysis model.

Health

 How is Ace Hardware Indonesia's financial health and their level of debt?

A company's financial position is much like your own financial position, it includes everything you own (assets) and owe (liabilities).

The boxes below represent the relative size of what makes up Ace Hardware Indonesia's finances.

The net worth of a company is the difference between its assets and liabilities.
Net Worth
  • Ace Hardware Indonesia is able to meet its short term (1 year) commitments with its holdings of cash and other short term assets.
  • Ace Hardware Indonesia's cash and other short term assets cover its long term commitments.
Balance sheet
This treemap shows a more detailed breakdown of Ace Hardware Indonesia's finances. If any of them are yellow this indicates they may be out of proportion and red means they relate to one of the checks below.
Assets
Liabilities and shares
The 'shares' portion represents any funds contributed by the owners (shareholders) and any profits.
  • High level of physical assets or inventory.
  • Debt is covered by short term assets, assets are 322.6x debt.
Historical Debt
Nearly all companies have debt. Debt in itself isn’t bad, however if the debt is too high, or the company can’t afford to pay the interest on its debts this may have impacts in the future.

The graphic below shows equity (available funds) and debt, we ideally want to see the red area (debt) decreasing.

If there is any debt we look at the companies capability to repay it, and whether the level has increased over the past 5 years.
Raw Data

All data from Ace Hardware Indonesia Company Filings, last reported 2 months ago.

DB:4AH1 Past Debt and Equity Data
Date (Data in IDR Millions) Total Equity Total Debt Cash & Short Term Investments
2019-03-31 4,474,806.21 13,008.41 788,862.04
2018-12-31 4,235,471.05 115,080.97 804,747.11
2018-09-30 3,825,099.93 25,342.50 530,163.91
2018-06-30 3,551,148.77 0.00 832,446.54
2018-03-31 3,720,725.71 0.00 1,025,761.18
2017-12-31 3,510,421.85 0.00 912,115.18
2017-09-30 3,295,517.98 0.00 739,878.67
2017-06-30 3,095,369.13 0.00 870,091.27
2017-03-31 3,202,960.98 5,713.19 899,490.69
2016-12-31 3,048,727.69 5,339.71 707,091.68
2016-09-30 2,836,037.60 16,073.12 520,997.80
2016-06-30 2,598,686.85 26,255.19 395,860.09
2016-03-31 2,766,237.06 19,342.17 808,304.56
2015-12-31 2,628,825.52 23,052.96 623,460.34
2015-09-30 2,467,160.50 24,715.03 210,388.75
2015-06-30 2,335,723.24 28,831.49 116,340.33
2015-03-31 2,487,289.32 32,207.89 418,893.52
2014-12-31 2,329,112.42 26,709.23 397,496.96
2014-09-30 2,185,198.71 32,747.50 226,406.64
2014-06-30 2,056,239.27 35,823.03 122,722.53
2014-03-31 2,050,726.98 38,272.38 152,818.07
2013-12-31 1,915,498.44 35,321.83 165,334.42
2013-09-30 1,734,430.51 40,955.39 207,430.65
2013-06-30 1,628,919.92 42,299.53 272,204.60
2013-03-31 1,708,184.67 34,984.55 477,960.18
2012-12-31 1,618,001.04 35,449.07 276,985.99
2012-09-30 1,447,871.11 26,135.73 150,344.31
2012-06-30 1,355,771.56 33,380.15 194,330.99
  • Ace Hardware Indonesia's level of debt (0.3%) compared to net worth is satisfactory (less than 40%).
  • The level of debt compared to net worth has been reduced over the past 5 years (1.9% vs 0.3% today).
  • Debt is well covered by operating cash flow (2140.7%, greater than 20% of total debt).
  • Ace Hardware Indonesia earns more interest than it pays, coverage of interest payments is not a concern.
X
Financial health checks
We assess Ace Hardware Indonesia's financial health by checking for:
  1. Are short term assets greater than short term liabilities? (1 check)
  2. Are short term assets greater than long term liabilities? (1 check)
  3. Has the debt to equity ratio increased in the past 5 years? (1 check)
  4. Is the debt to equity ratio over 40%? (1 check)
  5. Is the debt covered by operating cash flow? (1 check)
  6. Are earnings greater than 5x the interest on debt (if company pays interest at all)? (1 check)
  7. Ace Hardware Indonesia has a total score of 6/6, see the detailed checks below.
For companies that are loss making and have been so on average in the past we replace the last 2 checks with:
  1. Does cash and short term investments cover stable operating expenses (recurring G&A and R&D) for more than 3 years? (1 check)
  2. Does cash and short term investments cover growing operating expenses (recurring G&A and R&D) for more than 3 years? (1 check)


Full details on the Health part of the Simply Wall St company analysis model.

Dividends

 What is Ace Hardware Indonesia's current dividend yield, its reliability and sustainability?

Dividends are regular cash payments to you from the company, similar to a bank paying you interest on a savings account.
Annual Dividend Income
Dividend payments
1.27%
Current annual income from Ace Hardware Indonesia dividends. Estimated to be 1.86% next year.
If you bought €2,000 of Ace Hardware Indonesia shares you are expected to receive €25 in your first year as a dividend.
Dividend Amount
Here we look how much dividend is being paid, if any. Is it above what you can get in a savings account? It is up there with the best dividend paying companies?
  • Ace Hardware Indonesia's pays a lower dividend yield than the bottom 25% of dividend payers in Germany (1.45%).
  • Ace Hardware Indonesia's dividend is below the markets top 25% of dividend payers in Germany (3.87%).
Annualized Historical and Future Dividends
It is important to see if the dividend for a company is stable, and not wildly increasing/decreasing each year. This graph shows you the historical rate to count toward your assessment of the stock.

We also check to see if the dividend has increased in the past 10 years.
Raw Data
DB:4AH1 Annualized Past and Future Dividends
Data Point Source Value
Past Annualized Dividend Yield S&P Global Market Data See Below
Past Dividends per Share Company Filings/ Annualized Dividend Payments See Below
Future Dividends per Share Estimates Average of up to 12 Analyst Estimates (S&P Global) See Below
Europe Specialty Retail Industry Average Dividend Yield Market Cap Weighted Average of 60 Stocks 3.9%
Germany Market Average Dividend Yield Market Cap Weighted Average of 328 Stocks 3.1%
Germany Minimum Threshold Dividend Yield 10th Percentile 0.8%
Germany Bottom 25% Dividend Yield 25th Percentile 1.5%
Germany Top 25% Dividend Yield 75th Percentile 3.9%

Industry and Market average data is calculated daily.

Note all dividend per share amounts are annualized and not quarterly or other period.

DB:4AH1 Future Dividends Estimate Data
Date (Data in IDR) Dividend per Share (annual) Avg. No. Analysts
2021-12-31 38.51 8.00
2020-12-31 33.99 12.00
2019-12-31 29.30 11.00
DB:4AH1 Past Annualized Dividends Data
Date (Data in IDR) Dividend per share (annual) Avg. Yield (%)
2018-07-30 22.810 1.467
2018-04-02 22.810 1.771
2017-07-28 16.470 1.355
2017-03-31 16.470 1.649
2016-07-29 15.400 1.828
2016-03-31 15.400 1.720
2015-07-31 16.000 2.268
2015-03-31 16.000 2.404
2014-10-31 6.000 0.777
2014-07-25 6.000 0.673
2014-04-01 6.000 0.710
2013-10-31 10.000 1.410
2013-07-31 10.000 1.451
2013-04-01 10.000 1.203
2013-03-28 10.000 1.177
2012-10-30 2.500 0.329
2012-08-07 2.500 0.399
2012-03-30 2.500 0.484
2011-08-01 5.185 1.376
2011-03-31 5.185 1.848
2010-03-31 0.920 0.433

Learn more about our ratios and growth rates in Simply Wall St’s analysis model >

  • Ace Hardware Indonesia has been paying a dividend for less than 10 years and during this time payments have been volatile (annual drop of over 20%).
  • Dividend payments have increased, but Ace Hardware Indonesia only paid a dividend in the past 9 years.
Current Payout to shareholders
What portion of Ace Hardware Indonesia's earnings are paid to the shareholders as a dividend.
  • Dividends paid are well covered by earnings (2.5x coverage).
Future Payout to shareholders
  • Dividends after 3 years are expected to be well covered by earnings (2.3x coverage).
X
Income/ dividend checks
We assess Ace Hardware Indonesia's dividend by checking for:
  1. Firstly is the company paying a notable dividend (greater than 0.8%) - if not then the rest of the checks are ignored.
  2. Is current dividend yield above the bottom 25% of dividend payers? (1 check)
  3. Is current dividend yield above the top 25% of dividend payers? (1 check)
  4. Have they paid a dividend for 10 years, and during this period has the dividend been volatile (drop of more than 25%)? (1 check)
  5. If they have paid a dividend for 10 years has it increased in this time? (1 check)
  6. How sustainable is the dividend, can Ace Hardware Indonesia afford to pay it from its earnings today and in 3 years (Payout ratio less than 90%)? (2 checks)
  7. Ace Hardware Indonesia has a total score of 2/6, see the detailed checks below.


Full details on the Dividends part of the Simply Wall St company analysis model.

Management

 What is the CEO of Ace Hardware Indonesia's salary, the management and board of directors tenure and is there insider trading?

Management is one of the most important areas of a company. We look at unreasonable CEO compensation, how long the team and board of directors have been around for and insider trading.
CEO
Prabowo Widya krisnadi
AGE 56
TENURE AS CEO 23.4 years
CEO Bio

Mr. Prabowo Widya Krisnadi has been President Director of PT Ace Hardware Indonesia Tbk since 1996 and serves as its a Director.

CEO Compensation
  • Insufficient data for Prabowo to compare compensation growth.
  • Insufficient data for Prabowo to establish whether their remuneration is reasonable compared to companies of similar size in Germany.
Management Team Tenure

Average tenure and age of the Ace Hardware Indonesia management team in years:

14
Average Tenure
53
Average Age
  • The average tenure for the Ace Hardware Indonesia management team is over 5 years, this suggests they are a seasoned and experienced team.
Management Team

Prabowo Widya krisnadi

TITLE
President Director
AGE
56
TENURE
23.4 yrs

Sugiyanto Wibawa

TITLE
Operations & Business Develop. Director and Non-Affiliated Director
AGE
60

Helen Tanzil

TITLE
Head of Investor Relations Division & Corporate Secretary
AGE
50
TENURE
9.6 yrs

Petrus Prakoso

TITLE
Head of Internal Audit
AGE
50
TENURE
18.4 yrs

Hartanto Djasman

TITLE
Controller & support Director and Director
AGE
61

Tarisa Widyakrisnadi

TITLE
Merchandising Director & Director
AGE
50
TENURE
8.4 yrs
Board of Directors Tenure

Average tenure and age of the Ace Hardware Indonesia board of directors in years:

23.4
Average Tenure
60.5
Average Age
  • The average tenure for the Ace Hardware Indonesia board of directors is over 10 years, this suggests they are a seasoned and experienced board.
Board of Directors

Prabowo Widya krisnadi

TITLE
President Director
AGE
56
TENURE
23.4 yrs

Sugiyanto Wibawa

TITLE
Operations & Business Develop. Director and Non-Affiliated Director
AGE
60

Hartanto Djasman

TITLE
Controller & support Director and Director
AGE
61

Tarisa Widyakrisnadi

TITLE
Merchandising Director & Director
AGE
50

Kuncoro Wibowo

TITLE
President Commissioner
AGE
62
TENURE
24.4 yrs

Teddy Setiawan

TITLE
Independent Commissioner
AGE
61
TENURE
7.1 yrs

Ijek Widyakrisnadi

TITLE
Commissioner
AGE
60
TENURE
24.4 yrs

Purn Tarub

TITLE
Independent Commissioner
AGE
76
TENURE
11.4 yrs
Who owns this company?
Recent Insider Trading
  • No 3 month individual insider trading information.
Recent Insider Transactions
Announced Type Name Entity Role Start End Shares Max Price (€) Value (€)
X
Management checks
We assess Ace Hardware Indonesia's management by checking for:
  1. Is the CEO's compensation unreasonable compared to market cap? (1 check)
  2. Has the CEO's compensation increased more than 20% whilst the EPS is down more then 20%? (1 check)
  3. Is the average tenure of the management team less than 2 years? (1 check)
  4. Is the average tenure of the board of directors team less than 3 years? (1 check)
  5. Ace Hardware Indonesia has a total score of 0/6, this is not included on the snowflake, see the detailed checks below.


Note: We use the top 6 management executives and board members in our calculations.

Note 2: Insider trading include any internal stakeholders and these transactions .

Full details on the Management part of the Simply Wall St company analysis model.

News

Simply Wall St News

Company Info

Description

PT Ace Hardware Indonesia Tbk engages in the retail of household appliances and lifestyle products in Indonesia. It operates through Home Improvement Products, Lifestyle Products, and Toy Products segments. As of December 31, 2018, it operated 176 retail outlets located in Jakarta, Tangerang, Cilegon, Bekasi, Bogor, Depok, Cirebon, Bandung, Tasikmalaya, Gresik, Semarang, Surabaya, Aceh, Palembang, Balikpapan, Tegal, Malang, Kediri, Bali, Medan, Batam, Padang, Pekanbaru, Bengkulu, Makassar, Banjarmasin, Karawang, Yogyakarta, Solo, Jambi, Lampung, Pontianak, Maluku, Samarinda, Kupang, Lombok, Manado, Jember, Banjarbaru, Purwokerto, and Sidoarjo. The company was formerly known as PT Ace Indoritel Perkakas and changed its name to PT Ace Hardware Indonesia Tbk in August 2001. The company was founded in 1995 and is headquartered in Jakarta, Indonesia. PT Ace Hardware Indonesia Tbk is a subsidiary of PT Kawan Lama Sejahtera.

Details
Name: PT Ace Hardware Indonesia Tbk
4AH1
Exchange: DB
Founded: 1995
IDR1,911,417,967
17,117,248,100
Website: http://www.acehardware.co.id
Address: PT Ace Hardware Indonesia Tbk
Kawan Lama Building,
5th floor,
Jakarta,
11610,
Indonesia
Listings
Exchange Symbol Ticker Symbol Security Exchange Country Currency Listed on
IDX ACES Ordinary Shares Indonesia Stock Exchange ID IDR 06. Nov 2007
OTCPK ACEH.F Ordinary Shares Pink Sheets LLC US USD 06. Nov 2007
DB 4AH1 Ordinary Shares Deutsche Boerse AG DE EUR 06. Nov 2007
Number of employees
Current staff
Staff numbers
16,173
Ace Hardware Indonesia employees.
Industry
Home Improvement Retail
Retail
Company Analysis and Financial Data Status
Area Date (UTC time)
Company Analysis updated: 2019/06/24 21:43
End of day share price update: 2019/06/24 00:00
Last estimates confirmation: 2019/06/20
Last earnings filing: 2019/04/29
Last earnings reported: 2019/03/31
Last annual earnings reported: 2018/12/31


All dates and times in UTC. All financial data provided by Standard & Poor’s Capital IQ.

Unless specified all financial data is based on a yearly period but updated quarterly. This is known as Trailing Twelve Month (TTM) or Last Twelve Month (LTM) Data. Learn more here.