Question

Use Dylex Corporation's financial statements to compute the below ratios. Compared to the industry averages provided...

Use Dylex Corporation's financial statements to compute the below ratios. Compared to the industry averages provided in the question data determine if the ratio is favourable or unfavourable. Also select the ratio type it represents.
Please make sure your final answer(s) are accurate to 2 decimal places and don't use percentages. For your analysis, assume that all other things have remained constant. Apply your analysis in very general terms.

Ratio 2015 Industry Average Favourable/Unfavourable Ratio Type
Days' sales in inventory 4.42
Days' sales uncollected 7.12
Inventory turnover 63.3
Book value per common share 35.82
Equity ratio 0.6
Balance Sheet
Assets 2015 2014
Cash 16600 16200
Short-term investments 37000 39000
Accounts receivable, net 23700 21200
Inventory 13800 12400
Prepaid insurance 2900 3200
Notes receivable, due in 2018 9000 10000
Plant assets, net 575000 419550
Total assets 678000 521550
Liabilities and Shareholders' Equity
Accounts payable 20800 26400
Salaries payable 9800 13100
Property taxes payable 23000 24850
Long-term notes payable 142000 168000
Common shares, issued 50,000 shares 280000 280000
Retained earnings 202400 9200
Total liabilities and shareholders' equity 678000 521550
Income Statement
2015 2014
Net sales (on credit) 1539900 1212300
Cost of goods sold 1109500 749300
Gross profit from sales 430400 463000
Operating expenses 170000 163800
Income from operations 260400 299200
Interest expense 4250 4600
Income before taxes 256150 294600
Income taxes 41500 62000
Net income 214650 232600
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Thank you for your patience. Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
Dylex Company
Statement of Earnings 2015 2014
Sales      1,539,900.00       1,212,300.00
Cost of goods sold      1,109,500.00           749,300.00
Gross Margin         430,400.00          463,000.00
Operating Expenses         170,000.00           163,800.00
Income from operations         260,400.00          299,200.00
Interest Expense              4,250.00               4,600.00
Income before taxes         256,150.00          294,600.00
Income taxes            41,500.00             62,000.00
Net Income         214,650.00          232,600.00
Common Dividends         350,000.00           455,700.00
Net Income Retained        (135,350.00)         (223,100.00)
Beginning Retained Earnings      1,290,000.00           834,300.00
Ending Retained Earnings      1,154,650.00           611,200.00
Statement of Financial Position
Assets 2015 2014
Current Assets
Cash            16,600.00             16,200.00
Short-term investments            37,000.00             39,000.00
Accounts Receivable (Net)            23,700.00             21,200.00
Inventory            13,800.00             12,400.00
Prepaid Expense              2,900.00               3,200.00
Total Current Assets           94,000.00             92,000.00
Notes receivable, due in 2018              9,000.00             10,000.00
Plant assets, net         575,000.00           419,550.00
Total Assets         678,000.00          521,550.00
Liabilities & Stockholders' Equity 2015 2014
Liabilities
Accounts payable            20,800.00             26,400.00
Salaries payable              9,800.00             13,100.00
Property taxes payable            23,000.00             24,850.00
Current Liabilities           53,600.00             64,350.00
Long-term notes payable         142,000.00           168,000.00
Total Liabilities         195,600.00          232,350.00
Stockholders' Equity
Common shares, issued 50,000 shares         280,000.00           280,000.00
Retained Earnings         202,400.00               9,200.00
Total Stockholders' Equity         482,400.00          289,200.00
Total Liabilities & Stockholders' Equity         678,000.00          521,550.00
2015 2014
Accounts Receivable (Net)            23,700.00             21,200.00
Average Accounts Receivable           22,450.00
Inventory            13,800.00             12,400.00
Average Inventory           13,100.00
Ratios 2015 Industry Average Remarks Ratio Type
Inventory turnover
Cost of goods sold/ Average Inventory                84.69                      63.30 Favorable because it is higher than industry average. It is an activity ratio.
Days' sales in inventory
365/ Inventory turnover                  4.31                         4.42 Favorable because it is lower than industry average. It is an activity ratio.
Accounts Receivable turnover
Sales/ Average Accounts Receivable                68.59 It is an activity ratio.
Days' sales uncollected
365/ Accounts Receivable turnover                  5.32 7.12 Favorable because it is lower than industry average. It is an activity ratio.
Book value per common share
Total Stockholders' Equity/ Number of common shares                  9.65                      35.82 Unfavorable because it is lower than industry average. It is a financial ratio.
Equity ratio
Total Stockholders' Equity/ Total Assets                    0.7 0.6 Favorable because it is higher than industry average. It is a leverage ratio.
Add a comment
Know the answer?
Add Answer to:
Use Dylex Corporation's financial statements to compute the below ratios. Compared to the industry averages provided...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2015 to compare 4-9. (Ratio analysis) The financial statements and industry norms are shown be for...

    2015 to compare 4-9. (Ratio analysis) The financial statements and industry norms are shown be for Pamplin, Inc.: a. Compute the financial ratios for Pamplin for 2014 and for 2015 to com both against the industry norms. b. How liquid is the firm? c. Areits managers generating an adequate operating profit on the firm's d. How is the firm financing its assets? e. Are its managers generating a good return on equity? INDUSTRY NORN 5.00 3.00 2.20 90.00 0.33 Current...

  • Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation...

    Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit: selected balance sheet amounts at December 31, 2016, were inventory, $50,900; total assets, $249,400; common stock. $90,000; and retained earnings, $43,304.) OK CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 451,600 Cost of goods sold 298,050 Gross profit 153,550 Operating expenses 99,000 Interest expense 3.900 Income before taxes 50,650 Income taxes 20,404 Net income...

  • ASSURANCE OF LEARNING EXERCISES 1. conn LO4-1 Using the financial ratios provided in the Appendix and...

    ASSURANCE OF LEARNING EXERCISES 1. conn LO4-1 Using the financial ratios provided in the Appendix and the following financial statement information for Macy's, Inc., calculate the following ratios for Macy's for both 2015 and 2016. 1. Gross profit margin 2. Operating profit margin 3. Net profit margin 4. Times interest earned coverage 5. Return on shareholders' equity 6. Return on assets 7. Long-term debt-to-equity ratio 8. Days of inventory 9. Inventory turnover ratio 10. Average collection period Based on these...

  • 2015 Analysis and Interpretation of Liquidity and Solvency Refer to the financial information for Target Corporation...

    2015 Analysis and Interpretation of Liquidity and Solvency Refer to the financial information for Target Corporation (TGT), presented below, to answer the following. Target Corporation Balance Sheets January 31, February 1, ($ millions) 2014 Assets Cash and cash equivalents $2,210 $670 Inventory 8,790 8,278 Other current assets 3,087 2,625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders' investment Accounts payable $7,759 $7,335 Accrued and other...

  • I was provided both the Balance Sheet and Statement of income from which I am supposed...

    I was provided both the Balance Sheet and Statement of income from which I am supposed to calculate the inventory turnover ratio. But the balance sheet only has the inventory values for 2016 and 2015, while the statement of income only states the cost of sales for 2015, 2014, and 2013. So: Merchandise inventory (from balance sheet): January 30, 2016 = $5,506 January 31, 2015 = $5,417 Cost of Sales (from income statement): 2015 = $16,496 2014 = $16,863 2013...

  • Using the financial ratios provided in Table 4.1 and the financial statement infor- mation presented below...

    Using the financial ratios provided in Table 4.1 and the financial statement infor- mation presented below for Costco Wholesale Corporation, calculate the follow ing ratios for Costco for both 2013 and 2014: a. Gross profit margin b. Operating profit margin c. Net profit margin d. Times-interest-earned (or coverage) ratio e. Return on stockholders' equity 1. 1 f. Return on assets g. Debt-to-equity ratio h. Days of inventory . Inventory turnover ratio j. Average collection period Based on these ratios, did...

  • Exercise Calculate liquidity, Profitability, Debt ratios from the below details and comment on the financial performance,...

    Exercise Calculate liquidity, Profitability, Debt ratios from the below details and comment on the financial performance, compared to the previous year. 400,000 Statement of Income of XYZ LLC for the year ended 31st December 2015 & 2014 Particulars Amount(RO) Amount (RO) 2015 2014 Sales 270,000 Less: Cost of goods sold 135,000 200,000 Salaries 48,600 66,250 Depreciation 22,950 37,500 Interest 5,400 211,950 6,250 Income before taxes 58,050 Less: Income taxes 27,000 Net Income 31,050 310,000 90,000 29,700 60,300 Balance sheet of...

  • Exercise Calculate liquidity, Profitability, Debt ratios from the below details and comment on the financial performance,...

    Exercise Calculate liquidity, Profitability, Debt ratios from the below details and comment on the financial performance, compared to the previous year. 400,000 Statement of Income of XYZ LLC for the year ended 31st December 2015 & 2014 Particulars Amount(RO) Amount (RO) 2015 2014 Sales 270,000 Less: Cost of goods sold 135,000 200,000 Salaries 48,600 66,250 Depreciation 22,950 37,500 Interest 5,400 211,950 6,250 Income before taxes 58,050 Less: Income taxes 27,000 Net Income 31,050 310,000 90,000 29,700 60,300 Balance sheet of...

  • 5. Calculate the 2015 financial ratios for Phocbe Corporation rounded to the nearest tenth and put...

    5. Calculate the 2015 financial ratios for Phocbe Corporation rounded to the nearest tenth and put a checkmark in tbe row in which Phorbe's ratios are better than the industry average: Ratio Gross Profit Margin Net Profit Margin Current Ratio Inventory Turnover Receivables Turnover Phoebe Corporation (2015) Industry Averages Phocbe is Better 55.0% 27.5% 3.3 % % 15.5 8.5 Select Financial Ratios What It Measures Eficiency of operations and product pricing Lisiency afher all expenses are considered Short-run debt-paying ability...

  • Part 1: Ratio Analysis calculate the following ratios Part 2: Perform a vertical analysis of statement...

    Part 1: Ratio Analysis calculate the following ratios Part 2: Perform a vertical analysis of statement of financial position & Income statement Part 3: Perform a Horizontal Analysis of statement of Financial Position for 2015 and 2014 & Income statement for 2015 Instructions: 1. On pages three and four, you will find condensed statement of financial position and income statement data for Waterloo Corporation. 2. Use the same information to answer all the three parts. 3. Part 1: a. In...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT