Data analytics (Data should be presented in Excel) NEED THE SOLUTION IN 7 Hours !!

profilebullriser
Deltaapparelincfile.xls
Home>Business & Finance homework help>Financial markets homework help>Data analytics (Data should be presented in Excel) NEED THE SOLUTION IN 7 Hours !!

Overview

Overview
This is the business, financial ratios analysis of Delta Apparel Inc.a leading business of apparels production, which is also a registered brand on newyork stock exchange and shares are publically traded. The ratios are computed based over the financial statements available of 2016, 2015, 2014, and the comparison is done with the relevant competitors in industry.
Summary
Usually the management, expects the employees from finance department to be able to present different kinds of analysis related to business performance and the comparison with industry competitions to analyze where the business is behind or where it is taking lead. There is a standard pattern which is through decades has been developed, based on certain parameters to analyze the business performance, these are called business ratios, these ratios are calculated through the business financial data, available through company financial statements. To perform this analysis the company i selected in delta apparels inc, and to compare it with industry, i selected 2 competitors of same line, both are listed on stock exchanges, one is a US based company and other one is German based, named, Oxford Industries inc, and Michael Kors Holding Limited. The average of both competitions is taken and added in the comparison draft right adjuscent of Delta Apparel inc financial ratios, on the far right side, is the analysis section in which detailed analysis of Delta, in comparison to industry ratios is done reflecting the comments over business performance. If we discuss about the excel functions used in this analysis, those are simple functions of division of one cell figure with other cell figure, multiplication and making links to different data, so the figures and data can be replicated in the columns of this tab.

Ratio analysis

Ratio Analysis
Ratios Delta Apparel Inc Benchmark Firms Average Analysis
2016 2015 2014 2016 2015 2014
Revenue 425.25 449.14 452.90 2,765.23 2,847.91 2,693.70 The revenue is declining, which is unfavorable for the business, if the industry average is considered, the industry numbers are above the company performance.
EBIT 18.02 9.43 2.50 397.18 636.31 1,340.85 EBIT of the business is growing in favor of company, while the industry is showing a continuous significant decline.
Market Value 125.26 137.46 71.61 3,430.71 5,604.94 7,024.61 The market value of business is in favorable, but slow growth in line of last three years, while industry is declining over all.
Current Ratio 2.83 2.70 2.67 1.91 2.76 3.94 The current ratio of the business has reflected in favor of business growth , while the industry is reflecting a continuous decline in all three years.
Quick Ratio 0.00 0.00 0.01 0.23 0.83 1.50 The quick ratio of business has gained favor for company, but it is overall too low in comparison to the industry performance.
Operating Cash Flow Ratio 0.11 0.10 (0.01) 0.69 1.19 1.48 The ratio has significantly improved in favor of company, but it is too low than the industry average.
Receivable Turnover 6.75 7.25 6.64 17.35 15.98 12.44 The receivable turnover has been almost stable for the three years with minor changes, it is in not in favor of company as compared to industry performance.
Days Outstanding in Accounts Receivable 54.08 50.32 54.95 21.05 22.88 29.38 Days are much more than the industry average, hence it is unfavorable, also the three years data reflect the same thing.
Inventory Turnover 1.95 2.36 2.20 3.06 3.21 3.03 The inventory turnover has declined, hence it is unfavorable for the company, and industry is performing better than the company.
Days of Inventory on Hand 186.74 154.52 165.92 119.95 114.67 121.34 The days in hand of inventory reflects that business is holding more than the industry average days, which is not in favor of business.
Gross Profit Margin 24.51 21.97 21.22 60.43 60.53 60.21 The gross profit margin, has improved in three years, in favor of company, how ever it is significantly lower than the industry average.
Profit Margin 4.24 2.10 0.55 12.30 17.43 18.51 Net profit margin has improved in favor of company, and someone little lower than the industry average, this reflects good performance of company.
Return on Assets 5.23 2.90 0.71 21.35 31.26 29.85 The ROA has been favorable for company, but its lower than the industry average.
Return on Equity 11.85 6.53 1.81 34.40 44.02 42.48 The ROE has been in favor of the company as it has increased, but it is lower than the industry performance.
Debt to Equity 0.70 0.65 0.82 0.12 0.07 0.18 The debt to equity ratio has increased, which in unfavorable for the business, and as the industry average is considered, company is performing even worst.
Time Interest Earned Ratio 3.41 1.56 0.43 100.44 365.45 2935.23 Times interest earned ratio has improved in favor of business, but it is lower than the industry average.

Sheet3