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.6015.164.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:

  1. Average inventory turnover increased by 20%: Mainly due to increase in operating costs associated with sales.
  2. Total assets turnover increased by 26%: Mainly due to increase in sales driven by sales growth.
  3. Net margin decreased by 28%: Mainly due to decrease in gross margin.
  4. Cash flow reinvestment ratio increased: Mainly due to increase in net cash provided by operating activities and decrease in cash dividend.
  5. 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 adjustments12.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:

  1. Quick ratio decreased by 25%: Mainly due to increase in inventory and current liabilities.
  2. Times interest earned decreased by 20%: Mainly due to decrease in pre-tax income.
  3. 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.
  4. Total assets turnover increased by 25%: Mainly due to increase in sales driven by sales growth.
  5. Net margin decreased by 25%: Mainly due to decrease in gross margin.
  6. 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.
  7. 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)