Question

In: Accounting

Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years...

  1. Common-Size Income Statements and Horizontal Analysis
  2. Income statements for Mariners Corp. for the past two years are as follows:
  3. (amounts in thousands
    of dollars)
    2017 2016
    Sales revenue $60,000 $50,000
    Cost of goods sold 42,000 30,000
       Gross profit $18,000 $20,000
    Selling and administrative expense 9,000 5,000
       Operating income $9,000 $15,000
    Interest expense 2,000 2,000
       Income before tax $7,000 $13,000
    Income tax expense 2,000 4,000
       Net income $5,000 $9,000
  4. Required:
  1. 1. Using the format in Example 13-5, prepare common-size comparative income statements for the two years for Mariners Corp. Round percentages to one decimal point.

  1. Mariners Corp.
  1. Common-Size Comparative Income Statements
  1. For The Years Ended December 31, 2017 And 2016 (In Thousands of Dollars)
  1. 2017 Dollars
  1. 2017 Percent
  1. 2016 Dollars
  1. 2016 Percent
    1. Income before tax
    • Income tax expense
    • Operating income
    • Sales revenue
  1. $
  1. %
  1. $
  1. %
    1. Cost of goods sold
    • Income before tax
    • Income tax expense
    • Operating income
  1. Gross profit
  1. $
  1. %
  1. $
  1. %
    1. Cost of goods sold
    • Interest payable
    • Sales revenue
    • Selling and administrative expense
  1. Cost of goods sold
  • Interest payable
  • Operating income
  • Sales revenue
  1. $
  1. %
  1. $
  1. %
    1. Cost of goods sold
    • Interest expense
    • Interest payable
    • Sales revenue
  1. Cost of goods sold
  • Income before tax
  • Interest payable
  • Sales revenue
  1. $
  1. %
  1. $
  1. %
    1. Cost of goods sold
    • Income tax expense
    • Interest payable
    • Sales revenue
  1. Net income
  1. $
  1. %
  1. $
  1. %
  1. Feedback

  1. 2. Based on Mariner's common size statements in 2017 compared to 2016, it can be concluded that

  1. all of these are true.
  2. gross profit as a percentage of sales declined due to higher cost of goods sold.
  3. net income decreased both in dollars and as a percentage of sales.
  4. selling and administrative expenses increased both in dollars as well as percentage of sales.
  1. a
  • b
  • c
  • d
  1. Feedback

  1. 3. Using the format in Example 13-2, prepare comparative income statements for Mariners Corp., including columns for the dollars and for the percentage increase or decrease in each item on the statement. Round all percentages to the nearest whole percent. If an answer is zero, enter "0".

  1. Mariners Corp.
  1. Comparative Statements of Income
  1. For The Years Ended December 31, 2017 And 2016
  1. December 31, 2017
  1. December 31, 2016
  1. Increase/Decrease Dollars
  1. Increase/Decrease (Percent)
    1. Income before tax
    • Income tax expense
    • Operating income
    • Sales revenue
  1. $
  1. $
  1. $
  1. %
    1. Cost of goods sold
    • Income before tax
    • Income tax expense
    • Operating income
  1. Gross profit
  1. $
  1. $
  1. $
    1. Cost of goods sold
    • Interest payable
    • Sales revenue
    • Selling and administrative expense
  1. Cost of goods sold
  • Interest payable
  • Operating income
  • Sales revenue
  1. $
  1. $
  1. $
    1. Cost of goods sold
    • Interest expense
    • Interest payable
    • Operating income
  1. Cost of goods sold
  • Income before tax
  • Interest payable
  • Sales revenue
  1. $
  1. $
  1. $
    1. Cost of goods sold
    • Income tax expense
    • Interest payable
    • Sales revenue
  1. Net income
  1. $
  1. $
  1. $
  1. Feedback

  1. 4. Identify the two items on the income statement that experienced the largest change from one year to the next. For each of these items, where you would look to find additional information about the change.

  1. selling and administration expense, and for information refer to individual expense records.
  2. Income tax expense, and for information refer to income tax return and supporting records.
  3. cost of goods sold, and for information refer to refer to individual expense records.
  4. sales revenue, and for information refer to sales ledgers and supporting records.
  1. a and b
  • b and c
  • c and d
  • d and a
  1. Feedback

  1. Feedback

  2. Loading item

There was an error loading this item. If this continues to occur, please contact Technical Support.

Check My Work

  • Previous
  • Next
  • 100% Correct
  • Partially Correct
  • Incorrect
  • Needs Instructor Grading

Basic Calculatorclose

0

UseEntBSBSpCEHomCEnd

789+

456-

123*

0.=/

Solutions

Expert Solution

Requirement 1

Mariners Corp.

Common-Size Comparative Income Statements

For The Years Ended December 31, 2017 And 2016 (In Thousands of Dollars)

2017 Dollars

2017 Percent

2016 Dollars

2016 Percent

Sales revenue

$ 60,000.00

100.0%

$ 50,000.00

100.0%

Cost of goods sold

$ 42,000.00

70.0%

$ 30,000.00

60.0%

    Gross profit

$ 18,000.00

30.0%

$ 20,000.00

40.0%

Selling and administrative expense

$     9,000.00

15.0%

$    5,000.00

10.0%

    Operating income

$     9,000.00

15.0%

$ 15,000.00

30.0%

Interest expense

$     2,000.00

3.3%

$    2,000.00

4.0%

    Income before tax

$     7,000.00

11.7%

$ 13,000.00

26.0%

Income tax expense

$     2,000.00

3.3%

$    4,000.00

8.0%

    Net income

$     5,000.00

8.3%

$    9,000.00

18.0%

Requirement 2

Correct answer---(a) all of these are true

Requirement 3

Mariners Corp.

Comparative Statements of Income

For The Years Ended December 31, 2017 And 2016

December 31, 2017

December 31, 2016

Increase/Decrease Dollars

Increase/Decrease (Percent)

Sales revenue

$ 60,000.00

$ 50,000.00

$ 10,000.00

20.0%

Cost of goods sold

$ 42,000.00

$ 30,000.00

$ 12,000.00

40.0%

    Gross profit

$ 18,000.00

$ 20,000.00

$ (2,000.00)

-10.0%

Selling and administrative expense

$     9,000.00

$    5,000.00

$    4,000.00

80.0%

    Operating income

$     9,000.00

$ 15,000.00

$ (6,000.00)

-40.0%

Interest expense

$     2,000.00

$    2,000.00

$                 -  

0.0%

    Income before tax

$     7,000.00

$ 13,000.00

$ (6,000.00)

-46.2%

Income tax expense

$     2,000.00

$    4,000.00

$ (2,000.00)

-50.0%

    Net income

$     5,000.00

$    9,000.00

$ (4,000.00)

-44.4%

Requirement 4

Correct answer—a and b

Selling and administrative expense and income tax expense showed most change


Related Solutions

Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years...
Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years are as follows: (amounts in thousands of dollars) 2017 2016 Sales revenue $60,000 $50,000 Cost of goods sold 42,000 30,000    Gross profit $18,000 $20,000 Selling and administrative expense 9,000 5,000    Operating income $9,000 $15,000 Interest expense 2,000 2,000    Income before tax $7,000 $13,000 Income tax expense 2,000 4,000    Net income $5,000 $9,000 Required: 1. Using the format in Example 13-5, prepare common-size comparative income...
Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years...
Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years are as follows: (amounts in thousands of dollars) 2017 2016 Sales revenue $60,000 $50,000 Cost of goods sold 42,000 30,000    Gross profit $18,000 $20,000 Selling and administrative expense 9,000 5,000    Operating income $9,000 $15,000 Interest expense 2,000 2,000    Income before tax $7,000 $13,000 Income tax expense 2,000 4,000    Net income $5,000 $9,000 Required: 1. Using the format in Example 13-5, prepare common-size comparative income...
Preparing Common-Size Income Statements by Using Base Period Horizontal Analysis Scherer Company provided the following income...
Preparing Common-Size Income Statements by Using Base Period Horizontal Analysis Scherer Company provided the following income statements for its first 3 years of operation: Scherer Company Income Statements Years of Operation Year 1 Year 2 Year 3 Net sales $1,010,000 $1,131,200 $1,353,400 Less: Cost of goods sold (293,000) (314,000) (362,000) Gross margin $717,000 $817,200 $991,400 Less: Operating expenses (424,000) (490,000) (595,500) Income taxes (110,800) (120,200) (135,000) Net income $182,200 $207,000 $260,900 repare common-size income statements by using Year 1 as...
Common size statements: the following are income statements for Lowe's and Home depot for the years...
Common size statements: the following are income statements for Lowe's and Home depot for the years ended February 3, 2012 and January 29, 2012, respectively: 1. The companies do not use exactly the same account titles. Align the accounts accross two companies int he manner you beleive to be the most appropriate. Then prepare common-size income statemens for Lowe's and The Home Depot. 2. Compare the two companies by using the common-size statements. The income statements for the two companies...
In a financial statement analysis, you are examining the common-size income statements for the XYZ Metrical...
In a financial statement analysis, you are examining the common-size income statements for the XYZ Metrical Company for the past 5 years and have noticed that the cost of goods as a percentage of sales has been increasing steadily. At the same time, EBIT as a percentage of sales has been decreasing. What might account for the trends in these ratios? What actions might managers take to improve these ratios?
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $925,000 $740,000 Cost of goods sold 780,800 640,000 Gross profit $144,200 $100,000 Selling expenses $41,400 $36,000 Administrative expenses 36,900 30,000 Total operating expenses $78,300 $66,000 Income before income tax $65,900 $34,000 Income tax expenses 26,400 13,600 Net income $39,500 $20,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
Horizontal Analysis of the Income Statement Income statement data for Boone Company for two recent years...
Horizontal Analysis of the Income Statement Income statement data for Boone Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $546,000 $420,000 Cost of goods sold 473,600 370,000 Gross profit $72,400 $50,000 Selling expenses $21,600 $18,000 Administrative expenses 19,200 15,000 Total operating expenses $40,800 $33,000 Income before income tax $31,600 $17,000 Income tax expenses 12,600 6,800 Net income $19,000 $10,200 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $806,000 $650,000 Cost of goods sold 683,200 560,000 Gross profit $122,800 $90,000 Selling expenses $35,340 $31,000 Administrative expenses 31,720 26,000 Total operating expenses $67,060 $57,000 Income before income tax $55,740 $33,000 Income tax expenses 22,300 13,200 Net income $33,440 $19,800 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $806,000 $650,000 Cost of goods sold 683,200 560,000 Gross profit $122,800 $90,000 Selling expenses $35,340 $31,000 Administrative expenses 31,720 26,000 Total operating expenses $67,060 $57,000 Income before income tax $55,740 $33,000 Income tax expenses 22,300 13,200 Net income $33,440 $19,800 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $496,100 $410,000 Cost of goods sold 413,000 350,000 Gross profit $83,100 $60,000 Selling expenses $23,310 $21,000 Administrative expenses 20,230 17,000 Total operating expenses $43,540 $38,000 Income before income tax $39,560 $22,000 Income tax expenses 15,800 8,800 Net income $23,760 $13,200 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT