Question

In: Accounting

Use the following data to prepare a common-size comparative income statement for Old Mill Corporation on...

Use the following data to prepare a common-size comparative income statement for Old Mill Corporation on December 31, 2016. Round percentages to one-tenth percent.

2016

2015

Net sales

$1,151,000

$1,350,000

Expenses:

   Cost of goods sold

$980,000

$860,000

   Selling and general expenses

290,000

230,000

   Interest expense

59,000

59,000

   Income tax expense

71,000

53,000

   Total expenses

$1,400,000

$1,202,000

   Net income

$110,000

$148,000

Solutions

Expert Solution

Common size income statement
2016 2015
Amount Percentage Amount Percentage
Net sales $       11,51,000.00 100.00% $    13,50,000.00 100.00%
Expenses:
   Cost of goods sold $         9,80,000.00 85.14% $       8,60,000.00 63.70%
   Selling and general expenses $         2,90,000.00 25.20% $       2,30,000.00 17.04%
   Interest expense $             59,000.00 5.13% $          59,000.00 4.37%
   Income tax expense $             71,000.00 6.17% $          53,000.00 3.93%
   Total expenses $       14,00,000.00 121.63% $    12,02,000.00 89.04%
   Net income $       (2,49,000.00) -21.63% $       1,48,000.00 10.96%

The net income amount in 2015 seems wrong, I have solved the question in the amount which it should be . Although i have given below alternate solution with the amounts as it is in the above question.

Please see below given alternate solution

Common size income statement
2016 2015
Amount Percentage Amount Percentage
Net sales $       11,51,000.00 100.00% $    13,50,000.00 100.00%
Expenses:
   Cost of goods sold $         9,80,000.00 85.14% $       8,60,000.00 63.70%
   Selling and general expenses $         2,90,000.00 25.20% $       2,30,000.00 17.04%
   Interest expense $             59,000.00 5.13% $          59,000.00 4.37%
   Income tax expense $             71,000.00 6.17% $          53,000.00 3.93%
   Total expenses $       14,00,000.00 121.63% $    12,02,000.00 89.04%
   Net income $         1,10,000.00 9.56% $       1,48,000.00 10.96%

Related Solutions

Question 3 Use the following data to prepare a common-size comparative income statement for Old Mill...
Question 3 Use the following data to prepare a common-size comparative income statement for Old Mill Corporation on December 31, 2016. Round percentages to one-tenth percent. A step by step detail would be most helpful 2016 2015 Net sales $1,151,000 $1,350,000 Expenses:    Cost of goods sold $980,000 $860,000    Selling and general expenses 290,000 230,000    Interest expense 59,000 59,000    Income tax expense 71,000 53,000    Total expenses $1,400,000 $1,202,000    Net income $110,000 $148,000
prepare a common size income statement from the following income statement: CONSOLIDATED STATEMENTS OF OPERATIONS -...
prepare a common size income statement from the following income statement: CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) 12 Months Ended shares in Millions, $ in Millions Feb. 01, 2020 Feb. 02, 2019 Feb. 03, 2018 Total net sales $10,716 $11,664 $12,554 Credit income and other 451 355 319 Total revenues 11,167 12,019 12,873 Costs and expenses/(income): Cost of goods sold (exclusive of depreciation and amortization shown separately below) 7,013 7,870 8,208 Selling, general and administrative (SG&A) 3,585 3,596 3,845...
Use the following comparative Balance Sheets, Income Statement, and additional information to prepare the 2018 Statement...
Use the following comparative Balance Sheets, Income Statement, and additional information to prepare the 2018 Statement of Cash Flows for United Brands Corporation. Required: Prepare an entire Statement of Cash Flows (all three sections) using the indirect method for the Operating Activities section. Prepare the Operating Activities section using the direct method. United Brands Corporation Balance Sheets December 31, 2018 and 2017 ($ in millions) 2018 2017 Incr (Decr) ASSETS Current Assets: Cash $41 $20 $21 Accounts receivable 32 30...
Prepare a horizontal analysis of the following comparative income statement for the Buff Bodies Corporation. Round...
Prepare a horizontal analysis of the following comparative income statement for the Buff Bodies Corporation. Round percentage changes to the nearest one-tenth percent. Buff Bodies Corporation Comparative Income Statement For the Years Ended December 31, 2019 and 2018    2019                              2018 Total revenue                       $1,450,000                        $1,300,000 Expenses: Cost of goods sold       $   1,023,000                        $   930,000 Operating expenses             310,000                             275,000 Interest expense                    48,300                               38,000 Income tax expense            12,000                               10,000 Total expenses                      $1,393,300                        $1,253,000 Net income                          $    ...
The Carla Vista Supply Company reported the following information for 2017. Prepare a common-size income statement...
The Carla Vista Supply Company reported the following information for 2017. Prepare a common-size income statement for the year ended June 30, 2017. (Round answers to 1 decimal place, e.g. 52.7%.) Carla Vista Supply Company Income Statement for the Fiscal Year Ended June 30, 2017($ thousands) % of Net Sales Net sales $2,110,000 % Cost of goods sold 1,461,000 % Selling and administrative expenses 312,800 % Nonrecurring expenses 27,200 % Earnings before interest, taxes, depreciation, and amortization (EBITDA) $309,000 %...
The following are income statement and comparative statement of financial position for Rabies Corporation for the...
The following are income statement and comparative statement of financial position for Rabies Corporation for the year ended 31/12/2019. Sales 1,915,000 C.G.S (965,000) gross income 950,000 Operating expenses (721,000) income from operating 229,000 Other gain or losses ( 2,000) Interest expenses (12,000) Tax (65,000) net income 150,000 Comparative statement of financial positions for the year ended 31/12/2019 ASSETS 2019 2018 L. S. Equity 2019 2018 Cash 104,000 57,000 Accounts payable 69,000 75,000 Accounts receivable 82,000 36,000 Accrued expenses 15,700 16000...
to create a common size income statement ---- all items on the income statement by -----...
to create a common size income statement ---- all items on the income statement by ----- a) divide; net income b) multiply; total revenue c) multiply; net income d) divide; total revenue
89) Following are selected data from the comparative income statement and balance sheet for Owens Corporation...
89) Following are selected data from the comparative income statement and balance sheet for Owens Corporation for the years ended December 31, 2014, and 2013: Selected Data                                    2014                      2013 Net sales (all on credit)                $96,000                $93,000 Cost of goods sold                           51,300                  52,500 Gross margin                                    44,700                  40,500 Income from operations                 16,300                  15,000 Interest expense                                 3,000                    3,500 Net income                                          9,800                    9,000 Cash                                                      2,700                    3,500 Accounts receivable, net                10,700                  12,500 Inventory                                           25,000                  30,000 Prepaid expenses                               1,000                       900 Total current assets                         39,400                  46,900 Total...
Common-Size Income Statements Consider the following income statement data from the Ross Company: 2013 2012 Sales...
Common-Size Income Statements Consider the following income statement data from the Ross Company: 2013 2012 Sales revenue $529,000 $454,000 Cost of goods sold 336,000 279,000 Selling expenses 105,000 99,000 Administrative expenses 64,000 58,000 Income tax expense 11,800 9,400 Prepare common-size income statements for each year. Note: Round answers to one decimal place (ex: 0.2345 = 23.5%). ROSS COMPANY Common-Size Income Statements (Percent of Sales Revenue) 2013 2012 Sales Revenue Answer Answer Cost of Goods Sold Answer Answer AnswerGross Profit on...
Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets...
Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of January 31, 2015 and February 1, 2014. (Round your answers to one decimal place.) ($ millions) January 31, 2015 February 1, 2014 Assets Cash and cash equivalents $2,210 $670 Inventory 8,790 8,278 Other current assets 3,087 2,625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders’ investment Accounts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT