90.2K

Verified Solution

Link Copied!

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.

Answer & Explanation Solved by verified expert

See Answer