Question
Computer Doctor Ltd, has asked for your help in comparing the company's profit performing and financial position with the computer services industry average. The manager
Computer Doctor Ltd, has asked for your help in comparing the company's profit performing 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 similar companies.
Income statement
For the year ended in 2020 | ||
Computer Doctor LTD | Industry Average | |
Net Sales | $425,625 | 100.0% |
Cost of goods sold | $250,375 | 53.2 |
Gross margin | $175,250 | 46.8 |
Operating expenses | $87,300 | 21.3 |
Operating income | $87,950 | 25.5 |
Other expenses | $20,500 | 5.2 |
Net Income | $67,450 | 20.3% |
Balance sheet December 31,2020 | ||
Computer Doctor LTD | Industry Average | |
Current assets | $162,750 | 62.5% |
Property and equipment net | 85,250 | 35.2 |
Other Assets | 6,000 | 2.3 |
Total Assets | $254,000 | 100.0% |
Current Liabilities | $112,500 | 42.5% |
Long term liabilities | 62,500 | 32.5 |
Shareholders equity | 79,000 | 25.0 |
Total liabilities and shareholder's equity | $254,000 | 100.0% |
Required
1) Prepare a two-column common size income statement and a two-column common size balance sheet for Computer Doctor Ltd. The first column of each statement should present the Computer Doctor LTD's common-size statement, and the second column should show the industry averages. Round all answers to one decimal place.
2) For the profitable analysis, compare each of the Computers Doctor Ltd (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 Computer Doctor Ltd's profit performance better or worse than the industry average?
3) For the analysis of financial position, compare each of Computer Doctor Ltd's (a) ratio of current assets to total assets and (b) ratio of shareholder's equity to total assets to the industry averages. Is Computer Doctor Ltd's financial position better or worse than the industry averages?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started