Main menu

 

Finansial analysis report generated by Finstanon.com

 

Analysis of RetailTrade's financial statements for the period from quarter I to quarter IV

This report analyzes the balance sheets and income statements of RetailTrade. Trends for the major balance sheet and income statement items and ratio analysis are used to understand the financial position and financial effectiveness of the company. The report studied the quarter I - quarter IV period.

1. The Common-Size Analysis of the Assets, Liabilities and Shareholders' Equity

Table 1. Assets Trend Analysis, in million USD

Indicators quarter I quarter II quarter III quarter IV Absolute change (quarter IV / quarter I) Percentage change (quarter IV / quarter I)
Cash, cash equivalents 6718 9135 7759 5751 -967 -14.39
Receivables, net, current 6091 6778 5813 5275 -816 -13.4
Inventory, net 51501 45141 46310 45007 -6494 -12.61
Prepaid expense, current 1531 1496 2251 0 -1531 -100
Deferred tax assets, net, current 0 728 0 0 0 division by 0
CURRENT ASSETS (TOTAL) 65841 63278 62133 58132 -7709 -11.71
Property, plant and equipment, net 117492 116655 115685 116511 -981 -0.83
Long-term investments, net 500 512 514 508 8 1.6
Goodwill 18888 18102 17531 17799 -1089 -5.77
Intangible assets, net (excluding goodwill) 0 419 0 0 0 division by 0
Deferred tax assets, net, noncurrent 0 1033 0 0 0 division by 0
Other assets, noncurrent 5168 3707 4884 5670 502 9.71
NONCURRENT ASSETS (TOTAL) 142048 140428 138614 140488 -1560 -1.1
ASSETS (TOTAL) 207889 203706 200747 198620 -9269 -4.46

It can be noticed from Table 1 that there was a tendency to decrease in the total value of the assets. The percentage change was equal 4.46% in quarter IV. The value of the assets totalled USD 198,620 million at the end of quarter IV.

The overall decrease of the assets reflects both a reduction in the noncurrent assets by 1.1% and a reduction in the current assets by 11.71%.


Noncurrent and Current Assets analysis

The change of the noncurrent assets value in quarter I-quarter IV was connected with a negative change of the following assets:

- Property, plant and equipment (-0.83%)

- Goodwill (-5.77%)

The change of the current assets value in quarter I-quarter IV was connected with a negative change of the following assets:

- Cash, cash equivalents (-14.39%)

- Receivables (-13.4%)

- Inventory (-12.61%)

- Prepaid expense (-100%)

Table 2. Sources of Finance (Equity and Liabilities) Trend Analysis, in million USD

Indicators quarter I quarter II quarter III quarter IV Absolute change (quarter IV / quarter I) Percentage change (quarter IV / quarter I)
Accounts payable, current 39656 38410 37224 37225 -2431 -6.13
Accrued liabilities, current 18772 19152 18684 18290 -482 -2.57
Debt, current 6019 1592 799 1725 -4294 -71.34
Other liabilities, current 7113 6118 12917 8022 909 12.78
CURRENT LIABILITIES 71560 65272 69624 65262 -6298 -8.8
Long-term debt and capital lease obligations 41867 41696 39328 39217 -2650 -6.33
Long-term tax liability 7642 4671 7708 7755 113 1.48
Other liabilities, noncurrent 2767 6130 4097 4262 1495 54.03
NONCURRENT LIABILITIES 52276 52497 51133 51234 -1042 -1.99
LIABILITIES (TOTAL) 123836 117769 120757 116496 -7340 -5.93
Common stock 323 323 323 321 -2 -0.62
Additional paid-in capital 2223 2462 2354 1979 -244 -10.98
Retained earnings 80814 85777 82492 84959 4145 5.13
Other equity accounts 693 -2625 -5179 -5135 -5828 -840.98
EQUITY (TOTAL) 84053 85937 79990 82124 -1929 -2.29
LIABILITIES AND EQUITY (TOTAL) 207889 203706 200747 198620 -9269 -4.46

Similar to the value of total assets, the liabilities and equity value amounted to USD 198,620 million in quarter IV, 4.46% less than in quarter I.

There was a decline in the stockholders' equity value in quarter I-quarter IV, which indicates that the company's assets would worth less after all claims upon those assets were paid. This means that RetailTrade was degrading.

The change of the stockholders' equity value in quarter I-quarter IV was related to the decline of the following sources:

- Common stock (-0.62%)

- Additional paid-in capital (-10.98%)

- Other Equity Accounts (-840.98%)


Equity and Liabilities Analysis

The change of the liabilities value in quarter I-quarter IV was related to the decline of the following sources:

- Current accounts payable (-6.13%)

- Current accrued liabilities (-2.57%)

- Current debt (-71.34%)

- Long-term debt and capital lease obligations (-6.33%)

 

Table 3. Assets Structure Analysis, %

Indicators quarter I quarter II quarter III quarter IV Absolute change (quarter IV / quarter I)
Cash, cash equivalents 3.23 4.48 3.87 2.9 -0.34
Receivables, net, current 2.93 3.33 2.9 2.66 -0.27
Inventory, net 24.77 22.16 23.07 22.66 -2.11
Prepaid expense, current 0.74 0.73 1.12 0 -0.74
Deferred tax assets, net, current 0 0.36 0 0 0
CURRENT ASSETS (TOTAL) 31.67 31.06 30.95 29.27 -2.4
Property, plant and equipment, net 56.52 57.27 57.63 58.66 2.14
Long-term investments, net 0.24 0.25 0.26 0.26 0.02
Goodwill 9.09 8.89 8.73 8.96 -0.12
Intangible assets, net (excluding goodwill) 0 0.21 0 0 0
Deferred tax assets, net, noncurrent 0 0.51 0 0 0
Other assets, noncurrent 2.49 1.82 2.43 2.85 0.37
NONCURRENT ASSETS (TOTAL) 68.33 68.94 69.05 70.73 2.4
ASSETS (TOTAL) 100 100 100 100 0

At the end of quarter I the assets consisted of 68.33% noncurrent assets and 31.67% current assets. The most significant items of the current assets were cash, cash equivalents (3.23% of total assets), inventory (24.77% of total assets), etc. The following noncurrent assets had the highest values: property, plant and equipment (56.52% of total assets), goodwill (9.09% of total assets), while the other items did not play a significant role.


The Assets Structure Analysis

Over the period under review the assets structure changed. At the end of quarter IV the assets consisted of 70.73% noncurrent assets and 29.27% current assets. Total current assets composed mostly of: inventory (22.66% of total assets), etc. The most significant items of the noncurrent assets were property, plant and equipment (58.66% of total assets), goodwill (8.96% of total assets), etc.

Table 4. Equity and Liabilities Structure Analysis, %

Indicators quarter I quarter II quarter III quarter IV Absolute change (quarter IV / quarter I)
Accounts payable, current 19.08 18.86 18.54 18.74 -0.33
Accrued liabilities, current 9.03 9.4 9.31 9.21 0.18
Debt, current 2.9 0.78 0.4 0.87 -2.03
Other liabilities, current 3.42 3 6.43 4.04 0.62
CURRENT LIABILITIES 34.42 32.04 34.68 32.86 -1.56
Long-term debt and capital lease obligations 20.14 20.47 19.59 19.74 -0.39
Long-term tax liability 3.68 2.29 3.84 3.9 0.23
Other liabilities, noncurrent 1.33 3.01 2.04 2.15 0.81
NONCURRENT LIABILITIES 25.15 25.77 25.47 25.79 0.65
LIABILITIES (TOTAL) 59.57 57.81 60.15 58.65 -0.92
Common stock 0.16 0.16 0.16 0.16 0.01
Additional paid-in capital 1.07 1.21 1.17 1 -0.07
Retained earnings 38.87 42.11 41.09 42.77 3.9
Other equity accounts 0.33 -1.29 -2.58 -2.59 -2.92
EQUITY (TOTAL) 40.43 42.19 39.85 41.35 0.92
LIABILITIES AND EQUITY (TOTAL) 100 100 100 100 0

By looking at Table 4 it can be noticed that the sources of finance consisted of 40.43% shareholders' equity, 25.15% noncurrent liabilities and 34.42% current liabilities. The average share of the equity in quarter I means the financial risk level was acceptable. The total equity consisted mostly of retained earnings (USD 80,814 million), etc. The company's liabilities included current accounts payable (19.08% of the total sources of finance), current accrued liabilities (9.03% of the total sources of finance), other current liabilities (3.42% of the total sources of finance), long-term debt and capital lease obligations (20.14% of the total sources of finance), long-term tax liability (3.68% of the total sources of finance), etc.


The Equity and Liabilities Structure Analysis

At the end of quarter IV the sources of finance comprised 41.35% shareholders' equity, 25.79% noncurrent liabilities and 32.86% current liabilities. This shows that the share of the equity was in the area of critical values, meaning that the financial risk level was average. The most significant items of the equity were following: retained earnings (USD 84,959 million), etc. The following liabilities had the highest values: current accounts payable (18.74% of the total sources of finance), current accrued liabilities (9.21% of the total sources of finance), other current liabilities (4.04% of the total sources of finance), long-term debt and capital lease obligations (19.74% of the total sources of finance), long-term tax liability (3.9% of the total sources of finance), etc.

2. Financial Sustainability and Long-Term Debt-Paying Ability

Table 5. Key ratios of the company's financial sustainability

Indicators quarter I quarter II quarter III quarter IV Absolute change (quarter IV / quarter I)
Times Interest Earned 7.3 10.82 4.76 8.75 1.45
Debt Ratio 0.6 0.58 0.6 0.59 -0.01
Long-Term Debt Ratio 0.25 0.26 0.25 0.26 0.01
The Long-Term Debt to Total Capitalization Ratio 0.99 0.99 0.99 0.99 -0
Debt/Equity Ratio 1.47 1.37 1.51 1.42 -0.05
Debt to Tangible Net Worth Ratio 1.9 1.75 1.93 1.81 -0.09
Long-Term Debt to Equity 161.85 162.53 158.31 159.61 -2.24

The times interest earned ratio indicates that RetailTrade had no difficulty generating enough cash flow to pay interest on its debt at the end of quarter IV. Company's ability to pay interest on debt was better in quarter IV comparing to quarter I.

The debt ratio tells us that in quarter I each USD 1.00 of the assets was financed by USD 0.6 of debt (and USD 0.4 of equity). In quarter II 57.81% of the sources of finance were liabilities. For every USD 1.00 of the assets there were USD 0.6 of liabilities at the end of quarter III. The debt ratio lies in the area of critical values (from 0.4 to 0.6) at the end of the period, meaning that there was an acceptable financial and credit risk. An increase in the long-term debt ratio suggests that the company was progressively becoming more dependent on debt to grow a business. 26% of the sources of finance were a long-term debt at the end of quarter IV.

The value of the long-term debt to total capitalization ratio was 0.99 at the end of quarter I, 0.99 in quarter II, 0.99 in quarter III and 0.99 in quarter IV. Total capitalization consists of the long-term debt, preferred stock, and common stockholders' equity. Lower ratio shows lower risk.

The debt/equity ratio is another computation that determines the entity's long-term debt-paying ability. At the end of quarter IV this ratio was 142%, meaning that creditors were protected in case of insolvency.

The debt to tangible net worth ratio is a more conservative ratio than the debt/equity ratio. It eliminates intangible assets because they do not provide resources to pay creditors. The table 5 shows that the ratio changed from 1.9 in quarter I to 1.81 in quarter IV. This shows that the creditors' protection was getting better.

The value of the long-term debt to equity ratio was 161.85 at the end of quarter I, 162.53 in quarter II, 158.31 in quarter III and 159.61 in quarter IV.

 

3. Liquidity of Short-Term Assets

Table 6. Liquidity Ratios

Indicators quarter I quarter II quarter III quarter IV Absolute change (quarter IV / quarter I)
Current Ratio 0.92 0.97 0.89 0.89 -0.03
Quick Ratio (Acid Test Ratio) 0.18 0.24 0.19 0.17 -0.01
Cash Ratio 0.09 0.14 0.11 0.09 -0.01
Net Working Capital -5719 -1994 -7491 -7130 -1411
Sales to Net Working Capital - -34.12 -24.21 -16.45 17.67

The current ratio was 0.92 in quarter I, meaning that RetailTrade had 0.92 times as many current assets as current liabilities. The value of the ratio lies below the area of critical values. The current ratio was 0.97 at the end of quarter II and 0.89 at the end of quarter III. The value of the ratio was unacceptable at the end of the period under review. This means that RetailTrade had problems with paying its suppliers and creditors in due time.

The quick ratio for quarter I was 0.18, showing there were USD 0.18 of the quick assets for every USD 1.00 of the current liabilities. The ratio for period quarter IV from Table 6 shows USD 0.19 of the quick assets were available for every USD 1.00 of the current liabilities. The decrease in the quick ratio from quarter I to quarter IV indicates that the company has been losing its ability to pay its short-term debt.

The company's quick liquidity was unsatisfactory at the end of the period.

The cash ratio shows that the company was able to pay off 8.81% of its debt immediately as for the end of quarter IV. It indicates an immediate problem with paying bills.

Table 6 presents the working capital for RetailTrade at the end of quarter I-quarter IV. RetailTrade had USD -5,719 million in the working capital in quarter I, USD -1,994 million in the working capital in quarter II and USD -7,491 million in the working capital in quarter III. Overall, the value of the working capital had dropped over quarter I-quarter IV.

The working capital value was negative at the end of the period under review, meaning low flexibility, since noncurrent assets may not be modified easily as the sales volume changes.

The sales to working capital ratio increased from quarter II to quarter IV. This indicates a more profitable use of the working capital in quarter IV in relation to quarter II.

4. Overview of the Financial Results

Table 7. Financial Results Trend Analysis, in million USD

Indicators quarter I quarter II quarter III quarter IV Absolute change (quarter IV / quarter I) Percentage change (quarter IV / quarter I)
Net sales (Revenues) 119001 131565 114826 120229 1228 1.03
Cost of goods sold (Cost of sales) 89247 99115 86483 90056 809 0.91
Gross profit 29754 32450 28343 30173 419 1.41
Other income and expenses from continuing operations, except interest and debt expense and income tax expense -23469 -24464 -22644 -24080 -611 2.6
EBIT 6285 7986 5699 6093 -192 -3.05
Interest and debt expense 676 623 843 567 -109 -16.12
Income tax expense (benefit) 1783 2175 1573 1891 108 6.06
Income (loss) from continuing operations 3826 5188 3283 3635 -191 -4.99
Comprehensive income (loss) 3711 4966 3341 3475 -236 -6.36

The comparative income statement given above shows there has been an increase in the net sales of 1.03% over the reported period. At the end of quarter IV the cost of goods and services totaled USD 90,056 million. This has resulted in an increase in the gross profit by 1.41%. EBIT was positive at USD 6,093 million in quarter IV. The EBIT decline was 3% during quarter I-quarter IV. On the whole, quarter IV was a good period as the company recorded USD 3,475 million comprehensive income.


The Financial Results Analysis
The chart above shows that the gross profit to net sales ratio increased in quarter IV by 0.09% comparing to quarter I. This growth of the gross profit to net sales ratio over the period of quarter I-quarter IV indicates that the company was either becoming more efficient with the manufacturing or distribution process by decreasing the cost of production of the goods, or finding ways to make the goods generate more revenue (increasing the price, promo-activities, etc.). Quarter IV also witnessed the decrease of the company's EBIT to sales ratio comparing to quarter I. The dynamics of the EBIT to sales ratio over the period of quarter I-quarter IV demonstrate the company's declining earning ability and its cost management became worse. The share of the comprehensive income in the company's net sales decreased in quarter IV by 0.23% comparing to quarter I. This should notify the company's management about the negative trend of its profitability indicators.

 

5. Profitability Ratios

Table 8. Profitability Ratios, %

Indicators quarter I quarter II quarter III quarter IV Absolute change
Net Profit Margin 3.22 3.94 2.86 3.02 -0.19
Operating Income Margin 5.26 6.04 4.95 5.05 -0.22
Gross Profit Margin 25 24.66 24.68 25.1 0.09
Return on Assets - 2.52 1.62 1.82 -0.7
Return on Operating Assets - 4.37 3.17 3.43 -0.94
Return on Investment - 4.23 3.06 3.18 -1.05
Return on Equity after Tax - 6.1 3.96 4.48 -1.62

By looking at Table 8. 'Profitability Ratios' it can be seen that the net profit margin was positive in quarter I-quarter IV. At the end of quarter IV the net profit margin was 3.02%, showing USD 0.03 of the net profit per USD 1.00 of sales.

The RetailTrade's operating performance was robust in quarter IV. For every dollar of the net sales the company earned USD 0.05 in the operating income.

Gross profit margin shows that the company earned USD 0.25 of the gross profit per dollar of sales in quarter IV. Sales increased much more than the cost of goods sold, resulting in a higher gross margin in quarter IV comparing to quarter I.

For RetailTrade the ROA shows that the company was earning a profit of about 1.82 cents per dollar of the asset value in quarter IV.

The operating assets were yielding a 3.43% return in quarter IV. This ratio was 0.94% lower at the end of quarter IV.

Higher ROIs suggest better performance. Overall, ROI declined from 4.23% in quarter II to 3.18% in quarter IV.

The ROE represents the increase in the value of the stockholders' wealth.

Table 9. Dupont Analysis

Indicators quarter II quarter III quarter IV Absolute change (quarter IV / quarter II)
Return on Assets 2.52 1.62 1.82 -0.7
Net Profit Margin 3.94 2.86 3.02 -0.92
Total Asset Turnover 0.64 0.57 0.6 -0.04

Company's return on assets decreased from 2.52% in quarter II to 1.82% in quarter IV. The explanation for this trend can be found, as both net profit margin and total asset turnover declined in quarter IV comparing to quarter II. Net profit margin decreased from 3.94 in quarter II to 3.02 in quarter IV, indicating the amount of the net profit generated by 1 dollar of sales became smaller. Total asset turnover declined from 0.64 in quarter II to 0.6 in quarter IV, meaning the company has been deteriorating the efficiency of managing its assets, turning them over less frequently.

6. Activity Ratios (Turnover Ratios)

Table 10. Activity Ratios (Turnover Ratios)

Indicators quarter II quarter III quarter IV Absolute change (quarter IV / quarter II)
Asset Turnover 0.64 0.57 0.6 -0.04
Sales to Fixed Assets 1.12 0.99 1.04 -0.09
Current Asset Turnover 2.04 1.83 2 -0.04
Working Capital Turnover -34.12 -24.21 -16.45 17.67
Accounts Receivable Turnover (Times) 20.45 18.24 21.69 1.24
Average Collection Period (Accounts Receivable Turnover in Days) 17.61 19.74 16.6 -1.01
Accounts Payable Turnover (Times) 2.54 2.29 2.42 -0.12
Days Payable Outstanding 141.77 157.42 148.81 7.03
Inventory Turnover (Times) 2.05 1.89 1.97 -0.08
Inventory Turnover in Days 175.51 190.34 182.52 7.01
Cash Turnover 16.6 13.59 17.8 1.2
Operating Cycle 193.12 210.08 199.12 6.01
Cash Conversion Cycle 51.34 52.66 50.32 -1.03

By looking at Table 10 it can be seen that the company produced USD 0.6 of products and services for every dollar of the assets used at the end of the period.

The fixed assets turned over 1.12 times in quarter II and 0.99 times in quarter IV. At the end of quarter IV fixed assets turned over 1.04 times. Within the period under review, on average, the current assets were turned over at least 1 times. The improvement in the current asset turnover ratio during the quarter II-quarter IV was due to an increase in the net turnover figure and a decrease in the current assets.

It can be seen that the working capital turnover was -34.12 in quarter II, -24.21 in quarter III and -16.45 in quarter IV. The quarter II accounts receivable turnover of 20.45 indicates RetailTrade collected its average receivables 20.45 times that period. The higher the turnover is, the faster the collection process. Each dollar invested in the accounts receivable generated USD 21.69 in sales in quarter IV. As a result, the average collection period grew up from 17.61 days to 21.69 days. This means that it took an average of 21.69 days to collect a receivable in quarter IV. The accounts payable turned over 2.54 times in quarter II and 2.42 times in quarter IV. The turnover of the accounts payable was raised from 141.77 days to 148.81 days. By comparing the turnover data of the accounts receivable and accounts payable during quarter IV it can be seen the accounts receivable were turned over slower than the accounts payable.

RetailTrade's inventory was less active in quarter IV than in quarter II. The company was holding the inventory almost a 7.01 day(s) longer in quarter IV than in quarter II. The cash turnover ratio was 16.6 in quarter II and 17.8 in quarter IV.

It took the company 193.12 days from a moment of buying inventories until getting cash for selling goods and services in quarter II. The operating cycle was 199.12 in quarter IV. Longer operating cycle indicates worse performance. The cash conversion cycle shows how long it takes for a company to convert the resource inputs into cash flows. According to the data it can be seen that the cash conversion cycle was 51.34 days long in quarter II and 50.32 days long in quarter IV.

 

OTHER INDICATORS

7. Investor Analysis

Table 11. Investor Analysis

Indicators quarter I quarter II quarter III quarter IV Absolute change (quarter IV / quarter I)

Net assets (Net worth), in million USD

84053 85937 79990 82124 -1929

Degree of Financial Leverage

1.12 1.08 1.17 1.1 -0.02

The net value of the enterprise's assets was USD 82,124 million at the end of quarter IV, about USD 2,134 million more than declared at the end of quarter III. Overall, the net worth dropped from USD 84,053 million to USD 82,124 million. This means that RetailTrade is degrading.

If earnings before interest increase, the financial leverage will be favorable. The degree of financial leverage was 1.1 in quarter IV. This means that any change in the EBIT will be accompanied by 1.1 times that change in the net income. This is a low degree of financial leverage.

 

8. Forecasting Financial Failure (Bankruptcy Test) (Financial Distress Prediction)

Table 12. The Z-Score Model for Private Firms

Indicators

quarter I quarter II quarter III quarter IV

X1 (Working Capital/Total Assets)

-0.03 -0.01 -0.04 -0.04

X2 (Retained Earnings /Total Assets)

0.39 0.42 0.41 0.43

X3 (Earnings Before Interest and Taxes/Total Assets)

0.03 0.04 0.03 0.03

X4 (Market Value of Equity/Book Value of Total Debt)

0.68 0.73 0.66 0.7

X5 (Sales/Total Assets)

0.57 0.65 0.57 0.61

Z =

1.26 1.42 1.26 1.33

RetailTrade was in the gray area between 1.20 and 2.90 in quarter I. The Altman Z-score for quarter II shows an average bankruptcy risk. At the end of quarter IV the Altman Z-score was 1.33 (within the gray area). The increase of the company's Z-Score value over the period of quarter I-quarter IV showed that RetailTrade has been improving its financial condition and declining the risk of bankruptcy. It also witnessed that the company did not perform well enough to move its Z-Score value to the safe area, and so it stayed within the gray area in quarter IV.

9. Labor productivity


The Labor Productivity Analysis

The labor productivity in RetailTrade improved from quarter I to quarter IV by 9.75%.

10. Financial Rating

A rating helps to sum up the current financial position and future expectations with one word.

Table 13. Financial Rating

Indicators Weighting factor Score (Period 3) Score (Period 4) Average score Weighted average score
1 2 3 4 5=0,35*3+0,65*4 6=5*2
Net Profit Margin 0,15 0.5 0.5 0.5 0.075
Return on Assets 0,15 -0.5 -0.5 -0.5 -0.075
Debt/Equity Ratio 0,15 -1 -1 -1 -0.15
Current Ratio 0,1 -0.5 -0.5 -0.5 -0.05
Net Sales Change 0,1 -1 0 -0.35 -0.035
Operating Income Margin 0,1 -0.5 0 -0.175 -0.0175
Equity Change 0,1 -1 0 -0.35 -0.035
Quick Ratio 0,05 -1 -1 -1 -0.05
Debt Ratio 0,05 0 0.5 0.325 0.01625
Times Interest Earned 0,05 1 1 1 0.05
Total Score 1 - - - -0.27125

Table 14. Financial condition scale


Score from (inclusive)

to
Sign Current financial condition
1 0,8 AAA Excellent
0,8 0,6 AA Very good
0,6 0,4 A Good
0,4 0,2 BBB Positive
0,2 0 BB Normal
0 -0,2 B Satisfactory
-0,2 -0,4 CCC Unsatisfactory
-0,4 -0,6 CC Adverse
-0,6 -0,8 C Bad
-0,8 -1 D Critical

As a result we can confirm an unsatisfactory (CCC) financial situation.

 

The comparison with the major competitors

Different industry variables create the unique financial conditions, in which the company is currently working. This is why a comparison with the major competitors helps to get a precise estimation of the RetailTrade's financial position and effectiveness.

Gross profit margin benchmarking

RetailTrade was generating less gross profit for every dollar of revenue than it's major competitors in quarter IV. 

Return on equity after tax benchmarking

 In quarter IV RetailTrade's equity utilization was the least efficient. Return on equity after tax was 4.48%, while TechIndustries (the most effective competitor) demonstrates 128.01%.

Current ratio benchmarking

RetailTrade shows lower ability to pay it's short-term debt comparing to TechIndustries, but better liquidity comparing to DPS Market. The company had 0.89 of current assets for every dollar of current liabilities. 

Sales to net working capital benchmarking

 Sales to net working capital ratio shows how effectively companies are using it's working capital to generate sales. On the other hand, low or negative value indicates the dependency of the operating process on the external sources of finance. A stable value of this ratio is desirable.

Debt ratio benchmarking

 58.65% of RetailTrade's sources of finance were liabilities in quarter IV. This reflects the highest dependence of RetailTrade from the external sources of finance among the major competitors. If any unpredictable financial turmoil happens (in the industry or in the financial market), RetailTrade will be the first to meet problems with the attraction of financial resources or refinancing current loans.

Total assets turnover benchmarking

 RetailTrade generated 0.6 of sale for every dollar of assets used in quarter IV. The worst value of this ratio in comparison to the major competitors reflects the lowest quality of assets management and threats for it's current market position.

Inventory turnover comparison benchmarking

 The inventory management was the least efficient in RetailTrade in quarter IV and the inventory turnover equaled 1.97 times per quarter IV.

 

Conclusion

By assessing the financial position of RetailTrade the following can be concluded:

- RetailTrade's financial sustainability ratios indicate good financial health at the end of quarter IV. This company was able to generate enough cash flow to pay interest on its debt while the debt ratio laid in the area of critical values (from 0.4 to 0.6).

- There is a serious concern about company's liquidity. This is why it must urgently start looking for additional resources to be able to improve its liquidity. Company was not able to pay its suppliers and creditors in due time.

- The positive profitability provides evidence of a good work during quarter IV. The ROA shows that the company was earning a profit of about 1.82 cents per dollar of the asset value. The return on equity after tax was 4%.

- An average accounts receivable collection period dropped from 17.61 days to 16.6 days. This means that it took an average of 16.6 days to collect a receivable in quarter IV. Comparing the turnover data of the accounts receivable and accounts payable during quarter IV it can be seen that the accounts receivable were turned over faster than the accounts payable.

- The net value of the enterprise's assets was USD 82,124 million at the end of quarter IV, about USD 2,134 million more than declared at the end of quarter III. Overall, the net worth dropped from USD 84,053 million to USD 82,124 million. This means that RetailTrade was degrading.

- At the end of quarter IV the Altman Z-score was 1.33 (within the gray area).

- The overall financial position of the company was unsatisfactory (CCC).