Question
Use the following information to answer the questions on page 2 below: (Note: all sales are credit sales) Income Stmt info: 2015 2016 Sales $
Use the following information to answer the questions on page 2 below:
(Note: all sales are credit sales)
Income Stmt info: | 2015 | 2016 |
Sales | $ 1,000,000 | $ 1,050,000 |
less Cost of Goods Sold: | 400,000 | 424,000 |
Gross Profit | 600,000 | 626,000 |
Operating Expenses | 350,000 | 365,750 |
Earnings before Interest & Taxes | 250,000 | 260,250 |
Interest exp | 25,000 | 25,500 |
Earnings before Taxes | 225,000 | 234,750 |
Taxes | 90,000 | 93,900 |
Net Income | $ 135,000 | $ 140,850 |
Balance Sheet info: | 12/31/2015 | 12/31/2016 |
Cash | 25,000 | $ 30,000 |
Accounts Receivable | 50,000 | $ 51,000 |
Inventory | 125,000 | $ 137,500 |
Total Current Assets | $ 200,000 | $ 218,500 |
Fixed Assets (Net) | $ 300,000 | $ 315,000 |
Total Assets | $ 500,000 | $ 533,500 |
Current Liabilities | $ 110,000 | $ 117,700 |
Long Term Liabilities | $ 180,000 | $ 183,000 |
Total Liabilities | $ 290,000 | $ 300,700 |
Stockholder's Equity | $ 210,000 | $ 232,800 |
Total Liab & Equity: | $ 500,000 | $ 533,500 |
Compute each of the following ratios for 2015 and 2016, and | ||
indicate whether each ratio was getting "better" or "worse" from 2015 to 2016 | ||
and was "good" or "bad" compared to the Industry Avg in 2016. | ||
(Round all numbers to 2 digits past the decimal place.) | ||
2015 | 2016 | Getting Better or Getting Worse? | 2016 Industry Avg | "Good" or "Bad" compared to Industry Avg | |
Profit Margin | 0.11 | ||||
Current Ratio | 1.90 | ||||
Quick Ratio | 0.66 | ||||
Return on Assets | .28 | ||||
Debt to Assets | .50 | ||||
Receivables turnover | 18.00 | ||||
Avg. collection period* | 21.20 | ||||
Inventory Turnover** | 8.25 | ||||
Return on Equity | 0.55 | ||||
Times Interest Earned | 11.15 | ||||
*Assume a 360-day year | |||||
**Inventory Turnover can be computed 2 different ways. | |||||
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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