MAXIS and DIGI Company Ratio Analysis

MAXIS and DIGI company ratio analysis
The analysis is based on the data calculated in the table bellows:
MAXIS company ratio data
YEAR 2014 2015 2016 2017 2018
LIQUIDITY
Operating Cycle
= Day sales in inventory + Days sales
in receivables
43.9037 53.4589 67.8662 61.8162 83.5874
Net Operating Cycle
= Operating Cycle - Days in payables 1.6774 1.7726 0.7969 0.5263 1.9304
Working Capital
= Current assets - currents liabilities
-
1,605,119
-
2,075,138
-
2,538,728
-
1,690,609
-
1,874,356
Currents ratio
= current assets / current liabilities 0.6163 0.5759 0.4919 0.5701 0.5873
Quick (acid-test) ratio
= (currents assets - inventories) /
currents liabilities
0.6133 0.5732 0.4907 0.5690 0.5838
Cash ratio
= cash, cash equivalents and
marketable securities / currents
liabilities
0.3659 0.2649 0.1366 0.1531 0.1234
Operating cash flow to short term
debt ratio = operating cash flow /
short term debt
4.6679 3.7823 2.8150 18.6152 16.5571
ASSETS MANAGEMENT
Accounts receivable turnover
= sales / accounts receivables 8.6439 7.0618 5.4421 5.9553 4.4699
Days sales in receivables
= accounts receivables * 365 days /
sales
42.2263 51.6863 67.0693 61.2898 81.6570
Inventory turnover
= cost of goods sold / inventory 217.6017 205.9142 458.0451 693.4813 189.0822
Days sales in inventory
= 365 days / inventory turnover 1.6774 1.7726 0.7969 0.5263 1.9304
Total assets turnover
= sales / total assets (fixed assets) 0.4632 0.4530 0.4384 0.4893 0.4641
PROFITABILITY
Gross profit margin
= gross profit / sales 67.73% 68.28% 68.40% 66.91% 67.26%
Operating profit margin 33.56% 33.40% 36.60% 40.14% 46.73%

= operating profit before tax / sales
Net profit margin
= net income / sales 20.56% 20.31% 23.37% 23.27% 19.36%
Return on total assets
= net income / total assets 9.52% 9.20% 10.25% 11.39% 8.99%
Return on common equity
= net income / common equity 36.41% 41.40% 42.63% 31.12% 24.89%
Dupont ROA
= net profit margin * total assets
turnover
9.52% 9.20% 10.25% 11.39% 8.99%
DuPont ROE
= ROA * Financial leverage multiplier 36.41% 41.40% 42.63% 31.12% 24.89%
Financial leverage multiplier (FLM)
= total assets / common equity 3.8224 4.4983 4.1609 2.7335 2.7703
DEBT RATIOS
Total debt ratio
= total liabilities / total assets 73.84% 77.77% 75.97% 63.42% 63.90%
Debit/equity ratio
= total long-term debt / total
shareholders’ equity
193.94% 233.88% 210.25% 117.51% 113.50%
Times interest earned
= EBIT / interest expense 10.8534 13.4359 17.0196 7.5540 7.1996
Cash coverage ratio
= EBIT + Depreciation expense /
interest expense
15.5288 19.2670 23.3983 9.8662 9.9941
MARKET
Earnings per share (basic)
= net income/weighted average share
outstanding 22.88 23.16 26.81 28.5 22.8
Dividend payout ratio
= dividend per common share / EPS 1.0000 1.0000 1.0000 1.0039 1.0000
DIGI company ratio data
YEAR 2014 2015 2016 2017 2018

LIQUIDITY
Operating Cycle
= Day sales in inventory + Days
sales in receivables
49.3532 69.6278 142.0043 84.3091 96.1453
Net Operating Cycle
= Operating Cycle - Days in
payables
11.2220 20.9580 8.3149 14.2511 14.4616
Working Capital
= Current assets - currents
liabilities
-
1,663,778
-
2,336,852
-
679,288
-
395,993
-
605,396
Currents ratio
= current assets / current
liabilities
0.4603 0.3780 0.7598 0.8265 0.7754
Quick (asid-test) ratio
= (currents assets - inventories) /
currents liabilities
0.4394 0.3470 0.7429 0.8005 0.7527
Cash ratio
= cash, cash equivalents and
marketables securities / currents
liabilities
0.1707 0.0622 0.1331 0.2520 0.1607
Operating cash flow to short
term debt ratio
= operating cash flow / short term
debt
0.8755 0.5922 0.5417 1.1292 0.8074
ASSETS MANAGEMENT
Accounts receivable turnover
= sales / accounts receivables 9.5722 7.4995 2.7302 5.2100 4.4685
Days sales in receivables
= accounts receivables * 365
days / sales
38.1312 48.6698 133.6895 70.0580 81.6837
Inventory turnover
= cost of goods sold / inventory 32.5254 17.4158 43.8972 25.6120 25.2393
Days sales in inventory
= 365 days / inventory turnover
11.2220061
1
20.957969
8
8.314876
8 14.2511 14.4616
Total assets turnover
= sales / total assets (fixed assets) 1.6309 1.4829 0.8480 1.0869 1.0517
PROFITABILITY
Gross profit margin
= gross profit / sales 70.09% 70.58% 64.81% 76.11% 76.36%
Operating profit margin
= operating profit before tax /
sales
61.51% 61.08% 50.54% 65.61% 67.37%
Net profit margin
= net income / sales 28.94% 24.91% 35.02% 23.29% 23.61%
Return on total assets 47.20% 36.95% 29.70% 25.31% 24.83%

= net income / total assets
Return on common equity
= net income / common equity 296.02% 331.67% 314.41% 219.36% 228.88%
Dupont ROA
= net profit margin * total assets
turnover
47.20% 36.95% 29.70% 25.31% 24.83%
DuPont ROE
= ROA * Financial leverage
multiplier
296.02% 331.67% 314.41% 219.36% 228.88%
Financial leverage multiplier
(FLM)
= total assets / common equity
6.2719 8.9770 10.5879 8.6657 9.2189
DEBT RATIOS
Total debt ratio
= total liabilities / total assets 84.06% 88.86% 90.56% 91.11% 89.15%
Debit/equity ratio
= total long-term debt / total
shareholders’ equity
77.87% 74.26% 414.07% 57.29% 79.37%
Times interest earned
= EBIT / interest expense 73.7738 41.9410 27.1464 17.9101 16.0174
Cash coverage ratio
= EBIT + Depreciation expense /
interest expense
84.1173 51.0243 28.5179 18.9101 20.7644
MARKET
Earnings per share (basic)
= net income - preferred
dividend / number of common
shares outstanding
13.82 12.19 20.88 23.92 27.08
Dividend payout ratio
= divident per common share /
EPS 1.8886 1.8212 1.0057 0.7943 0.7312