1. Calculate and explain activity ratios for
the year 2017, 2016, 2015
Type of Ratios
|
Ratios
|
Measures
|
Values
|
Ratios
|
|
|
|
2017
|
2016
|
2015
|
2017
|
2016
|
2015
|
Activity Ratios
|
Receivable turnover
|
Net Sales
|
13936
|
14699
|
13795
|
13.37
|
10.48
|
7.83
|
|
|
Accounts Receivables
|
1042
|
1402
|
1762
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Inventory Turnover
|
Cost of Goods Sold
|
8352
|
8865
|
8511
|
2.68
|
2.80
|
3.00
|
|
|
Inventory
|
3122
|
3169
|
2836
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Payable Turnover
|
Cost of Goods Sold
|
8352
|
8865
|
8511
|
5.24
|
2.76
|
1.77
|
|
|
Accounts Payable
|
1593
|
3207
|
4821
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Asset Turnover
|
Net Sales
|
13936
|
14699
|
13795
|
0.44
|
0.51
|
0.50
|
|
|
Total Assets
|
31896
|
29023
|
27371
|
|
|
|
|
|
|
|
|
|
|
|
|
It
can be seen that there are four activity ratios and these are receivables
turnover, payables turnover, Inventory turnover and Asset turnover.
2. Calculate and explain liquidity ratios for
the year 2017, 2016, 2015
Type of Ratios
|
Ratios
|
Measures
|
Values
|
Ratios
|
|
|
|
2017
|
2016
|
2015
|
2017
|
2016
|
2015
|
Liquidity Ratios
|
Current ratio
|
Current Assets
|
6813
|
5305
|
6155
|
1.18
|
1.11
|
1.28
|
|
|
Current Liabilities
|
5771
|
4793
|
4807
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Quick Ratio
|
Current Assets
|
6813
|
5305
|
6155
|
0.64
|
0.45
|
0.69
|
|
|
Inventory
|
3122
|
3169
|
2836
|
|
|
|
|
|
Current Liabilities
|
5771
|
4793
|
4807
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Ratio
|
Cash and equivalent
|
1892
|
730
|
2039
|
0.33
|
0.15
|
0.42
|
|
|
Current Liabilities
|
5771
|
4793
|
4807
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Working Capital
|
Current Assets
|
6813
|
5305
|
6155
|
1042.00
|
512.00
|
1348.00
|
|
|
Current Liabilities
|
5771
|
4793
|
4807
|
|
|
|
It
can be seen that there are four liquidity ratios discussed here, including the
current ratio, quick ratio, cash ratio and net working capital.
3. Calculate and explain profitability ratios
for the year 2017, 2016, 2015
Type of Ratios
|
Ratios
|
Measures
|
Values
|
Ratios
|
|
|
|
2017
|
2016
|
2015
|
2017
|
2016
|
2015
|
Profitability Ratios
|
Gross Profit Margin
|
Gross Profit
|
5584
|
5834
|
5284
|
40.07%
|
39.69%
|
38.30%
|
|
|
Net Sales
|
13936
|
14699
|
13795
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Profit Margin
|
Net Income
|
2182
|
2080
|
1916
|
15.66%
|
14.15%
|
13.89%
|
|
|
Net Sales
|
13936
|
14699
|
13795
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return on Assets
|
Net Income
|
13936
|
14699
|
13795
|
43.69%
|
50.65%
|
50.40%
|
|
|
Total Assets
|
31896
|
29023
|
27371
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return on equity
|
Net Income
|
13936
|
14699
|
13795
|
96.22%
|
112.76%
|
114.41%
|
|
|
Total Equity
|
14484
|
13036
|
12058
|
|
|
|
|
|
|
|
|
|
|
|
|
There
are four profitability ratios discussed and these include the gross profit
margin. Ney margin, return on assets and return on equity.
4. Calculate and explain Debt ratios for the
year 2017, 2016, 2015
Type of Ratios
|
Ratios
|
Measures
|
Values
|
Ratios
|
|
|
|
2017
|
2016
|
2015
|
2017
|
2016
|
2015
|
Debt Ratios
|
Debt Ratio
|
Total Liabilities
|
17412
|
15987
|
15313
|
0.55
|
0.55
|
0.56
|
|
|
Total Assets
|
31896
|
29023
|
27371
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Debt to Equity Ratio
|
Total Liabilities
|
17412
|
15987
|
15313
|
1.20
|
1.23
|
1.27
|
|
|
Total Equity
|
14484
|
13036
|
12058
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Times Interest Earned Ratios
|
Net Income
|
13936
|
14699
|
13795
|
34.67
|
41.88
|
45.98
|
|
|
Interest Expense
|
402
|
351
|
300
|
|
|
|
There
are three ratios in debt ratios that are discussed here and there include Debt
ratio, Debt to equity ratio, and times interest earned ratio.
5. All the ratios calculated must be graphed
so that a trend is created and the decision in (part 6) is justified
The graphs of each set of ratios is given
below
Activity ratios
It can be seen that inventory turnover is
almost constant, payables turnover is increasing. Asset turnover is constant
too and the receivable turnover is also increasing.
Liquidity ratios
It can be seen that the current ratio and
quick ratio are almost consistent and the net working capital along with the
cash ratio are both volatile, lowest in 2016, and high in 2017 and 2015.
Profitability ratios
It can be seen that the Gross margin, net margin
and ROE are all constant, with a small percentage decline, whereas return of
assets is seeing a constant decline.
Debt Ratios
It can be seen that there is a decline in
times interest earned and the debt ratio along with the debt to equity ratio are
almost constant.
6. In a couple of paragraphs, advice a friend
on whether or not this company represents a good investment opportunity. Your
answer must go in-line with the above ratios you have calculated.
From the ratios of the three years, it can be
concluded that the company is observing a decline and this decline indicates
that the investment in the company should not be made, as instead of growing
the company is shrinking.
Appendix: