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

Mariner's corporation

Common size income statement for the year ended December 2016 and 2017

Particulars 2017 % 2016 %
Sales revenue $60000 100% $50000 100%
Cost of goods sold ($42000) ($30000)
Gross profit $18000 30% $20000 40%
Selling and administrative expenses ($9000) ($5000)
Operating income $9000 15% $15000 30%
Interest expense ($2000) ($2000)
Income before tax $7000 11.67% $13000 26%
Income tax expense ($2000) ($4000)
Net income $5000 8.33% $9000 18%

Comparitive income statement for the year ended December 31 2016 and 2017

Particulars 2017 2016 Increase / Decrease %
Sales $60000 $50000 $10000 20%
Cost of goods sold ($42000) ($30000) $12000 40%
Gross profit $18000 $20000 ($2000) (10%)
Selling and administrative expenses ($9000) ($5000) $4000 80%
Operating income $9000 $15000 ($6000) (40%)
Interest expense ($2000) ($2000) $0 0
Income before tax $7000 $13000 ($6000) (46%)
Income tax ($2000) ($4000) ($2000) (50%)
Net income $5000 $9000 ($4000) (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