Question

In: Finance

The comparative condensed income statements of Emley Corporation are shown below.

The comparative condensed income statements of Emley Corporation are shown below.

EMLEY CORPORATION Comparative Condensed Income Statements For the Years Ended December 31 2017 2016 Net sales $660,000 483,000 $600,000 Cost of goods sold Gross profit Operating expenses 420,000 177,000 125,000 180,000 120,000 Net income $ 52,000 $ 60,000

 

Instructions

(a) Prepare a horizontal analysis of the income statement data for Emley Corporation using 2016 as a base. (Show the amounts of increase or decrease.)

(b) Prepare a vertical analysis of the income statement data for Emley Corporation in columnar form for both years.

Solutions

Expert Solution

a.

Horizontal Analysis    
Particulars 2016 2017 Increase % increase= change/figures in 2016 *100    
Net Sales 600000 660000 60000 10    
Less: Cost of goods sold 420000 483000 63000 15    
Gross Profit 180000 177000 -3000 -1.67    
Less: Operating Expenses 120000 125000 5000 4.17    
Net Income 60000 52000 -8000 -13.33  


 

b.

Vertical Analysis    
Particulars 2016 % of sales 2017 % of sales Increase in terms of Proportion of sales  
Net Sales 600000 100 660000 100.00 -  
Less: Cost of goods sold 420000 70 483000 73.18 3.18  
Gross Profit 180000 30 177000 26.82 -3.18  
Less: Operating Expenses 120000 20 125000 18.94 -1.06  
Net Income 60000 10 52000 7.88 -2.12  
             
Liquidity ratios    
Particulars 2016 Ratios 2017      
Net Sales 600000   660000      
Less: Cost of goods sold 420000   483000      
Gross Profit 180000 30 177000 26.82    
Less: Operating Expenses 120000   125000      
Net Income 60000 10 52000 29.38  

a.

Horizontal Analysis    
Particulars 2016 2017 Increase % increase= change/figures in 2016 *100    
Net Sales 600000 660000 60000 10    
Less: Cost of goods sold 420000 483000 63000 15  

Junaid answered 2 years ago
Next > < Previous

Related Solutions

The comparative condensed balance sheets of Gurley Corporation are presented below. GURLEY CORPORATION Comparative Condensed Balance...
The comparative condensed balance sheets of Gurley Corporation are presented below. GURLEY CORPORATION Comparative Condensed Balance Sheets December 31 2017 2016 Assets     Current assets $ 73,800 $ 79,400     Property, plant, and equipment (net) 97,100 91,200     Intangibles 27,400 40,200       Total assets $198,300 $210,800 Liabilities and stockholders’ equity     Current liabilities $ 40,400 $ 49,200     Long-term liabilities 143,200 148,000     Stockholders’ equity 14,700 13,600       Total liabilities and stockholders’ equity $198,300 $210,800 b) Prepare a vertical analysis of the balance sheet data for Gurley Corporation...
The comparative statements of Simpson Company are shown below. SIMPSON COMPANY Income Statements For the Years...
The comparative statements of Simpson Company are shown below. SIMPSON COMPANY Income Statements For the Years Ended December 31 2020 2019 Net sales $780,000 $624,000 Cost of goods sold 440,000 405,600 Gross profit 340,000 218,400 Selling and administrative expenses 176,880 149,760 Income from operations 163,120 68,640 Other expenses and losses Interest expense 9,920 7,200 Income before income taxes 153,200 61,440 Income tax expense 34,000 14,000 Net income $119,200 $ 47,440 Liabilities and Stockholders’ Equity Current liabilities Accounts payable $138,200 $132,000...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 45,900 $ 30,600 Accounts receivable 39,500 40,800 Inventory 73,700 62,400 Total current assets 159,100 133,800 Long-term investments 165,200 208,000 Property, plant, and equipment 294,700 163,500 Less accumulated depreciation 53,000 51,500 Total assets $ 566,000 $ 453,800 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 39,600 $ 43,200 Accrued liabilities 25,700 30,600...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 48,600 $ 33,000 Accounts receivable 39,900 43,200 Inventory 71,000 61,200 Total current assets 159,500 137,400 Long-term investments 168,500 220,000 Property, plant, and equipment 286,300 159,000 Less accumulated depreciation 53,000 52,500 Total assets $ 561,300 $ 463,900 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 38,500 $ 42,800 Accrued liabilities 25,000 31,800...
128. Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance...
128. Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 45,900 $ 31,500 Accounts receivable 39,900 42,800 Inventory 71,000 62,400 Total current assets 156,800 136,700 Long-term investments 176,600 212,000 Property, plant, and equipment 286,300 162,000 Less accumulated depreciation 57,200 53,500 Total assets $ 562,500 $ 457,200 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 38,200 $ 42,800 Accrued liabilities 25,400...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 49,500 $ 30,600 Accounts receivable 39,100 43,600 Inventory 71,000 63,000 Total current assets 159,600 137,200 Long-term investments 176,600 208,000 Property, plant, and equipment 303,000 165,000 Less accumulated depreciation 57,200 51,000 Total assets $ 582,000 $ 459,200 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 38,200 $ 42,400 Accrued liabilities 25,400 30,600...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 49,500 $ 32,400 Accounts receivable 38,800 41,200 Inventory 71,000 64,200 Total current assets 159,300 137,800 Long-term investments 175,000 214,000 Property, plant, and equipment 294,700 165,000 Less accumulated depreciation 56,200 52,000 Total assets $ 572,800 $ 464,800 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 36,700 $ 41,600 Accrued liabilities 25,200 31,800...
Question 1 The comparative condensed balance sheets of Gurley Corporation are presented below. GURLEY CORPORATION Comparative...
Question 1 The comparative condensed balance sheets of Gurley Corporation are presented below. GURLEY CORPORATION Comparative Condensed Balance Sheets December 31 2017 2016 Assets     Current assets $ 72,500 $ 79,200     Property, plant, and equipment (net) 99,000 90,200     Intangibles 25,600 41,800       Total assets $197,100 $211,200 Liabilities and stockholders’ equity     Current liabilities $ 40,600 $ 49,000     Long-term liabilities 140,000 149,600     Stockholders’ equity 16,500 12,600       Total liabilities and stockholders’ equity $197,100 $211,200 (a) Prepare a horizontal analysis of the balance sheet data for...
The comparative balance sheets of First Solar Corporation are presented below. First Solar Corporation Comparative Condensed...
The comparative balance sheets of First Solar Corporation are presented below. First Solar Corporation Comparative Condensed Balance Sheets December 31 2018              2017 Assets Current assets                            $ 90,000         $ 80,000 Property, plant, and equipment (net)         95,400            90,000 Intangibles                                  33,600            40,000 Total assets                            $219,000          $210,000 Liabilities and stockholders' equity                                    Current liabilities                       $ 58,320         $ 48,000 Long-term liabilities                       142,500           150,000 Stockholders' equity                         18,180            12,000 Total liab & stockholders' equity       $219,000          $210,000 Instructions (a) Prepare a horizontal analysis of the...
Presented below is a condensed version of the comparative balance sheets for Grouper Corporation for the...
Presented below is a condensed version of the comparative balance sheets for Grouper Corporation for the last two years at December 31. 2017 2016 Cash $174,900 $46,600 Accounts receivable 116,900 75,800 Investments 71,300 93,900 Equipment 352,900 173,900 Accumulated depreciation—equipment (90,900) (66,100) Current liabilities 137,700 91,900 Common stock 138,300 63,700 Retained earnings 354,700 174,100 Additional information: Investments were sold at a gain of $9,100; no investments were purchased; no equipment was sold; cash dividends paid were $41,700; and net income was...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT