Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Risk Assessment Made Easy Seeing What Others Miss

Authors: Charles Hall

1st Edition

0578961679, 978-0578961675

Students also viewed these Accounting questions

Question

differentiate the function ( x + 1 ) / ( x ^ 3 + x - 6 )

Answered: 1 week ago

Question

Explain key approaches to implementing LMD

Answered: 1 week ago