Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Financial Ratio Worksheet 2014 2015 2016 2017 2018 (Receivables/sales)*365 Days Receivable 75.47 80.31 63.69 78.74 76.59 (Inventory/Cost of Goods Sold)*365 Days Inventory 17.42 21.58 18.24
Financial Ratio Worksheet | ||||||
2014 | 2015 | 2016 | 2017 | 2018 | ||
(Receivables/sales)*365 | Days Receivable | 75.47 | 80.31 | 63.69 | 78.74 | 76.59 |
(Inventory/Cost of Goods Sold)*365 | Days Inventory | 17.42 | 21.58 | 18.24 | 41.88 | 41.43 |
(Accounts Payable/Cost of Goods Sold)*365 | Days Payable | 45.19 | 57.23 | 61.09 | 109.84 | 103.13 |
(Sales Yr2-Sales Yr1)/Sales Yr1 | Sales Growth | -5.47% | -5.47% | -3.81% | -42.40% | 6.86% |
Cost of Goods Sold/Sales | Costs of Goods Sold | 71.63% | 71.33% | 70.84% | 69.89% | 69.88% |
SG&A Expenses/Sales | SG&A to sales | 15.81% | 15.40% | 15.60% | 17.54% | 16.03% |
Operating Profit/Sales | Operating Profit to Sales | 6.92% | 7.15% | 8.10% | 6.31% | 3.35% |
Current Assets/Current Liabilities | Current Ratio | 1.11 | 1.41 | 1.28 | 1.13 | 1.00 |
Total Liabilities/Net Worth | Debt Ratio | 0.77 | 1.42 | 1.53 | 1.62 | 1.61 |
Sales/Total Assets | Sales Turnover | 0.85 | 0.64 | 0.63 | 0.47 | 0.56 |
Earnings Before Taxes/Net Worth | Return on Equity | 16.39 | 22.81 | 7.71 | 86.27 | 79.25 |
Earnings Before Taxes/Total Assets | Return on Assets | 0.03 | 0.02 | 0.05 | 0.00 | 0.00 |
Identify the 3 bottom ratios and the 3 top ratios. Give a detailed explanation for each.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started