Question: Lacavelier Ltd. has asked for your help in comparing the company's profit performance and financial position with the computer services industry average. The manager has

Lacavelier Ltd. has asked for your help in comparing the company's profit performance and financial position with the computer services industry average. The manager has given you the company's income statement and balance sheet, and also the following industry average data for computer services companies:

Lecavelier Ltd.
Income Statement
For the Year Ended December 31, 2020
Industry
Lecavelier Ltd.Average
Net sales$427,000100.00%
Cost of goods sold258,00053.2
Gross margin169,00046.8
Operating expenses95,00021.3
Operating income74,00025.5
Other expenses23,0005.2
Net income$51,00020.30%
Lecavelier Ltd.
Balance Sheet
31-Dec-20
Industry
Lecavelier Ltd.Average
Current assets$164,00062.50%
Property and equip., net88,00035.2
Other assets6,9002.3
Total assets$258,900100.00%
Current liabilities$118,00042.50%
Long-term liabilities69,00032.5
Shareholders' equity71,90025
Total liabilities and shareholders' equity$258,900100.00%

1.

Make a two-column common-size income statement and a two-column common-size balance sheet for

Lecavelier

Ltd. The first column of each statement should present

Lecavelier

Ltd.'s common-size statement, and the second column should show the industry averages.

2.

For the profitability analysis, compare each of

Lecavelier

Ltd.'s (a) ratio of gross margin to net sales, (b) ratio of operating income to net sales, and (c) ratio of net income to net sales. Compare these figures to the industry averages. Is

Lecavelier

Ltd.'s profit performance better or worse than the industry average?

3.

For the analysis of financial position, compare each of

Lecavelier

Ltd.'s (a) ratio of current assets to total assets, and (b) ratio of shareholders' equity to total assets to the industry averages. Is

Lecavelier

Ltd.'s financial position better or worse than the industry averages?

Requirement 1. Prepare a two-column common-size income statement and a two-column common-size balance sheet for Lecavelier Ltd. The first column of each statement should present Lecavelier

Ltd.'s common-size statement, and the second column should show the industry averages.Begin with the common-size income statement. (Round all percentages to one decimal place. In order to avoid rounding issues, complete each line individually. The total of the column may not add up to 100.0.)

Lecavelier Ltd.
Common-Size Income Statement Compared to Industry Average
For the Year Ended December 31, 2020
Lecavelier Ltd.Industry
(%)Average (%)
Net sales100
Cost of goods sold53.2
Gross margin46.8
Operating expenses21.3
Operating income25.5
Other expenses5.2
Net income20.3

Prepare a common-size balance sheet for Lecavelier Ltd. (Round all percentages to one decimal place. In order to avoid rounding issues, complete each line individually. The total of the column may not add up to 100.0.)

Lecavelier Ltd.
Common-Size Balance Sheet Compared to Industry Average
31-Dec-20
Lecavelier Ltd.Industry
(%)Average (%)
Current assets62.5
Property and equipment, net35.2
Other assets2.3
Total assets100
Current liabilities42.5
Long-term liabilities32.5
Shareholders' equity25
Total liabilities and shareholders' equity100
Lacavelier Ltd. has asked for your help in
Requirement 2. For the profitability analysis, compare each of Lecavelier Ltd.'s (a) ratio of gross margin to net sales, to} ratio of operating income to net sales, and (c) ratio of net income to net sales. Compare these gures to the industry averages. Is Lecavelier Ltd.'s prot performance better or worse than the industry average? Lecavelier Ltd.'s commonsize income statement shows that its ratios of gross margin to net sales, operating income to net sales, and net income to net sales are :I'l' than the industry averages. The company's prot performance is |:l average for the industry. Requirement 3. For the analysis ofnancial position, compare each of Lecavelier Ltd.'s {a} ratio of current assets to total assets, and {b} ratio of shareholders' equity to total assets to the industry averages. ls Lecavelier Ltd.'s nancial position better or worse than the industry averages? Lecavelier Ltd.'s commonsize balance sheet shows that its ratio of current assets to total assets. and of shareholders' equity to total assets are "I" than the industry averages. Overall, Lecavelier Ltd.'s nancial position is El than average for companies in its industry

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!