Reference no: EM131851826

Question: Financial statement analysis

Question 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.