Based on the following financial information, which best describes the company’s liquidity and quality of its current assets over the past three years?

Financial statement analysis

  1. Based on the following financial information, which best describes the company’s liquidity and quality of its current assets over the past three years?

20Y1

20Y2

20Y3

Current ratio

1.4

1.4

1.4

Quick ratio

0.4

0.5

0.5

Working capital (000)

$ 66

$ 97

$ 135

Accounts receivable days on hand

8

11

18

Inventory days on hand

123

126

108

Liquidity is trending downward as shown by the declining current and quick ratios. The ratios would be even lower were it not for the 10-day slowdown of the collection period.

While the company’s quick ratio and working capital indicate its liquidity is improving, a substantial part of the improvement is the direct result of the 10-day slowdown in the collection period. Until we know what caused the slowdown, the company’s liquidity is unclear and its asset quality may actually be deteriorating.

Liquidity has doubled as shown by the doubling of working capital. In fact, it may have more than doubled because inventory is reported at a lower value due to a 15-day shortening of the holding period.

Liquidity is declining as shown by the steady increase in the company’s reliance on inventory to cover current liabilities. This, coupled with the decreasing amount of inventory due to a 15-day shortening of the holding period, indicates even less liquidity.

Question 2: What is the trend in the EBITDA-to-total-debt-service and Funded debt-to-EBITDA ratios for the years 20Y2 and 20Y3?

Company Revolutionary Designs, Inc.

EBITDA-to-Total-debt-service increased from 0.3 to 0.4 and Funded-debt-to-EBITDA decreased from 3.6 to 4.1.

EBITDA-to-Total-debt-service increased slightly from 0.2 to 0.3, but Funded-debt-to-EBITDA weakened from 4.4 to 3.7.

EBITDA-to-Total-debt-service increased from 2.8 to 3.1 and Funded-debt-to-EBITDA decreased from 4.4 to 3.7.

EBITDA-to-Total-debt-service strengthened, increasing from 2.8 to 3.1, but Funded-debt-to-EBITDA weakened, decreasing from 3.6 to 3.1.

The current portion of a company’s balance sheets for the past three years are as follows:

20Y1

20Y2

20Y3

Cash

$ 100

$ 123

$ 66

Accounts receivable

240

303

376

Inventory

417

461

547

Other current assets

117

70

107

Total current assets

$ 874

$ 957

$ 1,096

Notes payable

$ 0

$ 5

$ 101

Current portion LTD

67

67

67

Accounts payable

148

204

244

Accrued expenses

57

64

69

Other current liabilities

47

28

46

Total current liabilities

$ 319

$ 368

$ 527

question 3:Which of the following best describes the company’s liquidity over the past three years?

Liquidity indicators showed improvement as evidenced by lower current and quick ratios in 20Y3.

Liquidity indicators deteriorated in each of the three years as evidenced by the consecutive increases in both the current and quick ratios.

Liquidity indicators were relatively stable from 20Y1 to 20Y2 but then deteriorated in 20Y3 when both the current and quick ratios declined.

Liquidity indicators were mixed with the quick ratio improving and the current ratio declining over the three year period.

Three years of balance sheets for a very profitable furniture manufacturer at its seasonal low point of accounts receivable and inventory are as follows:

20Y1

20Y2

20Y3

Cash

$ 221

$ 230

$ 310

Accounts receivable

794

846

1,194

Inventory

871

1,176

1,099

Other current assets

23

41

36

Total current assets

1,909

2,293

2,639

Net fixed assets

612

624

582

Patents & trademarks

34

20

40

Total non-current assets

646

644

622

Total assets

$ 2,555

$ 2,937

$ 3,261

Notes payable

945

975

1010

Current portion LTD

19

19

19

Accounts payable

551

834

1053

Accrued expenses

155

207

288

Other current liabilities

12

25

11

Total current liabilities

1682

2060

2381

Long-term debt

178

172

165

Total liabilities

1,860

2,232

2,546

Owners equity

695

705

715

Total liabilities and equity

$ 2,555

$ 2,937

$ 3,261

Total liabilities to Tangible net worth

2.8

3.3

3.8

question 4:Which of the following most accurately describes the company’s capital structure?

Leverage is deteriorating, and long-term debt would be more appropriate than short-term notes payable since the company is at its seasonal low point.

Leverage is improving, and long-term debt would be more appropriate than short-term notes payable since the company is at its seasonal low point.

Leverage is improving, and the breakdown of short- and long-term debt is about right.

Leverage is deteriorating, and the breakdown of short- and long-term debt is about right.

Question 5:What was the company’s pretax return on equity in 20Y3?

Company Muebles Mexicanos

61.80%

48.70%

108.90%

41.00%

Question 6: Which of the following had a favorable impact on Muebles Mexicanos’ gross profit margin in the most recent year?

Higher selling prices

Cheaper raw materials

Better efficiencies

Higher regional unemployment

Question 7: A company’s income statements for the past three years are as follows:

20Y1

20Y2

20Y3

Sales

$ 6,515

$ 7,506

$ 8,010

Cost of goods sold

5,473

6,377

6,328

Gross profit

1,042

1,129

1,682

SG&A expense

706

858

1,315

Depreciation expense

18

24

26

Total operating expense

724

882

1,341

Operating profit

318

247

341

Loss on sale of fixed assets

0

0

27

Interest expense

54

78

84

Other expenses

0

4

22

Income before taxes

264

165

208

Taxes

130

79

100

Net income

$134

$86

$108
Which of the following best describes the company’s profit margin performance?

The company’s gross profit margin, operating profit margin and net profit margin all trended downward over the three year period.

All profit margins declined in 20Y2. Gross profit margin improved substantially in 20Y3, but the net profit margin only partially recovered.

Gross profit margin and operating profit margin both increased in 20Y2 and 20Y3.

Gross profit margin, operating profit margin and net profit margin all declined in 20Y2 and then fully recovered in 20Y3.

Question 8: The company’s leverage is steadily decreasing. Which of the following is the best explanation?

The company is paying down its long term debt by $400,000 per year while a portion of net income is being retained.

The company’s gross profit margin is steadily increasing and so is the net profit margin.

The company’s total liabilities are steadily decreasing, and net income is steadily increasing.

Most of the liabilities that are increasing are current, and they don’t affect the leverage calculation.

Question 9–In 20Y2, most of Light Touch’s profit margins declined; in 20Y3, they leveled off. Company management expects those same margins to return to 20Y1 levels in 20Y4. How realistic is that expectation?

Company

Light Touch

The company’s high income tax rate makes it quite unlikely that the expectation will be realized.

Light Touch’s steadily improving gross profit margin makes it quite likely that the expectation will be realized.

The company’s operating profit margin has leveled off, indicating the company should be able to fulfill its expectations.

Light Touch’s operating expenses are growing faster than sales. The company will need to control those costs better in order to meet its expectations.

Question 10 Review the following year end financial statement excerpts to answer the question below.

20Y1

20Y2

20Y3

Sales

$ 2,500

$ 3,000

$ 3,570

Cost of goods sold

1,773

2,093

2,467

Gross profit

$ 727

$ 907

$ 1,103

Cash

$ 100

$ 123

$ 66

Accounts receivable

240

303

376

Inventory

417

461

547

Other current assets

117

70

107

Total current assets

$ 874

$ 957

$ 1,096

Which of the following best describes the company’s inventory over the past three years?

Inventory days on hand was stable in 20Y2 and slower in 20Y3.

Inventory days on hand improved in 20Y2 and lengthened slightly in 20Y3.

Inventory days on hand was stable in all three years.

Inventory days on had improved in all three years.