Question: Otto's Auto Sales asked for your help in comparing the company's profit performance and financial position with the average for the auto sales industry. The

Otto's Auto Sales asked for your help in comparing the company's profit performance and financial position with the average for the auto sales industry. The owner has given you the company's income statement and balance sheet as well as the industry average data for retailers of used autos.

Otto's Auto Sales Income Statement Compared with Industry Average Year Ended December 31, 2016 INDUSTRY OTTO'S $955,100

Otto's Auto Sales Balance Sheet Compared with Industry Average December 31, 2016 INDUSTRY OTTO'S AVERAGE 77.2% Current A


Requirements
1. Prepare a two-column, common-size income statement and a two-column, common- size balance sheet for Otto’s Auto Sales. The first column of each statement should present Otto’s Auto Sales’ common-size statement and the second column should show the industry averages.

2. For the profitability analysis, examine Otto’s Auto Sales’ (a) ratio of gross profit to net sales, (b) ratio of operating income to net sales, and (c) ratio of net income to net sales. Compare these figures with the industry averages. Is Otto’s profit performance better or worse than the industry average?

3. For the analysis of financial position, examine Otto’s Auto Sales’ (a) ratio of current assets to total assets, and (b) ratio of stockholders’ equity to total assets. Compare these ratios with the industry averages. Is Otto’s Auto Sales’ financial position better or worse than the industry average?

Otto's Auto Sales Income Statement Compared with Industry Average Year Ended December 31, 2016 INDUSTRY OTTO'S $955,100 651,400 303,700 AVERAGE Net Sales 100.0% 64.3% Cost of Goods Sold Gross Profit 35.7% 27.3% 8.4% Operating Expenses Operating Income Other Expenses Net Income 217,800 85,900 11,500 $74,400 1.1% 7.3% Otto's Auto Sales Balance Sheet Compared with Industry Average December 31, 2016 INDUSTRY OTTO'S AVERAGE 77.2% Current Assets $516,800 112,300 Fixed Assets, Net Intangible Assets, Net Other Assets 16.3% 23,100 27,900 $680,100 2.8% 3.7% Total Assets 100.0% Current Liabilities $268,600 40.1% Long-Term Liabilities Stockholders' Equity Total Liabilities and Stockholders' Equity 129,200 20.3% 282,300 $680,100 39.6% 100.0%

Step by Step Solution

3.38 Rating (179 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Req 1 Ottos Auto Sales CommonSize Income Statement Compared to Industry Average Year Ended December ... View full answer

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

Document Format (3 attachments)

PDF file Icon

1350_60b9f89b03dfa_607962.pdf

180 KBs PDF File

Excel file Icon

1350-B-M-A-I(3638).xlsx

300 KBs Excel File

Word file Icon

1350_60b9f89b03dfa_607962.docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!