Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute each of the following ratios for 2017 and 2018 and indicate whether each ratio was getting better or worse from 2017 to 2018 and

image text in transcribed

Compute each of the following ratios for 2017 and 2018 and
indicate whether each ratio was getting "better" or "worse" from 2017 to 2018
and was "good" or "bad" when compared to the Industry Avg in 2018
(round all numbers to 2 digits past the decimal place)
2017 2018 Getting Better or Getting Worse? 2018 Industry Avg "Good" or "Bad" compared to Industry Avg
Profit Margin 0.08
Current Ratio 1.90
Quick Ratio 1.12
Return on Assets 0.15
Debt to Assets 0.55
Receivables turnover 18.00
Avg. collection period* 21.20
Inventory Turnover** 4.06 3.99 8.25 Bad
Return on Equity 0.25
Times Interest Earned 8.15
*Assume a 360 day year

**Inventory Turnover can be computed 2 different ways. Use the formula listed in the text and by Connect.

COGS/Inventory

(the one the text indicates many credit reporting agencies generally use)
Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2017 2018 Sales 1,100,000 1,155,000 less Cost of Goods Sold: 325,000 351,000 Gross Profit 775,000 804,000 Operating Expenses 575,000 609,500 Earnings before Interest & Taxes 200,000 194,500 Interest exp 25,000 30,000 earnings before Taxes 175,000 164,500 es 70,000 65800 105,000 Net Income 98,700 12/31/18 Balance Sheet info: 12/31/17 Cash 55,000 52,250 Accounts Receivable 110,000 111,100 80,000 88,000 Inventory 245,000 350000 S 595,000 Total Current Assets 251,350 Fixed Assets (Net) 371,000 $ Total Assets 622,350 140,000 Current Liabilities 161,000 Long Term Liabilities 150,000 290,000 S 305,000 155,000 Total Liabilities 316,000 306,350 Stockholder's Equity Total Liab & Equity: 595,000 622,350

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

Step: 3

blur-text-image

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

TS 16949 Insights From A Third Party Auditor With A Process Approach Audit Checklist

Authors: Karen Welch

1st Edition

0873896548, 978-0873896542

More Books

Students also viewed these Accounting questions