Question

In: Finance

1 Horizontal analysis [5–10 min] McCormick, Corp., reported the following on its comparative income statement: (In...

1 Horizontal analysis [5–10 min]

McCormick, Corp., reported the following on its comparative income statement:

(In millions)

2012

2011

2010

Revenue ..............................

$9,575

$9,300

$8,975

Cost of sales........................

6,000

5,975

5,900

Requirement

1. Prepare a horizontal analysis of revenues and gross profit—both in dollar amounts and in percentages—for 2012 and 2011.

Financial Statement Analysis 751

Solutions

Expert Solution

[$ in millions]
2012 2011 2010 2012 2011
Increase/ (Decrease) % Increase/ (Decrease) %
Revenue $          9,575 $           9,300 $         8,975 $                600 6.69% $               325 3.62%
Cost of sales $          6,000 $           5,975 $         5,900 $                100 1.69% $                 75 1.27%
Gross profit $          3,575 $           3,325 $         3,075 $                500 16.26% $               250 8.13%

Related Solutions

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                          $    ...
Horizontal Analysis of Comparative Financial Statements Amounts from the comparative income statement and balance sheet of...
Horizontal Analysis of Comparative Financial Statements Amounts from the comparative income statement and balance sheet of Miller Electronics Corporation for the last two years are as follows: Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2 20-1 Net Sales (all on account) $652,630    $416,530    Cost of goods sold 387,960    250,560    Gross profit $264,670    $165,970    Administrative expenses $65,676    $42,758    Selling expenses 66,261    43,915    Total operating expenses $131,937    $86,673    Operating income $132,733    $79,297    Interest expense 1,331   ...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $693,095 $579,000 Cost of goods sold 518,000 370,000 Gross profit $175,095 $209,000 Selling expenses $73,500 $49,000 Administrative expenses 42,160 31,000 Total operating expenses $115,660 $80,000 Income from operations $59,435...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $815,178 $741,000 Cost of goods sold 573,400 470,000 Gross profit $241,778 $271,000 Selling expenses $79,050 $62,000 Administrative expenses 46,720 39,000 Total operating expenses $125,770 $101,000 Income from operations $116,008...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $505,848 $446,000 Cost of goods sold 358,400 280,000 Gross profit $147,448 $166,000 Selling expenses $51,300 $38,000 Administrative expenses 30,050 24,000 Total operating expenses $81,350 $62,000 Income from operations $66,098...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $501,094 $418,000 Cost of goods sold 364,000 260,000 Gross profit $137,094 $158,000 Selling expenses $52,500 $35,000 Administrative expenses 29,920 22,000 Total operating expenses $82,420 $57,000 Income from operations $54,674...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At...
Horizontal Analysis of Income Statement For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $526,224 $456,000 Cost of goods sold 382,800 290,000 Gross profit $143,424 $166,000 Selling expenses $53,200 $38,000 Administrative expenses 30,910 24,000 Total operating expenses $84,110 $62,000 Income from operations $59,314...
1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a...
1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a base. Neiman Corp. Comparative Balance Sheet For the years ended December 31 2019 2018 Assets Current Assets 360 300 Plant Assets 640 500 Total Assets 1,000 800 Liabilities & Stockholders' Equity Current liabilities 150 120 Long-term debt 240 160 Common stock 350 320 Retained earnings 260 200 Total liabilities & stockholders' equity 1,000 800 2 VERTICAL ANALYSIS INSTRUCTIONS: Prepare a vertical analysis of the...
Horizontal Analysis of Income Statement For 20Y2, Macklin Inc. reported a significant decrease in net income....
Horizontal Analysis of Income Statement For 20Y2, Macklin Inc. reported a significant decrease in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparative income statement: Macklin Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $867,160 $731,000 Cost of goods sold (634,800) (460,000) Gross profit $232,360 $271,000 Selling expenses $(91,450) $(62,000) Administrative expenses (52,340) (39,000) Total operating expenses $(143,790) $(101,000) Operating income $88,570...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the...
Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Calvin Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $92,316 $104,544 Event-related revenue 135,648 131,648 NASCAR broadcasting revenue 179,922 170,368 Other operating revenue 63,114 77,440 Total revenue $471,000 $484,000 Expenses and other: Direct expense of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT