Ratio Assignment 1)Use the excel sheets you completed for 2013 & 2014 years for Micro…

Ratio Assignment

1)Use the excel sheets you completed for 2013 & 2014 years for Micro TilesAnalysis.

2) Examine Micro Tiles Ratios Sheet #6

3)List the Ratiosa.Liquidity Ratios –i.Current and Quickii.Working Capital Turnoveriii.Days of Working Capital Ratiosb.Debt Coverage Ratiosi. Debt-to-total assets ratio (percent)ii. Debt-to-equity ratio (times)iii.Times-interest-earned ratio (times)iv.Fixed-charges-coverage ratio (times)c.Asset Management Ratiosi.Accounts receivable performance measures1.Average collection period (days)2.Accounts receivable turnover (times)ii.Inventory performance measures1.Turnover performance measures2.Using cost of sales (times)iii.Asset ratios1.Capital assets turnover ratio (times)2.Total assets turnover ratio (times)d.Profitability Ratiosi.Gross profit to revenue ratio (percent)ii.Operating income to revenue ratio (percent)iii.Profit for the year to revenue ratio (percent)iv.Return on total assets ratio (percent)v.Return on invested capital ratio (percent)vi.Return on equity ratio (percent)4)Explain each ratio and the difference between 2013 and 20145) Submit your report on Micro Tiles Ratios for 2013 and 2014