4.1. 2012-2017Q1 Consolidated Financial Analysis – MediaTek & Subsidiaries
Item |
2012 |
2013 |
2014 |
2015 |
2016 |
2017Q1 |
||
Capital structure analysis |
Debt ratio (%) |
16.61 |
24.47 |
29.48 |
29.65 |
33.46 |
34.78 |
|
Long-term fund to property, plant and equipment ratio (%) |
1,635.89 |
1,727.71 |
1,063.17 |
718.48 |
670.37 |
714.22 |
||
Liquidity Analysis |
Current ratio (%) |
357.02 |
263.49 |
244.59 |
212.19 |
184.60 |
178.59 |
|
Quick ratio (%) |
311.52 |
245.97 |
220.40 |
186.19 |
154.91 |
148.31 |
||
Times interest earned (Times) |
151.61 |
202.25 |
110.34 |
54.87 |
49.69 |
47.93 |
||
Operating performance analysis |
Average collection turnover (Times) |
11.88 |
11.58 |
12.88 |
10.37 |
10.89 |
8.43 |
|
Days sales outstanding |
31 |
32 |
28 |
35 |
34 |
43 |
||
Average inventory turnover (Times) |
4.05 |
5.36 |
5.07 |
3.87 |
4.67 |
3.18 |
||
Average payment turnover (Times) |
6.44 |
7.63 |
8.55 |
7.87 |
8.70 |
5.33 |
||
Average inventory turnover days |
90 |
68 |
72 |
94 |
78 |
115 |
||
Property, plant and equipment turnover (Times) |
9.64 |
12.34 |
12.31 |
7.39 |
7.73 |
6.18 |
||
Total assets turnover (Times) |
0.55 |
0.58 |
0.70 |
0.61 |
0.76 |
0.59 |
||
Profitability analysis |
Return on total assets (%) |
8.73 |
11.77 |
15.35 |
7.47 |
6.79 |
7.11 |
|
Return on equity attributable to owners of the parent (%) |
10.66 |
14.82 |
20.95 |
10.42 |
9.73 |
10.59 |
||
Pre-tax income to paid-in capital (%) |
122.17 |
218.91 |
333.12 |
186.87 |
172.00 |
47.41 |
||
Net margin (%) |
15.66 |
20.20 |
21.78 |
12.08 |
8.72 |
11.84 |
||
Earnings per share (NT$) |
Before adjustments |
12.81 |
20.51 |
30.04 |
16.60 | 15.16 | 4.29 | |
After adjustments |
12.81 |
20.51 |
30.04 |
16.60 |
N/A |
N/A |
||
Cash flow |
Cash flow ratio (%) |
34.58 |
64.47 |
43.62 |
23.08 |
27.28 |
(0.91) |
|
Cash flow adequacy ratio (%) |
125.00 |
141.34 |
105.66 |
94.44 |
98.80 |
96.90 |
||
Cash flow reinvestment ratio (%) |
0.65 |
14.68 |
10.75 |
(6.21) |
8.23 |
(0.62) |
||
Leverage |
Operating leverage |
5.72 |
4.13 |
3.60 |
6.25 |
9.21 |
36.15 |
|
Financial leverage |
1.01 |
1.01 |
1.01 |
1.02 |
1.02 |
1.15 |
Changes that exceed 20% in the past two years and explanation for those changes:
- Average inventory turnover increased by 20%: Mainly due to increase in operating costs associated with sales.
- Total assets turnover increased by 26%: Mainly due to increase in sales driven by sales growth.
- Net margin decreased by 28%: Mainly due to decrease in gross margin.
- Cash flow reinvestment ratio increased: Mainly due to increase in net cash provided by operating activities and decrease in cash dividend.
- Operating leverage increased by 47%: Mainly due to increase in net sales.
4.2. 2012-2016 Financial Analysis – Parent Company
Item |
2012 |
2013 |
2014 |
2015 |
2016 |
||
Capital structure analysis |
Debt ratio (%) |
11.41 |
15.25 |
22.58 |
17.51 |
19.70 |
|
Long-term fund to property, plant and equipment ratio (%) |
2,792.41 |
3,084.74 |
2,693.91 |
2,275.69 |
1,985.04 |
||
Liquidity Analysis |
Current ratio (%) |
235.06 |
210.25 |
211.94 |
192.50 |
156.79 |
|
Quick ratio (%) |
182.63 |
190.46 |
198.88 |
174.50 |
131.51 |
||
Times interest earned (Times) |
9,414.56 |
1,393.09 |
294.80 |
96.42 |
77.05 |
||
Operating performance analysis |
Average collection turnover (Times) |
15.98 |
13.20 |
14.15 |
11.95 |
14.12 |
|
Days sales outstanding |
23 |
28 |
26 |
31 |
26 |
||
Average inventory turnover (Times) |
3.89 |
5.31 |
5.94 |
3.72 |
5.10 |
||
Average payment turnover (Times) |
6.05 |
7.89 |
9.43 |
7.46 |
10.29 |
||
Average inventory turnover days |
94 |
69 |
61.47 |
98.07 |
71.52 |
||
Property, plant, and equipment turnover (Times) |
9.93 |
15.26 |
17.57 |
10.05 |
10.58 |
||
Total assets turnover (Times) |
0.38 |
0.45 |
0.50 |
0.33 |
0.41 |
||
Profitability analysis |
Return on total assets (%) |
9.28 |
12.85 |
16.93 |
8.58 |
8.04 |
|
Return on equity attributable to shareholders of the parent (%) |
10.69 |
14.84 |
20.97 |
10.65 |
9.77 |
||
Pre-tax income to paid-in capital (%) |
120.97 |
216.40 |
318.81 |
178.49 |
156.05 |
||
Net margin (%) |
24.55 |
28.59 |
34.05 |
26.16 |
19.57 |
||
Basic earnings per share (NT$) |
Before adjustments | 12.81 |
20.51 |
30.04 |
16.60 |
15.16 |
|
After adjustments |
12.81 |
20.51 |
30.04 |
16.60 |
N/A |
||
Cash flow |
Cash flow ratio (%) |
21.33 |
92.35 |
101.08 |
19.29 |
24.28 |
|
Cash flow adequacy ratio (%) |
91.43 |
96.33 |
116.95 |
106.96 |
107.05 |
||
Cash flow reinvestment ratio (%) |
(3.39) |
9.81 |
21.41 |
(11.59) |
(1.46) |
||
Leverage |
Operating leverage |
7.65 |
3.72 |
3.00 |
5.70 |
122.95 |
|
Financial leverage |
1.00 |
1.00 |
1.01 |
1.03 |
1.89 |
Changes that exceed 20% in the past two years and explanation for those changes:
- Quick ratio decreased by 25%: Mainly due to increase in inventory and current liabilities.
- Times interest earned decreased by 20%: Mainly due to decrease in pre-tax income.
- Average inventory turnover increased by 37%, average payment turnover increased by 38% and average inventory turnover days decreased by 27%: Mainly due to increase in operating costs associated with sales.
- Total assets turnover increased by 25%: Mainly due to increase in sales driven by sales growth.
- Net margin decreased by 25%: Mainly due to decrease in gross margin.
- Cash flow ratio increased by 26% and cash flow reinvestment ratio increased by 87%: Mainly due to increased in net cash provided by operating activities and decrease in cash dividend.
- Operating leverage increased by 2055% and financial leverage increased by 84%: Mainly due to decrease in operating income.
Glossary:
1. Capital Structure Analysis:
(1). Debt ratio = Total liabilities / Total assets
(2). Long-term fund to property, plant and equipment ratio = (Shareholders’ equity + non-current liabilities) / Net property, plant and equipment
2. Liquidity Analysis:
(1). Current ratio = Current assets / Current liabilities
(2). Quick ratio = (Current assets – inventories – prepaid expenses) / Current liabilities
(3). Times interest earned = Earnings before interest and taxes / Interest expenses
3. Operating Performance Analysis:
(1). Average collection turnover = Net sales / Average trade receivables
(2). Days sales outstanding = 365 / Average collection turnover
(3). Average inventory turnover = Operating costs / Average inventory
(4). Average payment turnover = operating costs / Average trade payables
(5). Average inventory turnover days = 365 / Average inventory turnover
(6). Property, plant and equipment turnover = Net sales / Average property, plant and equipment
(7). Total assets turnover = Net sales / total assets
4. Profitability Analysis:
(1). Return on total assets = [Net income + Interest expenses x (1 – tax rate)] / Average total assets
(2). Return on equity attributable to shareholders of the parent = Net income attributable to shareholders of the parent / Average equity attributable to shareholders of the parent
(3). Net margin = Net income / Net sales
(4). Earnings per share = (Net income attributable to shareholders of the parent – preferred stock dividend) / Weighted average number of shares outstanding
5. Cash Flow:
(1). Cash flow ratio = Net cash provided by operating activities / Current Liabilities
(2). Cash flow adequacy ratio = Five-year sum of cash from operations / Five-year sum of capital expenditures, inventory additions, and cash dividend
(3). Cash flow reinvestment ratio = (Cash provided by operating activities – cash dividends) / (Gross property, plant and equipment + long-term investments + other noncurrent assets + working capital)
6. Leverage:
(1). Operating leverage = (Net sales – variable cost) / Operating income
(2). Financial leverage = Operating income / (Operating income – interest expenses)