Apple Inc
Apple is an American corporation that manufactures personal and tablet computers, audio players, phones and software. It is one of the pioneers in the sphere of personal computers and new multi-tasking operating systems with a graphical interface. Due to modern technology and alluring design, Apple has created a unique reputation in the consumer electronics industry, comparable to the cult.
It is the first American company whose capitalization exceeded 1.044 trillion US dollars. This happened during the trading in the company's shares on September 10, 2018. On the same day, the company became the most expensive public company in the entire history, exceeding the capitalization of the previous record holder - PetroChina (1.005 trillion dollars in November 2007). Company is headquartered in Cupertino, California.
Results
Vertical analysis
Vertical analysis is a method of financial statement analysis in which each line item is listed as a percentage of a base figure within the statement in order to gain a picture of whether performance metrics are improving or deteriorating.
Statement of income
Base figure is Net Revenue = 100 %.
Period
Net Revenue
Cost of sales
Gross Profit
Selling, general & administrative expenses
Other income
Other expenses
Results from operating activities (EBIT)
Interest and other income, net
Profit before tax (EBT)
Tax expenses (provision)
Net profit from continuing operations
Profit/Loss from discontinued operations
Net profit for the year
2015, mln USD
233 715
(140 089)
93 626
(22 396)
0
0
71 230
1 285
72 515
(19 121)
53 394
0
53 394
2016, mln USD
215 639
(131 376)
84 263
(24 239)
0
0
60 024
1 348
61 372
(15 685)
45 687
0
45 687
2017, mln USD
229 234
(141 048)
88 186
(26 842)
0
0
61 344
2 745
64 089
(15 738)
48 351
0
48 351
2015, %
100.00
(59.94)
40.06
(9.58)
0.00
0.00
30.48
0.55
31.03
(8.18)
22.85
0.00
22.85
2016, %
100.00
(60.92)
39.08
(11.24)
0.00
0.00
27.84
0.63
28.46
(7.27)
21.19
0.00
21.19
2017, %
100.00
(61.53)
38.47
(11.71)
0.00
0.00
26.76
1.20
27.96
(6.87)
21.09
0.00
21.09
Main earnings components in mln USD
201520162017060000120000180000240000
  • Revenue
  • Gross profit
  • EBIT
  • EBT
  • Net profit
Main earnings components in % (Revenue = 100%)
2015201620170255075100
  • Revenue
  • Gross profit
  • EBIT
  • EBT
  • Net profit
Statement of financial position
Base figure is Total assets / Total equity and liabilities = 100 %.
Period
Property, plant and equipment
Goodwill
Intangible assets
Other non-current assets
Total non-current assets
Inventories
Trade receivables
Cash and cash equivalents
Other current assets
Total current assets
Total assets
Share capital
Additional Paid-In Capital
Retained earnings
Treasury stock
Capital Surplus
Other equity
Total equity
Long term debt
Other non-current liabilities
Total non-current liabilities
Short-term debt
Accounts payable
Accrued liabilities
Other current liabilities
Total current liabilities
Total liabilities
Total equity and liabilities
2015, mln USD
22 471
5 116
3 893
169 487
200 967
2 349
16 849
21 120
49 060
89 378
290 345
27 416
0
92 284
0
0
(345)
119 355
53 329
37 051
90 380
0
35 490
25 181
19 939
80 610
170 990
290 345
2016, mln USD
27 010
5 414
3 206
179 187
214 817
2 132
15 754
20 484
68 499
106 869
321 686
31 251
0
96 364
0
0
634
128 249
75 427
39 004
114 431
0
37 294
22 027
19 685
79 006
193 437
321 686
2017, mln USD
33 783
5 717
2 298
204 876
246 674
4 855
17 874
20 289
85 627
128 645
375 319
35 867
0
98 330
0
0
(150)
134 047
97 207
43 251
140 458
0
49 049
25 744
26 021
100 814
241 272
375 319
2015, %
7.74
1.76
1.34
58.37
69.22
0.81
5.80
7.27
16.90
30.78
100.00
9.44
0.00
31.78
0.00
0.00
(0.12)
41.11
18.37
12.76
31.13
0.00
12.22
8.67
6.87
27.76
58.89
100.00
2016, %
8.40
1.68
1.00
55.70
66.78
0.66
4.90
6.37
21.29
33.22
100.00
9.71
0.00
29.96
0.00
0.00
0.20
39.87
23.45
12.12
35.57
0.00
11.59
6.85
6.12
24.56
60.13
100.00
2017, %
9.00
1.52
0.61
54.59
65.72
1.29
4.76
5.41
22.81
34.28
100.00
9.56
0.00
26.20
0.00
0.00
(0.04)
35.72
25.90
11.52
37.42
0.00
13.07
6.86
6.93
26.86
64.28
100.00
Assets structure
Assets structure in %
2015201620170255075100
  • Current assets
  • Non-current assets
Assets structure in mln USD
201520162017095000190000285000380000
  • Current assets
  • Non-current assets
Assets structure in %
2015201620170255075100
  • Property
  • Goodwill
  • Intangible
  • Other non-current assets
  • Inventories
  • Trade receivables
  • Cash
  • Other curren assets
Assets structure in mln USD
201520162017095000190000285000380000
  • Property
  • Goodwill
  • Intangible
  • Other non-current assets
  • Inventories
  • Trade receivables
  • Cash
  • Other curren assets
Equity and liabilities structure
Equity and liabilities structure in %
2015201620170255075100
  • Equity
  • Total Liabilities
Equity and liabilities structure in mln USD
201520162017095000190000285000380000
  • Equity
  • Total Liabilities
Horizontal analysis
Horizontal analysis looks at amounts from the financial statements over a horizon of many years. Horizontal analysis is also referred to as trend analysis. The amounts from past financial statements will be restated to be a percentage of the amounts from a base year.
Statement of income
YoY change
Period
Net Revenue
Cost of sales
Gross Profit
Selling, general & administrative expenses
Other income
Other expenses
Results from operating activities (EBIT)
Interest and other income, net
Profit before tax (EBT)
Tax expenses (provision)
Net profit from continuing operations
Profit/Loss from discontinued operations
Net profit for the year
2015, mln USD
233 715
(140 089)
93 626
(22 396)
0
0
71 230
1 285
72 515
(19 121)
53 394
0
53 394
2016, mln USD
215 639
(131 376)
84 263
(24 239)
0
0
60 024
1 348
61 372
(15 685)
45 687
0
45 687
2017, mln USD
229 234
(141 048)
88 186
(26 842)
0
0
61 344
2 745
64 089
(15 738)
48 351
0
48 351
2015 / 2016, %
(7.73)
(6.22)
(10.00)
8.23
0.00
0.00
(15.73)
4.90
(15.37)
(17.97)
(14.43)
0.00
(14.43)
2016 / 2017, %
6.30
7.36
4.66
10.74
0.00
0.00
2.20
103.64
4.43
0.34
5.83
0.00
5.83
Due to horizontal analysis for 2015 / 2016 period Selling, general & administrative expenses showed the maximum growth by 8.23 % and Tax expenses (provision) changed by -17.97 %, which is the minimum percent change.
Statement of financial position
Period
Property, plant and equipment
Goodwill
Intangible assets
Other non-current assets
Total non-current assets
Inventories
Trade receivables
Cash and cash equivalents
Other current assets
Total current assets
Total assets
Share capital
Additional Paid-In Capital
Retained earnings
Treasury stock
Capital Surplus
Other equity
Total equity
Long term debt
Other non-current liabilities
Total non-current liabilities
Short-term debt
Accounts payable
Accrued liabilities
Other current liabilities
Total current liabilities
Total liabilities
Total equity and liabilities
2015, mln USD
22 471
5 116
3 893
169 487
200 967
2 349
16 849
21 120
49 060
89 378
290 345
27 416
0
92 284
0
0
(345)
119 355
53 329
37 051
90 380
0
35 490
25 181
19 939
80 610
170 990
290 345
2016, mln USD
27 010
5 414
3 206
179 187
214 817
2 132
15 754
20 484
68 499
106 869
321 686
31 251
0
96 364
0
0
634
128 249
75 427
39 004
114 431
0
37 294
22 027
19 685
79 006
193 437
321 686
2017, mln USD
33 783
5 717
2 298
204 876
246 674
4 855
17 874
20 289
85 627
128 645
375 319
35 867
0
98 330
0
0
(150)
134 047
97 207
43 251
140 458
0
49 049
25 744
26 021
100 814
241 272
375 319
2015 / 2016, %
20.20
5.82
(17.65)
5.72
6.89
(9.24)
(6.50)
(3.01)
39.62
19.57
10.79
13.99
0.00
4.42
0.00
0.00
(283.77)
7.45
41.44
5.27
26.61
0.00
5.08
(12.53)
(1.27)
(1.99)
13.13
10.79
2016 / 2017, %
25.08
5.60
(28.32)
14.34
14.83
127.72
13.46
(0.95)
25.00
20.38
16.67
14.77
0.00
2.04
0.00
0.00
(123.66)
4.52
28.88
10.89
22.74
0.00
31.52
16.87
32.19
27.60
24.73
16.67
According to horizontal analysis for 2015 / 2016 period Long term debt showed the maximum growth by 41.44 % and Other equity changed by -283.77 %, which is the minimum percent change. for 2016 / 2017 period Inventories showed the maximum growth by 127.72 % and Other equity changed by -123.66 %, which is the minimum percent change.
Financial ratio analysis
Period
Formula for calculating
Liquidity ratios
Current ratio
Current Assets / Current Liabilities
Quick ratio
(Current Assets - Inventories) / Current Liabilities
Cash ratio
(Cash and cash equivalents) / Current Liabilities
Working capital
Current assets - Current liabilities
Working capital ratio
Current assets / Current liabilities
Asset management
Inventory turnover
Cost of goods sold / Inventories
Days inventory
365 days / Inventory Turnover
Receivables turnover
Revenue / Receivables
Days Receivables
365 days / Receivables turnover
Fixed assets turnover
Revenue / Net Fixed Assets
Total assets turnover
Revenue / Total assets
Debt management
Debt to assets ratio
(Short-term debt + Long-term debt)/Total assets
Debt to equity ratio
Total liabilities / Total shareholder equity
Long-term debt to equity
Total long-term liabilities / Total shareholder equity
Debt to EBITDA ratio
(Short-term debt + Long-term debt) / EBITDA
Assets to equity ratio
Total assets / Shareholder equity
Profitability
Gross profit margin
Gross Profit / Revenue
EBITDA Margin
EBITDA / Revenue
Operating profit margin
EBIT / Revenue
Net profit margin
Net Profit / Revenue
Return on assets
Net Income / Total Assets
Return on equity
Net Income / Total shareholder equity
2015
1.11
1.08
0.26
8 768.00
1.11
59.64
6.12
13.87
26.31
10.40
0.80
0.59
1.43
0.76
2.07
2.43
0.40
0.35
0.30
0.23
0.18
0.45
2016
1.35
1.33
0.26
27 863.00
1.35
61.62
5.92
13.69
26.67
7.98
0.67
0.60
1.51
0.89
2.74
2.51
0.39
0.33
0.28
0.21
0.14
0.36
2017
1.28
1.23
0.20
27 831.00
1.28
29.05
12.56
12.82
28.46
6.79
0.61
0.64
1.80
1.05
3.37
2.80
0.38
0.31
0.27
0.21
0.13
0.36
Average
1.25
1.21
0.24
21 487.33
1.25
50.10
8.20
13.46
27.15
8.39
0.70
0.61
1.58
0.90
2.73
2.58
0.39
0.33
0.28
0.22
0.15
0.39
Remark
It is not safe.
It is optimal.
It is not safe.
0
0
Depends on industry.
Number of days.
Depends on industry.
Number of days.
Depends on industry.
Depends on industry.
Higher debt financing.
It's optimal.
It's satisfactory
It's acceptable.
It's risky from investment view.
Depends on industry.
Depends on industry.
Depends on industry.
Depends on industry.
It's acceptable.
It's acceptable.
Financial ratio analysis explanation
Liquidity ratios
Ratio name
Average
Ratio explanation (common business practice)
Current ratio
1.25
The best current ratio is between 1.2 to 2. A current ratio below 1.2 means that the company doesn’t have enough liquid assets to cover its short-term liabilities or a company is just able to cover all of its short-term obligations. A ratio higher than 2 may indicate that the company is not investing its assets efficiently.
Quick ratio
1.21
The ideal quick ratio is right around 1. This means a company has enough current assets to cover its existing near-term debt. A higher ratio is safer than a lower one because of the excess cash. A low quick ratio indicates that a company doesn't have adequate current assets, without inventory, to cover near-term debt.
Cash ratio
0.24
A ratio of not lower than 0.5 to 1 is usually preferred. If a ratio is > 1, it means that company is not using its capital for its best use. Although creditors prefer a high cash ratio as it indicates that the company can easily pay off its debt.
Working capital
21 487.33
An indicator should be > 0. Negative indicator means assets aren’t being used effectively, and threre may be liquidity crisis. Excessive working capital refers to the position where when the level of current assets is much higher to meet current liabilities.
Working capital ratio
1.25
Generally, a working capital ratio of less than 1 is taken as indicative of potential future liquidity problems. If a ratio is 1.5-2, it means that a company on solid financial ground in terms of liquidity. If a ratio is > 2, a company is not doing a good job of employing its assets to generate maximum possible revenue.
20152016201700.350.71.051.4
  • Current ratio
  • Quick ratio
  • Cash ratio
Assets management ratios
Ratio name
Average
Ratio explanation (common business practice)
Inventory turnover
50.10
Low turnover implies weak sales and possibly excess inventory, also known as overstocking. It may indicate a problem with the goods being offered for sale or be a result of too little marketing. A high ratio implies either strong sales or insufficient inventory, which leads to lost business.
Days inventory
8.20
Days sales of inventory is a measure of how long it takes a company to sell off inventory. Decreases in DSI means that a company is selling products much more quickly or is acquiring inventory too slowly. Increases in DSI generally suggest sales are slowing down or the company is buying too much inventory.
Receivables turnover
13.46
A high receivables turnover ratio can imply the followings: 1. a company operates on a cash basis. 2. efficient collection of accounts receivable. 3. conservative credit policy. A low ratio can suggest a few things: 1. poor collecting processes. 2. bad credit policy or none at all 3. bad customers or customers with financial difficulty.
Days Receivables
27.15
There is not an absolute number of accounts receivable days that is considered to represent excellent or poor accounts receivable management, since the figure varies considerably by industry and the underlying payment terms. An effective way to use the accounts receivable days measurement is to track it on a trend line.
Fixed assets turnover
8.39
Optimal ratio is at least 2, better when it's higher, which indicates that a company has more effectively utilized investment in FA. An increasing trend in fixed assets turnover ratio is desirable. A declining trend in fixed asset turnover may mean that the company is over investing in the property, plant and equipment.
Total assets turnover
0.70
Generally, a higher ratio is favored because there is an implication that the company is efficient in generating sales or revenues. A lower ratio illustrates that a company is not using the assets efficiently and has internal problems.
201520162017020406080
  • Inventory turnover
  • Receivables turnover
  • Fixed assets Turnover
  • Total assets turnover
Debt management ratios
Ratio name
Average
Ratio explanation (common business practice)
Debt to assets ratio
0.61
If the ratio is > 0.5, most of the assets are financed through equity. If the ratio is > 0.5, most of the assets are financed through debt. Whether or not a debt ratio is good depends on the context within which it is being analyzed. From a pure risk perspective, lower ratios (0.4 or lower) are considered better debt ratios.
Debt to equity ratio
1.58
The optimal debt to equity (D/E) ratio will tend to vary widely by industry, but the general consensus is that it should not be > 2.0. Companies with a higher debt to equity ratio are considered more risky to creditors and investors than companies with a lower ratio.
Long-term debt to equity ratio
0.90
A high ratio usually indicates a higher degree of business risk because the company must meet principal and interest on its obligations. If a ratio is < 0.5, a company is attractive from investment viewpoint, else if a ratio is 0.5-1, it's satisfactory, else if a ratio is > 1, a company is defined as risky from investment viewpoint.
Debt to EBITDA ratio
2.73
Companies in normal financial state show debt/EBITDA ratio less than 3. Ratios higher than 4 or 5 usually set off alarms causes concern for rating agencies, investors, creditors as it indicates that a company is likely to face difficulties in handling its debt burden, so there could be problems to raise additional loans.
Assets to equity ratio
2.58
The higher the ratio is, the greater the firm's debt. There is no ideal ratio to aim for, as all firms have a different tolerance for debt. A low ratio indicates that a business has been financed in a conservative manner. A high asset to equity ratio can indicate that a business can no longer access additional debt financing.
20152016201700.851.72.553.4
  • Debt to assets ratio
  • Debt to equity ratio
  • Debt to EBITDA ratio
  • Assets to equity ratio
Profitability ratios
Ratio name
Average
Ratio explanation (common business practice)
Gross profit margin
0.39
A ratio tells how good a company is at creating a product or providing a service compared to its competitors. The higher the gross profit margin percentage, the more funds are available to reinvest, save and/or pay expenses. Trend lines in gross margin are equally important, because they indicate potential problems.
EBITDA Margin
0.33
The EBITDA margin figure is helpful in comparing the profitability of different companies while factoring out the effects of decisions related to financing and accounting. Normal EBITDA margin may be in range from 10% to 50% depending on industry.
Operating profit margin
0.28
Operating Profit Margin often differs across companies and industries and is often used as a metric for benchmarking one company against similar companies within the same industry, because some industries have higher labor or materials costs than others.
Net profit margin
0.22
A ratio represents how much profit each dollar of sales generates. Companies that can expand their net margins over time are generally rewarded with share price growth. Generally, a net profit margin in excess of 10% is considered excellent, though it depends on the industry and the structure of the business.
Return on assets
0.15
The profit percentage of assets varies by industry, but in general, the higher ROA indicates more asset efficiency. For this reason it is often more effective to compare a company's ROA to that of other companies in the same industry or against its own ROA figures from previous periods. Falling ROA is almost always a problem.
Return on equity
0.39
ROE is expressed as a percentage and can be calculated for any company if net income and equity are both positive numbers. ROE is especially used for comparing the performance of companies in the same industry. ROEs of 15-20% are generally considered good.
20152016201700.10.20.30.4
  • Gross profit margin
  • EBITDA margin
  • Operating profit margin
  • Net profit margin
Analysis Summary of Apple Inc
According to vertical analysis of Statement of income: For 2016 period Gross profit accounted for 39.08 %, Results from operating activities (EBIT) - for 27.84 %, Profit before tax (EBT) - for 28.46 % and Net profit - for 21.19 % from Net revenue of the Company. For 2017 period Gross profit accounted for 38.47 %, Results from operating activities (EBIT) - for 26.76 %, Profit before tax (EBT) - for 27.96 % and Net profit - for 21.09 % from Net revenue of the Company.
Due to horizontal analysis for 2015 / 2016 period Selling, general & administrative expenses showed the maximum growth by 8.23 % and Tax expenses (provision) changed by -17.97 %, which is the minimum percent change.
According to horizontal analysis for 2015 / 2016 period Long term debt showed the maximum growth by 41.44 % and Other equity changed by -283.77 %, which is the minimum percent change. for 2016 / 2017 period Inventories showed the maximum growth by 127.72 % and Other equity changed by -123.66 %, which is the minimum percent change.
Average current ratio of the Company is 1.25 for the analyzed period, which means that the company doesn’t have enough liquid assets to cover its short-term liabilities or a company is just able to cover all of its short-term obligations.
Average debt to EBITDA ratio of the Company is optimal (< 3) which indicates that the company is not excessively indebted.
For analyzed period average gross profit margin of the Company equivalent to 39.20%, average EBITDA margin - 33.06%, average operating profit margin - 28.36%, average net profit margin - 21.71%.