Question

In: Accounting

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 statements for the two years for Mariners Corp. Round percentages to one decimal point.

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 $ % $ %
Cost of goods sold
Gross profit $ % $ %
Selling and administrative expense
Operating income $ % $ %
Interest expense
Income before tax $ % $ %
Income tax expense
Net income $ % $ %

Feedback

Prepare in correct form common-size comparative income statements for two years. Set up with five columns.

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

all of these are true.

gross profit as a percentage of sales declined due to higher cost of goods sold.

net income decreased both in dollars and as a percentage of sales.

selling and administrative expenses increased both in dollars as well as percentage of sales.

a

Feedback

Correct

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".

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 $ $ $ %
Cost of goods sold
Gross profit $ $ $
Selling and administrative expense
Operating income $ $ $
Interest expense
Income before tax $ $ $
Income tax expense
Net income $ $ $

Solutions

Expert Solution

Answer

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

100.00%

        50,000

100.00%

Cost of goods sold

        42,000

70.00%

        30,000

60.00%

Gross profit

        18,000

30.00%

        20,000

40.00%

Selling and administrative expense

          9,000

15.00%

          5,000

10.00%

Operating income

          9,000

15.00%

        15,000

30.00%

Interest expense

          2,000

3.33%

          2,000

4.00%

Income before tax

          7,000

11.67%

        13,000

26.00%

Income tax expense

          2,000

3.33%

          4,000

8.00%

Net income

          5,000

8.33%

          9,000

18.00%

2.

Yes it is true that

Gross profit as a percentage of sales declined due to higher cost of goods sold.

Net income decreased both in dollars and as a percentage of sales.

Selling and administrative expenses increased both in dollars as well as percentage of sales

3.

Mariners Corp.

Comparative Statements of Income

For The Years Ended December 31, 2017 And 2016

31-Dec-17

31-Dec-16

Increase/Decrease Dollars

Increase/Decrease (Percent)

Sales revenue

        60,000

          50,000

                 10,000

20.00%

Cost of goods sold

      42,000

          30,000

                 12,000

40.00%

Gross profit

        18,000

          20,000

                  (2,000)

-10.00%

Selling and administrative expense

          9,000

           5,000

                   4,000

80.00%

Operating income

          9,000

          15,000

                  (6,000)

-40.00%

Interest expense

          2,000

           2,000

                        -  

0.00%

Income before tax

          7,000

          13,000

                  (6,000)

-46.15%

Income tax expense

          2,000

           4,000

                  (2,000)

-50.00%

Net income

          5,000

           9,000

                  (4,000)

-44.44%


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