## Summary of Company Analysis Aptiv

Capitalization = 27.12, Grade = **6/10**

Revenue = 20.05, Grade = **6/10**

EBITDA margin, % = 7.78, Grade = **2/10**

Net margin, % = 14.51, Grade = **4/10**

ROA, % = 12.56, Grade = **4/10**

ROE, % = 28.56, Grade = **8/10**

P/S = 1.2618, Grade = **9/10**

P/BV = 2.14, Grade = **7/10**

Debt/EBITDA = 4.36, Grade = **1/10**
**Summary:**

EBITDA margin **below the average**, judging by the multipliers it is estimated **fair and interesting to buy**.

Earnings per share (14.16%) and EBITDA yield (-11.1%) are located on **low level**, and worth thinking about and comparing with other companies.

Efficiency (ROE=28.56%) are located on **quite high level**, interesting for purchase as the company effectively uses its own capital.

All company characteristics ⇨

## Dividend payment stability index

DSI - (Dividend Stability Index, DSI7), Dividend payment stability index

DSI = (Yc + Gc) / 14

Yc – number of consecutive years out of the last seven years in which dividends were paid;

Gc - number of consecutive years out of the last seven years in which the dividend amount was not lower than the previous year.

**Yc** = 7 **Gc** = 5 **DSI** = 0.86

## Stability index share price increase

SSI - (Stock Stability Index, SSI7) Stability index share price increase

SSI = Yc / 7

Yc – number of consecutive years out of the last seven years in which the stock price was higher than the previous year.

**Yc** = 3 **SSI** = 0.43

## Warren Buffett Valuation

1. Stable profit, Value = 84.76% > 0

If growth over 5 years / growth over last 12 months > 0

2. Good debt coverage, Value = 0 < 3

When will the company be able to pay off the debt within 3 years

3. High return on capital, Value = 21.32% > 15

If the average ROE > 15% over the last 5 years

4. High return on investment capital, Value = 134.81% > 12

If average ROIC > 12% over the last 5 years

5. Positive free cash flow, Value = 0.99 > 0

Positive FCF in the last 12 months

6. Are there any share buybacks?, Value = no

If the number of shares today < number of shares 5 years ago

## Benjamin Graham score

1. Adequate company size, Grade = 6/10 (20.05, LTM)

2. Stable financial position (current assets/current liabilities), Grade = 1/10 ( LTM)

Current assets must be at least twice the current liabilities

3. Stable profit, Grade = 10/10

The company must not have incurred losses over the past 10 years

4. Dividend history, Grade = 10/10

The company must pay dividends for at least 20 years

5. Earnings growth (earnings per share), Value = 14.16%

The company's earnings per share must have increased by at least 1/3 over the last 10 years.

5.5. Share price growth, Value = 34.49%

The share price, as an indicator of the company's profit growth, should increase by at least 1/3 over the last 10 years

5.6. Dividend growth, Value = 41.94%

Dividend payments, as an indicator of company profit growth, should increase by at least 1/3 over the last 10 years

6. Optimal price/earnings ratio, Grade = 9/10 ( LTM)

The current share price should not exceed the average earnings for the last three years by more than 15 times

7. The optimal value of the price/book value ratio, Grade = 7/10 ( LTM)

The current share price should not exceed its book value by more than 1.5 times

## Score by Peter Lynch

1. Current assets exceed last year's = 3.5 > 7.73

Comparison of assets for the last 2 years. If the last year exceeds the previous one, this is a good sign

2. Debt reduction = 6.79 < 6.79

Reducing debt over recent years is a good sign

3. Excess cash debt = 1.64 > 6.79

If cash exceeds debt load, this is a good sign, which means the company is not at risk of bankruptcy.

4. Are there any share buybacks? = no

If the number of shares today < number of shares 5 years ago

5. Increased earnings per share = 10.28 > 10.28

Increased earnings per share compared to the previous year. This means efficiency is increasing, and this is a good sign.

6. Valuation of P/E and EPS versus price = 251.5 < 81.7

If the P/E and earnings per share are less than the share price, then the share is undervalued (see “The Peter Lynch Method,” page 182)

## Dividend strategy

1. Current dividend = **0.22** $.

1.5. Dividend yield = **1.45%** , Grade = **3.63/10**

2. Number of years of dividend growth = **0** , Grade = **0/10**

2.5. Number of recent years when the dividend percentage increased = **0**

3. DSI = **0.86** , Grade = **8.57/10**

4. Average dividend growth = **-22.17%** , Grade = **0/10**

5. Average percentage for 5 years = **0.26%** , Grade = **0.62/10**

6. Average percentage for payments = **15.88%** , Grade = **2.65/10**

7. Difference with sector = **-1.55**, Industry average = **3%** , Grade = **0/10**

## Beta coefficient

β > 1 – the profitability (as well as volatility) of such securities is very sensitive to market changes. Such assets are more exposed to risk, but potentially more profitable. In general, such securities can be called aggressive;

β = 1 – the profitability of such a security will change equally with the profitability of the market (stock index);

0 < β < 1 – with such a beta, assets are less exposed to market risk and, as a result, less volatile. Such securities have less risk, but are also less profitable in the future;

β = 0 – there is no connection between the security and the market (index) as a whole;

β < 0 – the yield of securities with a negative beta goes in the opposite direction to the market.

β = **0.04** - in 90 days

β = **-0.49** - in 1 year

β = **-0.21** - in 3 years

## Altman index

In 1968, Professor Edward Altman proposed his now classic five-factor model for predicting the likelihood of enterprise bankruptcy. The formula for calculating the integral indicator is as follows:

Z = 1.2*X1 + 1.4*X2 + 3.3*X3 + 0.6*X4 + X5

X1 = Working capital/Assets, X2 = Retained earnings/Assets, X3 = Operating profit/Assets, X4 = Market value of shares/Liabilities, X5 = Revenue/Assets

If Z > 2.9 – zone of financial stability (“green” zone).

If 1.8 < Z< 2.9 – zone of uncertainty (“gray” zone).

If Z < 1.8 – financial risk zone (“red” zone).

Altman index, Z = 1.2 * 1.11 + 1.4 * 0.12 + 3.3 * 0.09 + 0.6 * 0.68 + 0.82 = **3.0185**

## PEG ratio

PEG = 1 - the company's shares have a fair valuation.

PEG < 1 – shares are undervalued.

PEG > 1 - shares may be “overheated”.

PEG < 0 - the company is doing worse.

PEG = P/E / (Growth + Div %)

PEG = 24.47 / (28.49 + 1.45) = **0.8171**

## Graham index

**NCAV** = -15.31 per share (ncav/market_cap = -16%)

Net Current Asset Value, NCAV = Total Current Assets – Total Liabilities

Price = 81.7

undervalued = -533.64%

purchase at 50-70% (price range: -7.66 - -10.72), more than 100% overpriced

Data

**NNWC** = -23.99 per share (nnwc/market_cap = -25%)

Net-net Working Capital (NNWC) = Cash and short-term investments + (Receivables * 75%) + (Inventory * 50%) - Total liabilities

Price = 81.7

undervalued = -340.56%

purchase at 50-70% (price range: -12 - -16.79), more than 100% overpriced

Data

**Total Liabilities/P** = 0.4639

Total Liabilities/P = 6.79 / 27.12

The Total Liabilities/P coefficient must be less than 0.1

**P/S** = 1.687

P/S = Capitalization / Revenue

The P/S ratio should be between 0.3 - 0.5. The closer the multiplier value is to 0.3, the better. Describes the company's sales.