Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions