Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

n\'a leg Ratio Test Problemtsu xvX cash for Docs, Sheets & Slides chrome extensi

ID: 2560096 • Letter: N

Question

n'a leg Ratio Test Problemtsu xvX cash for Docs, Sheets & Slides chrome extension/bpmopidpdmajfigpchkicefoigmkfalc/views/app.htm tistudent XTX Ratio Test Proteng × Sign into XFINITY WiFi Ratio Test Problem (Student) (1).xls File Edr Insert Format Help Diff96 Common Size 2015 2014 2015 2014 61,587 61,897 coos 42,795 43,450 25,393 27,244 17,402 16,206 Op. Income Interest E 16,91715,755 Balance Sheet 2015 2014 Diff %Common Size 27,658 19,425 9,774 5,378 44375290 47,317 39.541 18.716 16.323 15.M14,862 9038 9,197 4,553 14,799 102,908 94682 18 Prons ty Ratios Cart Assts Totd Current 23,07221,731 23,25722,363 Total Uab 4,220 14220 ,5T950,588 102, 94682 Total Equity 33 Addrtobal Common Saock Dividends 34 Information Prelomed Liat, & Equity 4 6 %5 #3 ? 56 2

Explanation / Answer

income statement

common size = item of income statement/total sales

common size = item of income statement/total sales

2015

2014

difference = 2015-2014

Difference in % = difference/sales of 2014

2015

2014

sales

61587

61897

-310

-0.50%

100%

100%

COGS

18792

18447

345

1.00%

30.51%

29.80%

gross profit

42795

43450

-655

-1.51%

69.49%

70.20%

expenses

25393

27244

-1851

-6.79%

41.23%

44.02%

operating income

17402

16206

1196

7.38%

28.26%

26.18%

interest

455

451

4

0.89%

0.74%

0.73%

net income

16947

15755

1192

7.57%

27.52%

25.45%

common size = item of income statement/total of assets / liabilities and shareholders equity

common size = item of income statement/total of assets / liabilities and shareholders equity

Balance Sheet

Difference

%

2015

2014

cash

27658

19425

8233

42.38%

26.88%

20.52%

A/R

9774

9646

128

1.33%

9.50%

10.19%

inventory

5378

5180

198

3.82%

5.23%

5.47%

other current assets

4497

5290

-793

-14.99%

4.37%

5.59%

total current assets

47307

39541

7766

19.64%

45.97%

41.76%

intangible assets

16716

16323

393

2.41%

16.24%

17.24%

goodwill

15294

14862

432

2.91%

14.86%

15.70%

other LT assets

9038

9197

-159

-1.73%

8.78%

9.71%

PPE

14553

14759

-206

-1.40%

14.14%

15.59%

total assets

102908

94682

8226

8.69%

100%

100%

0

current liabilities

23072

21731

1341

6.17%

LT liabilities

23257

22363

894

4.00%

total liabilities

46329

44094

2235

5.07%

0

c.stock

14220

14220

0

0.00%

RE

42359

36368

5991

16.47%

total of liabilities and shareholders equity

102908

94682

8226

8.69%

Profitabilty and solvency ratio

current ratio

current assets/current liabilities

47307/23072

2.050407

Quick assets

quick assets/current liabilities

(47307-5378)/23072

1.817311

debt to equity ratio

total of liabilities/total equity

46329/(14220+42359)

0.818837

debt ratio

total of liabilities/total assets

46329/102908

0.450198

Equity ratio

total equity/total assets

(14220+42359)/102908

0.549802

Profitability ratio

Gross profit

gross profit/sales

42795/61587

69.49%

net profit ratio

net profit/sales

16947/61587

27.52%

return on total assets

net income/total assets

16947/102908

16.47%

return on total equity

net income/total equity

16947/(14220+42359)

29.95%

operating profit ratio

operating profit/sales

17402/61587

28.26%

income statement

common size = item of income statement/total sales

common size = item of income statement/total sales

2015

2014

difference = 2015-2014

Difference in % = difference/sales of 2014

2015

2014

sales

61587

61897

-310

-0.50%

100%

100%

COGS

18792

18447

345

1.00%

30.51%

29.80%

gross profit

42795

43450

-655

-1.51%

69.49%

70.20%

expenses

25393

27244

-1851

-6.79%

41.23%

44.02%

operating income

17402

16206

1196

7.38%

28.26%

26.18%

interest

455

451

4

0.89%

0.74%

0.73%

net income

16947

15755

1192

7.57%

27.52%

25.45%

common size = item of income statement/total of assets / liabilities and shareholders equity

common size = item of income statement/total of assets / liabilities and shareholders equity

Balance Sheet

Difference

%

2015

2014

cash

27658

19425

8233

42.38%

26.88%

20.52%

A/R

9774

9646

128

1.33%

9.50%

10.19%

inventory

5378

5180

198

3.82%

5.23%

5.47%

other current assets

4497

5290

-793

-14.99%

4.37%

5.59%

total current assets

47307

39541

7766

19.64%

45.97%

41.76%

intangible assets

16716

16323

393

2.41%

16.24%

17.24%

goodwill

15294

14862

432

2.91%

14.86%

15.70%

other LT assets

9038

9197

-159

-1.73%

8.78%

9.71%

PPE

14553

14759

-206

-1.40%

14.14%

15.59%

total assets

102908

94682

8226

8.69%

100%

100%

0

current liabilities

23072

21731

1341

6.17%

LT liabilities

23257

22363

894

4.00%

total liabilities

46329

44094

2235

5.07%

0

c.stock

14220

14220

0

0.00%

RE

42359

36368

5991

16.47%

total of liabilities and shareholders equity

102908

94682

8226

8.69%

Profitabilty and solvency ratio

current ratio

current assets/current liabilities

47307/23072

2.050407

Quick assets

quick assets/current liabilities

(47307-5378)/23072

1.817311

debt to equity ratio

total of liabilities/total equity

46329/(14220+42359)

0.818837

debt ratio

total of liabilities/total assets

46329/102908

0.450198

Equity ratio

total equity/total assets

(14220+42359)/102908

0.549802

Profitability ratio

Gross profit

gross profit/sales

42795/61587

69.49%

net profit ratio

net profit/sales

16947/61587

27.52%

return on total assets

net income/total assets

16947/102908

16.47%

return on total equity

net income/total equity

16947/(14220+42359)

29.95%

operating profit ratio

operating profit/sales

17402/61587

28.26%